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

Internal rate of return, Internal Rate of Retur n The discount ...

Internal Rate of Retur n The discount rate at which the net current value (the value of all future cash flows, in excess of the real investment, expressed  in today's d

Foreign bonds, They are issued in the local market, by a foreig...

They are issued in the local market, by a foreign borrower are usually denominated in the local currency. For example, Yankee bonds are USD denominated bon

Operating cycle, discuss an operating cycle of vegetable growing in Uganda

discuss an operating cycle of vegetable growing in Uganda

Valuing a putable bond using binomial model, In a putable bond, the b...

In a putable bond, the bondholder has the right to force the issuer to pay off the bond prior to the maturity date. Let us consider the previous example with the

Audit opinion, Clean Opinion - AUDIT opinion not qualified for any material...

Clean Opinion - AUDIT opinion not qualified for any material scope restrictions nor departures from GENERALLY ACCEPTED ACCOUNTING PRINCIPLES (GAAP). Also called UNQUALIFIED OPINION

Abnormal earnings valuation model, A technique for knowing a company's wort...

A technique for knowing a company's worth that is based on earnings and book value. It is also known as the residual income model, it seems at whether management's decisions cause

Shareholders'' wealth maximization, Shareholders' wealth maximization S...

Shareholders' wealth maximization Shareholders' wealth maximization refers to maximization of the net present value of every decision made in the firm. Total present value is e

Analysis of financial statements, Turnover has increased 10% since 2009 eve...

Turnover has increased 10% since 2009 even if this is at the expense of a drop in the gross margin earned which has fallen from 35.0% to 32.7% which has resulted in only a marginal

Accounting framework - convention of consistency, Accounting Framework  - ...

Accounting Framework  - Convention of Consistency This doctrine denotes that accounting rules, practices & conventions should be continuously observed and applied that implies

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