In: Finance
A 50000$ mortgage is to be repaid by means of monthly payments, at the beginning of each month, for 20 years. If the nominal interest rate is 12% convertible monthly, (a) Find the monthly payment (b) Suppose now an extra payment of 1000$ is made at the end of each year. Determine the monthly payment (This problem needs to be solved using the concept of annuities)..
| Solution a | |||
| PV of annuity for making pthly payment | |||
| P = PMT x (((1-(1 + r) ^- n)) / i) | |||
| Where: | |||
| P = the present value of an annuity stream | $ 50,000 | ||
| PMT = the dollar amount of each annuity payment | PMT | ||
| r = the effective interest rate (also known as the discount rate) | 12.68% | (1+12%/12)^12)-1) | |
| i=nominal Interest rate | 12% | ||
| n = the number of periods in which payments will be made | 20 | ||
| PV of annuity= | PMT x (((1-(1 + r) ^- n)) / i) | ||
| 50000= | PMT x (((1-(1 + 12.68%) ^-20)) / 12%) | ||
| Annual payment= | 50000/(((1-(1 + 12.68%) ^-20)) / 12%) | ||
| Annual payment= | $ 6,606.81 | ||
| Monthly payment= | $ 550.57 | 
Solution b:
| First we would compute the PV of annual payments | ||
| PV of annuity for making pthly payment | ||
| P = PMT x (((1-(1 + r) ^- n)) / r) | ||
| Where: | ||
| P = the present value of an annuity stream | ||
| PMT = the dollar amount of each annuity payment | $ 1,000 | |
| r = the effective interest rate (also known as the discount rate) | 12.68% | (1+12%/12)^12)-1) | 
| n = the number of periods in which payments will be made | 20 | |
| PV of annuity= | PMT x (((1-(1 + r) ^- n)) / r) | |
| PV of annuity= | 1000*(((1-(1+12.68%) ^-20)) /12.68%) | |
| PV of annuity= | $ 7,161.00 | |
| Initial loan balance | $50,000.00 | |
| Remaining loan balance | $42,839.00 | 50000-7161 | 
| PV of annuity for making pthly payment | ||
| P = PMT x (((1-(1 + r) ^- n)) / i) | ||
| Where: | ||
| P = the present value of an annuity stream | $ 42,839 | |
| PMT = the dollar amount of each annuity payment | PMT | |
| r = the effective interest rate (also known as the discount rate) | 12.68% | (1+12%/12)^12)-1) | 
| i=nominal Interest rate | 12% | |
| n = the number of periods in which payments will be made | 20 | |
| PV of annuity= | PMT x (((1-(1 + r) ^- n)) / i) | |
| 42839= | PMT x (((1-(1 + 12.68%) ^-20)) / 12%) | |
| Annual payment= | 42839/(((1-(1 + 12.68%) ^-20)) / 12%) | |
| Annual payment= | $ 5,660.59 | |
| Monthly payment= | $ 471.72 |