On January 1, you win $51,750,000 in the state lottery. The $51,750,000 prize will be paid in equal installments of $5,750,000 over nine years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.Open spreadsheetDetermine the present value of your winnings. Round your answer to the nearest dollar.$ fill in the blank 2

On January 1, you win $51,750,000 in the state lottery. The $51,750,000 prize will be paid in equal installments of $5,750,000 over nine years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.Open spreadsheetDetermine the present value of your winnings. Round your answer to the nearest dollar.$ fill in the blank 2

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Present Value of an Annuity On January 1, you win $1,900,000 in the state lottery. The $1,900,000 prize will be paid in equal installments of $190,000 over 10 years. The payments will be made on December 31 of each year, beginning on December 31. If the current interest rate is 7%, determine the present value of your winnings. Use the present value tables in Exhibit 7. Round to the nearest whole dollar.$fill in the blank 1
The Cooper Foundation contributes $25,000 per year into an annuity fund for building a new zoo. The fund earns 7.5% interest. Find the amount in the fund at the end of 10 years. (Round your final answer to two decimal places.)
I ....-I MY NOTES ASK YOUR TEACHER A state lottery commission pays the winner of the Million Dollar lottery 40 installments of $25,000/year. The commission makes the first payment of $25,000 immediately and the other n = 39 payments at the end of each of the next 39 years. Assume that the balance on deposit with the bank earns interest at the rate of 4%/year compounded yearly. Determine the present value (in dollars) of the 39 future payments. (Round your answer to the nearest cent.) 24 Determine how much money (in dollars) the commission should have in the bank initially to guarantee the payments. (Round your answer to the nearest cent.) 24 MY NOTES ASK YOUR TEACHER The Martinezes are planning to refinance their home. The outstanding balance on their original loan is $125,000. Their finance company has offered them two options. (Assume there are no additional finance charges. Round your answers to the nearest cent.) Option A: A fixed-rate mortgage at an interest rate of 3.5%/year…
Thomas won a lottery that will pay $550000 at the end of each of the next twenty years. Sandhill Finance has offered to purchase the payment stream for $6853000. What interest rate (to the nearest percent) was used to determine the amount of the payment? O 5% O 7% O 6% 8% e Textbook and Media
Alex Meir recently won a lottery and has the option of receiving one of the following three prizes: (1) $94,000 cash immediately, (2) $38,000 cash immediately and a six-period annuity of $9,700 beginning one year from today, or (3) a six-period annuity of $19,600 beginning one year from today. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. Assuming an interest rate of 7%, determine the present value for the above options. Which option should Alex choose?2. The Weimer Corporation wants to accumulate a sum of money to repay certain debts due on December 31, 2030. Weimer will make annual deposits of $190,000 into a special bank account at the end of each of 10 years beginning December 31, 2021. Assuming that the bank account pays 8% interest compounded annually, what will be the fund balance after the last payment is made on December 31, 2030?
On January 1 you win $3,480,000 in the state lottery. The $3,480,000 prize will be paid in equal installments of $290,000 over 12 years. The payments will be made on December 31 of each year, beginning on December 31. If the current interest rate is 7%, determine the present value of your winnings. Use the present value tables in Exhibit 7. Round to the nearest whole dollar.
You just won a special lottery which will entitle you to an annual payment $45000 for 10 years, but the first payment won't start until 5 years later (i.e. 1st payment at the end of the 5th year). If you plan to immediately deposit every payment into an annuity product that gives you 5.62% APR with annual compounding, how much is your account balance at the end of the lottery payment plan (i.e. when you receive the last payment)?
A winner of the multi-state lotto won a one-time payout and decided to invest part of it into an annuity. If the winner invests $9,500,000.00 into a 30 year annuity that pays 3.1%, compounded monthly and makes each month payments. What is the amount of each month payments? The payment would be $ .(Round to 2 decimal places.) Submit Question b Payo... Confirm Permissions
You like to buy lottery tickets every week. The lottery pays an insurancecompany that pays the winner an annuity. If you win a $60,000,000 lotteryand elect to take an annuity, you get $3,000,000 per year at the beginningof each year for the next 20 years.a. How much must the state pay the insurance company if money can earn3 percent?b. How much interest is earned on this lump-sum payment over the 20 years?c. If you take the cash rather than the annuity, the state pays you $30,000,000in one lump sum today. You must pay 40 percent of this in taxes. If you arecurrently working and invest this money at 6 percent, how much moneywill you have in a mutual fund at the end of 20 years?d. Are you better off with the annuity, or should you take the cash? Explain.

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS