In-Depth Notes:

1. Restating Financials for Modeling Consistency:
Raw financial statements from corporate filings (10-Ks or Annual Reports) are formatted for legal disclosure, not for modeling. The first step in financial statement analysis is “restating” these documents into a clean, organized “taxonomy” that separates operating, financing, and investing activities with absolute clarity. This restatement involves:

• Reclassifying Operating Leases: Under both ASC 842 (US) and IFRS 16 (Europe), lessees must recognize right-of-use assets and lease liabilities. However, for ratio analysis, the model must separate the interest component of the lease payment from the principal component to avoid distorting EBITDA and operating cash flow.

• Separating Non-Recurring Items: Restructuring charges, asset impairments, and legal settlements are classified as “below the line” or flagged with a toggle in the model. This allows the analyst to view both “Reported EBITDA” and “Adjusted EBITDA” side-by-side, which is a critical requirement under ESMA (European Securities and Markets Authority) guidelines for alternative performance measures.

2. The Core Taxonomy for the Income Statement (Function of Expense Method):
Globally, companies can present expenses by either “Function” (Cost of Sales, SG&A) or “Nature” (Raw Materials, Staff Costs, Depreciation). The modeling standard mandates the Function of Expense method, as it allows for the direct calculation of Gross Margin and Operating Margin. The mandatory line items for a modeling-ready P&L are:

• Top Line: Gross Revenue minus Returns, Allowances, and Discounts = Net Revenue.

• Direct Costs: Cost of Goods Sold (COGS) includes raw materials, direct labor, and manufacturing overhead (including depreciation related to production facilities).

• Operating Expenses: SG&A (Selling, General, and Administrative), which is further split into Cash SG&A (salaries, marketing) and Non-Cash SG&A (stock-based compensation).

• Depreciation and Amortization (D&A): This must be presented as a separate line item or disclosed in the notes. For analytical purposes, it must be extracted from COGS and SG&A and shown explicitly to calculate EBITDA.

• Operating Income (EBIT): The critical checkpoint before financing and tax considerations.

3. The Core Taxonomy for the Balance Sheet (The “R” vs. “S” Structure):
The balance sheet must be reorganized to immediately separate Operating Working Capital from Long-Term Capital.

• Current Assets: Cash and Equivalents, Marketable Securities, Accounts Receivable (Trade), Inventory, and Prepaid Expenses. Under IFRS, “Cash and Equivalents” includes bank overdrafts repayable on demand, whereas US GAAP excludes them; the model must flag this.

• Operating Liabilities: Accounts Payable (Trade), Accrued Liabilities (salaries, taxes, utilities), and Deferred Revenue (customer advances). Under US GAAP, deferred revenue is often presented within current liabilities; under IFRS, it may be presented separately if material.

• Long-Term Assets: PP&E (Property, Plant, Equipment), Goodwill (only arises from acquisitions), Intangible Assets (patents, trademarks), and Right-of-Use Assets (leases).

• Long-Term Liabilities: Long-Term Debt (bonds, bank loans), Deferred Tax Liabilities, and Lease Liabilities.

• Equity: Share Capital (par value), Additional Paid-In Capital (APIC), Retained Earnings, and Accumulated Other Comprehensive Income (AOCI). AOCI is a major reconciling item; under IFRS, more items flow through OCI than under US GAAP, so the model must segregate OCI to ensure the balance sheet ties correctly.

4. The Cash Flow Statement (The Indirect Method Mandate):
The cash flow statement is the bridge between the accrual-based Income Statement and the cash-based Balance Sheet. Globally, the indirect method is mandatory under US GAAP and widely used in IFRS.

• Operating Cash Flow (OCF): Starts with Net Income. Adds back non-cash charges (D&A, stock comp, deferred taxes). Subtracts gains (which are non-operating) and adjusts for Changes in Working Capital. Crucially, “Changes in Working Capital” must be broken down into individual components (change in AR, change in Inventory, change in AP) to analyze the company’s cash conversion cycle.

• Investing Cash Flow (ICF): Primarily CAPEX (capital expenditures) and cash proceeds from asset sales. This also includes acquisitions of other businesses (which are treated separately from CAPEX in the model’s supporting schedules).

• Financing Cash Flow (FCF): Proceeds from issuing debt, repayments of debt, proceeds from issuing equity, dividends paid, and share buybacks.