A lender requires that monthly mortgage payments be no more than 25% of your gross monthly income with a maximum repayment period of 30 years. If you can make a 15% down payment, what is the minimum monthly payment needed when the interest rate is 6% compounded monthly?
A mortgage payments are part of a planned installment agreement between a borrower and a money lender, such as a bank. In addition to the principal (remaining cost of the home after the downpayment) and interest, monthly mortgage payments typically include property and private mortgage insurance premiums and property taxes.
Answer and Explanation:
For the purpose of this question, let's assume that the cost of house is $300,000.
- Present value (PV) of the mortgage loan = 300,000 * (1 - 0.15) = $255,000
- Annual interest rate = 6%
- Tenure of loan (nper) = 30 years (360 months)
The monthly interest rate can be calculated as follows:
- Rate (r) = 6% / 12
- Rate (r) = 0.5%
We can calculate the monthly payment (pmt) by using the Excel function: PMT(rate, nper, pv,):
Monthly repayment = Pmt(0.5%,360,-255000)= $1,528.85.
As per the question, the monthly mortgage repayments can't be any more than 25% of the gross monthly income.
- Gross Monthly income = $1,528.85 / 25%
- Gross Monthly Income = $6,115.42
Become a member and unlock all Study Answers
Try it risk-free for 30 daysTry it risk-free
Ask a question
Our experts can answer your tough homework and study questions.Ask a question Ask a question
Learn more about this topic:
from Finance 102: Personal FinanceChapter 7 / Lesson 4