DEBT SCENARIO · USD
Method version gcp-exact-1.0.0.Worked example (illustrative)
Currency amounts in USD, reported to two decimals.
| Input | Value | Unit |
|---|---|---|
| Opening principal | 3,000,000 | USD |
| Additional draw at start | 0 | USD |
| Annual simple interest rate | 8 | % |
| Equal monthly principal repayment | 50,000 | USD |
| Scenario horizon | 12 | months |
| Output | Value | Unit |
|---|---|---|
| Ending principal | 2,400,000.00 | USD |
| Total scenario interest | 218,000.00 | USD |
| Principal repaid | 600,000.00 | USD |
| Total cash debt service | 818,000.00 | USD |
Monthly debt schedule
| Month | Opening principal | Interest | Repayment | Ending principal |
|---|---|---|---|---|
| 1 | 3,000,000.00 | 20,000.00 | 50,000.00 | 2,950,000.00 |
| 2 | 2,950,000.00 | 19,666.67 | 50,000.00 | 2,900,000.00 |
| 3 | 2,900,000.00 | 19,333.33 | 50,000.00 | 2,850,000.00 |
| 4 | 2,850,000.00 | 19,000.00 | 50,000.00 | 2,800,000.00 |
| 5 | 2,800,000.00 | 18,666.67 | 50,000.00 | 2,750,000.00 |
| 6 | 2,750,000.00 | 18,333.33 | 50,000.00 | 2,700,000.00 |
| 7 | 2,700,000.00 | 18,000.00 | 50,000.00 | 2,650,000.00 |
| 8 | 2,650,000.00 | 17,666.67 | 50,000.00 | 2,600,000.00 |
| 9 | 2,600,000.00 | 17,333.33 | 50,000.00 | 2,550,000.00 |
| 10 | 2,550,000.00 | 17,000.00 | 50,000.00 | 2,500,000.00 |
| 11 | 2,500,000.00 | 16,666.67 | 50,000.00 | 2,450,000.00 |
| 12 | 2,450,000.00 | 16,333.33 | 50,000.00 | 2,400,000.00 |
SCENARIO TOOL
Calculated on this device.Debt Scenario
Nothing you enter leaves your browser.
