Pierre borrowed $100,000 from his grandfather for college expenses. The interest rate is to be 5% annually (and compounded annually). The plan is that he will graduate in four years and start making payments at the end of the fifth year.
a. How much will Pierre owe just before he makes his first payment?
b. If he wants to pay off the loan in 10 years, what would his annual payment be?
c. How long would it take to pay off the loan after he graduates if he pays his grandfather $15,000 annually.
Please refer attached file for better understanding of formulas.
a How much will Pierre owe just before he makes his first payment?
Annual Payment made=PMT=0
Number of periods=NPER=5
Type of payment=0 Year End Payments
Amount at the end of 5th Year=FV=?
We can use FV function in MS Excel to get ...
Solution determines the desired parameters by using the functions in MS Excel.