What acquisition price, sources and uses, and sponsor economics create a credible transaction case?
Model profile
Three-Statement Financial Analysis
Build a connected income statement, cash flow, and balance sheet from an opening balance sheet and actual years, then forecast from growth, margin, working-capital, capex, and financing drivers. A revolver funds any shortfall, every case must pass independent reconciliation checks before it is saved, and lender covenants are tested under scenarios and reverse stress.
Decision scope
Questions this model helps you examine
How do operating projections, cash generation, and debt paydown support the proposed capital structure?
How do exit timing, exit multiples, and downside cases affect sponsor returns and value per share?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- Opening balance sheet plus revenue, cost, working-capital, asset, and financing schedules
- Import actual years from Excel, with a prefilled template and a review step
- Price, volume and cost-inflation drivers, straight-line asset vintages, and a revolver solved on average balances
- 26 independent integrity checks; a case that does not reconcile is never saved
- Ratios on average balances, DuPont analysis, FFO to debt, fixed-charge cover, CFADS and debt service cover
- Covenant tests on reported or frozen-GAAP definitions with headroom and equity cure, scenarios, and reverse stress testing
- Tax losses carried forward, tax payable timing, disposals, facility fees, foreign-currency debt and other comprehensive income
- DCF valuation with a sensitivity tornado, a Monte Carlo risk profile, and a quarterly liquidity view
- Optional AI assistance with your own Anthropic, OpenAI, Google Gemini or Groq key: read annual reports, suggest drivers, review runs
- XLSX, PDF, and CSV exports
Build the case
Inputs and workspaces
- Case setupName, currency and units, forecast method, minimum cash and the revolver.
- Import actual yearsUpload the template or your own statements workbook, review, then apply.
- Linked schedulesOpening balance sheet, yearly schedules, and adding, removing or rolling years.
- Forecast driversGrowth, margins, working-capital days, capex, tax, interest, payout and debt plan by year.
- Covenants and scenariosCovenant thresholds and the scenario shocks used by full analysis runs.
Review the result
Outputs and analysis
- Final revenueFinal period
- Final EBITDAFinal period
- Final net incomeFinal period
- Ending cashFinal period
- Minimum cashForecast years
- Peak revolverForecast years
- Maximum net debt / EBITDAForecast years
- Minimum interest coverEBITDA / finance costs
- 2 additional metrics in the workspace
- Financial statementsDetailed schedules
- Ratios, checks and covenantsDetailed schedules
- Inputs and schedulesDetailed schedules
Designed for review
Who this model is for
- Private-equity sponsors and corporate development teams
- Investment and financial analysts
- Transaction advisers
- Investment committees and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?