User Account

All Pages

Determine lump sum payment granddaddy mac would receive.

Assignment Help Financial Accounting
Reference no: EM132497153

Background: Granddaddy Mac has come to you for advice. Given his excellent health and desire to spend your inheritance, he has decided to take Tom Selleck's advice and sell his home through a reverse mortgage transaction. According to the terms of the contact, AAG will pay him now, take his home as collateral, and sell it in 20 years when he dies to repay the loan. If the market value of the house exceeds the loan balance in 20 years any excess proceeds will be given to his heirs. Any deficit will be borne by the AAG. The bank has offered him the choice of a lump sum payment now, or 20 annual payments beginning with a $20,000 payment today and 19 additional annual payments growing at 2% per year to compensate for inflation. Granddaddy Mac thinks that he will have a lot more fun with a lump sum payout and is planning a trip to Las Vegas.

Required:

Question 1: Prepare an Excel spread sheet to calculate each annual payment (use the future value formula, $1(1 + i)n) and the total payments Granddaddy Mac will receive. Also, calculate the present value of the payments using Excel's NPV function which assumes payments are made at the end of the period. 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).

Question 2: Assuming a discount rate of 2%, determine the lump sum payment Granddaddy Mac would receive. How do you know this answer is correct?

Question 3: Calculate the lump sum payment assuming discount rates of 1% and 4%.

Question 4: Aside from the fun factor, how should Granddaddy Mac decide between annual payments and a lump sum payment?

Question 5: Assume instead Granddaddy Mac chose to take his payments as an annuity over fifteen years. Use the PMT function in EXCEL to calculate the payments he would receive beginning at the end of year one assuming discount rates of 1%, 2% and 4%.

Reference no: EM132497153

Questions Cloud

What percent of the male offspring will have white eyes : In a cross between a pure bred, red-eyed female fruit fly and a white-eyed male, what percent of the male offspring will have white eyes?
Hijack cellular machinery of their prey : Is a virus a living celland what components are the virus composed and what goal of action is it for viruses to hijack cellular machinery of their prey?
DALT7011 Introduction to Machine : DALT7011 Introduction to Machine Assignment help and solution, Oxford Brookes University - assessment writing service - Evaluate and articulate the issues
Contrast dna and rna in terms of structure and function : Compare and contrast DNA and RNA in terms of structure and function.
Determine lump sum payment granddaddy mac would receive. : Assuming a discount rate of 2%, determine the lump sum payment Granddaddy Mac would receive. How do you know this answer is correct?
How much amortization expense is included in Shamrock income : The trade name has a remaining life of 5 years. How much amortization expense is included in Shamrock income for the year ended December 31, 2019
Make the Income Statement for Car Parts Pty Ltd : Accumulated depreciation-office equipment 2,000. Make the Income Statement for Car Parts Pty Ltd for the year ended 30 June 2019
What is the bonds coupon rate : A fifteen-year bond sells for $832.38 and yields 6.80% APR. What is the bond's coupon rate? Assume semi-annual compounding. Enter coupon rate as decimal.
Record depreciation on building using straight-line : Record depreciation on the building using straight-line depreciation the building was contributed on December 1 for $35,000 and bought some believes

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is the minimum price-accept for an internal transfer

Homer Glen Division has the capacity to make 3,000 units of an intermediate good that is sold both internally and on the open market for a price of $63 each. To make the product, Homer Glen incurs $14 of variable cost per unit and $24 of fixed costs ..

  What is the depreciation expense for the equipment for year

What is the depreciation expense for the equipment for Year 1? (Round your intermediate calculations and final answer to the nearest whole dollar amount.

  Develop the sources and use of funds and plan assumptions

This exercise uses the "Business Plan Financials" MS Excel template. Develop the Sources and use of funds, Plan assumptions and Break-even analysis.

  Is eps growth rate may be different to net income

Is The appropriate risk-free rate for a firm operating in two different countries the average of the risk-free rates of the two countries.

  Vidalia company reported revenues

For the current year, Vidalia Company reported revenues of $250,000 and expenses of $225,000.

  Rent expense and income from lease before taxes

On February 20, 2014, Barbara Brent Inc., purchased a machine for $1,500,000 for the purpose of leasing it. The machine is expected to have a 10-year life, no residual value, and will be depreciated on the straight-line basis. What expense should Rud..

  What is mission of the us government accountability office

What is the mission of the US Government Accountability Office? What role does the GAO play in government? What do the term GAO play mean

  How much are agiles shareholders likely to gain or lose

The synergy created through the combination of Agile and Mobile adds 10 percent to the value of the combined firm. How much are Agile's shareholders likely to gain or lose through this acquisition?

  Discuss the relative nondiversifiable risk of projects

Assume that recent economic events have caused investors to become less risk averse, causing the market return to decline by 2%, to 12%.

  Classify the costs as variable-fixed or mixed costs

In this segment of our continuing cookie company case, you will classify the costs of the business as variable, fixed, or mixed; use the high-low method to evaluate utility costs; and prepare a contribution margin income statement. Review your cookie..

  Adjusting journal entries-preparing adjusted trial balance

Recording four adjusting journal entries and preparing an adjusted trial balance: Mint Cleaning Inc. prepared the following unadjusted trial balance at the end of its second year of operations ending December 31, 2013. To simplify, the amounts are in..

  Prepare a process cost report for the mixing department

Using the FIFO costing method, prepare a process cost report for the Mixing Department for January and explain how the analysis for the Cooking Depart­ment will differ from the analysis for the Mixing Department.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd