Most owners decide how much to borrow by asking how much they can get. The better question is what the next thirteen weeks actually look like.
Ask an owner how much they want to borrow and the answer is usually a round number, arrived at by feel. Ask what the next three months of cash look like, week by week, and the answer is often less certain.
That gap is where borrowing goes wrong. Borrow too little and you are back for a second loan, often on worse terms. Borrow too much and you pay interest on money sitting idle. Pick the wrong tenure and a workable loan becomes a monthly strain.
A basic cash flow forecast answers all three questions. It takes an afternoon, and it is the most useful paper you can bring to a lender.
Why thirteen weeks
A thirteen-week forecast is a common choice for a short-term cash view. It is one quarter. It is long enough to cover a full collection cycle for most businesses. It is short enough that you can still forecast honestly from what you know today.
If your customers usually pay in 90 days or more, stretch the view to cover at least one full cycle. The point is to see the money come back, not just go out.
Build it in four rows
Set up a column for each week. Fill in four rows.
Opening balance. What is actually in the account at the start of the week.
Money in. Collections from named customers on the dates you genuinely expect them, not the dates on the invoice. If a customer has paid at seventy days for two years, forecast seventy days.
Money out. Suppliers, salaries, rent, GST, existing EMIs and everything else. Put fixed costs in first, because they arrive whether trade is good or not.
Closing balance. This becomes next week's opening balance.
The output is a line that dips and recovers. The deepest point shows your largest shortfall. The number of weeks below zero shows how long it lasts.
Here is a short illustration for the first six weeks of a trading business. The figures are made up for the example.
| Week | Opening | Money in | Money out | Closing |
|---|---|---|---|---|
| 1 | ₹4,00,000 | ₹2,50,000 | ₹3,80,000 | ₹2,70,000 |
| 2 | ₹2,70,000 | ₹1,20,000 | ₹3,10,000 | ₹80,000 |
| 3 | ₹80,000 | ₹90,000 | ₹4,20,000 | minus ₹2,50,000 |
| 4 | minus ₹2,50,000 | ₹1,60,000 | ₹2,90,000 | minus ₹3,80,000 |
| 5 | minus ₹3,80,000 | ₹5,40,000 | ₹2,60,000 | minus ₹1,00,000 |
| 6 | minus ₹1,00,000 | ₹4,30,000 | ₹2,40,000 | ₹90,000 |
The shortfall reaches ₹3,80,000 in week 4 and clears by week 6. That is a short, repeating gap, not a permanent one.
What it tells you about the loan
How much. The depth of the deepest dip, plus a genuine buffer. Not the largest number a lender is willing to sanction. In the example above, that is ₹3,80,000 plus your buffer.
For how long. If the dip recovers within a few weeks, you likely need a short or revolving facility, not a five-year term loan. If the trough never recovers, you are not funding a gap. You are funding a structural shortage of working capital, and that is a different conversation. Working capital versus a term loan explains which product fits which shape.
Whether you can repay it. Add the proposed EMI or interest to your money out and run the forecast again. If the line goes negative in a normal month, the loan does not fit, whatever the sanction letter says.
That last step is the one owners skip. It is also the one that matters most. How much can my business actually borrow? shows how to turn spare monthly cash into a loan amount.
How a lender sizes the same gap
Lenders use their own methods, and your forecast helps you meet them.
For micro and small enterprises with working capital limits up to ₹5,00,00,000, the government has described a simplified method: the limit is computed as at least 20% of projected annual turnover. A believable forecast is what makes your projected turnover credible.
For a term loan, the lender looks at the debt service coverage ratio (DSCR). In RBI's wording, that is net cash accruals plus interest and finance charges, divided by the current portion of long-term debt plus interest and finance charges. Your forecast, extended across the year, gives you an early read on it. The DSCR calculator and the working capital calculator do the arithmetic.
Then break it
A forecast built on everything going right is a wish. Change three assumptions and run it again:
- Your largest customer pays a month later than usual.
- Revenue comes in 15% below plan for two months.
- One unplanned expense arrives, of a size you have actually faced before.
None of these is a disaster, and each happens to most businesses at some point. If the loan still works with any one of them, it is a sound loan. If it only works when everything lands on time, you are borrowing against optimism.
Fix the money in before you borrow for it
A forecast often shows that the gap is not a lack of sales. It is money owed to you that arrives late. Two tools can close part of that gap before you take on debt.
Your right to be paid on time. If your business is a micro or small enterprise with Udyam registration, the MSMED Act sets a limit on how long a buyer may take. Payment is due within the agreed period, and no later than 45 days from acceptance of the goods or services. A buyer who pays late owes compound interest at three times the bank rate notified by RBI. Disputes can be filed with the state's MSE Facilitation Council through the MSME Samadhaan portal.
Discounting your invoices. On TReDS, the RBI-authorised platforms for trade receivables, your accepted invoices can be financed by several financiers. The financing is without recourse to you: if the buyer does not pay, the financier cannot recover from your business. Invoice discounting explained covers how it works.
What it does for the application
A forecast is also a persuasive document to bring to a lender, and few owners bring one.
It shows that you know why you need the money, how much, and how it comes back. It lets you answer the repayment question with a schedule rather than a reassurance. Lenders see many files where the owner cannot explain the amount beyond a round figure. Being the exception helps.
It also helps the file move. For banks, RBI requires a credit decision within 14 working days on loans up to ₹25,00,000 to micro and small enterprises. A complete file with a clear forecast gives the lender fewer reasons to come back with questions. Pair it with the papers in the business loan documents list.
It protects you from a pleasant trap too: being offered more than you asked for. A larger sanction feels like validation. It is more interest on money your forecast says you do not need. The true cost of a business loan shows how fast that adds up.
Keep it running
The forecast is more useful as a habit than as a document. Update it every week, replacing forecast figures with actuals. Within a couple of months you will know how accurate your own predictions are. That is the point at which the tool starts protecting you.
A profitable business can still run out of cash, because profit is recorded when you sell and cash arrives when you are paid. A weekly forecast is a cheap way to see a cash squeeze coming.
Capnix is not a lender. Its free Capnix score rates your business from 0 to 100 and shows what to fix before you take your loan requirement to a lender.
Sources
- PIB, government reply on simplified working capital for MSE units (23-Jul-2019), checked 02-Oct-2026
- RBI, Resolution Framework for COVID-19-related stress: financial parameters (RBI/2020-21/34), Annex, checked 02-Oct-2026
- RBI Master Direction, Lending to MSME Sector, checked 02-Oct-2026
- Ministry of MSME, MSME Samadhaan (MSE Facilitation Council), checked 02-Oct-2026
- RBI, FAQs on TReDS, checked 02-Oct-2026
