Financial Modeling Basics
1. What is a financial model and what is it used for?
A financial model is a quantitative representation of a company's or project's financial performance, built in a spreadsheet, that projects future revenues, expenses, cash flows, and returns based on a set of assumptions. Financial models are used for company valuation (DCF, comparable company analysis), investment decisions, M&A analysis (accretion/dilution), LBO financing, budgeting and forecasting, project feasibility analysis, and fundraising presentations. A well-built model is transparent, auditable, and flexible enough to run scenarios without breaking.
2. What are the three core financial statements and how are they linked?
The Income Statement shows revenue, expenses, and net income over a period. The Balance Sheet shows assets, liabilities, and equity at a point in time. The Cash Flow Statement reconciles net income to actual cash movements and shows operating, investing, and financing cash flows. They are linked: net income from the Income Statement flows into retained earnings on the Balance Sheet and is the starting point of the Cash Flow Statement. Capital expenditures reduce cash (Cash Flow Statement) and increase PP&E (Balance Sheet). Debt drawings affect both the Balance Sheet and the financing section of the Cash Flow Statement.
3. What is EBITDA and why is it widely used?
EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortisation) measures a company's operating performance before the effects of capital structure (interest), tax jurisdiction (taxes), and non-cash accounting charges (D&A). It is widely used as a proxy for operating cash flow, as the basis for valuation multiples (EV/EBITDA), and in debt covenant calculations. Its limitation is that it ignores capex requirements — two companies with identical EBITDA but vastly different capex needs have very different true cash generation. EBITDA – Capex = a better measure of cash generation.
4. What is the difference between equity value and enterprise value?
Enterprise Value (EV) represents the total value of a company's operations available to all capital providers (equity holders and debt holders): EV = Market Capitalisation + Net Debt + Minority Interest + Preferred Stock. It is capital structure-neutral. Equity Value (Market Cap) represents only the value attributable to equity holders: Equity Value = EV – Net Debt. EV is used for operational multiples (EV/EBITDA, EV/Revenue) because EBITDA is pre-interest and thus available to all capital providers. P/E uses equity value because earnings are post-interest and available only to equity holders.
5. What is working capital and how does it affect cash flow?
Working Capital = Current Assets – Current Liabilities. The components most relevant for cash flow modelling are accounts receivable (AR), inventory, and accounts payable (AP). An increase in AR or inventory is a use of cash (cash conversion cycle lengthens). An increase in AP is a source of cash (you owe more to suppliers). In the Cash Flow Statement, changes in working capital are shown in the operating section: "Change in Working Capital = Prior Period WC – Current Period WC." A growing business typically consumes cash in working capital as sales grow. Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), and Days Payable Outstanding (DPO) drive WC assumptions.
6. What is the difference between gross profit, operating profit, and net income?
Gross Profit = Revenue – Cost of Goods Sold (COGS). It reflects the profitability of the core product or service before overhead costs. Operating Profit (EBIT) = Gross Profit – Operating Expenses (SG&A, R&D, D&A). It reflects profitability from operations before the effects of financing and taxes. Net Income = EBIT – Interest Expense – Taxes. It is the "bottom line" after all expenses. Gross margin, operating margin, and net margin (each divided by revenue) are key profitability ratios that analysts track to understand cost structure and pricing power.
7. What is free cash flow (FCF) and how is it calculated?
Unlevered Free Cash Flow (UFCF) = EBIT × (1 – Tax Rate) + D&A – Change in Working Capital – Capital Expenditures. It represents cash generated by operations available to all capital providers before debt service and is used in DCF models. Levered Free Cash Flow (LFCF) = Net Income + D&A – Change in Working Capital – Capex – Mandatory Debt Repayment. It represents cash available to equity holders after debt obligations. UFCF is used for EV-based DCF valuation; LFCF is used for equity value DCF and LBO returns analysis.
8. What are the most common valuation methodologies?
The three primary valuation methods are: DCF (Discounted Cash Flow) — intrinsic value based on projected free cash flows discounted at WACC; Comparable Company Analysis (CCA / Trading Comps) — value based on multiples (EV/EBITDA, P/E) of similar publicly traded companies; and Precedent Transaction Analysis (Deal Comps) — value based on multiples paid in prior M&A transactions for similar companies. Football field charts display the valuation range from all three methods. DCF requires the most assumptions; comps are market-based. Control premiums (typically 20-30%) mean transaction multiples exceed trading multiples.
9. What is sensitivity analysis and how is it done in Excel?
Sensitivity analysis tests how a model output (e.g., equity value, IRR) changes when key input assumptions vary. A one-variable data table shows the output across a range of one input (e.g., revenue growth). A two-variable data table (Excel Data → What-If Analysis → Data Table) shows the output for every combination of two inputs (e.g., EBITDA margin and revenue growth). The output is colour-coded with conditional formatting to show the range of outcomes. Tornado charts rank assumptions by their impact on the output. Sensitivity analysis communicates model risk and helps focus due diligence on the most impactful assumptions.
10. What is scenario analysis and how does it differ from sensitivity analysis?
Scenario analysis creates distinct versions of a model representing different possible futures — for example, Base Case, Bull Case, and Bear Case — each with a consistent, internally logical set of assumptions for all inputs simultaneously. Sensitivity analysis isolates the impact of changing one or two variables while holding others constant. Scenario analysis is more realistic because real-world outcomes involve correlated changes across many variables. In Excel, scenarios are managed with dropdown cells driving assumption ranges via IF statements or Excel's built-in Scenario Manager. The best models include both a sensitivity table and defined scenarios.
DCF Valuation
11. What is a DCF model and what are its key components?
A Discounted Cash Flow (DCF) model values a company by projecting future free cash flows and discounting them back to the present using a discount rate (WACC). Components include: a revenue and cost forecast (typically 5-10 years), UFCF calculation (EBIT after tax + D&A – ΔWC – Capex), terminal value (capturing value beyond the forecast period), discount rate (WACC), and bridge from EV to equity value. The DCF is highly sensitive to terminal value assumptions (which often represent 60-80% of total value) and WACC, making the assumptions and their justification critical to the analysis.
12. What is WACC and how is it calculated?
WACC (Weighted Average Cost of Capital) is the blended cost of capital, weighting the cost of equity and the after-tax cost of debt by their proportions in the capital structure: WACC = (E/V) × Ke + (D/V) × Kd × (1 – T), where E = equity value, D = debt value, V = E + D, Ke = cost of equity, Kd = pre-tax cost of debt, T = tax rate. The cost of equity is typically estimated using CAPM: Ke = Risk-free Rate + Beta × Equity Risk Premium. The risk-free rate uses the 10-year government bond yield. Beta is obtained from comparable companies, unlevered, and re-levered to the target's capital structure.
13. What is the terminal value and what are the two methods to calculate it?
Terminal value captures the present value of all cash flows beyond the explicit forecast period and typically represents the majority of a DCF's total value. The Gordon Growth Model (perpetuity growth method) assumes FCF grows at a constant rate in perpetuity: TV = FCF(n+1) / (WACC – g), where g is the long-term growth rate (typically GDP growth, 2-3%). The Exit Multiple method applies an EV/EBITDA multiple (based on comparable company trading multiples) to terminal year EBITDA: TV = EBITDA(n) × Exit Multiple. Both methods should be cross-checked against each other. The chosen terminal growth rate or exit multiple has an outsized impact on the final valuation.
14. What is the difference between levered and unlevered beta?
Unlevered beta (asset beta) measures a company's business risk independent of its capital structure — it reflects only the risk of the underlying assets. Levered beta (equity beta) incorporates both business risk and financial risk (leverage). The Hamada equation relates them: Levered Beta = Unlevered Beta × (1 + (1 – T) × D/E). In a DCF, you un-lever the betas of comparable companies (remove the effect of their capital structures), take the median unlevered beta, then re-lever it using the target company's capital structure to derive the appropriate equity beta for CAPM. This process accounts for different leverage levels across peers.
15. How do you handle the DCF bridge from enterprise value to equity value?
The bridge from EV to equity value adjusts for all non-operating items and capital structure components: Equity Value = Enterprise Value − Net Debt − Minority Interest − Preferred Stock + Cash and Cash Equivalents + Non-Operating Assets. Net Debt = Total Debt − Cash. Minority Interest is subtracted because the EBITDA and FCF used are consolidated (including minority-owned subsidiaries), so the portion attributable to minorities must be deducted. The resulting equity value divided by diluted shares outstanding (including in-the-money options using the treasury stock method) gives implied price per share.
16. What is the mid-year convention in DCF?
The mid-year convention assumes cash flows are received evenly throughout the year (at the midpoint) rather than all at year-end. Instead of discounting year 1 cash flows by 1/(1+WACC)^1, the mid-year convention discounts by 1/(1+WACC)^0.5 for year 1, 1/(1+WACC)^1.5 for year 2, etc. This produces a slightly higher valuation than the end-of-year convention because cash flows are assumed to arrive sooner. It is considered more realistic for operating businesses that generate cash continuously. The terminal value's discount period is also adjusted (e.g., to year 4.5 instead of year 5 for a 5-year projection).
17. What is CAPM?
The Capital Asset Pricing Model (CAPM) calculates the expected return (cost of equity) for an asset based on its systematic risk: Ke = Rf + β × (Rm – Rf), where Rf = risk-free rate (10-year government bond yield), β = beta (sensitivity of the stock's returns to the market), and (Rm – Rf) = equity risk premium (ERP), the excess return investors require over the risk-free rate for taking on equity risk. Typical ERP is 5-7% for developed markets. Higher beta stocks have higher required returns. CAPM is used in WACC calculations and is the standard cost of equity estimation method despite its limitations.
18. What are the limitations of a DCF valuation?
DCF limitations include high sensitivity to assumptions — small changes in WACC or terminal growth rate create large valuation swings (GIGO: Garbage In, Garbage Out). Projecting cash flows 5-10 years into an uncertain future requires judgement. The terminal value (60-80% of total value) depends heavily on the chosen methodology. WACC calculation requires estimating beta and ERP, both of which involve subjectivity. The model assumes the company continues as a going concern. It does not capture synergies, control premiums, or strategic optionality. Despite these limitations, DCF remains the most intellectually rigorous valuation method.
19. How do you value a company with negative earnings?
Companies with negative earnings cannot be valued with P/E multiples. Alternatives include EV/Revenue multiples (for high-growth companies like SaaS, where revenue is positive even if margins are negative), EV/Gross Profit, EV/EBITDA if EBITDA is positive, or a DCF based on projected positive free cash flows in the future. For pre-revenue startups, venture capital methods (pre-money valuation based on comparable funding rounds and ownership requirements) or real options analysis may be used. The key is to find a metric that is both positive and meaningful as a proxy for the company's value-generating potential.
20. What is a football field chart?
A football field chart is a horizontal bar chart that displays the valuation range derived from multiple methodologies side by side — DCF (low and high cases), comparable company analysis (low and high multiples), precedent transactions, and sometimes a 52-week trading range. Each bar represents the min-to-max valuation range from that method. Overlapping bars suggest robust support for a value range; methods with wide bars indicate high uncertainty. Football field charts are standard in investment banking pitchbooks and fairness opinions to communicate the full range of value rather than a single point estimate.
LBO Analysis
21. What is an LBO and why is it done?
A Leveraged Buyout (LBO) is the acquisition of a company using a significant proportion of debt financing, with the target company's assets and cash flows serving as collateral. The buyer (typically a private equity firm) contributes only 20-40% equity with the remainder financed by debt, using financial leverage to amplify equity returns. LBOs are done to acquire companies at a reasonable price, improve operations and profitability, pay down debt with the company's cash flows over a 3-7 year hold period, and exit (via IPO, secondary sale, or strategic sale) at a higher multiple, delivering strong equity IRR (typically 20-30% target).
22. What are the key drivers of LBO returns?
LBO returns (IRR) are driven by three main levers: multiple expansion (buying at a lower EV/EBITDA and selling at a higher multiple — the most powerful driver), EBITDA growth (revenue growth and margin improvement increasing the exit EBITDA), and debt paydown (deleveraging over the hold period increases equity value as debt is repaid from operating cash flows). A fourth lever is dividends (cash returned to equity holders during the hold period). In practice, modern PE deals rely less on financial engineering and more on operational improvement and strategic repositioning as buyout multiples have increased.
23. How do you build a basic LBO model?
An LBO model is built in six steps: (1) Sources and Uses table — total acquisition cost and how it is financed (debt tranches, equity); (2) Pro forma balance sheet — post-acquisition opening balance sheet with acquired debt; (3) Income Statement and FCF projections — revenue, EBITDA, interest expense, taxes, and free cash flow for 5 years; (4) Debt schedule — track each debt tranche, interest payments, mandatory amortisation, and cash sweep paydowns; (5) Exit analysis — apply exit multiple to exit-year EBITDA to get exit EV, subtract remaining debt to get equity proceeds; (6) Returns analysis — calculate IRR and MOIC on sponsor equity.
24. What is MOIC and how does it differ from IRR?
MOIC (Multiple of Invested Capital) is the total value returned divided by the amount invested: MOIC = (Exit Equity Value + Dividends Received) / Initial Equity Invested. A 3.0x MOIC means the investor tripled their money. IRR (Internal Rate of Return) is the annualised rate of return accounting for the time value of money — it is the discount rate that sets the NPV of cash flows to zero. IRR is time-sensitive: the same MOIC achieved in 3 years produces a higher IRR than over 7 years. Both metrics are used together: PE firms target ~20-25% IRR and 2.5-3.5x MOIC over a 5-year hold.
25. What is a debt schedule in an LBO model?
A debt schedule tracks each debt tranche (Term Loan B, Senior Notes, Mezzanine) through the hold period. For each tranche: beginning balance, interest expense (rate × beginning balance or average balance), mandatory amortisation (e.g., 1% per year for TLB), cash sweep (excess FCF applied to optional prepayment, usually in order of seniority), and ending balance. The total debt service (interest + amortisation) feeds into the income statement and cash flow statement. The cash sweep reduces debt and interest expense in subsequent periods, improving FCF in a virtuous cycle. The model must be circular-free or use iterative calculation.
M&A Analysis
26. What is accretion/dilution analysis?
An accretion/dilution analysis determines whether an acquisition increases (accretion) or decreases (dilution) the acquirer's earnings per share (EPS) in the first full year post-close. If the target's earnings yield (E/P) exceeds the acquirer's after-tax cost of financing, the deal is accretive. For a stock deal, if the target's P/E is lower than the acquirer's P/E, the deal is accretive. Accretion/dilution analysis is used to assess whether a deal makes financial sense for the acquirer's shareholders in the near term, though long-term strategic value may justify short-term dilution.
27. What is a merger model?
A merger model (also called an M&A model) combines the financial statements of an acquirer and target to analyse the pro forma impact of an acquisition on the combined entity's financials, especially EPS. It involves determining the purchase price, financing mix (cash, stock, debt), purchase price allocation (PPA) for goodwill and intangible amortisation, synergies (cost and revenue), and one-time transaction costs. The model then compares the acquirer's standalone EPS to the combined pro forma EPS to determine accretion or dilution. It is a standard deal analysis tool in investment banking.
28. What are synergies in M&A and what are the different types?
Synergies are the additional value created from combining two companies that neither could achieve independently. Cost synergies reduce expenses (eliminating duplicate headcount, consolidating facilities, procurement savings from greater buying power, IT system rationalisation). Revenue synergies increase sales (cross-selling to each other's customer bases, entering new markets, combining product lines). Revenue synergies are typically harder to achieve and more uncertain than cost synergies, so analysts apply a "haircut" (discount) to revenue synergy estimates. The market often values synergies at 30-50% of their theoretical total to account for execution risk.
29. What is the difference between a strategic buyer and a financial buyer?
A strategic buyer is a corporate acquirer in the same or adjacent industry who buys a company for strategic reasons — market share, product capabilities, geographic expansion, or synergies. Strategic buyers can justify paying higher prices because they realise synergies. A financial buyer is typically a private equity firm that acquires companies purely for financial return, financing the acquisition with leverage and targeting a specific IRR over a 3-7 year hold period. Financial buyers cannot typically pay as much as strategic buyers because they rely on the standalone value of the business and financial engineering rather than synergies.
30. What is goodwill and how does it arise in M&A?
Goodwill arises when an acquirer pays more for a target than the fair market value of its identifiable net assets (tangible assets + identifiable intangible assets − liabilities). Goodwill = Purchase Price − Fair Value of Net Assets. It represents unidentifiable intangible value such as brand reputation, customer relationships, and synergies. Under IFRS and US GAAP, goodwill is not amortised but is tested annually for impairment — if the carrying value exceeds the recoverable amount, an impairment charge reduces goodwill and increases expenses. Goodwill impairment was a signal of overpayment in deals like AOL-Time Warner.
Financial Statement Analysis
31. What are the key profitability ratios?
Gross Margin = Gross Profit / Revenue (measures core product profitability). EBITDA Margin = EBITDA / Revenue (measures operating cash generation). EBIT Margin = EBIT / Revenue (operating profitability after D&A). Net Profit Margin = Net Income / Revenue (bottom-line profitability). Return on Equity (ROE) = Net Income / Average Shareholders' Equity (return on equity invested). Return on Assets (ROA) = Net Income / Average Total Assets. Return on Invested Capital (ROIC) = NOPAT / Invested Capital (overall capital efficiency). ROIC compared to WACC indicates whether a company is creating or destroying value.
32. What is the DuPont analysis?
DuPont analysis decomposes ROE into three components to understand the drivers of return: ROE = Net Profit Margin × Asset Turnover × Equity Multiplier. Net Profit Margin (Net Income / Revenue) measures operational efficiency. Asset Turnover (Revenue / Total Assets) measures how efficiently assets generate revenue. Equity Multiplier (Total Assets / Equity) measures financial leverage. A company can achieve high ROE through high margins, efficient asset use, or high leverage — the DuPont breakdown reveals which factor is driving it. An extended 5-factor DuPont further breaks down margin into tax burden and interest burden.
33. What are liquidity ratios?
Liquidity ratios measure a company's ability to meet short-term obligations. The Current Ratio = Current Assets / Current Liabilities (above 1.0 is generally acceptable). The Quick Ratio (Acid Test) = (Current Assets − Inventory) / Current Liabilities (more conservative, excludes inventory which may not be quickly converted to cash). The Cash Ratio = Cash / Current Liabilities (most conservative). Credit analysts focus on liquidity ratios when assessing default risk. A declining current ratio may indicate tightening liquidity; excessively high ratios may indicate idle cash that is not being deployed efficiently.
34. What are leverage ratios and why do lenders care about them?
Leverage ratios measure how much debt a company carries relative to its earnings or assets. Net Debt / EBITDA is the most widely used — it shows how many years of EBITDA are needed to repay net debt (3.0-4.0x is typical for investment-grade companies; 6.0x+ for highly leveraged LBOs). Debt / Equity = Total Debt / Shareholders' Equity (capital structure measure). Interest Coverage = EBIT / Interest Expense (ability to service debt; below 1.5x raises concern). Lenders include leverage and coverage covenants in loan agreements — breaching them triggers acceleration of debt repayment or renegotiation.
35. What is the cash conversion cycle (CCC)?
The Cash Conversion Cycle measures how long it takes for a company to convert investments in inventory and other resources into cash from sales: CCC = DSO + DIO − DPO, where DSO (Days Sales Outstanding) = AR / (Revenue / 365), DIO (Days Inventory Outstanding) = Inventory / (COGS / 365), and DPO (Days Payable Outstanding) = AP / (COGS / 365). A shorter CCC means faster conversion of operations to cash — Amazon famously achieves negative CCC, collecting from customers before paying suppliers. Analysts track CCC trends to identify working capital efficiency improvements or deterioration.
36. What is normalisation in financial analysis?
Normalisation adjusts reported financial statements to remove one-time, non-recurring, or non-operating items so that the underlying, sustainable earnings are visible. Adjustments include adding back restructuring charges, litigation settlements, asset write-downs, stock-based compensation, and acquisition-related costs. The resulting "adjusted" or "normalised" EBITDA and earnings better reflect the business's ongoing performance and are more appropriate for valuation multiples and trend analysis. In M&A, normalisation is critical because buyers are purchasing future earnings power, not historical one-time items.
37. What are the key metrics for SaaS companies?
SaaS companies are valued on growth and unit economics rather than traditional profitability. Key metrics include ARR (Annual Recurring Revenue) and MRR (Monthly Recurring Revenue) — the predictable, recurring revenue base; Net Revenue Retention (NRR) — the percentage of revenue retained from existing customers including expansions, ideally >110%; Churn Rate — the percentage of customers or ARR lost; CAC (Customer Acquisition Cost); LTV (Customer Lifetime Value); LTV/CAC ratio (ideally >3x); and the Rule of 40 (Revenue Growth % + EBITDA Margin % should exceed 40%). EV/ARR and EV/NTM Revenue are the primary SaaS valuation multiples.
38. How do you analyse a company's debt capacity?
Debt capacity analysis determines the maximum debt a company can service based on its projected cash flows. Steps include building a base case and downside scenario FCF projection, calculating the implied maximum debt at various leverage ratios (e.g., 4.0x, 5.0x EBITDA) and coverage ratios (e.g., 2.0x interest coverage), stress-testing whether the company can service debt through a downturn, assessing the debt amortisation schedule against projected FCF, and comparing to peer capital structures and market precedents. Investment-grade companies target Net Debt / EBITDA below 3.0x; leveraged finance deals typically range from 4.0-7.0x.
39. What is the price-to-earnings (P/E) ratio and its limitations?
The P/E ratio = Market Price per Share / Earnings Per Share. It measures how much investors pay for each dollar of earnings. A high P/E implies high growth expectations or premium quality; a low P/E implies low expectations or undervaluation. Limitations include: it is distorted by accounting choices (D&A methods, revenue recognition), capital structure (interest expense affects earnings but not enterprise value), non-cash charges, and negative earnings making the ratio meaningless. Comparisons are only valid between companies with similar capital structures, growth rates, and accounting policies. Forward P/E (using next year's earnings) is more useful than trailing P/E.
40. What is meant by "running the numbers" in a deal?
"Running the numbers" in investment banking means building or stress-testing the quantitative analysis behind a deal — typically the DCF, LBO model, accretion/dilution analysis, and comparable company/precedent transaction analyses. It involves checking key outputs (implied valuation ranges, IRR, EPS impact), stress-testing with different assumptions, and summarising results for presentation. In pitches, it means verifying that the deal economics are compelling enough to present to a client. Analysts are expected to run numbers quickly and accurately, understand what is driving each output, and articulate the key value drivers and risks.
Modeling Best Practices
41. What are best practices for building a financial model in Excel?
Best practices include separating inputs (assumptions, clearly highlighted in blue or yellow), calculations (formulas, in black), and outputs (results, often in a separate summary tab). Hard-coded values should never appear in formulas — always reference a single assumption cell. Use consistent formatting (labels, units, decimal places). Avoid hidden rows/columns that obscure logic. Structure the model with clear sections (Income Statement → Balance Sheet → Cash Flow Statement → Valuation). Use named ranges for key assumptions. Include a checks tab for balance sheet balances and formula consistency. Build in circular reference avoidance (or use iterative calculation deliberately).
42. What is a circular reference in financial modeling and how is it handled?
A circular reference occurs when a formula refers back to its own cell directly or indirectly, most commonly in models where interest expense depends on the average debt balance, which depends on the cash available for debt repayment, which depends on after-tax earnings, which depends on interest expense. Solutions include enabling iterative calculation in Excel (File → Options → Formulas → Enable iterative calculation with 100 iterations), using a "plug" approach that breaks the circular by using prior-period debt for interest calculations, or structuring the debt schedule to avoid the circularity through careful sequencing of calculations.
43. What is a sources and uses table?
A sources and uses table summarises how an acquisition is financed (sources) and where the money goes (uses). Sources include debt tranches (senior secured, TLB, high-yield bonds), sponsor equity, rollover equity (management reinvesting), and seller notes. Uses include the equity purchase price (calculated from the acquisition multiple and EBITDA), transaction fees (banking, legal, accounting), financing fees (debt issuance costs), and other deal costs. Sources must equal uses — the table provides a check on the financing structure and is the entry point for both the LBO model and the pro forma balance sheet.
44. What is the treasury stock method?
The treasury stock method calculates the diluted share count by assuming that proceeds from the exercise of in-the-money options and warrants are used to repurchase shares at the current market price. Diluted shares = Basic shares + Options exercised − Shares repurchased with proceeds. For example, if 1 million options have a $5 strike and the stock trades at $10, the company receives $5M in proceeds, which would repurchase 500K shares at $10 — net dilution is 500K shares. This method is used in EPS calculations and equity bridge computations. Options with exercise prices above the current share price are out-of-the-money and excluded.
45. What is a waterfall analysis in private equity?
A waterfall distribution model defines how exit proceeds are allocated among different stakeholders (LP investors, GP, management) based on the terms of the fund's limited partnership agreement. A typical PE waterfall: (1) Return of capital — LPs receive their invested capital back first; (2) Preferred return (hurdle rate, typically 8%) — LPs receive a preferred return; (3) GP catch-up — the GP (general partner) receives distributions to "catch up" to their carried interest percentage; (4) Carried interest split — remaining profits split (typically 80% LP, 20% GP carry). The waterfall ensures LPs are compensated adequately before the GP earns performance fees.
46. How do you calculate IRR in an LBO?
IRR in an LBO is calculated from the equity cash flow stream: initial equity investment at time 0 (negative), dividends received during the hold period (positive, if any), and equity proceeds at exit (positive). Using Excel's =IRR(cash_flows) function returns the annualised rate of return that sets the NPV of these cash flows to zero. If there are no dividends, IRR simplifies to: IRR = (Exit Equity Value / Initial Equity)^(1/Hold Period) − 1. IRR is sensitive to exit timing — holding longer reduces IRR even if MOIC stays the same. A 3.0x MOIC over 3 years ≈ 44% IRR; over 7 years ≈ 17% IRR.
47. What is a sensitivity table in Excel and how is it built?
A sensitivity table uses Excel's Data Table feature (Data → What-If Analysis → Data Table) to display how a model output changes across a range of two input assumptions. Steps: (1) Set up a table with one assumption's range across the top row and another's range down the left column; (2) Place a formula in the top-left corner cell that references the output cell; (3) Select the full table including the corner formula; (4) Data → What-If Analysis → Data Table → enter the row input cell and column input cell referencing the assumption cells in the model. Excel instantly populates all combinations. Colour-code with conditional formatting to highlight attractive/unattractive scenarios.
48. What is a precedent transaction analysis?
Precedent transaction analysis values a company using multiples (EV/EBITDA, EV/Revenue) paid in comparable past M&A deals. Transaction multiples typically exceed trading comps because they include a control premium (buyers pay a premium to acquire control). Key steps: identify transactions in the same sector with similar size, growth, and timing (typically last 3-5 years); collect deal terms (purchase price, target EBITDA/Revenue); calculate implied multiples; note deal context (strategic vs. PE buyer, hostile vs. friendly, market conditions). Transactions include strategic buyer synergies, so they represent the upper end of the valuation range.
49. What are comparable company multiples and how do you select comps?
Comparable company multiples derive a company's value by applying trading multiples (EV/EBITDA, EV/Revenue, P/E, P/S) from publicly traded peers. Peer selection criteria include similar industry and sub-sector, comparable size (revenue, EBITDA, market cap), similar business model, geographic market, and growth profile. EV/NTM EBITDA (next twelve months) is most commonly used for mature businesses; EV/NTM Revenue for high-growth companies. The median or 25th-75th percentile range is applied to the target company's corresponding metric. Quality of the comps set is critical — inappropriate comps produce misleading valuations.
50. How do you present a valuation to a client?
Investment banking valuation presentations include: a football field chart summarising the valuation range from all methodologies, a DCF summary (WACC and terminal growth rate sensitivity table, key assumptions), a trading comps table (peers with key financials and multiples), a precedent transactions table, and a deal rationale slide connecting the valuation to the strategic context. The narrative frames the analysis: what range is supportable, what drives the premium/discount versus peers, and why the proposed price is fair. Presentations are tailored to the audience — CEOs want conclusions, CFOs want methodology, lawyers want disclosure adequacy.