Reference no: EM13213362
Based on the value driver assumptions provided, create pro-forma income statement (Cells Rows 25 - 39) and balance sheet (Rows 40 -57) for years 2xx1 through 2xx5. Assume cash and revolving credit as plugs.
- Calculate cash flow provided by operating activities (CFO) (Rows 65 - 73)
- Calculate free cash flow using CFO. (Row 79)
- Calculate free cash flow using EBIT (Rows 81 - 94)
- What is WACC? (B96)
- What is the terminal value for FCFs for the period after 2xx5? (B97)
- Calculate the value of the firm (enterprise value) (B99)
- Calculate the share holder equity (B100)
- Calculate the value of one share of equity (B101)
- Conduct a sensitivity analysis on the effects of sales growth rate on stock value (B120:C130). How would you describe the effect? (Double click this area and answer below)
- Conduct a Sensitivity analysis on the effects of Beta and LT growth rate of FCF on Enterprise value (B135 - G146). How would you describe the effects?
Monte Carlo simulation given the probability assumptions (use WorkSheet "Simulation")
- Copy the entire worksheet to a separate worksheet, "Simulation"
- Set the simulation setting: 5,000 iterations
- Use the following distributions of the input variables
Sales growth rate: Uniform (7%,9%)
Capital expenditure to sales ratio: Uniform (8%,12%)
Long-term growth rate of FCFs: Uniform (0%, 4%)
Dividend payout ratio: Triang(25%,30%,35%)
Company equity beta: Triang(1.2, 1.5,1.8
- Run the simulation. Using the tornado graph, identify the value drivers with the most impact and the least impact on the stock price.
ANSWER: (Write your answer in the space below)
- What is the mean value of the stock price?
ANSWER: (Write your answer in the space below)
- Would you buy the stock at the current price of $70.00? Why?
ANSWER: (Write your answer in the space below)
- Explain the significance of the terminal value in your analysis and recommendation above.
ANSWER: (Write your answer in the space below)
Download:- MonteCarlo.xls
|
How did françois boucher use art as social tool
: How did François Boucher use art as social tool in the Le Déjeuner (The Breakfast) painting? How does François Boucher question the high society family values in his painting Déjeuner (The Breakfast)?
|
|
What is the importance of strategic lighting in facilities
: What is the importance of strategic lighting in facilities? Why is surveillance equipment important in internal security?
|
|
Developed countries in international development
: What are the responsibilities of developed countries in international development? Specifically comment on the role of the U.S. in engaging in international development.
|
|
Print media worksheet
: Print Media Worksheet. Write each response using complete sentences in a paragraph of at least 75 words. Provide specific examples and cite at least three professional publications or articles
|
|
Calculate cash flow provided by operating activities (cfo)
: Based on the value driver assumptions provided, create pro-forma income statement (Cells Rows 25 - 39) and balance sheet (Rows 40 -57) for years 2xx1 through 2xx5. Assume cash and revolving credit as plugs.Calculate cash flow provided by operating a..
|
|
Revolt-night journey-cave of the heart or appalachian spring
: The triumph of love and common sense over the fire and brimstone of American Puritanism is the theme of which dance by Martha Graham? revolt, night journey, cave of the heart, or appalachian spring
|
|
Lacks self-discipline and fails to plan ahead
: Andy, a high school sophomore, lacks self-discipline, fails to plan ahead, and is excessively anxious. he is quickly frustrated by challenging tasks and frequently becomes overly critical of others.
|
|
Formal law enforcement code of ethics
: what conflicks do you see between the formal law enforcement code of ethics and the police subculture also known as cop code?
|
|
Manufacturer of ready-to-drink iced tea
: As a manufacturer of ready-to-drink iced tea, Nestea sells a highly standardized product to consumers all over the United States. You would expect Nestea to rely on _____ to promote its product.
|