Develop a financial planning model

Reference no: EM131030770

Problem 1:

How much will your portfolio be worth in 10 years? In 20 years? When you stop working? The Human Resource department at EcoCarnifex Corporation was asked to develop a financial planning model that would help employees address these questions. Frank Joseph was asked to lead this effort and decided to begin by developing a financial plan for himself. Frank has a degree in business and at the age of 25, is making $34,000 per year. After 2 years of contribution to the company retirement plan and receiving a small inheritance, Frank has accumulated a portfolio valued at $14,500. Frank plans to work for 30 more years and hopes to accumulate a portfolio valued at $1,000,000. Can he do it?

Assumptions:

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.

Frank projected he could save around $691,500 after 30 more years of service. What would Frank's alternatives be if he wants to make $1,000,000? Frank showed this to his boss who made the following observations.

1. Salary growth should not be constant. Should vary from 0 to 10 percent 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.

Frank is willing to work 5 more years. What is the result of that decision?

Use @Risk to perform these simulations.

Problem 2:

James Kildare claims to have injured his back as a result of falling out of a chair. James, who has a PhD in physics, but can't find a job because of government budget cuts, had been hired to play a doctor in a hastily produced video. The producer of the video wanted to hire a PhD, since they can legitimately be called "doctor," and are cheap. Not having a real job, James cannot afford medical insurance and thus is looking for someone to sue. The producer of the video has fled the country, the chair is manufactured in the Kaesong Industrial Region of North Korea, and he can't find out who commissioned the video and forced the rushed schedule. Thus, he has filed a lawsuit against the only deep-pocket he could find; Roland Wellington who owns the company that imports these chairs and stamps their logo on them. He is asking for damages of $1,500,000. James claims that the chair frame was made from recycled soda cans and that his fall could have been prevented if Mr. Wellington had not circumvented chair safety requirements by making huge contributions to the political campaign of Congressman Ned Froemer who chairs the committee responsible for oversight of the government agency charged with regulating office chairs. Mr. Wellington notified his insurance company, Axis Insurance, of the lawsuit. Axis must defend Mr. Wellington and decide what action to take regarding the lawsuit.

Some depositions and a series of discussions have taken place between both sides. As a result, James offered to accept a settlement of $750,000. Thus, one option is for Axis to pay James $750,000 to settle the claim. Axis is also considering making James a counteroffer of $400,000 in the hope that he will accept a lesser amount to avoid the time and the cost of going to trial. Dr. Kildare's PhD thesis was in the metallurgy of recycled soda cans, and thus Axis Insurance believes that James may have a strong case since he can act as his own expert witness. Axis is also concerned that James may reject their counteroffer and request a jury trial. Axis' lawyers spent some time exploring James' likely reaction if they make a counteroffer of $400,000.

The lawyers concluded that it is adequate to consider three possible outcomes to represent James' possible reaction to a counteroffer of $400,000. (1) James will accept the counteroffer and the case will be closed. (2) James will reject the counteroffer and elect to have a jury decide the settlement amount, or (3) James will make a counteroffer to Axis of $600,000. If James does make a counteroffer, Axis decided that they will not make additional counteroffers. They will either accept James' counteroffer of $600,000 or go to trial.

If the case goes to jury trial, Axis considers three outcomes possible: (1) The jury may reject James' claim and Axis will not be required to pay any damages; (2) The jury will find in favor of James and award him $750,000 in damages or (3) The jury will conclude that James has a strong case and award him the full amount of $1,500,000.

Key considerations as Axis develops its strategy for disposing of the case are the probabilities associated with James' response to an Axis counteroffer of $400,000 and the probabilities associated with the three possible trial outcomes. Axis' lawyers believe the probability that James will accept the counteroffer of $400,000 is 0.1; that the probability that James will reject the counteroffer of $400,000 is 0.4; and the probability that James will, himself, make a counteroffer to Axis of $600,000 is 0.5. If the case goes to court, they believe that the probability the jury will award James damages of $1,500,000 is 0.3; the probability that the jury will award James damages of $750,000 is 0.5; and the probability that the jury will award James nothing is 0.2.

Perform an analysis of the problem facing Axis Insurance and prepare a report that summarizes your findings and recommendations. Be sure to include: (1) a decision tree; (2) a recommendation regarding whether Axis should accept James' initial offer to settle the claim for $750,000; (3) a decision strategy that Axis should follow if they decide to make James a counteroffer of $400,000; and (4) compute the probability for each final outcome using your recommended strategy (that is, develop a risk profile of your recommended strategy).

Reference no: EM131030770

Questions Cloud

Determine the minimum time needed for the plate temperature : Initially, the iron is in thermal equilibrium with the ambient air at 22°C. Assuming 85 percent of the heat generated in the resistance wires is transferred to the plate, determine the minimum time needed for the plate temperature to reach 140°C.

Determine the price of the io and po security : Determine the price of the IO and PO security, assuming that there is no prepayment. Further assume that the IO investors require a market rate of return of 4.5% and the PO investors require a market return of 6%.

Relatively inelastic demand curve : Characterize each of the following goods and services in terms of their price elasticity of demand. In so doing, indicate whether a steeply sloped (vertical) and relatively inelastic demand curve

Determine step that believe is the most important in process : Review the seven (7) steps required in the process of developing a strategic communication plan. Determine the step that you believe is the most important in the process. Include example(s) to support your response.

Develop a financial planning model : How much will your portfolio be worth in 10 years? In 20 years? When you stop working? The Human Resource department at EcoCarnifex Corporation was asked to develop a financial planning model that would help employees address these questions.

Determine the power rating of the heater in kw : When the heat losses from the room on a winter day amount to 6500 kJ/h, the air temperature in the room remains constant even though the heater operates continuously.

Cut taxes were opposed so strongly as treasury secretary : From Myth of the Robber Barons: Explain how Charles Schwab and Andrew Carnegie outperformed competitors and why these methods not successful at U.S. Steel and explain why Andrew Mellon’s attempts to cut taxes were opposed so strongly as U.S. Treasury..

Summarises current state and proposes sustainable strategies : Analyse the information presented and conceptualise the state of environmental planning in Australia. Apply innovative and entrepreneurial thinking and practice to corporate sustainability management in Australia and produce a report that summarise..

Does the current level of customer satisfaction : Write a data analysis report that provides the results to each of the fivehypothesis tests above and make overall recommendations to Computers R Us that management can use for future business decision-making.

User Account

All Pages