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

can you please do these three question on excel. all of them 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 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!