Melisandre wins the lottery! She has a choice between Option A: $23,000,000.00 received today. Option B:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Melisandre wins the lottery! She has a choice between Option A: $23,000,000.00 received today. Option B: 12 payments of $2,949,840.58 at the start of every year for 12 years, with the first payment today. The nominal annual interest rate is i(1) = 10.000%. Melisandre wants you to advise them which option to choose. a) Build a spreadsheet (see the posted example) to compare the present value of the 2 options. Which would you recommend? b) Suppose instead you assumed they would never spend any of the money, instead saving it all until the time of the last payment of Option B. Find the future value of both options at this time. Would this calculation change your recommendation? c) If the interest rate were i(1) = 5.000% instead, would that change which option you recommend? d) Obviously there is some interest rate i(1) at which the present value of the two options is the same. Find that value (accurate to 3 decimal places, e.g. 3.456%) using either trial and error or goal seek. (Warning: if you are using trial and error using only 3 decimal places for the interest rate, the present values you compute might not match exactly!) 1 TT A▾ B I S ..2 = E B $$ ! Melisandre wins the lottery! She has a choice between Option A: $23,000,000.00 received today. Option B: 12 payments of $2,949,840.58 at the start of every year for 12 years, with the first payment today. The nominal annual interest rate is i(1) = 10.000%. Melisandre wants you to advise them which option to choose. a) Build a spreadsheet (see the posted example) to compare the present value of the 2 options. Which would you recommend? b) Suppose instead you assumed they would never spend any of the money, instead saving it all until the time of the last payment of Option B. Find the future value of both options at this time. Would this calculation change your recommendation? c) If the interest rate were i(1) = 5.000% instead, would that change which option you recommend? d) Obviously there is some interest rate i(1) at which the present value of the two options is the same. Find that value (accurate to 3 decimal places, e.g. 3.456%) using either trial and error or goal seek. (Warning: if you are using trial and error using only 3 decimal places for the interest rate, the present values you compute might not match exactly!) 1 TT A▾ B I S ..2 = E B $$ !
Expert Answer:
Answer rating: 100% (QA)
a Using a spreadsheet to calculate the present value of the two options we get Option A PV 23000000 ... View the full answer
Related Book For
Financial Accounting An Integrated Statements Approach
ISBN: 978-0324312119
2nd Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren
Posted Date:
Students also viewed these finance questions
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
1.Alice is your long-term friend from high school. Alice was typically quieter in the group, but she was well liked amongst your peers. In high school she began to come out of her shell a little...
-
Why is the Sharpe ratio frequently referred to as a 'risk-adjusted' measure of performance?
-
Identify the curve by finding a Cartesian equation for the curve. r 2 = 5
-
Financial Globalization. Explain the twin agency problems. How do the twin agency problems limit financial globalization?
-
For several years Fister Links Products has held shares ofMicrosoftcommon stock, considered by the company to be securities available-for-sale. The shares were acquired at a cost of $500,000. Their...
-
Listen Complete the truth table for the given statement by filling in the required columns. ~PAQ P ~P T T T F. F LL F TF T F 1) P 9 ~ T F F T F F T F T T T F F T F
-
You are discussing your 401(k) with Dan Ervin when he mentions that Sarah Brown, a representative from Bledsoe Financial Services, is visiting East Coast Yachts today. You decide that you should meet...
-
How would you implement the ideas within ACHE's 2016 statement into Figure 2.1: The Decision Quality Chain found in Ch. 2, "The Requirements for Decision Quality," of" Decision Quality: Value...
-
Given what you learned in this class, explain what is the most significant issue to consider in "rethinking" homeland security intelligence (and why).?
-
Dividend Yield and Dividend Payout The following information is available for West Texas Waste Management Inc. (WTWM). Year 1 Year 2 Year 3 Dividends per share $0.03 $0.06 $0.12 1.07 1.28 1.41...
-
A pulsar is a type of rotating neutron star that emits a beam ofelectromagnetic radiation. Imagine a pulsar that is moving towardEarth at a speed of 740.00 km/s. It emits mostly radio waves with...
-
The controversy over government monitoring of citizens' phone and email communications is a complex issue that touches on fundamental rights, national security, and technological capabilities. My...
-
Find the final value, correct to 2 places of decimals, of 3 0 0 0 invested for 1 0 years at an annual equivalent rate ( AER ) of 3 % .
-
Kluth Corporation has two manufacturing departments--Molding and Customizing. The company used the following data at the beginning of the year to calculate predetermined overhead rates: Estimated...
-
If a process has a six-sigma capability, what is the process capability index? a. 1 b. 2 c. 6 d. 12
-
Several years ago, your brother opened Chestnut Television Repair. He made a small initial investment and added money from his personal bank account as needed. He withdrew money for living expenses...
-
The following were selected from among the transactions completed by Girder Company during November of the current year: Nov. 3 Purchased merchandise on account from Whiting Co., $20,000, terms FOB...
-
Rocky Mountain Interiors deposits all cash receipts each Wednesday and Friday in a night depository after banking hours. The data required to reconcile the bank statement as of May 31 have been taken...
-
Oswego Corporation reported net income $24,000; net sales $400.000; and average assets \($600,000\) for 2002. What is the 2002 profit margin? (a) 6%. (b) 12%. (c) 40%. (d) 200%.
-
Which measure is an evaluation of a company's ability to pay current liabilities? (a) Acid-test ratio. (b) Current ratio. (c) Both (a) and (b). (d) None of the above.
-
Which of the following is generally not considered to be a limitation of financial analysis? (a) Use of ratio analysis. (b) Use of estimates. (c) Use of cost. (d) Use of alternative account- ing...
Study smarter with the SolutionInn App