What acquisition price, sources and uses, and sponsor economics create a credible transaction case?
Model profile
Company Valuation Model
Value a listed company the way an equity analyst or banker would. Forecast each revenue segment, build three linked statements with leases and debt, and value the shares by DCF, trading comparables, sum of the parts and precedent transactions, set against broker targets and the trading range, ending in a football field and a buy, hold or sell indication.
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.
- An offer price build with a control-basis fairness view, a valuation report, and an audit trail with reviewer sign-off
- Reported years analysed: segment growth, common-size costs, working capital days, capital intensity and ROIC
- A segmented forecast under base, bull, bear and no-growth cases, growth fading to the long-term rate, all recalculated on every run
- Margin targets, fixed costs, and drivers averaged over the reported years you choose, with growth compounded
- Three balanced statements with depreciation by vintage, intangible amortization, lease schedules, tax losses, debt repayment and capital raises
- A DCF from the balance sheet date with mid-year discounting, a normalised terminal cash flow and a reverse DCF
- A full bridge from enterprise value to the shares: minorities, preferred equity, pensions and associates
- Explicit policies for stock-based compensation and leases, so free cash flow, net debt and multiples stay consistent
- WACC from peer betas unlevered and relevered at a target structure, with low and high cases
- Calendarised trading comparables in any currency, a sum of the parts with head-office costs, and precedents net of the control premium
- An implied value summary, probability-weighted scenarios, football field, buy, hold or sell indication and 17 model checks
- A Monte Carlo DCF with correlated, optionally bounded shocks, the probability of beating the share price and a sensitivity tornado
- Up to ten documents per upload: annual reports read by AI with page citations, iXBRL filings and price or peer lists read exactly
Build the case
Inputs and workspaces
- DocumentsUpload up to ten annual reports, filings, presentations and lists; review what was read, then apply it.
- Valuation settingsCompany and market data, DCF, cost of capital, comparables and the football field.
- Forecast assumptionsScenario, growth taper, costs, working capital, assets, leases and financing.
- Reported financialsRevenue segments, reported years and option tranches.
- Peers and transactionsComparable companies, sum-of-the-parts businesses and precedent transactions.
- Market evidenceBroker targets, share price history, addressable markets and the macro outlook.
- Audit trail and sign-offEvery saved change to the case, and the preparer and reviewer sign-off of each run.
Review the result
Outputs and analysis
- Average implied value per shareMethods in the average
- Upside to the average implied valueAgainst the share price
- DCF value per shareSelected terminal method
- WACCUsed in the DCF
- Sum-of-the-parts value per shareCentral multiples
- Precedent transactions value per shareCentral multiple
- Trading comparables value per shareCentral multiple
- Broker mean target priceEquity analysts
- 7 additional metrics in the workspace
- Financial statements and free cash flowDetailed schedules
- Valuation, comparables and market evidenceDetailed 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?