John won a $45 million lottery today. The payout is the following: John gets $1.5 million today and $1.5 million each year for the next 29 years. How much money worth today for the lottery assuming John’s federal tax rate is 39.6%, state tax is 8.5% and his annual discount rate is 12%?

John won a $45 million lottery today. The payout is the following: John gets $1.5 million today and $1.5 million each year for the next 29 years. How much money worth today for the lottery assuming John’s federal tax rate is 39.6%, state tax is 8.5% and his annual discount rate is 12%?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Related questions

Q: The Caldwell Herald newspaper reported the following story: Frank Ormsby of Caldwell is the…

A: Requirement 1:

Q: Colin has inherited $6,000 from the death of Grandma Anna. He would like to use this money to buy…

A: The Future Value of a lumpsum investment: The future value of a single investment (lumpsum) made now…

Q: Ronnie Cox has just inherited $27,000. How much of this money should he set aside today to have…

A: We know that, PV=FV(1 + r)t PV=$17000 (1 + 0.018)1 PV=$16,699.41

Q: If Tony dies prior to expiration of the 10-year period, will any portion of the remaining payments…

A: No, any portion of remaining payments will not include in Tony’s gross estate under 2033. it is…

Q: Howie Long has just learned he has won a $500,000 prize in the lottery. The lottery has given him…

A: In the given case, the person has won a $500000 prize and has been offered two options: either to…

Q: Marlene won 20 million dollars, but the prize is actually 2 million paid over 10 years. If the…

A: We will make use of the PV function of excel to get the equivalent total amount she would receive…

Q: By the time he turns 60, Justin (just turned age 31) wants the amount in his RRSP to have the…

A: Future Value of an Ordinary Annuity (FVOA): The Future Value of an ordinary annuity refers the…

Q: Your friend is celebrating his 25th birthday today and wants to start saving for his retirement at…

A: Annual withdrawal = $ 100,000 Annual interest rate = 6% Number of withdrawals = 20 As per formula…

Q: Philip just won $100,000 in the lottery! With this money he would like to invest it wisely and put…

A: Given, • We are at December 17, 2021 • Philip is 60 years old and just retired • Philip contributed…

Q: If you put $10,000 into an investment to fund your child's college education in 18 years, how much…

A: Initial investment = $10,000 Period = 18 years Interest rate = 0.1024 Accumulated amount = ?

Q: y that will pay him $ 480000 at the end of each of the next twenty years. Blue Spruce has offered to…

A: The given problem can be solved using RATE function in excel. RATE function computes interest rate…

Q: Donald will receive $450,000 from his trust fund in 20 years from today. He assumes he could get a…

Q: Alex Kelton recently won the jackpot in the Colorado lottery while he was visiting his parents. When…

A: Hence, the present value, in this case, is $100,000,000. The reason being, cash is received today.

Q: Mr. Bates is creating a college investment fund for his daughter. He will putin $850 at the end of…

A: The question is based on the concept of calculation of future value of period fix payment, which is…

Q: Michael Jones plans to save $5,928 every year for the next eight years, starting today. At the end…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: Thomas Finley wishes to become a millionaire. His money market fund has a balance of $183,204 and…

A: A money market fund is mutual fund that invests in liquid financial instruments. These instruments…

Q: Jia has just won a $20 million lottery, which will pay her $1 million at the end of each year for 20…

A: As per the time value of money, a dollar is worth more today than the same dollar in the future.…

Q: Alex Kelton recently won the jackpot in the Colorado lottery while he was visiting his parents. When…

A: Payout Option 1: Receive $100,000,000 in cash today. The present value of $100,000,000 today is…

Q: Your brother invested RM5,000 twenty years ago with an insurance company that paid him 5 percent…

A: Investment = RM 5,000 Time Period = 20 Years Interest Rate = 5%

Q: Ira Schwab wins the lottery and decides to take the one lump sum of$500,000 minus taxes. Ira…

A: The calculation is: Rule 72 tells how much time an investment will take to make the amount double.

Q: James Smith plans to save $4,000 every year for the next eight years, starting today. At the end of…

A: A deposit of $4000 is made every year starting from today. Number of years of investment is 8 and…

Q: You and 11 coworkers just won 6 million 500k each from state lottery, assuming you each receive your…

A: Total coworkers= 12 Lottery amount= 6,000,000 Share of one coworker= 5,00,000 n (Time period)= 19…

Q: Imagine that Homer Simpson actually invested the $160,000 he earned providing Mr. Burns…

A: Future Value: The future value is the amount that will be received at the end of a certain period.…

Q: Kristina just won the lottery, and she mustchoose among three award options. She can elect to…

A: “Hey, since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Q: A man who won 730,000 pesos in a lottery decided to place 50% of his winnings in a trust fund for…

A: A man won a lottery of worth = 730,000 pesos He invested 50% in trust funds for his son education =…

Q: Ronnie Cox has just inherited $27,000. How much of this money should he set aside today to have…

A: the formula for calculating present value = A = P ( 1 + i ) n P = A / ( 1 + i )n A = $18000…

Q: John won the lottery on Monday and can take either $50,000 per year for 20 years, or $500,000 today.…

A: Present Value is the current value of the cash flow that can be occurred in future. To find the…

Q: The multistate Powerball Lottery, worth $182 million, was won by a single individual who had…

A: Annuity refers to series of annual payment which is paid or received at start or ending of specific…

Q: Philip is 60 years old and just retired Philip contributed $4,000 to his TFSA in 2019 Tax-Free…

A: Tax-free savings accounts (TFSAs) are a type of tax-advantaged account available to Canadian…

Q: A few years ago, Michael purchased a home for $298,000. Today the home is worth $440,000. His…

A: A written agreement through which a lender gets the right to take the property that is put as a…

Q: James invests $20,000 on his 25th birthday and plans to add $2,000 to his investment each year until…

A: Investment means engaging your funds to generate income in the future. Interest is a return which is…

Q: Howie Long has just learned he has won a $500,000 prize in the lottery. The lottery has given him…

A: Present Value: The present value is the value of the sum received at time 0 or the current period.…

Q: A college student is reported in the newspaper as having won $10,000,000 in the Kansas State…

Q: After several years of working, Katy has saved $125,000. If she invests that $125,000 in a savings…

A: Investment = $ 125000 Annual interest rate = 4% Period = 15 Years

Q: The winner of a million dollar" lottery is to receive $60,000 plus $60,000 at the end of each year…

A: Given: Amount received at the end of each year (R) =$60000No. of years(n)=39Rate of interest(i)=8%…

Q: A man invested P50,000 now for the college education of his 2-year old son. If the fund earns 14%…

A: Future value can be calculated using FV (rate, nper, pmt, [Pv], [type]) Rate The interest rate Nper…

Q: Gabrielle just won $2.7 million in the state lottery. She is given the option of receiving a of…

A: Here, Annual Payment received is $90,000 Time Period is 30 years Interest Rate is 5% One time amount…

Q: You and 11 coworkers just won 6 million that's 500k each from state lottery, assuming you each…

A: Lottery Prize = $ 6,000,000 No. of person's sharing = 12 Each person's share = 500,000 Amount…

Q: Clarissa wants to fund a growing perpetuity that will pay $10,000 per year to a local museum,…

A: Present value of the growing perpetuity is the amount she needs to fund today This can be calculated…

Q: Howie Long has just learned he has won a $500,000 prize in the lottery. The lottery has given him…

A: After tax of cash flow from Annuity payout (Option #2) = Annuity amount - tax amount = $36000 -…

Q: Kevin won a lottery that will pay him $620000 at the end of each of the next twenty years. Assuming…

A: Present value of annuity = Annuity[1-(1+interest rate)^-time period]/rate

Q: A man invests P10,000 now for the college education of his 2-year old son. If the fund earns 14%…

A: We can define effective interest rate as that rate which has been adjusted for the effect of…

Q: Jackbought a lottery ticket and won €100,000. He wants to finance his newly born daughter and…

A: As per the given information: Amount of deposit - €100,000 Interest rate - 5% Period number of years…

Q: Tatsumi invested Php10,000 now for the college education of his three-year old son. If the fund…

A: First, we compute the Future value of the initial investment. On the basis of this future value, the…

Q: Suppose you want to use this fund to buy a $279,000 houseboat when you retire in 40 years. How much…

A: Future Value = $279,000 Interest Rate = 4.75% Time Period = 40 Years

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

John won a $45 million lottery today. The payout is the following: John gets $1.5 million today and S 1.5 million each year for the next 29 years. How much money worth today for the lottery assuming John's federal tax rate is 39.6%, state tax is 8.5% and his annual discount rate is 12% ? John won a $45 million lottery today. The payout is the following: John gets $1.5 million today and $1.5 million each year for the next 29 years. How much money worth today for the lottery assuming John's federal tax rate is 39.6%, state tax is 8.5% and his annual discount rate is 12%? please show solution in an excel spreadsheetplease show p
You and 11 coworkers just won 6 million 500k each from state lottery, assuming you each receive your share over 19 years and that the state lottery earns 3 percent return on its funds, what is the present value of your prize before taxes if you request up front cash ..
You won the state lottery and took the payout as a $1,823,475 lump sum today. Your spouse has decided that you need to invest this money for the next 9 years and can expect it to earn an average annual rate of return of 8.00%. If this comes to pass, how much money will be in the account at the end of the period?
Melody won a $30 million lottery today. The payout is the following: Melody gets $1 million today and $1 million each year for the next 29 years. Suppose that the discount rate is 6%, how much money worth today for the lottery assuming federal tax rate is 25% and state tax is 8%?
Gabrielle just won $2.7 million in the state lottery. She is given the option of receiving a of $1,200,000 now, or she can elect to receive $90,000 at the end of each of the next 30 years. If Gabrielle can earn 5% annually on her investments, which option should she take? If Gabrielle takes the prize as an annuity, the present value of the 30-year ordinary annuity is? Can you do it in an excel format?
Howie Long has just learned he has won a $500,000 prize in the lottery. The lottery has given him two options for receiving the payments. (1) If Howie takes all the money today, the state and federal governments will deduct taxes at a rate of 46% immediately. (2) Alternatively, the lottery offers Howie a payout of 20 equal payments of $36,000 with the first payment occurring when Howie turns in the winning ticket. Howie will be taxed on each of these payments at a rate of 25%. Assuming Howie can earn an 8% rate of return (compounded annually) on any money invested during this period, compute the present value of the cash flows for annuity payout.
A man who won 730,000 pesos in a lottery decided to place 50% of his winnings in a trust fund for the college education of his son. If the money will earn 14% a year compounded quarterly, how much will the man have at the end of 6 years, when his son will be starting his college education?
Matt recently deposited $41,250 in a savings account paying a guaranteed interest rate of 2.6 percent for the next 10 years. If Matt expects his marginal tax rate to be 22.00 percent for the next 10 years, how much interest will he earn after-tax for the first year of his investment? How much interest will he earn after-tax for the second year of his investment if he withdraws enough cash every year to pay the tax on the interest he earns? How much will he have in the account after 4 years? How much will he have in the account after 7 years?
Jose wants to cash in his winning lottery ticket. He can either receive eight, $6,000 annual payments starting today, or he can receive one lump-sum payment today based on a 3% annual interest rate. What would be the lump-sum payment?
Marcus has won a $6,000,000 state lottery. He can take his prize as either 15 yearly payments of $400,000 or a lump sum of $2,725,000. Which is the better option? Assume an interest rate of 12%.
A man invests P10,000 now for the college education of his 2-year old son. If the fund earns 14% effective, how much will the son get each year starting from his 18th to the 22nd birthday?
Wayne will need $1,250,000 in his retirement fund in 40 years at the time of his retirement. If Wayne can earn 8% annually over this period, how much does Wayne need to save annually to meet that goal? ( Round the answer to the nearest dollar.)