Random variability of the annual salary growth rate

Assignment Help Operation Management
Reference no: EM13856885

Tri-State Corporation

What will your portfolio be worth in 10 years? In 20 years? When you stop working? The Human Resources Department at Tri-State Corporation was asked to develop a financial planning model that would help employees address these questions. Tom Gifford was asked to lead this effort and decided to begin by developing a financial plan for himself. Tom has a degree in business and, at the age of 25, is making $34,000 per year. After two years of contributions to his company’s retirement program and the receipt of a small inheritance,

Tom has accumulated a portfolio valued at $14,500. Tom plans to work 30 more years and hopes to accumulate a portfolio valued at $1,000,000. Can he do it?

Tom began with a few assumptions about his future salary, his new investment contributions, and his portfolio growth rate. He assumed 5% annual salary growth rate as reasonable and wanted to make new investment contributions at 4% of his salary. After some research on historical stock market performance, Tom decided that a 10% annual portfolio growth rate was reasonable. Using these assumptions, Tom developed the Excel worksheet shown in Figure 16.18. Tom’s specific situation and his assumptions are in the top portion of the worksheet (cells D3:D8). The worksheet provides a financial plan for the next five years. In computing the portfolio earnings for a given year, Tom assumed that his new investment contribution would occur evenly throughout the year, and thus half of the new investment could be included in the computation of the portfolio earnings for the year. Using Figure 16.18, we see that at age 29, Tom is projected to have a portfolio valued at $32,898.

Tom’s plan was to use this worksheet as a template to develop financial plans for the company’s employees. The assumptions in cells D3:D8 would be different for each employee, and rows would be added to the worksheet to reflect the number of years appropriate for each employee. After adding another 25 rows to the worksheet, Tom found that he could expect to have a portfolio of $627,937 after 30 years. Tom then took his results to show his boss, Kate Riegle.

Although Kate was pleased with Tom’s progress, she voiced several criticisms. One of the criticisms was the assumption of a constant annual salary growth rate. She noted that most employees experience some variation in the annual salary growth rate from year to year. In addition, she pointed out that the constant annual portfolio growth rate was unrealistic and that the actual growth rate would vary considerably from year to year. She further suggested that a simulation model for the portfolio projection might allow Tom to account for the random variability in the salary growth rate and the portfolio growth rate.

After some research, Tom and Kate decided to assume that the annual salary growth rate would vary from 0% to 10% and that a uniform probability distribution would provide a realistic approximation. Tri-State’s accounting firm suggested that the annual portfolio growth rate could be approximated by a normal probability distribution with a mean of 10% and a standard deviation of 5%. With this information, Tom set off to develop a simulation model that could be used by the company’s employees for financial planning.

Question. 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.

Reference no: EM13856885

What is the managers perspective of leadership

What is the manager’s perspective of leadership? How does it differ from the leader’s perspective? How should a manager approach his or her job? What ideas should be their wat

Thesis statement

The introductory paragraph introduces your topic to your reader. It is used to identify the topic and purpose of the essay. What is the theory you want to write about? What is

Impacts a trainees motivation to training and learning

What is Maslow's Hierarchy of Needs Theory and how this impacts a trainees motivation to training and learning? What are the four fundamental learning styles? Define each styl

What are the four fundamental learning styles

What are the four fundamental learning styles? Define each style and provide a specific example of each based on your understanding. Then identify with the one learning style

Are learning and transfer of training related

Are learning and transfer of training related? Please explain your answer in detail. A good example will get you full credit on this response. Define each of the four stages o

What is hidden cost to company of making rate of defectives

Vera source Microprocessor Corporation (VMC) sells 2,000 specialized microprocessor chips each month at a price of $1,500 each. Variable costs amount to $1,500,000, and fixed

Evaluate three types of business strategies

Briefly identify the company and provide a short explanation of why the company is seeking to restructure. Evaluate three types of business strategies (low-cost, differentiati

Companies only gather data for the greater good

Data-collecting should be done both with the user's consent and for the greater good. The issue here is that privacy has become a really complicated issue, and in the name of


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd