Grandma nelly has come to you for advice given her

Reference no: EM13572162

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's NPV function. Using your spreadsheet, answer each of the following questions in the spaces provided. In order to receive full credit for your answers, you must attach a copy of your spreadsheet printed with the formulas showing ("Show Formulas" option).

1. Assuming a discount rate of 3%, determine the lump sum payment Grandma Nelly would receive. How do you know this answer is correct?

2. Calculate the lump sum payment assuming discount rates of 2% and 6%.

3. Aside from the fun factor, how should Grandma Nelly decide between annual payments and a lump sum payment?

4. If the discount rate is 3% how much will the house have to be worth when Grandma Nelly dies in 15 years for the bank to recoup its investment? You can do this calculation by hand.

Reference no: EM13572162

Questions Cloud

List at least three common miscellaneous itemized : list at least three common miscellaneous itemized deductions and explain why these expenses can not be deducted

Division p of turbo corporation has the capacity for making : division p of turbo corporation has the capacity for making 75000 wheel sets per year and regularly sells 60000 each

It ended the year with 187500 of retained earnings versus : during 2009 pfizer paid out 52500 of common dividends. it ended the year with 187500 of retained earnings versus the

Based on a comparison of their net present values and : a company is considering two alternative investment opportunities each of which requires an initial cash outlay of

Grandma nelly has come to you for advice given her : grandma nelly has come to you for advice. given her excellent health and desire to spend your inheritance she has

If the stock sells for 36 per share what is your best : stock in dragula industries has a beta of 1.2. the market risk premium is 6 percent and t-bills are currently yielding

The intrinsic value of a warrant to buy 5 shares of dawn : the intrinsic value of a warrant to buy 5 shares of dawn stoneworks stock at 70 per share is 25. what is the current

Today the internet provides an unprecedented amount of : critiquing internet sourcestoday the internet provides an unprecedented amount of information by way of blogs videos

A company expects its three departments to yield the : a company expects its three departments to yield the following income for next year.dept. adept. bdept.

User Account

All Pages