In: Accounting
Problem 12. Show your work!
(a) Cersei wants to set up a college fund for her son Tommen. Investments deposited at the Iron Bank of Braavos earn 8% interest per year, compounded quarterly. If Cersei invests $7000 with the Iron Bank of Braavos, how long will it take her investment to be worth $126 000?
(b) Cersei also take out a $212 000 mortgage to buy a home in King’s Landing, amortizing it over 30 years at 5.5%, compounded monthly.
(a) What are her monthly payments?
(b) What is the remaining principal after 18 years?
First:
| Payments to achieve future value | N= | Log(FV/PV)/ Log(1+r) |
| Future value | FV= | 126,000 |
| Present value | PV= | 7,000 |
| Interest rate: | ||
| Stated rate | 8.0% | |
| / number of compounding periods per year | 1 | |
| Interest rate per period | r= | 8% |
| Periods to achieve future value | N= | Log( 126000/7000 )/ Log( 1+ 0.08 ) |
| N= | 37.56 |
Second
a
| Monthly payment | = | [P × R × (1+R)^N ] / [(1+R)^N -1] | |
| Using the formula: | |||
| Loan amount | P | $ 212,000 | |
| Rate of interest per period: | |||
| Annual rate of interest | 5.500% | ||
| Frequency of payment | = | Once in 1 month period | |
| Numer of payments in a year | = | 12/1 = | 12 |
| Rate of interest per period | R | 0.055 /12 = | 0.4583% |
| Total number of payments: | |||
| Frequency of payment | = | Once in 1 month period | |
| Number of years of loan repayment | = | 30.00 | |
| Total number of payments | N | 30 × 12 = | 360 |
| Period payment using the formula | = | [ 212000 × 0.00458 × (1+0.00458)^360] / [(1+0.00458 ^360 -1] | |
| Monthly payment | = | $ 1,203.71 |
b
| Loan balance | = | PV * (1+r)^n - P[(1+r)^n-1]/r |
| Loan amount | PV = | 212,000.00 |
| Rate of interest | r= | 0.4583% |
| nth payment | n= | 216 |
| Payment | P= | 1,203.71 |
| Loan balance | = | 212000*(1+0.00458)^216 - 1203.71*[(1+0.00458)^216-1]/0.00458 |
| Loan balance | = | 126,683.64 |