Syntha Lab RU

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.

Cash and working capital For whom: Finance directors of a seasonal business.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Reserve over the peak%20A 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%22The 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%0The 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₽0Free cash before the first month of the table. Empty = 0. The example value is illustrative.

How it is calculated

StepFormula
Cumulative positionopening cash + the sum of flows up to and including the month
Line debt and the peakdebt = max(0; −position); peak = the largest debt
Limit25 m ₽ × (1 + 20%) = 30 m ₽
Interestthe sum of monthly debt balances × rate ÷ 12
Comparison with a permanent loanpeak × 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 position and line debt, m RUB
Line chart: Cumulative total: −5 → 34; Line debt: 5 → 0−30−20−10010203040123456789101112Cumulative total, 1: −5Cumulative total, 2: −13Cumulative total, 3: −25Cumulative total, 4: −19Cumulative total, 5: −9Cumulative total, 6: 5Cumulative total, 7: 1Cumulative total, 8: −8Cumulative total, 9: −5Cumulative total, 10: 7Cumulative total, 11: 25Cumulative total, 12: 34Line debt, 1: 5Line debt, 2: 13Line debt, 3: 25Line debt, 4: 19Line debt, 5: 9Line debt, 6: 0Line debt, 7: 0Line debt, 8: 8Line debt, 9: 5Line debt, 10: 0Line debt, 11: 0Line debt, 12: 0
  • Cumulative total
  • Line debt
Data as a table
MeasureCumulative totalLine debt
1−55
2−1313
3−2525
4−1919
5−99
650
710
8−88
9−55
1070
11250
12340

By month

MonthFlowCumulative totalLine debtInterest
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 46 m ₽−19 m ₽19 m ₽348,333 ₽
Month 510 m ₽−9 m ₽9 m ₽165,000 ₽
Month 614 m ₽5 m ₽0 ₽0 ₽
Month 7−4 m ₽1 m ₽0 ₽0 ₽
Month 8−9 m ₽−8 m ₽8 m ₽146,667 ₽
Month 93 m ₽−5 m ₽5 m ₽91,667 ₽
Month 1012 m ₽7 m ₽0 ₽0 ₽
Month 1118 m ₽25 m ₽0 ₽0 ₽
Month 129 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.

Terms used

Calculate on your data →