In: Finance
You borrow $396,000 to buy a home using a 15-year mortgage with an interest rate of 3.00 percent and monthly payment. What percentage of the total amount paid in the first 5 years will go toward principal repayment?
Group of answer choices
58.2 percent
68.7 percent
31.3 percent
41.8 percent
| Step 1 : | EMI = [P x R x (1+R)^N]/[(1+R)^N-1] | |||||
| Where, | ||||||
| EMI= Equal Monthly Payment | ||||||
| P= Loan Amount | ||||||
| R= Interest rate per period | ||||||
| N= Number of periods | ||||||
| = [ $396000x0.0025 x (1+0.0025)^180]/[(1+0.0025)^180 -1] | ||||||
| = [ $990( 1.0025 )^180] / [(1.0025 )^180 -1 | ||||||
| =$2734.7 | ||||||
| Step 2 : | Loan balance after 5th year | |||||
| Present Value Of An Annuity | ||||||
| = C*[1-(1+i)^-n]/i] | ||||||
| Where, | ||||||
| C= Cash Flow per period | ||||||
| i = interest rate per period | ||||||
| n=number of period | ||||||
| = $2734.7[ 1-(1+0.0025)^-120 /0.0025] | ||||||
| = $2734.7[ 1-(1.0025)^-120 /0.0025] | ||||||
| = $2734.7[ (0.2589) ] /0.0025 | ||||||
| = $2,83,210.33 | ||||||
| Step 3 : | Principal repaid =n $396000-283210.33 | |||||
| =$112789.7 | ||||||
| Total payment = $2734.7*12*5 | ||||||
| =$164082 | ||||||
| % of principal = 112789/164082 | ||||||
| =68.7 percent | ||||||