Calculation guide
Deduct upfront refinancing costs. Share positive net gains only.
public = max(0,gain) × share/100 · gain = Σ((old − new)/(1+r)^t) − fee
Inputs
Agreed discount rate (%)
Example entry 10.0 %. Allowed range 0 to 100.
Upfront refinancing costs
Example entry 2000.0 (in the selected currency).
Public authority share (%)
Example entry 50.0 %. Allowed range 0 to 100.
Old debt service
Example entry 66000.0 (in the selected currency).
New debt service
Example entry 55000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Agreed discount rate (%) | 10% |
| Upfront refinancing costs | 2,000 |
| Public authority share (%) | 50% |
Remaining years
| Old debt service | New debt service |
|---|---|
| 66,000 | 55,000 |
| 72,600 | 60,500 |
| Result | Value |
|---|---|
| Public authority gain | 9,000 |
| Gain · Refinancing, present value | 18,000 |
Interpreting the result
When refinancing costs consume the present-value saving, the public share falls to zero.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Agreed discount rate (%) | 10% | 11% | Public authority gain | 9,000 | 8,865.270676 |
| Upfront refinancing costs | 2,000 | 2,200 | Public authority gain | 9,000 | 8,900 |
| Public authority share (%) | 50% | 55% | Public authority gain | 9,000 | 9,900 |
| Old debt service (row 1) | 66,000 | 72,600 | Public authority gain | 9,000 | 12,000 |
| New debt service (row 1) | 55,000 | 60,500 | Public authority gain | 9,000 | 6,500 |
