COMPANY VALUATION
DETAILED COMPANY VALUATION
An Editable Excel Based Company Valuation Model on Listed Equities. The Model is based on 7 Years’ Historical Analysis of Business Segments and Key Drivers and 7 Years of Detailed Projections. This Model Covers the following on a Company
- COMPANY OVERVIEW
- TARGET PRICE & VALUATION ANALYSIS – FOOTBALL FIELD
- HISTORICAL VALUATION CHARTS – P/E, EV/EBITDA, EV/REVENUE
- FINANCIAL HIGHLIGHTS & RATIOS
- DCF VALUATION
- WACC CALCULATION
- RELATIVE VALUATION – EV/EBITDA, EV/EBIT, EV/REVENUE, P/E, P/BV, P/REVENUE
- KEY ASSUMPTIONS – BUSINESS SEGMENTS REVENUE DRIVERS, COST DRIVERS, BALANCE SHEET ETC.
- SCENARIO & SENSITIVITY
- INCOME STATEMENT PROJECTIONS
- BALANCE SHEET SCHEDULES & PROJECTIONS
- CASH FLOW PROJECTIONS
- QUARTERLY PERFORMANCE – 12 QUARTERS
- BUSINESS SEGMENTS HISTORICAL PERFORMANCE
- PEERS’ COMPARABLE PERFORMANCE