In: Finance
4. Joe Levi bought a home in Arlington, Texas, for $127,000. He put down 25% and obtained a mortgage for 30 years at 8.00%. What is the difference in interest cost if he had obtained a mortgage rate of 6.00%? (Use Table 15.1.) (Use 360 days a year. Round your intermediate values and final answer to the nearest cent.) Difference $
| Step-1: | Calculation of Interest costs at 8% | ||||||||||||
| a. | Monthly Payment | $ 699.18 | |||||||||||
| Working: | |||||||||||||
| i. | Present Value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | |||||||||
| = | (1-(1+0.00667)^-360)/0.00667 | i | 8%/12 | = | 0.00667 | ||||||||
| = | 136.2317 | n | 30*12 | = | 360 | ||||||||
| ii. | Cost of house | $ 1,27,000 | |||||||||||
| Down Payment | $ 31,750 | ||||||||||||
| Mortgage amount | $ 95,250 | ||||||||||||
| iii. | Monthly Payment | = | Mortgage Amount/Present value of annuity of 1 | ||||||||||
| = | $ 95,250 | / | 136.2317 | ||||||||||
| = | $ 699.18 | ||||||||||||
| b. | Total Interest costs | $ 1,56,453.50 | |||||||||||
| Working: | |||||||||||||
| Total Payment | = | $ 699.18 | x | 360 | = | $ 2,51,703.50 | |||||||
| Mortagage Amount | $ 95,250 | ||||||||||||
| Total Interest Costs | $ 1,56,453.50 | ||||||||||||
| Step-2: | Calculation of Interest costs at 6% | ||||||||||||
| a. | Monthly Payment | $ 571.07 | |||||||||||
| Working: | |||||||||||||
| i. | Present Value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | |||||||||
| = | (1-(1+0.005)^-360)/0.005 | i | 6%/12 | = | 0.005 | ||||||||
| = | 166.7916 | n | 30*12 | = | 360 | ||||||||
| ii. | Cost of house | $ 1,27,000 | |||||||||||
| Down Payment | $ 31,750 | ||||||||||||
| Mortgage amount | $ 95,250 | ||||||||||||
| iii. | Monthly Payment | = | Mortgage Amount/Present value of annuity of 1 | ||||||||||
| = | $ 95,250 | / | 166.7916 | ||||||||||
| = | $ 571.07 | ||||||||||||
| b. | Total Interest costs | $ 1,10,335.88 | |||||||||||
| Working: | |||||||||||||
| Total Payment | = | $ 571.07 | x | 360 | = | $ 2,05,585.88 | |||||||
| Mortagage Amount | $ 95,250 | ||||||||||||
| Total Interest Costs | $ 1,10,335.88 | ||||||||||||
| Step-3:Calculate difference in Interest Costs | |||||||||||||
| Interest Costs at 8% | $ 1,56,453.50 | ||||||||||||
| Interest Costs at 6% | $ 1,10,335.88 | ||||||||||||
| Difference in interest costs | $ 46,117.62 | ||||||||||||