Finance a project
Debt sizing, repayment profiles and sensitivities for working with lenders.
Explore the serviceWe structure debt and build financial models for sponsors, developers and funds. Clear assumptions. A clear view of what changes the decision.
Threshold 1.20x
| Scenario | Minimum debt service coverage | Critical year |
|---|---|---|
| Base case | 1.23x | 8 |
| Price −15% | 1.16x | 15 |
| Price −25% | 0.90x | 15 |
Debt: €64.6m. Repayments stay fixed when the price changes. Tax, working capital and reserves are excluded, among other items.
Open the full modelThree starting points, shaped around the decision ahead.
Debt sizing, repayment profiles and sensitivities for working with lenders.
Explore the serviceA new build, a reconstruction or an independent review, with documentation your team can use.
Explore the serviceAn integrated income statement, balance sheet and cash flow, with scenarios and tracking for business decisions.
Explore the serviceAn assumption, a formula, a decision. This fictional extract shows how they connect and where we would focus a review.
Explore the figures in the model
View the full-size image ↗Prices, costs and the contract term make the starting point visible.
From revenue to available cash, and from cash to debt service.
Identifying the tight year and its cause helps decide what to examine next.
One tight year and eleven years near the limit can share a minimum DSCR. Seeing the profile changes the question.
Minimum: 1.31x · Threshold: 1.20x
| Year | DSCR (times) |
|---|---|
| 1 | 1.61x |
| 2 | 1.60x |
| 3 | 1.31x |
| 4 | 1.58x |
| 5 | 1.60x |
| 6 | 1.62x |
| 7 | 1.61x |
| 8 | 1.60x |
| 9 | 1.59x |
| 10 | 1.62x |
| 11 | 1.63x |
| 12 | 1.61x |
| 13 | 1.60x |
| 14 | 1.62x |
| 15 | 1.64x |
Minimum: 1.31x · Threshold: 1.20x
| Year | DSCR (times) |
|---|---|
| 1 | 1.60x |
| 2 | 1.58x |
| 3 | 1.38x |
| 4 | 1.36x |
| 5 | 1.34x |
| 6 | 1.33x |
| 7 | 1.31x |
| 8 | 1.32x |
| 9 | 1.34x |
| 10 | 1.35x |
| 11 | 1.36x |
| 12 | 1.37x |
| 13 | 1.38x |
| 14 | 1.56x |
| 15 | 1.60x |
Mastia Consulting
Financial advisory · Cartagena
The person who agrees the scope builds the model and answers lenders’ questions.
We work with sponsors, developers and funds. Each engagement includes the file, its documentation and a working session with the team who will use it.
Tell us about the asset, the decision and the deadline. We will respond about scope and availability.