Question: how much should he be saving and saved by the time he retires with a similar lifestyle? Show by using the Decision support system(excel) 40

how much should he be saving and saved by the time he retires with a similar lifestyle? Show by using the Decision support system(excel)

40 years old men

yearly income of 120000

will retire at 65

current savings for retirement is 100000

work add 11000 per year to his fund for retiring in addition to his 8000 contributions per year

don't worry about taxes or other fee

Inflation rate3.8%
% Replacement

80%

Draw Down Rate4%
Saving Premium5%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

He should be saving and have saved 856000 by the time he reti... View full answer

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 Accounting Questions!

Q:

Three different design configurations are being considered for a particular component. There are four possible failure modes for the component. An engineer obtained the following data on number of...

Q:

Sheridan Paintball records adjusting entries on an annual basis. The company has the following information available on accruals that must be recorded for the year ended June 30, 2021. 1. Sheridan...

Q:

Refer to the Retirement Planning case. Review the problem statement and influence chart that were generated for this case in conjunction with the corresponding exercise in Chapter 2. (If this has not...

Q:

1. On July 14, Peterman Corporation exchanged 1,000 shares of its $8 par value common stock for a plot of land. Petermans common stock is listed on the NYSE and traded at an average price of $21 per...

Q:

Douglas Boats is a supplier of boating equipment for the states of Oregon and Washington. It sells 5,000 White Marine WM-4 diesel engines every year. These engines are shipped to Douglas in a...

Q:

Calculate the following: a. Suppose a 65-year-old person wants to purchase an annuity from an insurance company that would pay $ 20,000 per year until the end of that persons life. The insurance...

Q:

Jasper Valley Motors (JVM) is a family-run auto dealership selling both new and used vehicles. In an average month, JVM sells a total of 160 vehicles. New vehicles represent 60 percent of sales, and...

Q:

Solve various time value of money scenarios (Learning Objectives 3, 4) 1. Curt just hit the jackpot in Las Vegas and won $50,000! If he invests it now at a 10% interest rate, how much will it be...

Q:

Presented below are four independent situations. (a) On December 31, 2011, Beard Inc. sold computer equipment to Barber Co. and immediately leased it back for 10 years. The sales price of the...

Q:

You are considering a 10-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semiannually. If you require an effective annual interest rate (not a nominal rate) of 8.16%, how...

Q:

Identify which adjustments are required to profit after tax to determine basic earnings and headline earnings?

Q:

Repeat Problem 3, but change it as follows. Fred and Barney each have an additional option: to withdraw from the negotiations. If either one withdraws, he receives a payoff of $1.50. Everything else...

Q:

find the derivative o f y = 1 3 x + 2 t 1 + t 3

Q:

We wish to implement a dictionary by using direct addressing on a huge array. At the start, the array entries may contain garbage, and initializing the entire array is impractical because of its...

Q:

Now suppose this project has an investment timing option, since it can be delayed for a year. The cost will still be $70 million at the end of the year, and the cash flows for the scenarios will...

Q:

Use decision tree analysis to calculate the NPV of the project with the investment timing option. MINI CASE Assume that you have just been hired as a financial analyst by Tropical Sweets Inc., a...

Q:

Give an example of a directed graph G = (V, E), a source vertex s V, and a set of tree edges E E such that for each vertex v V, the unique path in the graph (V, E ) from s to v is a shortest path...

Q:

The column is used to support the upper floor. If the force F is removed from the handle of the jack, determine if the screw is self-locking.. The square-threaded screw on the jack has a coefficient...

Q:

solve The manager at Fry's wants to know if there are enough cart returns in their parking lot. She decides to spend an entire day watching the parking lot to track what happens to shopping carts....

Q:

question1 1a. This problem continues using the data and description for the Oxford comma. Assuming that this is a random sample that is representative of the population, focus on the variables:...

Q:

Part 1: Make a Pareto chart of the complaint data showing the frequencies and cumulative percentages. The complaint categories are: too much time in line, food cold, no vegetarian choice, not enough...

Q:

Q1: Budgets and Variance Analysis Jackson Company manufactures electric Heat Pump and uses standard costing. The company prepared its budget for the year ending 31 December 2020. The budgeted sales...

Q:

MULTIPLE CHOICE. Write the letter of your answer in CAPITAL letter only. SHOW YOUR SOLUTION. No solution no point. PROPERTY PLANT AND EQUIPMENT Acquisition on cash basis 1. LOQUACIOUS TALKATIVE Co....

Q:

MULTIPLE CHOICE. Write the letter of your answer in CAPITAL letter only. SHOW YOUR SOLUTION. No solution no point. PROPERTY PLANT AND EQUIPMENT Acquisition on cash basis 1. LOQUACIOUS TALKATIVE Co....

Q:

Part 1: Make a Pareto chart of the complaint data showing the frequencies and cumulative percentages. The complaint categories are: too much time in line, food cold, no vegetarian choice, not enough...