Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions