What acquisition price, sources and uses, and sponsor economics create a credible transaction case?
Model profile
DIY & Hardware Company Valuation
Value a listed home improvement retailer the way retail analysts do. Grow store sales by like-for-like and new space, split trade and DIY customers, test inventory turn and the spring stock build, carry leases as debt, check that new stores pay back, and see what a housing downturn does to the value.
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.
- Stores, selling space and sales density, with like-for-like growth and the space new stores add
- Trade (professional) and DIY customers, and a housing-market scenario
- Inventory turn and the seasonal spring stock build against cash and the facility
- Leases as debt: EV / EBITDAR multiples and lease-adjusted leverage
- New-store economics and payback; EV per square metre
- An offer price build with a control-basis fairness view, a valuation report, and an audit trail with reviewer sign-off
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
- Like-for-like growth, next yearSales density
- Sales per sqm, next yearOn average selling space
- Trade customers' share of revenueNext year
- Inventory turn, next yearCost of sales / inventory
- 13 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?