In: Finance
Problem 12.
(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:
Calculator | |
Inputs: | |
PV | (7,000.00) |
PMT | - |
FV | 126,000.00 |
Rate | 8.00000% |
Output: | |
Number of payments | 37.56 |
It takes 37.56 years
Second part:
Payment each period | |
Calculator | |
Inputs: | |
FV | - |
PV | 212,000.00 |
Rate (I/Y) per period | 0.458% |
Term N payments | 360 |
Output: | |
PMT | ($1,203.71) |
Payment is 1,203.71
b
Balance is:
Calculator | |
Inputs: | |
PV | 212,000.00 |
PMT | ($1,203.71) |
Rate (I/Y) | 0.458% |
Term N | 216.00 |
Output: | |
FV | ($126,683.64) |
Balance after 18 years is 126,683.64