What recommendations do you have for employees

Assignment Help Accounting Basics

Reference no: EM131021221

Finacncial Analysis- Portfolio Projection

Age			25
Current Salary			$34,000.00
Current Portfolio			$14,500.00
Annual Salary Growth rate			5%
Annual investment rate			4%
Annual Portfolio Growth Rate			10%


		Begginning		New	Portfolio	Ending
Year	age	Portfolio	Salary	Investment	Earnings	Portfolio
1	25	14,500	34,000	1,360	1,518	17,378
2	26	17,378	35,700	1,428	1,809	20,615
3	27	20,615	37,485	1,499	2,136	24,251
4	28	24,251	39,359	1,574	2,504	28,329
5	29	28,329	41,327	1,653	2,916	32,898

Without considering the random variability in growth rates, extend the worksheet in Figures 16.18 to 30 years. Confirm by using the constant annual salary growth rate and the constant annual portfolio growth rate. Tom can expect to have a 30- year portfolio of $627,937.

What would Tom's annual investment rate have to increase to in order for his portfolio to reach a 30-year, $1,000,000 goal?

Incorporate the random variability of the annual salary growth rate and the annual portfolio growth rate into a simulation model. Assume that Tom is willing to use the annual investment rate that predicted a 30-year, $1,000,000 portfolio in part 1. Show how to simulate Tom's 30-year financial plan. Use results from the simulation model to comment on the uncertainty associated with Tom reaching the 30-year, $1,000,000 goal. Discuss the advantages of repeating the simulation numerous times.

What recommendations do you have for employees with a current profile similar to Tom's after seeing the impact of the uncertainty in the annual salary growth rate and the annual portfolio growth rate?

Assume that Tom is willing to consider working 35 years instead of 30 years. What is your assessment of this strategy if Tom's goal is to have a portfolio worth $1,000,000?

Discuss how the financial planning model developed for Tom Gifford can be used as a template to develop a financial plan for any of the company's employees.

Reference no: EM131021221

Questions Cloud

Risk management maturity stages : 1. What are the risk management maturity stages? 2. Name the five elements of an sustainable ERM programme?

Describe the role of patents as barriers to entry : Describe the role of patents as barriers to entry in the Pharmaceutical industry.

Are there other measures of quality of health care systems : Why do comparisons of health care outcomes across countries often concentrate on measures such as life expectancy and infant mortality? Are there other measures of the quality of health care systems? Briefly explain.

Relevant data from operating budget : Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2014 are:

What recommendations do you have for employees : Assume that Tom is willing to consider working 35 years instead of 30 years. What is your assessment of this strategy if Tom's goal is to have a portfolio worth $1,000,000?

What is the first level of moral development : Which level of moral development does Kohlberg call the "principled level"?

Is health care actually free to residents of united kingdom : According to an article in the Economist about the health care system in the United Kingdom: "A defining principle of the National Health Service is that it is ‘free at the point of delivery'." What does "free at the point of delivery" mean? Is he..

Cameroon corp manufactures and sells electric staplers for : Cameroon Corp. manufactures and sells electric staplers for $16 each. If 10,000 units were sold in December, and management forecasts 4% growth in sales each month, the number of electric stapler sales budgeted for March should be:

Features of mutual funds and the investment : What features of mutual funds and the investment environment have led to mutual funds'rapid growth in the last two decades? What types of ethical factors must an investmentadvisor consider when recommending different types of mutual fund investmen..

User Account

All Pages