Question: can you please do these three question on excel. all of them M N 0. You won the lottery. It will pay you $50,000 per
M N 0. You won the lottery. It will pay you $50,000 per year for 20 years. Did you really win 1 million dollars? Why or why not? What is the amount you have won? You put away $2,000 per year into an IRA for 40 years. How much can you receive from the IRA each year for the 20-year period that follows your retirement? Assume k = 14%. Answer $405,254 You are 35 years old today and are considering your retirement needs. You expect to retire at 65, and your actuarial tables suggest that you will live to be 100. You what to move to the Bahamas when you retire. You estimate that it will cost you $300,000 to make the move on your sixty-fifth birthday) and that your living expenses will be $105,000 a year during your retirement. You expect to carn 12% on your money during the savings period and 8% during retirement. At the end of your retirement, you expect to have a zero balance in your retirement fund. You already have $50,000 in your fund. How much would you need to save each year for the next 30 years to be able to afford this retirement? Answer: S106.63
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
