In: Finance
A 20 year loan of $50, 000 is taken out at effective annual interest i = 6% for the first 10 years and then i = 7% for the next 10 years. Payments are constant at the end of each year. Find the outstanding balance after the 16th payment.
Step-1:Calculation of annual payment | ||||||
Annual payment | = | Loan amount | / | Cumulative discount factor | ||
= | $ 50,000.00 | / | 11.28202 | |||
= | $ 4,431.83 | |||||
Working: | ||||||
Present value of annuity of 1 for first 10 years | = | (1-(1+i)^-n)/i | Where, | |||
= | (1-(1+0.06)^-10)/0.06 | i | = | 6% | ||
= | 7.36008705 | n | = | 10 | ||
Present value of annuity of 1 for next 10 years | = | ((1-(1+i1)^-n)/i1)*(1+i2)^-n | Where, | |||
= | ((1-(1+0.07)^-10)/0.07)*(1+0.06)^-10 | i1 | = | 7% | ||
= | 3.92193125 | i2 | = | 6% | ||
n | = | 10 | ||||
Cumulative discount factor | = | 7.36008705 | + | 3.921931 | ||
= | 11.2820183 | |||||
Step-2:outstanding balance after the 16th payment | ||||||
Outstanding Balance | = | Annual payment | * | Present Value of annuity of 1 | ||
= | $ 4,431.83 | * | 3.387211 | |||
= | $ 15,011.55 | |||||
Working: | ||||||
Present value of annuity of 1 for first 10 years | = | (1-(1+i)^-n)/i | Where, | |||
= | (1-(1+0.07)^-4)/0.07 | i | = | 7% | ||
= | 3.38721126 | n | = | 4 |