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

Determine the name of some profit margin ratios, Determine the name of some...

Determine the name of some profit margin ratios Other profit margin ratios can also be computed: Gross profit/ turnover Profit after tax/ turnover Advertising co

Marshall-edgeworth method, Marshall-Edgeworth Method Marshall-Edgeworth...

Marshall-Edgeworth Method Marshall-Edgeworth method uses both the current year as well as the base year prices and quantities. Marshall-Edgeworth Index can be computed using th

Auto loan-backed securities (albs), The issuers of ALBS are the finan...

The issuers of ALBS are the financial subsidiaries of automobile manufacturers, commercial banks and other independent finance companies and small financial insti

Portfolio Management, Portfolio Project The purpose of this project is to h...

Portfolio Project The purpose of this project is to help you to gain an understanding of how the stock market works and of the relationship between theory and practice. You are gi

Acquisition strategy, T he acquisition strategy The most important str...

T he acquisition strategy The most important strategic consideration is the size of the acquisition. The completion of smaller series should be considered in the beginning tha

Explain a variety of factors determining dividend policy, Q. Explain a vari...

Q. Explain a variety of factors determining Dividend Policy? Dividend: - Dividend demotes to that part of net profits of a company which is distributed between shareholders as

Features and purpose CDs , The distinct features of CDs are: CD is a ...

The distinct features of CDs are: CD is a document of title to a time deposit and is distinct from conventional time deposit with respect to negotiability and marketability.

International strategic management, undertake a critical review of the curr...

undertake a critical review of the current academic literature to determine the reasons for benefits of and the costs to companies of cross listing.

Define the concept of a real option, Define the concept of a real option. D...

Define the concept of a real option. Discuss some real options a firm can be confronted with when investing in real projects. A positive APV project is accepted under the supposi

Valuation using forward rates, We can discount cash flows either by u...

We can discount cash flows either by using spot rates or forward rates, because a spot rate is simply a package of short-term forward rates. Assume that the cash

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