Develop a financial planning model

Assignment Help Applied Statistics

Reference no: EM13713774

The HR department at a certain company was asked to develop a financial planning model that would help employees address how much their portfolios would be worth in 10 years, 20 years, and when they retire. John was asked to lead this effort and decided to begin by developing a financial plan for himself. John is making $34,000/year at the age of 25. After 2 years of contribution to the company retirement plan and receiving a small inheritance, John has accumulated a portfolio valued at $14,500. John plans to work for 30 more years and hopes to accumulate a portfolio valued at $1,000,000. Is this possible?
Assume the following:
1. 5% salary growth is reasonable.
2. He plans to contribute 4% of his salary.
3. 10% annual portfolio growth seems reasonable.
4. Contributions occur monthly throughout the year.
Develop an Excel worksheet and calculate the value at the end of 5 years.
John projected he could save around $691,500 after 30 more years of service. What would his alternatives be if he wants to make $1,000,000? John showed this to his boss who made the following observations.
1. Salary growth should not be constant. Should vary from 0 to 10% with a uniform probability distribution.
2. Annual portfolio growth rate should be approximated by a normal probability distribution with a mean of 10% and a standard deviation of 5%
Develop an Excel worksheet with this new information.
John is willing to work 5 more years. What is the result of that decision?

Reference no: EM13713774

Questions Cloud

Determine the ph of the solution after the addition of hno3 : A 100 mL sample of .10 M NH3 is titrated with .10 M HNO3. Determine the PH of the solution after the addition of 150mL HNO3 the Kb of NH3 is 1.8X10^-5

What is the physical interpretation of three quantum numbers : What is the physical interpretation of the three quantum numbers and what restrictions are placed on them

Calculate oh and ph for nacn : Using data from Appendix D in the textbook, calculate [OH?] and pH for each of the following solutions.

Estimate the enthalpy change for the combustion of one mole : Estimate the enthalpy change for the combustion of one mole of acetylene, C2H2, to form carbon dioxide and water vapor. BE(C?H) = 456 kJ/mol)

Develop a financial planning model : The HR department at a certain company was asked to develop a financial planning model that would help employees address how much their portfolios would be worth in 10 years, 20 years, and when they retire. John was asked to lead this effort a..

What is the volume of a gas that exerts a pressure : What is the volume of a gas that exerts a pressure of 457 mm Hg if it exerted a pressure of 2.50 atm when its volume was 25.0 ml

Define a concentration of aqueous ammonia solution : A concentration of aqueous ammonia solution has a density of 0.90 g/ml and is 28.0% by mass ammonia. determine the molar concentration of this solution

Gerald black of blackfly airline has an exclusive contract : Gerald Black of BlackFly Airline has an exclusive contract to run flights of a four-passenger aircraft to a remote mining center. His contract requires him to fly if there are any passengers wanting to make the trip. His fixed costs per day ar..

Victoria heated the original solution to the water : Question- Victoria heated the original solution to 100 degrees Celsius, which cause some of the water to in the test tube to evaporate. a) Would this cause the calculated solubility of the solution to be too high, too low or no effect. Explain

User Account

All Pages