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

London stock exchange, London Stock Exchange (LSE) The origin of the Lo...

London Stock Exchange (LSE) The origin of the London Stock Exchange goes back to the coffee houses of 17th century. London, where people willing to invest or raise money, bough

Determine the cost, a) Social marketing is the use of normal marketing meth...

a) Social marketing is the use of normal marketing methods to achieve the benefits of social change, such as informing the public about the harm of under-age drinking, rather than

Accumulate the money necessary for your retirement, You plan to retire in 3...

You plan to retire in 35 years and can invest to earn 7 percent. You estimate that you will need $85,000 at the end of each year for an estimated 25 years after retirement, and you

Regular versus special redemption prices, The call prices for vario...

The call prices for various issues mentioned above are known as regular redemption prices. Point to be noted is that the regular redemption prices are above

Management accounting and financial management, Q. Distinguish between Mana...

Q. Distinguish between Management Accounting and Financial Management with clear mention of basis of differences. How does the traditional financial manager differ from the mode

Explain the financial desirability of burley plc, BURLEY PLC Financial...

BURLEY PLC Financial desirability In a real-terms analysis the real rate of return necessary by shareholders has to be used. This is found as follows 1 nominal rate/1 i

What are the functions of financial management, Functions of Financial Mana...

Functions of Financial Management Traditional function of financial management has been limiting the role of finance toraising and administrating of funds required by the compa

Managing finance, Read the journal article Lafferty, B. A., & Hult, G. T. M...

Read the journal article Lafferty, B. A., & Hult, G. T. M. (2001) ‘A synthesis of contemporary market orientation perspectives’, European Journal of Marketing, 35 (1/2), pp. 92–109

What are the types of major types of finance companies, What are the types ...

What are the types of major types of finance companies? There are three main types of finance companies: a. Sales finance institutions which make loans to customers of a cer

What is unsanctioned expenditure, Q. What is Unsanctioned Expenditure? ...

Q. What is Unsanctioned Expenditure? The expenditure, which is regularly incurred without the sanction of the competent authority or beyond the sanctioned limit of funds provid

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