In: Accounting
A loan is for $600,000 (mortgage), 30 years monthly, 4% fixed rate interest. What is the payment, 5-year payoff, 5-year principal paid, and 5-year interest paid?
Step-1:Calculation of monthly payment | ||||||||
Monthly Payment | = | Loan amount | / | Present value of annuity of 1 | ||||
= | $ 6,00,000 | / | 209.47136 | |||||
= | $ 2,864.35 | |||||||
Working: | ||||||||
Present value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | |||||
= | (1-(1+0.003333)^-360)/0.003333 | i | 4%/12 | = | 0.003333 | |||
= | 209.4713584 | n | 30*12 | = | 360 | |||
Step-2:Calculation of 5-year payoff, 5-year principal paid, and 5-year interest paid | ||||||||
5-year payoff | = | $ 2,864.35 | * | 360 | = | $ 10,31,167.23 | ||
5-year principal paid | $ 6,00,000.00 | |||||||
5-year interest paid | $ 4,31,167.23 |