You've decided to buy a house that is valued at $1 million. You have $150,000 to use as a down payment on the house, and you tak
e out a mortgage for the rest. Your bank has approved your mortgage for the balance amount of $850,000 and is offering you a standard 30-year mortgage with 8% fixed nominal interest rate (called the annual percentage rate, or APR). According to this proposal, what will be your monthly mortgage payment?
a. $6,237.
b. $8,420.
c. $9,667.
d. $7,796
a. $6,237.
b. $8,420.
c. $9,667.
d. $7,796
1 answer:
Answer:
a. $6,237.
Explanation:
We use the PMT formula i.e shown in the attachment below:
Data provided in the question
Present value = $850,000
Future value = $0
Rate of interest = 8% ÷ 12 months = 0.66666%
NPER = 30 years × 12 months = 360 months
The formula is shown below:
= PMT(Rate;NPER;-PV;FV;type)
The present value come in negative
So, after solving this, the monthly mortgage payment is $6,237
You might be interested in
Answer:
7.74%
Explanation:
In this question, we use the Rate formula which is shown in the spreadsheet.
The NPER represents the time period.
Given that,
Present value = $1,180
Assuming figure - Future value or Face value = $1,100
PMT = $105
NPER = 5 years
The formula is shown below:
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this, the answer would be 7.74%
