Comparison of the present value

Assignment Help Finance Basics
Reference no: EM133121270

In our class example, I simplified the "annuity" prize option by assuming level, equal annual payments. Actually, this annuity prize option us now on an annuitized prize payment schedule with 30 beginning of year payments that start at a lower amount with each successive payment being 5% higher than the previous annual payment. The sum of these 30 annuitized payments equals the announced estimated jackpot amount with a lower one-time lump-sum payment (which is the actual cash in the jackpot prize pool) also being available as the Cash Option. The Jan. 28 Mega Millions reported jackpot amount was $421 million which is the undiscounted sum of the 30 annuity option payments or the winner(s) could select the Cash Option of $290.9 million. The first payment under the Annuity Option which would occur immediately is $6,336,654 with 29 additional annual payments with each payment being 5% larger than the previous one. Using this information and assuming you demand a 3% annual return, would you prefer the Annuity Option or the Cash Option if you have the winning ticket? Please include the following to support your decision:

1. A complete schedule of all 30 annual payments (round to nearest dollar) under the Annuity Option.

2. A comparison of the present value of all the payments under the Annuity Option and the present value of the Cash Option.

3. Use the IRR function to find the annual rate of return on the Cash Option vs. the "annuity" payout. Assume you pay the cash option today to receive the annual payments where your initial outflow will be the cash option less the first (t=0) annuity option payment.

4. Your decision.

5. Finally, imagine you select the cash option and buy a 30-year annuity-due that has equal annual payments with a 3% annual rate of return. What annual annuity payment would you receive?

Please use excel to work the problem and show all the formula

Reference no: EM133121270

Questions Cloud

Determine the after-tax cost of the bond : Bisousatoi Corporation needs RM5,000,000 for its business expansion in Singapore. The firm can raise funds by issuing bonds with a 10 percent coupons.
What is the effective annual rate of return : These solar panels will save you $140 a month. What is the effective annual rate of return on this investment?
What is larry accounts receivable turnover : Larry's Lawn Equipment Company gives terms of 2/10, n/30. Larry has annual credit sales of $500,000 and average accounts receivable of $60,000.
What is the ear : Your firm needs to raise some cash for three quarters. It will pay all interest owed at the time of maturity. There are three options available:
Comparison of the present value : In our class example, I simplified the "annuity" prize option by assuming level, equal annual payments. Actually, this annuity prize option us now on an annuiti
What is the present value of new project : a) If Eastern adjusts its debt continuously to maintain a constant debt-equity ratio of 50%, then what is the present value of this new project?
Simple payback period for the option : It will require $4,000 of maintenance per year. The annual utility savings are to be $9,000. What is the simple payback period for the option?
Structural responses of an arbitrary wire : Structural responses of an arbitrary wire - What assumptions are made when deriving the flexure formula for beams? How do these assumptions relate
Give intuitive explanations of theorem : Can you give intuitive explanations of Theorem 2, i.e., it is never optimal to early/premature exercise an American call option on a non-dividend-paying stock?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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!

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