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%?

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%?

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: You want to endow a scholarship that will pay $9,000 per year forever, starting one year from now.…

A: PRESENT VALUE OF PERPETUITY FORMULA: PRESENT VALUE =ANNUAL CASHFLOWRATE

Q: In 1940, your gA lottery jackpot of one million is paid out $25,000 a year for 40 years. At a 10…

A: a) using excel PV function to calculate present value of annuity due

Q: Millet wants to provide a P200,000 graduation gift for her daughter Mae who is now 16 years old. She…

A: Present value is the sum of money that must be invested in order to achieve a specific future goal.…

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: A newborn child receives a $9,000 gift toward a college education from her grandparents. How much…

A: As per the given information: Principal amount or amount of money deposited (P) - $9,000 Time period…

Q: Angela has a trust fund that will mature in three years with a value of $15,000. If this trust fund…

A: solution Given Future value $15,000 Period (n) 3 years Interest rate (r) 5%…

Q: John won a $45 million lottery today. The payout is the following: John gets $1.5 million today and…

A: Calculate net amount of lottery as below: Resultant Table: Hence, amount available after tax is…

Q: Suppose that you won $1,500,000 in the Illinois state lottery. It will be paid to you over 20 years…

A: An annuity is end of year equal payments made for a fixed period of time at a specified interest…

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: Jia has just won a $20 million lottery, which will pay her $1 million at the end of each year for 20…

A: The value which shows the equivalent worth of payment that is expected to be realized in future by…

Q: Suppose you just won the state lottery, and you have a choice between receiving $2,679,000 today or…

A: Using Rate function in excel

Q: ou just won the NY State Lottery. The Grand Prize is $275 million. Lottery officials give you a…

A: Upfront payment $ 27,50,00,000.00 Periodic Payment 15000000 Time Period 25 Interest…

Q: You have just won the lottery and will receive $550,000 in one year. You will receive payments for…

A: Receipt in year 1 = $ 550,000 Annual growth rate = 3% Discount rate = 10%

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: Felice Lucas has just won the state lottery and has the following three payout options for…

A: Present value of the first option = Amount receivable at the end of each year x Present value of an…

Q: Please show excel formulas.

A: According to the time value of money, the value of money obtained today is greater than the value of…

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

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

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: Hence, the present value, in this case, is $100,000,000. The reason being, cash is received today.

Q: Holly wants to have $250,000 to send a recently born child to college. She sets up a 529 plan and…

A: Future value (FV) = $ 250,000 Annual interest rate (R) = 6% Number of annual investment (N) = 17…

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: You donate $400,000 to provide annual scholarships in perpetuity. The money is deposited into an…

A: in this we have to find out effective annual interest rate and from that we will get annual…

Q: A recent government study reported that a college degree is worth an extra Php23000 per year in…

A: Compounding is the process in which an asset's earnings, from interest, are reinvested to generate…

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: 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: You have received $200,000 from the PowerBall Lottery and want to have half that amount available…

A: Total lottary amount = $200,000 Amount required at retirement (FV) = $200,000/2 = $100,000 Interest…

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: To pay for your child’s education, you wish to have accumulated $25,000 at the end of 15 years. To…

A: Future Value refers to compounded value of present amount or a series of equal amount of payment…

Q: You have just won $10 million in a provincial lottery, which promises to pay you $2 million…

A: Given Rate = 6% No. of years = 4 years

Q: Your best friend won the state lottery and has offered to give you 500,000 in seven years, after he…

A: Present value of an investment is the trading price at which investment is available to the…

Q: Bill Baxter has $25,000 to invest for a year. He can lend it to his sister, who has agreed to pay…

A: given, simple interest to sister P = $25,000 r= 10% n = 1 retirement plan: P= $25000 r=6% m=4 n=1

Q: The Turners have 10 years to save a lump-sum amount for their child’s college education. Today a…

A: The present value of the annuity is the current worth of a cash flow series at a certain rate of…

Q: You have just received notification that you have won the $3 million first prize in the Centennial…

A: Future Value is $3 million Time Period us 63 years Discount rate is 10% Formula to be used is:-…

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: Brianca plans to save $5,000, $1,000, and $42,000 a year over the next three years, respectively.…

A: Time value It tells that value received today has more value than that of receiving the same amount…

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: money at the end of ten years

A: Future value is the amount of current assets at some future date on the basis of the assumed growth…

Q: Several years ago, an individual won $27 million in the state lottery. To pay off the winner, the…

A: The present value of the annuity is the current worth of a cash flow series at a certain rate of…

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: The winner of a state lottery will receive $5,000 per week for the rest of her life. If the winner’s…

A: Present Value of Annuity = Amount ÷ Rate of Interest

Question

100%

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

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 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 $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 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 ..
Frank just won the lottery! Starting one year from now, he will recieve $66, 000 per year for the next 30 years. If the discount rate is 9%, what is the value of his winnings?
Sima has won the Wisconsin lottery with a jackpot of $10,000,000. She will be paid out in 20 equal annual installments with the first payment made immediately. If she had the money now she could invest it in an account that generates 9% compounded annually. What is the present value of the stream of payments? Present value of the lottery winnings (round up to the nearest dollar):
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?
I solved the problems, but please put the information you provided in an excel spreadsheet to get the answers I have please. 1. 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%? Annual Discount Rate = 12% Annual Income = 1.5 million Annual Federal Tax = 39.6% * 1.5 million = 0.594 million Annual State Tax = 8.5% * 1.5 million = 0.1275 million Annual Net Income = 1.5 million - 0.594 million - 0.1275 million = 0.7785 million Calculate Total Present Value by using the PVOA Formula. Annuity Factor i = 12% ; time = 29 years ; Factor = 8.0218 PVOA = PMT x Annuity Factor = 0.7785 x 8.0218 = 6.244971 million Total PV = Initial Net Income + PVOA = 0.7785 million + 6.244971 million = 7.02 million 2. You are offered the opportunity to put some money away for…
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.
This is the third time submitting this question which is frustrating .... You and 11 coworkers just won 6 million that's 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 ..
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%.
the lottery commission wants to be able to withdraw $400,000 at the beginning of each year for twenty years to cover annual payments due to Randy who won 8 million. How much does the commission need to invest today in an account paying 3.6% compounded annually to provide these payments?
I solved the problem, but please put the information you provided in an excel spreadsheet to get the answers I have please and explain the steps/formula used. 1. 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%? Annual Discount Rate = 12% Annual Income = 1.5 million Annual Federal Tax = 39.6% * 1.5 million = 0.594 million Annual State Tax = 8.5% * 1.5 million = 0.1275 million Annual Net Income = 1.5 million - 0.594 million - 0.1275 million = 0.7785 million Calculate Total Present Value by using the PVOA Formula. Annuity Factor i = 12% ; time = 29 years ; Factor = 8.0218 PVOA = PMT x Annuity Factor = 0.7785 x 8.0218 = 6.244971 million Total PV = Initial Net Income + PVOA = 0.7785 million + 6.244971 million = 7.02 million