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.02
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.
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 retirement. You will receive 10 annual payments of $5,000 each beginning in 26 years. If you desire an annual interest rate of 12% compounded monthly, answer the following two questions:
- How much would you be willing to invest today?
- How much would the money (that you will be willing to invest today) be worth at the end of your last payment (i.e., in year 35)?
- Amount that you would be willing to invest today =
PV = $5,000/(1.01)26*12 + $5,000/(1.101)27*12 + $5,000/(1.01)28*12 + $5,000/(1.01)29*12 + $5,000/(1.01)30*12 + $5,000/(1.01)31*12 + $5,000/(1.01)32*12 + $5,000/(1.01)33*12 + $5,000/(1.01)34*12 + $5,000/(1.01)35*12
= $1,388.638
- Amount that would the money worth at the end of your last payment =
FV = $1388.64 * (1+ 0.01)35*12
= $90691.52
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
