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

Financial projections, A total of $426,000 seed-funding would be ideal to s...

A total of $426,000 seed-funding would be ideal to start the project on a local basis. The cost analysis done above is for the material required to perform the work, and as the wor

Liabilities, Liabilities The company must take into account the nature ...

Liabilities The company must take into account the nature of its liabilities as well as its solvency position. Cash Flows: Besides the investment yields, money flows as paid

Explain swap dealer, Explain Swap Dealer A swap dealer is a market make...

Explain Swap Dealer A swap dealer is a market maker of swaps and predicts a risk position in matching opposite sides of a swap and in making sure that every counterparty fulfil

Why are trend analysis and industry comparison, Why are trend analysis and ...

Why are trend analysis and industry comparison important to financial ratio analysis? Trend analysis assists financial analysts and managers see whether a company's current fin

Future value, Future V alue The value of an investment is based...

Future V alue The value of an investment is based on the rate of interest paid at set time periods and at some point in the future. Future values incorporate both the i

Establish budgets and allocate funds, 1. Allocate resources to different de...

1. Allocate resources to different departments by taking information from previous financial data. 2. What would be the estimated cost of new allotted resources to be included i

Explain the political events in a host country, Discuss the different ways ...

Discuss the different ways political events in a host country may affect local operations of an MNC. Answer:  The answer can be organized based on the three types of political ri

Financial issues of divestitures, FINANCIAL ISSUES OF DIVESTITURES Many...

FINANCIAL ISSUES OF DIVESTITURES Many corporations review the business portfolio to determine the operations that fit their core strategies. The firm's desire to achieve more f

Monthly cash flow, I need to prepare a monthly cash flow for a company with...

I need to prepare a monthly cash flow for a company with the given information, and need to comment on the current performance and the future sales increment. Then we need to find

Planning, how to do assignments based on these topics more specifically?

how to do assignments based on these topics more specifically?

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