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

The beta of a firm, Suppose the market portfolio is equally likely to incre...

Suppose the market portfolio is equally likely to increase by 30% or decrease by 10%. a.    Calculate the beta of a firm that goes up on average by 43% when the market goes up a

Treasury bills or t-bills, Treasury bills are the bills, the governme...

Treasury bills are the bills, the government issues with maturity period of one year or less than one year. Treasury bills are usually issued as discount securiti

Characteristics of a stock exchange, Characteristics of a Stock Exchange ...

Characteristics of a Stock Exchange The requirements for a stock exchange to act as a platform for buying and selling securities is dependant upon the trading prerequisites. Som

Show the motives of maintaining receivables, Q. Show the Motives of Maintai...

Q. Show the Motives of Maintaining Receivables? Motives of Maintaining Receivables :- (i) Sales Growth Motives: - The major objectives of credit sales are to increase the to

Market efficiency, Market Efficiency Though there are various markets p...

Market Efficiency Though there are various markets present in the financial system, the ease with which the transfer of funds take place depends on the level of efficiency pres

Cash discount, I am trying to solve this formula: 2/10, net 30. In the bo...

I am trying to solve this formula: 2/10, net 30. In the book I am reading they have 2% x 360 ------- ------ = 2.04% x 18=36.72% 100-2% (30-10) I want to know how the

Diffrence between present values of future cash, Q. Diffrence between prese...

Q. Diffrence between present values of future cash ? The difference among the present values of future cash inflows generated by an asset and its cost is known as net present v

What is adjusted gross income, Q. What is Adjusted Gross Income? Adjust...

Q. What is Adjusted Gross Income? Adjusted Gross Income - Gross income decreased by business and other specified expenses ofindividual taxpayers. Amount of adjusted gross incom

What is the tolerable error, What is the Tolerable error In addition t...

What is the Tolerable error In addition to looking at material differences individually the auditor must list all the differences (material or not) and consider in total wheth

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

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