Financial Valuation Model

Financial valuation model is essentially a MS Excel workbook that consists of the following worksheets:

1. Corporate income statement (P&L) – historic (for at least three years) plus projected (current year plus at least six years into the future). This worksheet also includes the statement of retained earnings. P&L includes important corporate financial KPI such as gross revenue, gross profit, EBITDA, EBIT, EBT, and net income (profit)
2. Corporate balance sheet – also historic (for at least three years) plus projected (current year plus at least six years into the future)
3. Free cash flow statement – also historic (for at least three years) plus projected (current year plus at least six years into the future)
4. Footnotes to the abovementioned financial statements (accessible via a hyperlink)
5. NOPLAT calculation. NOPLAT stands for Net Operating Profit Less Adjusted Taxes and is a very important financial KPI as it represents the profits generated from a company's core operations.
6. Worksheets for calculating ROIC, WACC and economic profit
7. Worksheet for calculating intrinsic financial value of your company (typically using the Discounted Cash Flow method)
8. Supplementary worksheets for calculating key components of the financial model

You can find a template for a financial valuation mode for the whole company here. In addition to financial valuation model for the whole company, I will post valuation model for other corporate objects and object portfolios (products, brands, clients, promotion campaigns, etc.)