ProspektLab.Open workspace
Menu

Editable financial models

From a filing to
a model you can inspect.

Review the source inputs, change the assumptions and follow the cash through the debt schedule. Download an Excel workbook with formulas you can edit.

Try the mechanics

What changes when debt or capex changes?

Example Manufacturing is an invented teaching company. Revenue is ₹1,000 crore and EBITDA is ₹200 crore; these are not live company figures. Inputs below stay in your browser.

Illustrative five-year equity return

33.3% IRR

4.21× MOIC · Entry EV ₹1,280 cr

The full workbook shows debt maturities, cash sweeps, minority assumptions and cash flow. This estimate excludes transaction-specific tax, legal and financing terms.

Illustrative EBITDA and cash flow before debt repayment. Values are also in the table below.Year 1Year 2Year 3Year 4Year 5Blue: EBITDA · Light blue / orange: cash flow before principal
Illustrative cash and financing in INR crore
YearEBITDACash flow before debt repaymentDebtUnfunded cash
1₹214 cr₹74.5 cr₹525.5 cr₹0 cr
2₹229 cr₹87.3 cr₹438.2 cr₹0 cr
3₹245 cr₹101.6 cr₹336.6 cr₹0 cr
4₹262.2 cr₹117.4 cr₹219.2 cr₹0 cr
5₹280.5 cr₹135.7 cr₹150 cr₹0 cr

A workbook, with the work visible.

1 / Source inputs

Read the filing excerpts, reporting periods and units. Missing inputs stay missing until you supply or verify them.

2 / Editable assumptions

Review growth, capex, financing and ownership assumptions. Keep reported facts separate from your scenario.

3 / Debt and returns

Inspect cash, facility limits, repayment schedules and sensitivities. Financing shortfalls remain visible.

Start with the right question.

For Reliance and other groups, consolidated EBITDA is not the same as cash available to the acquisition entity. Review subsidiary minorities, distributions, capex commitments and promoter control. A hypothetical LBO is a modelling exercise.

Read the LBO modelling guide