Question

You've decided to buy a house that is valued at $1 million. You have $350,000 to use as a down payment on the house, and want to take out a mortgage for the remainder of the purchase price. Your bank has approved your nterest rate (called the $650,000 mortgage, and is offering a standard 30-year mortgage at a 10% fixed nomina loan's annual percentage rate or APR). Under this loan proposal, your mortgage payment will be ___________per month.
a. $7,700.43
b. 7130.03
c. 8841.23
d. 5704.02

Answer 1

Answer:

d. 5704.02

Explanation:

Nper = 30*12 = 360

Rate = 10%/12 = 0.008333

PV = 650,000

Using the MS Excel function:

Monthly payment = PMT(RATE, NPER, -PV)

Monthly payment = PMT(10%/12, 360, -650000)

Monthly payment = $5,704.02