Open calculator ↗

Debt sculpting against cash available for debt service · Calculation guide

Each year pay accrued interest first, then principal up to the opening balance within the target debt-service coverage.

Calculation guide

Reject cash flow insufficient to cover interest at target.

remaining = opening debt − Σprincipal · repaid = Σ min(opening,CF/DSCR − interest)

Inputs

Initial debt

Example entry 100000.0 (in the selected currency).

Annual loan rate (%)

Example entry 5.0 %. Allowed range 0 to 100.

Target debt-service coverage

Example entry 1.2. Minimum 1e-12.

Annual available cash flow

Example entry 36000.0 (in the selected currency).

Worked example

InputValue
Initial debt100,000
Annual loan rate (%)5%
Target debt-service coverage1.2

Annual cash available for debt service

Annual available cash flow
36,000
37,800
ResultValue
Debt remaining after entered years47,250
Principal repaid52,750

Interpreting the result

Remaining principal is the balance that the entered cash flows cannot repay while maintaining target coverage.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Initial debt100,000110,000Debt remaining after entered years47,25058,275
Annual loan rate (%)5%6%Debt remaining after entered years47,25049,060
Target debt-service coverage1.22.2Debt remaining after entered years47,25075,886.363636
Annual available cash flow (row 1)36,00039,600Debt remaining after entered years47,25044,100
Debt sculpting against cash available for debt service →

Sources