Question: Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per

Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of $100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment account, beginning two years from now and ending the month before he retires. The investment account pays 9 percent compounded monthly. Construct a flexible spreadsheet model to answer the following questions:

1. How much must Stan invest each month to accomplish his retirement goals?

2. If Stan's employer will contribute $0.50 for every $1.00 he invests, how much of the deposit in #1 will Stan have to contribute?

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!

4. Spreadsheet simulation (more advanced): Suppose that stock growth is given by F(X) = aX bX2, where (a = r, b = r/k). Note that steady-state harvest H = E[a/b E/b]. If for simplicity we assume...

Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per year (in monthly installments) from an investment account for a...

Professor Brain is going to work for the next 25 years and then retire. At the end of the 25th year he would like to withdraw $80,000 per year from an investment account until the end of the 50th...

Professor Brain is going to work for the next 25 years and then retire. At the end of the 25th year he would like to withdraw 80,000 per year from an investment account until the end of the 50th year...

need help building this with the following parameters. work: anderson windows. own a home. buy a used car. married with a family of 4 The main task is to create an Excel spreadsheet with your...

6 | Consumer Choices Figure 6.1 Investment Choices Higher education is generally viewed as a good investment, if one can afford it, regardless of the state of the economy. (Credit: modification of...

PLEASE HELP AND PROVIDE EXCEL SPREADSHEET Jimmy Johnson is 25 years old. He and his wife Jane, 27 years old, have two children, Emmitt and Patricia, ages 3 and 5 respectively. Jimmy wants to retire...

Jimmy Johnson is 25 years old. He and his wife Jane, 27 years old, have two children, Emmitt and Patricia, ages 3 and 5 respectively. Jimmy wants to retire in 35 years and build boats. He would like...

In Exercises 1-6, match the equation with one of the graphs (a)-(f), which follow. a. b. c. d. e. 1. x2 + y2 = 5 2. y2 = 20 - x2 3. x2 + y2 - 6x + 2y = 6 4. x2 + y2 + 10x - 12y = 3 5-4-3-2-11 2 3 4 4...

The fine jewellery department in a department store has the same GMROI as the small appliances department, even though characteristics of the merchandise are quite different. Explain this situation.

You need to construct an open - top rectangular box with a square base that must hold a volume of exactly 7 2 5 c m 3 . The material for the base of the box costs 7 cents ? c m 2 and the material for...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Distinguish between the different types of job evaluation and how and when they should be used.

Appreciate the difference between conventional pay systems and broadbanded pay systems.

Appreciate the impact of legal issues on training, learning and development.