Lesson Objective: To calculate the standard valuation multiples (EV/Revenue, EV/EBITDA, EV/EBIT, P/E, P/BV) for both the target company and its peer group, and to perform the critical adjustments required to ensure “apples-to-apples” comparability, including adjustments for non-recurring items, differing fiscal year-ends, and accounting policy differences (US GAAP vs. IFRS).

In-Depth Notes:

1. Calculating Enterprise Value (EV) and Equity Value:
Before calculating any multiple, the numerator (EV or Equity Value) must be calculated correctly using the current market data.

• Enterprise Value (EV) Formula: EV = Market Capitalization + Total Debt + Preferred Equity + Minority Interest - Cash & Cash Equivalents.

  • Market Capitalization: Share Price x Number of Diluted Shares Outstanding. Diluted shares include all potentially dilutive securities (stock options, warrants, convertible bonds).

  • Total Debt: Includes both short-term and long-term interest-bearing debt, including leases (under ASC 842/IFRS 16) and off-balance sheet financing.

  • Cash & Equivalents: Cash is subtracted because it is a non-operating asset. If an acquirer buys the company, it can use the target’s cash to pay down the acquisition debt. Therefore, a company with a large cash balance has a lower enterprise value for the same market cap.

• Equity Value Formula: Equity Value = Market Capitalization. This is simply the market cap (using diluted shares).

• The “Trailing Twelve Months” (TTM) Standard: All multiples for Trading Comps are calculated using the TTM financials (the last 12 months of actual results) to ensure the financial data is as current as possible. The model must have a “TTM Date” logic that dynamically updates the financial data based on the most recent quarterly filings (10-Q in the US, Interim Reports in Europe).

2. The Multiples (The Denominator – Financial Metrics):
The denominator must be “normalized” to ensure comparability.

• Revenue: The easiest metric. No adjustments are typically required unless there are extraordinary revenue items (e.g., a one-time sale of a subsidiary). Under US GAAP and IFRS 15, revenue is recognized based on the transfer of control; the model must ensure the peer’s revenue recognition policy is consistent with the target’s.

• EBITDA: EBITDA = EBIT + D&A + Stock-Based Compensation (SBC). SBC is a non-cash charge but is a real economic cost. Many US tech companies have huge SBC; in European valuations, SBC is often treated as a true cost and is not added back. The model must include a “Normalized EBITDA” line that adds back non-recurring items (restructuring costs, legal settlements) and adjusts for differences in SBC treatment.

• EBIT (Operating Income): EBIT = Revenue - COGS - OPEX. It excludes interest and taxes. Under US GAAP, “restructuring charges” are included in EBIT; under IFRS, they are often presented as a separate line item. The model must standardize this by moving all non-recurring items “below” EBIT to create an Adjusted EBIT.

• Net Income (For P/E Ratio): This is the most heavily adjusted metric. The model must remove all non-recurring, non-operating, and extraordinary items:

  • Remove gains/losses from asset sales.

  • Remove restructuring charges.

  • Remove impairments.

  • Remove the impact of discontinued operations.

  • The “Cash Tax Rate” Adjustment: The Effective Tax Rate (ETR) can vary widely due to tax credits, NOLs, and jurisdictional mix. The model uses a “Normalized Tax Rate” (the statutory corporate tax rate in the company’s primary jurisdiction) to calculate a normalized Net Income.

3. The “Fiscal Year-End” Alignment Problem:
A US company may have a December 31 fiscal year-end, while a European peer may have a March 31 fiscal year-end. This means their financial data covers different periods, rendering the multiples non-comparable.

• The “Quarter Bridge” Solution: The model “stubs” the European company’s financials to align them with the US company’s December year-end. For example, if a European company reports as of March 31, its December 31 TTM data is calculated by summing the data from April 1 to March 31. The model uses the EOMONTH and DATE functions to dynamically pull the correct periods.

4. The “Currency Normalization” (USD vs. EUR):
If the target and peers report in different currencies, the multiples must be calculated in the same currency.

• The “Closing Rate” vs. “Average Rate” Rule: Enterprise Value (which includes market cap) is translated at the spot exchange rate (the exchange rate as of the valuation date). EBITDA and Net Income are translated at the average exchange rate over the relevant period (e.g., the average USD/EUR rate over the last 12 months). The model must include a dynamic FX assumption that pulls the correct spot and average rates from a data provider. Failing to do so is a common error that leads to inaccurate multiples.

5. The “Outlier” Removal Process:
A peer group will inevitably contain statistical outliers (companies with abnormally high or low multiples).

• The “Interquartile Range” (IQR) Method: The model calculates the 25th and 75th percentiles of the multiple distribution. The IQR is the difference between the two. Any company with a multiple more than 1.5x the IQR above the 75th percentile or below the 25th percentile is flagged as an outlier.

• The “Justification” Rule: The analyst cannot simply remove an outlier without justification. If the outlier is removed, the model must include a footnote stating why (e.g., “Company X was excluded from the median calculation due to significant distress and an abnormally high EV/EBITDA multiple of 25x, which was driven by a one-time litigation settlement, not core operations.”).