Financial Modelling Centre
One model. Every statement, ratio and sensitivity.
Move an assumption and the statements, coverage ratios and returns recalculate immediately. The same engine drives the memorandum, the credit assessment and the committee pack.
Model recalculating live
Equity IRR
0.0%
Eight-year hold
NPV at 12%
$-61.2M
Project cash flows
Minimum DSCR
0.36x
Below covenant floor
Payback
> 8 yrs
Cumulative equity cash
Assumption drivers
Adjust and observe the effect across every output.
Revenue build
EBITDA and debt service
Y1Y2Y3Y4Y5Y6Y7Y8
Assumptions
Figures in USD millions unless stated otherwise.
| Line | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 |
|---|---|---|---|---|---|---|---|---|
| Revenue growth | base | applied | applied | applied | applied | applied | applied | applied |
| EBITDA | 4.1 | 5.1 | 6.3 | 7.8 | 9.6 | 12.0 | 14.8 | 18.4 |
| Free cash flow | -8.6 | -7.5 | -6.3 | -4.8 | -3.1 | -1.1 | 1.3 | 4.2 |
Demonstration model, signed-in projects run on your own inputs