Estimate the companys wacc, Financial Management

Assignment Help:

Assemble all other inputs/assumptions based on the past data. Use your best judgment to have the most reasonable estimates.

Tasks

1. Prepare an Excel spreadsheet containing the following:

  1. Construct the next five-year pro-forma statements (income statement and balance sheet)following the FSM_B.xls file format.
  2. Estimate annual FCFF.
  3. Estimate the company's WACC.
  4. Estimate the terminal value and the enterprise value.
  5. Conduct the sensitivity analysis, scenario analysis, and Monte Carlo simulation on the enterprise value.

2. Prepare a PowerPoint deck including a high-level executive summary and conclusions, together with an appendix containing details such as assumptions and robustness checks.

Notes

  1. Each company includes different line items in its income statement and balance sheet. Your pro forma statements should resemble them as much as possible. You should not usea format identical to my filedemonstrated in class.
  2. This project is due on the 6th class.Late submission won't be accepted.
  3. Upload the PowerPoint and spreadsheet fileson the Blackboard.  If you log in to your Blackboard site, you will see Assignments on the left banner menu. Select Assignments and then click ProjectFile Submission. Then, upload your files. The file names should be your name (lastname_firstname). You won't be able to upload after the start time of the 6th class.
  4. When you prepare the final report of the project, keep in mind that you are submitting the report to your CEO. Your PowerPoint should start with the executive summary, in which you summarize important inputs/assumptions of your model, your estimated values, and conclusion whether the company is undervalued or overvalued. Besides the quality of analysis, the mannerin which the analysis is presented will also be graded. The CEO, who may not have a finance background, should be able to easily understand your work. And all your assumptions should be reasonable and realistic.After building the pro-forma statements, you should examine the results carefully to check forany unreasonable inputs/assumptions.

Related Discussions:- Estimate the companys wacc

Mutual fund services, Mutual Fund Services: Financial Mutual Funds laun...

Mutual Fund Services: Financial Mutual Funds launch schemes to cater to the need of the different categories of investors. They provide special services in addition to the retu

Financial Management, BigGardens Ltd (BigGardens) is a private company that...

BigGardens Ltd (BigGardens) is a private company that owns and operates a chain of garden centres in the Bristol area. The company has expanded rapidly over recent years, opening

Plan for financial management, 1. Review and analyse financial data for the...

1. Review and analyse financial data for the last year to establish areas which have generated a profit or loss in your organisation. 2. Conduct a research to review reasons for

What are the factors determining the cost of capital, What are the Factors ...

What are the Factors determining the cost of capital There are many factors which impact the cost of capital of any company.  This would mean that cost of capital of any two co

M.r, capital structure

capital structure

Hazard or risk, the procedures, techniques or strategies that could or shou...

the procedures, techniques or strategies that could or should be implemented to reduce the likelihood of harm > actions that could be taken to eliminate the hazard or reduce the r

Fiancial management, Ashok is to receive an amount of Rs. 15,00,000 from hi...

Ashok is to receive an amount of Rs. 15,00,000 from his relative after 3 years. He wants to buy a house for which he wants the money to be paid now. His relative had already invest

The time value of money , Calculate the present value and determine the npv...

Calculate the present value and determine the npv, Financial Management. Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently em

Cost of capital, what is the cost of capital and advantages of it?

what is the cost of capital and advantages of it?

Aeromag, Our geologist, Rebecca Paulka, has estimated from the earlier expl...

Our geologist, Rebecca Paulka, has estimated from the earlier exploration that the Malian prospects have a 30% likelihood of containing economic quantities of uranium ore, the Nige

Write Your Message!

Captcha
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