Credit line limit for the seasonal peak and its cost
From the monthly cash flow before the loan it finds the cumulative position, the peak deficit and the peak month, counts the limit as the peak plus a reserve, the interest for the period on the debt balance and the fee on the unused part. It compares with the cost of a permanent loan for the peak amount and shows what part of the limit you use on average.
At a glance
- What question does it answer?
- What line limit the deficit peak needs and what it costs against a permanent loan.
- What data is needed?
- The monthly net flow before the loan.
- How to read the result?
- Look at the peak and its month, then at the average utilization: a low one means the line is cheaper than a permanent loan. Example on the default values: Peak deficit: RUB 25 million; Peak month: 3; Line limit: RUB 30 million; Interest for the table period: RUB 1.54 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
A seasonal business needs not a loan for a year but a limit for the peak. In the example the cumulative position falls to −25 m RUB in month 3; with a 20% reserve the limit is 30.0 m RUB. The interest for the year on the balance is 1.54 m RUB, a permanent loan for the peak would cost 5.50 m RUB.
When to use it
When preparing a seasonal budget and negotiating a line with a bank.
How to read the result
The peak and its month, then the average limit utilization: the lower it is, the better the line.
Common mistakes
No reserve; only the peak is counted, not utilization; the forecast is taken without a “worse” scenario.
What data is needed?
- The monthly net flow before the loan.
- The reserve, the rate, the fee on the unused part.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Reserve over the peak | % | 20 | A cushion over the calculated peak for the forecast error and delayed receipts. Without a reserve the line runs out in the hardest month. The example value is illustrative. |
| Line rate | % | 22 | The annual rate on the used balance. It depends on the key rate; banks often ask for stock as collateral. The example value is illustrative. |
| Fee on the unused limit | % | 0 | The annual fee on the unused part of the limit if the bank charges it. Empty or 0: no fee. The example value is illustrative. |
| Cash at the start of the period | ₽ | 0 | Free cash before the first month of the table. Empty = 0. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Cumulative position | opening cash + the sum of flows up to and including the month |
| Line debt and the peak | debt = max(0; −position); peak = the largest debt |
| Limit | 25 m ₽ × (1 + 20%) = 30 m ₽ |
| Interest | the sum of monthly debt balances × rate ÷ 12 |
| Comparison with a permanent loan | peak × rate × months ÷ 12 against the line interest |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Peak deficit
- 25 m ₽The largest negative cumulative total.
- Peak month
- 3The number of the table row.
- Line limit
- 30 m ₽Peak × (1 + reserve).
- Interest for the table period
- 1.54 m ₽The sum of monthly debt balances × rate ÷ 12.
- Fee on the unused limit
- 0 ₽
- Total cost of the line
- 1.54 m ₽
- A permanent loan for the peak amount
- 5.5 m ₽Peak × rate for the same months: the loan is held for the whole period.
- Line saving against a permanent loan
- 3.96 m ₽
- Average limit utilization
- 23.3 %
- Months in debt
- 7
- Cumulative total
- Line debt
Data as a table
| Measure | Cumulative total | Line debt |
|---|---|---|
| 1 | −5 | 5 |
| 2 | −13 | 13 |
| 3 | −25 | 25 |
| 4 | −19 | 19 |
| 5 | −9 | 9 |
| 6 | 5 | 0 |
| 7 | 1 | 0 |
| 8 | −8 | 8 |
| 9 | −5 | 5 |
| 10 | 7 | 0 |
| 11 | 25 | 0 |
| 12 | 34 | 0 |
By month
| Month | Flow | Cumulative total | Line debt | Interest |
|---|---|---|---|---|
| Month 1 | −5 m ₽ | −5 m ₽ | 5 m ₽ | 91,667 ₽ |
| Month 2 | −8 m ₽ | −13 m ₽ | 13 m ₽ | 238,333 ₽ |
| Month 3 | −12 m ₽ | −25 m ₽ | 25 m ₽ | 458,333 ₽ |
| Month 4 | 6 m ₽ | −19 m ₽ | 19 m ₽ | 348,333 ₽ |
| Month 5 | 10 m ₽ | −9 m ₽ | 9 m ₽ | 165,000 ₽ |
| Month 6 | 14 m ₽ | 5 m ₽ | 0 ₽ | 0 ₽ |
| Month 7 | −4 m ₽ | 1 m ₽ | 0 ₽ | 0 ₽ |
| Month 8 | −9 m ₽ | −8 m ₽ | 8 m ₽ | 146,667 ₽ |
| Month 9 | 3 m ₽ | −5 m ₽ | 5 m ₽ | 91,667 ₽ |
| Month 10 | 12 m ₽ | 7 m ₽ | 0 ₽ | 0 ₽ |
| Month 11 | 18 m ₽ | 25 m ₽ | 0 ₽ | 0 ₽ |
| Month 12 | 9 m ₽ | 34 m ₽ | 0 ₽ | 0 ₽ |
Average utilization of 23%: the line is needed for several months, a permanent loan would be an overpayment.
What to do with the result: ask for a limit, not a one-off loan, and tie the drawdown to the peak months; compare with the “Choice of financing” calculation and with the stock collateral agreement.
A typical mistake: not adding a reserve and counting only the peak, not the average utilization. Interest is counted on the month-end balance and is not capitalized: a simplification.
Nuances and limits
- Not adding a reserve.
- Counting only the peak, not utilization.
- Taking the forecast without a worse scenario.