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

Defien the term ension funds, Pension funds Pension funds offers retire...

Pension funds Pension funds offers retirement income in the form of annuities to employees covered by a pension plan. They obtain contributions from employers or employees and

Explain what happen when government imposes a minimum price, Explain what w...

Explain what will happen while the government imposes a minimum price that is below the market equilibrium price. Why is this true? The minimum price will comprise no impact on t

Cash dividends factors that decided by stockholders, What are some of the f...

What are some of the factors that common stockholders consider when deciding how much, if any, cash dividends they desire from the corporation in which they have invested? Gene

Credit control - account receivable management, Q. Credit control - account...

Q. Credit control - account receivable management? Once credit has been established it is important to review outstanding accounts on a regular basis so overdue accounts can be

Describe career opportunities in the field of finance, List and describe th...

List and describe the three career opportunities in the field of finance? Finance has three key career paths: financial markets and institutions, financial management and inves

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

Calculate total amount of dividends in arrears, QTL Tech has an issue of pr...

QTL Tech has an issue of preferred shares outstanding with a $50 stated value that pays a dividend of 7.5%. There are 325,000 shares outstanding. QTL has not paid preferred share d

Weighted average cost of capital, Weighted Average Cost of Capital Wei...

Weighted Average Cost of Capital Weighted average cost of capital is the average cost of the costs of several sources of financing. Weighted average cost of capital is also kn

Stock market indicators, Stock Market indicators: Stock indices can be ...

Stock Market indicators: Stock indices can be organized by weighting the sample of stocks. The stock indicators can be of four types: price-weighted average, volume-weighted av

Accrued interest, When an investor buys a bond in between coupon paym...

When an investor buys a bond in between coupon payments, he is supposed to compensate the seller with the coupon interest earned on the bond from the last coupon

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