On January 1, you win $37,500,000 in the state lottery. The $37,500,000 prize will be paid in equal installments of $6,250,000 over 6 years. The payments will be made on December 31 of each year, beginn on December 31 of this year. If the current interest rate is 6.5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers

On January 1, you win $37,500,000 in the state lottery. The $37,500,000 prize will be paid in equal installments of $6,250,000 over 6 years. The payments will be made on December 31 of each year, beginn on December 31 of this year. If the current interest rate is 6.5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

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
Today is 1/7/2021, John plans to deposit $500 at the beginning of each month into an investment fund. The first deposit will be deposited today. John predicts that the return rate of this fund will be j2=2.23% from 1/7/2021 to 30/9/2021 and j2=4.3% from 1/10/2021 to 31/12/2021. What will be balance amount of this account on 31/12/2021? Round your answer to three decimal places. a. 3032.601 b. 3033.695 c. 3032.335 d. 3031.814
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)?
Today is 1/7/2021, John plans to deposit $500 at the beginning of each month into an investment fund. The first deposit will be deposited today. John predicts that the return rate of this fund will be j2=3.59% from 1/7/2021 to 30/9/2021 and j2=3.93% from 1/10/2021 to 31/12/2021. What will be balance amount of this account on 31/12/2021? Round your answer to three decimal places. Question Answer a. 3034.806 b. 3032.925 c. 3033.446 d. 3033.714
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.