Realistic assumptions are inputs a buyer or lender can rebuild from public or internal evidence and a clear method. In investment banking models, they are the bridge between diligence and valuation: verifiable, replicable, and skeptical of optimism. Hope is not a forecast; evidence is.
To be decision-useful, your assumptions must survive stress, disclosure, and audit. This guide distills how to structure inputs, tie them to documents and data, and present them so valuation, underwriting, and risk control converge on the same facts.
Set the objective and protect the perimeter
Treat assumptions as commitments, not placeholders. They should pass three tests: they survive sensitivity runs, they hold up under disclosure reviews, and they withstand audit-level questions. If governance has not cleared a decision, keep it in scenarios, not the base case. Keep the model aligned to the deal perimeter. Carve-outs, discontinued lines, and assets held for sale require explicit treatment and separate bridges, or you will mix performance signals and misstate capacity.
Separate operating, accounting, and financing inputs
Classify assumptions by type and owner so each follows a specific diligence path. Operating drivers include volume, price, mix, utilization, churn, and capacity. Accounting covers revenue recognition, leases, and presentation effects. Financing includes base rates, spreads, covenants, fees, and availability. That separation makes responsibility clear and prevents a single rosy input from contaminating multiple areas of the model or the three-statement model.
Incentives exist – anchor to evidence
Management will lean toward growth and budget defense. Bankers need forecasts that can support valuation and financing. Sponsors optimize for underwriting resilience. Lenders want visible debt service and strict definitions. Expect pressure to smooth gaps between guidance and valuation. Rank assumptions by verifiability, link each to a source, and push back with facts instead of counter-forecasts.
Use a hierarchy of evidence
- Audited internals: Cohorts, unit economics, bookings versus billings, realized price, cost actuals, and capacity. This is the foundation.
- Contracts and terms: Customer and supplier contracts, pricing schedules, lease terms, debt agreements, and service-level agreements.
- External data: Competitor disclosures, third-party datasets, benchmarks, and macro indicators.
- Model-inferred: Only use parameters inferred from the model after documenting the method that links them back to observed outcomes.
From clean history to disciplined forecast
Start by cleaning the historical base. Align accounting policies across time and perimeter. Normalize one-offs, but maintain a reconciled bridge from GAAP or IFRS to any adjusted metrics. Keep add-backs modest and transparent. ESMA has reminded issuers to define and reconcile alternative performance measures and not give them undue prominence since Oct-2023. Then identify the few inputs that actually drive results. In services, price, utilization, headcount, wage inflation, and churn often dominate. In manufacturing, volume, mix, input costs, yield, and labor productivity are key.
Next, create a short list of material assumptions. Everything else should be formulaic or grouped in an other bucket with a hard cap on combined impact. This reduces assumption creep and makes review faster.
Build revenue assumptions that stand up to diligence
Disaggregate revenue where economics differ by product, channel, and region. Keep total market growth for scenarios rather than the base case. Use cohort and pipeline math instead of slogans. Tie new logo wins to pipeline stages and historical conversion rates. Bridge bookings to billings to revenue through backlog burn and cancellation rates. If the average sales cycle is six months, do not assume two without defining the operational change enabling it.
Price realization matters. Quote realized net price versus list after rebates and promotions. If gross-to-net is 82 percent today, show contract enforcement or policy changes that move it. Product and mix must tie to engineering gates, field trials, launch capacity, and channel retraining with lag and cost. Model logo churn and net revenue retention separately. Enterprise multiyear contracts behave differently from small monthly accounts. Use cohort decay from billings, not a flat rate. Seasonality should come from at least three clean years, with any change tied to a calendar or contract shift.
Cost of goods sold and direct costs
Tie input costs to observable indices or executed contracts. If hedged, model the hedge profile and roll-off. If not, link to market curves and show scenarios. Apply learning curves and yield gains only where you can point to process investments, capex, or supplier changes, and document the lag between spend and effect. Treat freight, energy, and logistics as separate drivers where material. These items move margins even when volumes are unchanged.
Operating expenses and operating leverage
Base wages on current compensation bands and headcount rather than a stable percent of revenue. Use separate drivers for merit increases, market adjustments, and capacity additions by function and geography. Variable sales and marketing should track gross profit or bookings. Fixed overhead grows with inflation and step-changes tied to sites, systems, or compliance. Do not book zero-based budgeting gains without a plan. Model initiatives as programs with start dates, one-time costs, and run-rate effects.
Capex and working capital discipline
Split maintenance and growth capex. Maintenance sustains current revenue; growth adds capacity or product scope. Tie growth capex to capacity ramps and sales plans. If forecast revenue growth exceeds practical capacity, add capex or cap growth. Treat capitalized software and implementation costs explicitly; they affect amortization and EBITDA under lease and capitalization rules.
Model DSO, DIO, and DPO by segment where mix differs, using trailing 12-month averages scrubbed for one-offs. Link changes to contract terms, customer mix, and supply chain programs. As a quick check, at 110 revenue with DSO 55 days, DIO 60 days, and DPO 45 days, net working capital is about 21.7 compared with 19.7 at 100 revenue, a 2.0 cash use. Align revenue recognition and billing. Under ASC 606 and IFRS 15, contract assets can build when billing lags performance. Base assumptions on billing schedules and acceptance milestones, and show the mechanics in your working capital schedules.
Accounting posture affects capacity and comparability
Lease accounting boosts EBITDA but not cash. IFRS 16 and ASC 842 move operating leases onto the balance sheet. Adjust debt capacity for lease interest and amortization and measure lease-adjusted leverage. New standards improve data granularity. ASU 2023-07 expands segment expense disclosures, ASU 2023-09 expands income tax disclosures, and IFRS 18 standardizes presentation and subtotals. Use these updates to sharpen assumptions and comparability.
Financing assumptions and covenant math
Model base rates off observable curves with scenario bands, for example, Term SOFR or Treasuries by tenor. Do not hardcode a single rate across a multi-year forecast. Tie spreads and OID to rating or leverage bands, widen them in the downside, and include call protection, prepayment fees, and amendment risk. Include ticking fees, commitment fees on undrawn facilities, upfront fees amortized over life, and agency fees. Revolver availability should reflect borrowing bases or springing covenants. Build covenants on lender-style EBITDA and net leverage, not management’s adjusted numbers. Add tests on cash interest coverage and minimum liquidity. Anchor these line items in a transparent debt schedule and codify headroom with covenant modeling.
Tax assumptions and Pillar Two
Cash taxes are not the book rate. Model net operating loss usage, interest limits, stock-based compensation effects, R&D credits, and foreign tax credits. Tie jurisdictional mix to segment forecasts. OECD Pillar Two creates a 15 percent global minimum tax in many jurisdictions. For multinationals with low effective rates, model top-up taxes and safe harbors by jurisdiction. Update cash tax models as ASU 2023-09 disclosures arrive so you can reduce guesswork with better data.
Valuation choices that reflect market data
In a DCF model, anchor the risk-free rate to current government yields by currency. Cross-check the equity risk premium against market-implied and survey estimates. As of early 2024, the US implied ERP was around 5.0 percent and Kroll’s recommended ERP was 5.0 percent in Sep-2024. Use the lower of your market-implied estimate and a vetted range unless asset risk demands otherwise. Unlever and relever betas using a clean peer set, excluding peers distorted by events or divergent segments. Keep terminal growth tied to long-run nominal GDP or sector volume growth. Ensure terminal capex sustains capacity and margins reflect competition and industry structure. Use the midyear convention unless cash conversion is back-weighted.
For an LBO model, anchor purchase price and exit multiple to current trading and deal comps. In the downside, compress the exit multiple, especially if multiple expansion is the only path to returns. Set initial leverage where downside cash generation supports deleveraging. Step up cash interest when base rates or spreads widen. Include all fees, management incentives, and equity rollovers; cash-on-cash outcomes are sensitive to them even when IRR looks fine. For more on avoiding common pitfalls, see this overview of DCF valuation mistakes.
M&A mechanics and timing risk
Separate synergies and dis-synergies across cost, revenue, and working capital. Tie each to execution events: headcount actions, procurement waves, system cutovers, and channel overlap. Load synergy realization over 12 to 36 months, with gates for notices, site closures, and ERP work. Model purchase accounting effects including step-ups, intangibles, deferred taxes, and inventory fair value since they swing early-period EBITDA and cash. Reflect earnouts or contingent consideration in cash flows and alignment. Regulatory reviews can extend timing and require remedies. The 2023 Merger Guidelines raise timing and certainty risk for both horizontal and vertical combinations. Do not credit day-one synergies when close timing or remedies are uncertain. For practical tactics, review this guide to evaluating synergy realization.
Credit and project-style modeling
Estimate default risk with probability-of-default and loss-given-default anchored in rating migration or sector history. Haircut collateral values based on market depth and enforceability. For structured or asset-based deals, model eligibility, advance rates, triggers, and cash traps. Stress servicing costs and delinquency spikes. Define cure rights, equity cure limits, and replacement mechanics for critical providers, including timing for detection-to-remedy lags.
Scenarios and dependency mapping
Start with three cases: base, downside, and management plan. Set the downside to match the worst two-year sector period in the last decade unless you have strong evidence of resilience. Correlate assumptions. When price falls, mix often worsens, churn rises, and working capital expands. Avoid mirrored upsides and downsides with symmetric moves. Real stress is lopsided. Add one or two business-specific shocks, such as a key supplier outage or a product recall, to avoid false comfort. Summarize sensitivities with correlated drivers using Excel sensitivity tables.
Governance and documentation that withstand scrutiny
Keep an assumption log with owner, definition, source, as-of date, next update date, and whether it is an input or formula output. Freeze assumptions at gates: sell-side before launch, buy-side before investment committee, with pre-agreed triggers for changes only. Reconcile all non-GAAP and adjusted metrics to audited figures with definitions aligned to regulatory expectations.
Implementation cadence that drives discipline
- Weeks 1-2: Define scope and perimeter. Confirm reporting basis and carve-out boundaries. Assign owners for revenue, cost, capex, working capital, financing, and tax.
- Weeks 2-4: Collect and normalize data. Pull contracts, cohorts, and supplier terms. Map accounting policies and lease schedules. Build the assumption log and baseline metrics.
- Weeks 4-6: Draft driver models such as revenue cohorts, pricing ladders, cost curves, capacity ramps, and working capital turns. Establish financing term sheets and tax structures.
- Weeks 6-7: Run challenge sessions. Replace aspirational inputs with evidence-backed ranges. Lock base and downside.
- Weeks 7-8: Calibrate externally with peers, market data, and credit feedback. Update financing costs to current curves. Finalize materials with bridges and sensitivity maps.
- Ongoing: Refresh assumptions as new disclosures under IFRS 18, ASU 2023-07, and ASU 2023-09 arrive.
Fast kill tests before you build more
- Capacity: Compare forecast volume to installed capacity and hiring lead times. If utilization exceeds sustainable levels, add capex and ramp time or cut growth.
- Margin bridge: Require named programs, owners, timing, and contract changes. If detail is thin, cap expansion at peer medians.
- Working capital: Check DSO, DIO, and DPO against contract terms. If the model beats terms without incentives or process changes, revert to historical averages.
- Revenue recognition: Reconcile bookings and backlog to revenue. If contract assets grow without cash, tighten cash conversion and lift interest expense.
- Integration: Benchmark one-time costs at 50-100 percent of annual gross cost synergies for complex integrations. If below, increase and push timing.
- Financing: Run interest coverage and liquidity under the downside with base rates 100-200 bps higher. If it breaks, reduce leverage or add equity.
- Leases: Compute lease-adjusted leverage and fixed-charge coverage. If compliance depends on ignoring leases, revise debt capacity.
- Taxes: Reconcile modeled cash taxes to new disclosures and jurisdictional mix. If variance is large, lift the cash rate or add Pillar Two top-ups.
Speed checks and smart shortcuts
Cross-check gross margin expansion against supplier terms and wage inflation. Cross-check ROIC against peer medians. Cross-check capacity against lead times. When time is tight, use a simplified driver model with three to five revenue drivers, two cost drivers, maintenance capex, and working capital turns. If it cannot produce acceptable returns with conservative inputs, the full build will not rescue it. For credit, a cash waterfall can beat a full three-statement model for speed. If free cash flow covers fixed charges with cushion in the downside, the structure is more likely to hold.
Fresh angle – assumption heat map and red team review
Create an assumption heat map that scores each input on impact, evidence quality, and controllability. High-impact, low-evidence items trigger a red team review: a separate small group challenges the source, replicates math from raw files, and proposes ranges rather than points. This 90-minute ritual removes bias faster than another spreadsheet iteration and surfaces the two or three inputs that deserve the most incremental diligence.
Workbook map that reviewers understand fast
- Inputs: All assumptions with sources, as-of dates, owners, scenario selectors, and currency.
- Revenue engine: Cohorts, pipeline, price ladders, and backlog rolls, plus a module for accounting revenue versus operational bookings.
- Cost and capacity: Bills of materials, supplier costs, wage ladders, learning curves, capacity ramps, and capex links.
- Working capital: DSO, DIO, DPO by segment, plus contract asset and liability schedules.
- Financing: Debt schedule, fees, amortization, covenants, liquidity waterfall, cash interest timing, and cash sweep mechanics.
- Taxes: Jurisdictional rate stack, NOL and credit usage, Pillar Two mechanics, and cash payment timing.
- Cash and consolidation: Direct statement of cash flows from drivers, lease schedules, and lease-adjusted metrics.
- Outputs and checks: KPI dashboards, covenant tests, bridges to investment cases, and integrity checks for circularity and sign errors.
When history is distorted
Pandemic spikes, commodity shocks, and one-time events can break naive baselines. Use pre-shock cohorts and extrapolate normalized behavior. Apply reversion speeds based on periods where distortion faded. When data is missing, triangulate with peer disclosures, third-party datasets, and partial internal data. Use ranges and scenarios, mark them for confirmatory diligence, and avoid single point estimates.
Keep assumptions fresh
Update interest rates, spreads, and equity risk premium inputs regularly. The implied and recommended ERP near 5.0 percent in 2024 are useful guards, but the asset’s risk profile rules. Use new segment and tax disclosures to refine cost and cash tax models. Track lending standards through spreads, advance rates, and documentation terms. Central bank loan officer surveys and primary issuance feedback add context to financing assumptions.
Decision-useful presentation
Show a base case with a single-page bridge from revenue to free cash flow. Call out the five assumptions that move valuation or credit outcomes the most. Show a downside that preserves liquidity and covenant headroom, or the equity and structure needed to achieve it. Present sensitivities with correlated drivers where price decline, mix shift, and slower collections move together. Put GAAP or IFRS metrics first, non-GAAP second, with full reconciliations.
What realistic looks like
Each assumption has an owner, a documentable source, and an update cadence. The model reconciles to audited financials and contract terms with transparent and limited adjustments. Downside cases reflect real stress with dependent variable shifts, and liquidity and covenants survive there, or the capital structure changes on paper. Management plans respect operational capacity and regulatory timelines. If an approval is required, the model waits before taking credit. The final model fits on one page conceptually yet captures the few drivers that matter.
Closeout and records
Archive the assumption log, model index, versions, Q&A, user list, and full audit logs. Hash the archive. Apply retention rules. On vendor systems, request deletion and a destruction certificate. Honor legal holds over any deletion. The goal is simple: bring uncertainty into view, price it with discipline, and separate base facts from what must go right.
Conclusion
Build assumptions that anyone can trace back to source, replicate in a fresh workbook, and defend under pressure. When inputs are disciplined, valuation, financing, and risk control align faster and with fewer surprises.