In: Finance
A couple has just purchased a home for $327,400.00. They will pay 20% down in cash, and finance the remaining balance. The mortgage broker has gotten them a mortgage rate of 5.64% APR with monthly compounding. The mortgage has a term of 30 years.
How much interest is paid in the first year?
Answer Format: Currency: Round to: 2 decimal places.
Monthly Loan Payment
Loan Amount (P) = $261,920 [$327,400 x 80%]
Monthly Interest Rate (n) = 0.47% per month [5.64% / 12 Months]
Number of months (n) = 360 Months [30 Years x 12 months]
Monthly Loan Payment = [P x {r (1+r)n} ] / [( 1+r)n – 1]
= [$261,920 x {0.0047 x (1 + 0.0047)360}] / [(1 + 0.0047)360 – 1]
= [$261,920 x {0.0047 x 5.408848] / [5.408848 – 1]
= [$261,920 x 0.025422] / 4.408848
= $6,658.43 / 4.408848
= $1,510.24 per month
Monthly Loan Amortization Schedule
| 
 Month  | 
 Beginning Amount ($)  | 
 Total Payment ($)  | 
 Interest Payment at 0.47% ($)  | 
 Principal Payment ($)  | 
 Ending Balance ($)  | 
| 
 1  | 
 2,61,920.00  | 
 1,510.24  | 
 1,231.02  | 
 279.22  | 
 2,61,640.78  | 
| 
 2  | 
 2,61,640.78  | 
 1,510.24  | 
 1,229.71  | 
 280.53  | 
 2,61,360.26  | 
| 
 3  | 
 2,61,360.26  | 
 1,510.24  | 
 1,228.39  | 
 281.85  | 
 2,61,078.41  | 
| 
 4  | 
 2,61,078.41  | 
 1,510.24  | 
 1,227.07  | 
 283.17  | 
 2,60,795.24  | 
| 
 5  | 
 2,60,795.24  | 
 1,510.24  | 
 1,225.74  | 
 284.50  | 
 2,60,510.74  | 
| 
 6  | 
 2,60,510.74  | 
 1,510.24  | 
 1,224.40  | 
 285.84  | 
 2,60,224.90  | 
| 
 7  | 
 2,60,224.90  | 
 1,510.24  | 
 1,223.06  | 
 287.18  | 
 2,59,937.71  | 
| 
 8  | 
 2,59,937.71  | 
 1,510.24  | 
 1,221.71  | 
 288.53  | 
 2,59,649.18  | 
| 
 9  | 
 2,59,649.18  | 
 1,510.24  | 
 1,220.35  | 
 289.89  | 
 2,59,359.29  | 
| 
 10  | 
 2,59,359.29  | 
 1,510.24  | 
 1,218.99  | 
 291.25  | 
 2,59,068.04  | 
| 
 11  | 
 2,59,068.04  | 
 1,510.24  | 
 1,217.62  | 
 292.62  | 
 2,58,775.42  | 
| 
 12  | 
 2,58,775.42  | 
 1,510.24  | 
 1,216.24  | 
 294.00  | 
 2,58,481.42  | 
| 
 TOTAL  | 
 14,684.30  | 
||||
“Hence, the total interest is paid in the first year will be $14,684.30”