You currently owe $1,000,000 on an outstanding loan. You can afford to pay $50,000 per year back. As you are paying, the remaining balance of the loan that has not been paid will continue to grow at 3% compounded annually.
A. How long will it take to pay the entire loan back and for the balance to be 0?
B. An investor offers to immediately completely pay off your $1,000,000 and in exchange will accept an annual payment for $40,000 from you in perpetuity. What is the IRR for you of accepting this offer instead of paying the loan back on your own, and what is the IRR of the investment for the investor?
A. when all the parameters are fixed (as in this question)
FV = 0 PV = - 1,000,000 PMT = 50,000 I/Y = 3 CPT N --> N = 30.9989 years
And make sure P/Y is set to 1, since compounding is annual. Don’t worry about practicing too much in Quant… you will get a lot of practice with the TMV functions in the Fixed Income section
B. perpetuity needs a formula, not the calculator’s TMV functions
for a perpetuity with interst rates positive PV = a/r