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
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…
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)?
Please answer correct step by step Deferred Annuity: An annuity starts at the end of year 3 and runs for 5 years. The payment amount is $1,000. Interest rate is 9%. Compute the present value of the deferred annuity at time 0. Hint: follow the 4 -step process in the PowerPoint lecture. Round to the nearest $1
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
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.