Question

Rita Gonzales won the $80 million lottery. She is to receive $2.4 million a year for the next 30 years plus an additional lump sum payment of $8 million after 30 years. The discount rate is 12 percent.

What is the current value of her winnings? Use Appendix B and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.)




1012334445556666677777888 797 701 879 59 45 95 4 3 6 6 2 2 1 5 4 7 295 1481 10-2. 3 3 4 4 5 5 6 6 6 7 7 7 7 8 8 8 89999 1 012334555667778888899000 770 99753 80-2. 3 3 4 5 5 6 6 7 7 7 8 8 8 9 9 9 9 0 1 1 1 5 4 1 2 3 4 4 5 5 6 7 7 7 8 8 9 9 9 0 0 0 1 2 3 3 3527 2 1477 60-2. 3 4 4 5 6 6 7 7 8 8 99000112355 7 5012345567788990011224578 2 173 40 1. 2 3 4 5 6 6 7 8 8 9 . 0 1 1 2 2 3 3 5 791 2 30-2. 3 4 5 6 7 7 8 9 9 0 1 1 2 33447935 5 8 .7 6 4 3 1975 6 7 8 8 9 0 1 2 3 18529635334 012345 2344569 271 2 4321 -0. 1 2 3 4 5 6 7 8 9 0 1 2 3 34567825 32 39 1234567890123456789

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. B 1 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells EC521 DW DX STEP 1 DY DZ EA EB EC ED 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 /4 | CALCULATOR .. LOAN OPTIONS PRESENT VALUE OF ANNUITY OF 2.4 MILLION FOR 30 YEARS 2.4 30 12% PMT YEARS RATE 19.33 EXCEL PV(DZ610,DZ609,-DZ608) (IN MILLIONS) 19332441.52 STEP 2 PRESENT VALUE OF 8 MILLION AFTER 30 YEARS FV YEARS RATE 30 12% 0.27 EXCEL PV(DZ619,DZ618,-DZ617) (IN MILLIONS) 267023.39 ANSWER PRESENT VALUE - PRESENT VALUE- 19.60 (IN MILLIONS STEP 1 +STEP 2 19599464.91 STEP 1+STEP 2 CAP STRU VALUE BOX DILUTION. DOLLAR COST AVG MORTGAGE / EXPO Sheet1 . Sheet2. Sh41- rences: x261 福 130% 08:20 01-02-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard AY235 AO Alignment Number Cells Edting AQ AR AS AT AU AV AW AX AY BA 219 220 221 USING CALCULATOR STEP 1 PMT 2.4 30 12 RATE 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 4 CALCULATOR 19.33 IN MILLIONS OR PV 19332441.52 STEP 2 FV 30 RATE 12 0.27 267023.39 OR PV ANSWER: PRESENT VALUE 19599464.91 STEP 1+STEP 2 BOX DILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2 Shel 福 130% AN OPTIONS fv. ann CAP STRU VALUE 01-02-2019

Add a comment
Know the answer?
Add Answer to:
Rita Gonzales won the $80 million lottery. She is to receive $2.4 million a year for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Rita Gonzales won the $62 million lottery. She is to receive $2.8 million...

    Rita Gonzales won the $62 million lottery. She is to receive $2.8 million a year for the next 20 years plus an additional lump sum payment of $6 million after 20 years. The discount rate is 14 percent. What is the current value of her winnings? Use Appendix B and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Present...

  • Rita Gonzales won the $47 million lottery. She is to receive $1.2 million a year for...

    Rita Gonzales won the $47 million lottery. She is to receive $1.2 million a year for the next 30 years plus an additional lump sum payment of $11 million after 30 years. The discount rate is 6 percent. What is the current value of her winnings?

  • Rita Gonzales won the $47 million lottery. She is to receive $2.7 million a year for...

    Rita Gonzales won the $47 million lottery. She is to receive $2.7 million a year for the next 15 years plus an additional lump sum payment of $6.5 million after 15 years. The discount rate is 10 percent. What is the current value of her winnings? Use Appendix B and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods.(Do not round intermediate calculations. Round your final answer to 2 decimal places.)...

  • Rita Gonzales won the $41 milion lottery. She is to receive $1.8 million a year for...

    Rita Gonzales won the $41 milion lottery. She is to receive $1.8 million a year for the next 15 years plus an additional lump sum payment of $14 million after 15 years. The discount rate is 11 percent. What is the current value of her winnings? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Present value = _______ 

  • Christy Reed made a $2,400 deposit in her savings account on her 21st birthday, and she...

    Christy Reed made a $2,400 deposit in her savings account on her 21st birthday, and she has made another $2,400 deposit on every birthday since then. Her account earns 10 percent compounded annually. How much will she have in the account after she makes the deposit on her 32nd birthday? Use Appendix C for an approximate answer, but calculate your final answer using the formula and financial calculator methods. (Do not round intermediate calculations. Round your final answer to 2...

  • Please show work and use this chart if needed: Blums Inc. expects its operating income over the coming year to equal $3 million, with a standard deviation of $500,000. Its coefficient of variation i...

    Please show work and use this chart if needed: Blums Inc. expects its operating income over the coming year to equal $3 million, with a standard deviation of $500,000. Its coefficient of variation is equal to 0.15.Blums must pay interest charges of $2m next year and preferred stock dividends of $100,000. Blums' marginal tax rate is 40 percent. Assume that operating income is normally distributed.) Use Table V to answer the question What is your loss level EBIT?$ Round your...

  • A recent issue of the AARP Bulletin reported that the average weekly pay for a woman with a high school degree is $520. Suppose you would like to determine if the average weekly pay for all working w...

    A recent issue of the AARP Bulletin reported that the average weekly pay for a woman with a high school degree is $520. Suppose you would like to determine if the average weekly pay for all working women is significantly greater than that for women with a high school degree. Data providing the weekly pay for a sample of 50 working women are available in the file named WeeklyPay. These data are consistent with the findings reported in the AARP...

  • The initial investment for this project will be $2.4 million. This amount is for depreciable equipment,...

    The initial investment for this project will be $2.4 million. This amount is for depreciable equipment, which will be depreciated over 4 years using the straight-line method to zero book value. A working capital investment of $300,000 will also be made at the beginning of the project (Time T=0). The entire working capital investment will be recovered at the end of the project. Initial marketing studies suggest that Earnings before Depreciation and Taxes for 6 years will be as shown...

  • JKL Co. reported the following information for the year 2018: (1) Net income is €210 million....

    JKL Co. reported the following information for the year 2018: (1) Net income is €210 million. (2) Acquisitions were €32 million. (3) Customer accounts receivable increased by €12 million. (4) Dividends paid to common shareholders were €8 million. (5) Depreciation expense was €41 million. (6) Income tax payable decreased by €11 million. (7) Long-term debt increased by €28 million. (8) Accounts payable decreased by €6 million. (9) Inventories increased by €17 million. Based on the above information, calculate the following...

  • 1-What are the components of the Tax Formula? 2-Rita, age 45, earned a salary of $85,000...

    1-What are the components of the Tax Formula? 2-Rita, age 45, earned a salary of $85,000 in the current year. She contributed $4,000 to her traditional Individual Retirement Account (IRA), sold stock held as an investment for a short-term capital loss of $3,000, and paid $5,400 in alimony to her ex-husband (divorce finalized 2018). Determine her Adjusted Gross Income (AGI).? 3. What IRS Form do you file with the Tax Formula? 4. What is Gross Income? 5. What is accrual...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT