Background: Grandma Nelly has come to you for advice. Given her excellent health

Question

Background:Grandma Nelly has come to you for advice. Given her excellent health and desire to spend your inheritance, she has decided to sell her home through a reverse mortgage transaction. According to the terms of the contact, the bank will pay her now, take her home as collateral and sell it in 15 years when she dies to repay the loan. If the market value of the house exceeds the loan balance in 15 years any excess proceeds will be given to her heirs. Any deficit will be borne by the bank. The bank has offered her the choice of a lump sum payment now, or 15 annual payments beginning with a $15,000 payment today and 14 additional annual payments growing at 3% per year to compensate for inflation. Grandma Nelly thinks that she will have a lot more fun with a lump sum payout.

Required:Prepare an Excel spread sheet to calculate each annual payment (use the future value formula) and the total payments Grandma Nelly will receive. Also, calculate the present value of the payments using Excel

Explanation / Answer

1)$225000 as inflation in payments is off set by discount rate, lumpsum = 15*15000

2)with 2% discount rate PV=15000 + 15000*1.03/1.02 +15000*1.03^2/1.02^2 +............+ 15000*1.03^14/1.02^14=$258480.78

with 6% discount rate PV=15000 + 15000*1.03/1.06 +15000*1.03^2/1.06^2 +............+ 15000*1.03^14/1.06^14=$195206.03

3)based on PV the payment method should be decided i.e one with high PV

4)$278983 by calculating future value

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.