User Account

All Pages

Determine the discount rate used by the multi-state lottery

Assignment Help Financial Accounting
Reference no: EM131816660

Required: On March 17, 2016 you won $527.25 million in the Powerball Lottery. The Multi- State Lottery Association gave you the choice of 30 equal annual payments with the first payment of $17.575 million due on the day you claimed your prize. The remaining 29 payments follow at one year intervals. Alternatively, you can elect to take as a lump sum payout on the day you claim your prize.

Required:

1. In general, how would you decide between future annual payments and a lump sum payout?

2. Determine the lump sum payout that you would be offered if the Multi-State Lottery association uses a discount rate of 4%.

3. Assuming that the total payments remain unchanged, would you prefer that the payments increase, decrease or remain constant through time? Explain your response.

4. Assume instead the Lottery has offered you a payment of $21.7 million on the day you claim your prize and 19 additional payments at one year intervals each increasing by 2%. Prepare an Excel spread sheet to answer the following questions. In order to receive credit for your answers, you must attach a copy of your spreadsheet using the "show formulas" option. You must also use Excel's NPV function to calculate the present values.

a. Calculate the 19 additional annual payments using the future value formula.

b. Assuming a discount rate of 2%, calculate the lump sum payout you would receive. How do you know this answer is correct?

c. Assuming a discount rate of 4% determine the lump sum payout.

d. Assuming a discount rate of 8% determine the lump sum payout.

e. Assuming the Multi-State Lottery Association offer you a lump sum payout of million, determine the discount rate used by the Multi-State Lottery Association to compute the payout. Round your answer to the nearest percent.

Reference no: EM131816660

Questions Cloud

Identify potential costs for each component for development : (1) upgrading to Version 3 of the current software, (2) licensing the open source software, and (3) licensing another vendor's thin-client software.
Compute the gain or loss on the sale : On January 2, 2011, Kinnaird Hospital purchased a $103,150 special radiology scanner from Faital Inc. Compute the gain or loss on the sale
What is the maximum amount that joint costs can increase : What is the maximum amount that joint costs can increase before (a) it would not be better to process chewing tobacco further into premium chewing tobacco.
Find the proportions of hate crimes motivated : Find the proportions of hate crimes motivated by the victim's sexual orientation for white and for black offenders and tell which is higher.
Determine the discount rate used by the multi-state lottery : Calculate the 19 additional annual payments using the future value formula and How do you know this answer is correct
Comparing a variety of percentages : The New York Times reported in 2004 on the "Values Gap" in the United States by comparing a variety of percentages. For example, the number of divorces
Explain the concepts of current and long-term liabilities : Explain the concepts of current and long-term liabilities and give a total of at least five examples of both current and long-term liabilities consisting
Specify the maximum cardinalities for each relationship : The partial E-R diagram in Figure is for a sales order. Assume there is only one Salesperson per SalesOrder.
What proportion of all americans were institutionalized : a. The U.S. population in 1949 was about 150,000,000. What proportion of all Americans were institutionalized at that time?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate degree of operating leverage for both companies

Calculate the degree of operating leverage for both companies. Calculate the break-even point in $ for each company. Which company has the higher break-even point? Why?

  The converged standard on revenue recognition

The converged standard on revenue recognition

  Calculate book value per share of common stock

Wicom's financial statements as of December 31, 2006. Calculate book value per share of common stock. Assume that the company also had $1,000,000 worth of convertible bonds. The bonds are convertible at one $1,000 bond into 150 shares of stock.

  Prepare a statement of cash flows for company

ACCT160 - FINANCIAL ACCOUNTING ASSIGNMENT. Data for Rajesh Company are presented in Case Study 2. Further analysis reveals the following. Accounts payable pertain to merchandise suppliers. All operating expenses except for depreciation were paid in c..

  What is the free cash flow

XWY Company had the following info regarding their accounts. Increase in accounts receivable of $10,200; decrease in supplies of $3,100; gains on sale of equipment of $7,400; losses on sales of equipment of $630; net income of $63,150; increase in ac..

  General building supplies to building contractors

Carter Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: o Sales are budgeted at $380,000 for November, $390,000 for December, and $400,000 for J..

  Prepare a determination and distribution of excess schedule

Prepare a determination and distribution of excess schedule for the investment (a value analysis is not needed). Prepare all the eliminations and adjustments that would be made on the 20X1 consolidated worksheet.

  What is p and g accounting policy related to advertising

What is P&G's accounting policy related to advertising? What accounting principle does P&G follow regarding accounting for advertising? Where are advertising expenses reported in the financial statements?

  Show the relevant accounts including final accounts

maintain a provision for discount@3% on debtors, maintain a provision for bad debts@15% on debtors,required pass the necessary journal entries and show the relevant accounts including final accounts?

  Income statement of tkachuk corporation

The stockholders’ equity section of Tkachuk Corporation appears below as of December 31, 2014. 8% preferred stock, $50 par value, authorized 100,754 shares, outstanding 90,754 shares $4,537,700 Common stock, $1.00 par, authorized and issued 10.40 mil..

  Write a paper on business structures

Write a paper on Business Structures - Types of business structures that a person or persons choose from to start their business

  Prepare schedule of cost of good manufactured for year ended

Data for Brinley Company for the current fiscal year ended June 30, 20-2, are shown below. Prepare a schedule of cost of goods manufactured for the year ended June 30, 20-2.

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