1 / 11

McKinsey Valuation Model

Important notes. Make sure that the Analysis ToolPak and Report Manager Add-ins are installed before you use the modelThe model is in read-only format. Any changes you make must be saved under a different file name Enter General Section before making a valuation. Facilities Used in the Model. Fun

morwen
Download Presentation

McKinsey Valuation Model

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. McKinsey Valuation Model A brief Introduction

    2. Important notes Make sure that the Analysis ToolPak and Report Manager Add-ins are installed before you use the model The model is in read-only format. Any changes you make must be saved under a different file name Enter General Section before making a valuation

    3. Facilities Used in the Model Functions and Reference Grouping and Outlining Collapse and Expand: +/-, and 1/2 Range name Coloring Scheme: input: yellow; link: blue; calculation: white

    4. Components of the Model Historical Data Forecast Drivers Results Valuation Summary

    5. Time Horizon Historical Period Three-phase forecast period: Detailed forecast: 5 years Key Driver forecast: 10 years Continuing Value period

    6. Historical Inputs You can enter up to 10 years of data Historical Income Statement Statement of Changes in Equity Historical Balance Sheet Off Balance Sheet Items Enter number of shares in full

    7. Forecast Inputs General Section Operations Operating items and working capital Balance Sheet Items Three standard options for Capex Off Balance Sheet Items Provisions and Non-operating P&L

    8. Forecast Inputs (Cont’d) Debt finance and WACC Interest rates, addition/repayment Excess Cash and Balancing Debt WACC calculation is not included in the model Equity Finance Tax

    9. Forecast Inputs (Cont’d.) Phase 2 and CV Drivers Phase 2: six major inputs CV period: ROIC & growth Constants and Dates

    10. Results & Valuation Summary Results Sheet No Inputs Grouping Important calculations Checking cell Valuation Summary Sheet Enterprise DCF and EP

    11. Printing Print All Valuation Summary Financial Statements Results (Noplat etc) Ratios Phase 2 key summary Historical Inputs Forecast inputs Print results

More Related