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

Explain and compare the costs of hedging, Explain and compare the costs of ...

Explain and compare the costs of hedging via the forward contract and the options contract. Answer: There is no up-front cost of hedging through forward contracts. Though, in t

Negotiation with bidders, N egotiation You can also negotiate with the...

N egotiation You can also negotiate with the bidders based on the requirements as mentioned below. You can negotiate only with the lowest evaluated responsive and qualified

Cash flows from mortgage- backed security, It is a well known fact th...

It is a well known fact that the value of a financial claim reflects the present value of the cash flows produced by the financial claim. While valuing an MBS an

Calculations and graphing cumulative returns, Monthly Returns: You now nee...

Monthly Returns: You now need to calculate the monthly "periodic" returns for all three stocks and the S&P index.  Adapting the holding period return formula (End - Beg) / Beg for

Deterministic model, Deterministic Model After the macroeconomic, indus...

Deterministic Model After the macroeconomic, industrial and business analysis of the company chosen is done First of all a point estimate for all the input variables in a valua

Quantitative analysis, A researcher develops a regression model to understa...

A researcher develops a regression model to understand how student-to-teacher ratios affect test scores. The researcher theorizes that age, gender, and race do not impact test scor

Capital investment decisions, what are the key stages in capital investment...

what are the key stages in capital investment decision-making process and the role of investment appraisal in this process?

Identify an analytic theme for fictitious business, 1. identify an analytic...

1. identify an analytic theme or goal for a fictitious business or something that you are working on (e.g. Maximize revenue in a car dealership) 2. Build an Enterprise Bus Matri

Accounting period - accounting principle, Accounting Period - Accounting Pr...

Accounting Period - Accounting Principle Accounting period refers to span of time at the end of that and for which the financial statement are prepared to throw light on the r

Value of a warrant, Value of a Warrant: The market price of a warrant f...

Value of a Warrant: The market price of a warrant fluctuates between minimum and maximum limits. When the current market price of the stock Ps is greater than the exercise pri

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