Working Capital Loan Calculator
Estimate your working capital gap, MPBF and bank limit from your turnover and holding days, using RBI norms for MSMEs.
A working capital loan calculator estimates how much short-term bank finance your business needs to run its operating cycle. For MSMEs with limits up to ₹5 crore, RBI guidelines take the need as 25% of projected turnover, with the bank financing at least 20% and the owner bringing 5%.
This working capital loan calculator works out your stock, debtors and creditors from your turnover and holding days. It then shows the working capital gap, MPBF under the second method of lending, the turnover-method limit and an indicative loan limit.
Key takeaways
- Working capital = current assets − current liabilities.
- MSE limits up to ₹5 crore are assessed at 20% of projected turnover.
- Larger limits are usually assessed on the gap method (MPBF).
- A shorter operating cycle means a smaller loan need.
How to Use the Working Capital Loan Calculator
- Enter turnoverAdd your projected annual sales.
- Add cost sharesEnter raw material and other production costs as a % of sales.
- Set holding daysEnter stock, work in progress, debtor and creditor days.
- Add other itemsInclude other current assets and liabilities.
- Read the limitSee the gap, MPBF, turnover-method finance and your indicative limit.
Working Capital Formulas
Operating cycle (days) = Raw material days + WIP days + Finished goods days + Debtor days − Creditor days
MPBF (second method) = 75% of current assets − Current liabilities (excluding bank borrowings)
Turnover method = 20% of projected turnover (bank) + 5% (your margin)
How Banks Assess a Working Capital Limit
| Method | Used for | Bank finance |
|---|---|---|
| Turnover method | MSE limits up to ₹5 crore | At least 20% of projected turnover |
| Second method of lending (MPBF) | Larger limits, or when it gives more | 75% of current assets − current liabilities |
| Cash budget | Seasonal or service businesses | Peak cash gap in the budget |
RBI’s guidelines also let banks use the traditional method when it shows a higher requirement than the turnover method. Read the RBI master circular on lending to MSMEs for the full rules.
Working capital loan example
A manufacturer projects turnover of ₹1.20 crore with 45 days of raw material, 7 days of work in progress, 30 days of finished goods and 60 days of credit to buyers. It gets 30 days of supplier credit. As a result, current assets are ₹39,11,781 and current liabilities are ₹6,91,781, giving a gap of ₹32,20,000 and an operating cycle of 112 days. The second method gives an MPBF of ₹22,42,055, while the turnover method gives ₹24,00,000. Therefore, the indicative limit is ₹24,00,000, costing about ₹2,40,000 a year at 10% if fully used.
Working Capital Loan for a New Business
A new unit has no past accounts, so banks rely on projected turnover and a realistic operating cycle. Furthermore, loans up to ₹10 crore can be covered by CGTMSE, which reduces the need for collateral. Check the guarantee cost with our CGTMSE fee calculator.
How to Reduce Your Working Capital Need
- Collect from buyers faster to cut debtor days.
- Negotiate longer credit from suppliers.
- Keep stock levels close to actual demand.
- Bill promptly and follow up overdue invoices every week.
Documents Banks Ask For
A working capital loan application needs more than a calculation. Banks usually ask for the following papers, so keep them ready before you apply.
- Projected and past balance sheets and profit and loss accounts.
- CMA data with the assessment of working capital.
- GST returns and bank statements for recent months.
- Stock and debtor statements, usually every month after sanction.
- Udyam registration and KYC documents of the business and owners.
Additionally, banks review the stock statement each month to set your drawing power. As a result, the limit you can actually use depends on stock and debtors on hand, not just the sanctioned amount.
Related Tools
Prepare full bank statements with the CMA data format maker, check repayment strength with the DSCR calculator, and plan a new unit with the project report maker. For small limits, compare the Mudra loan EMI calculator and our business loan scheme guides.
Frequently Asked Questions
How do I calculate working capital?
Working capital = Current assets − Current liabilities. For a loan, banks use the working capital gap: current assets minus current liabilities other than bank borrowings.
What is the turnover method for working capital?
For MSE borrowers with fund-based limits up to ₹5 crore, the working capital need is taken as 25% of projected turnover. The borrower brings 5% and the bank finances at least 20%.
What is the working capital gap formula?
Working capital gap = Current assets − Current liabilities (excluding bank borrowings). It is the amount that must come from bank finance and your own margin.
Can a new business get a working capital loan?
Yes. Banks assess a new unit on projected turnover and its operating cycle. Loans may be backed by CGTMSE, so collateral is not always needed.
What is MPBF?
MPBF is the maximum permissible bank finance. Under the second method of lending, it is 75% of current assets minus current liabilities other than bank borrowings.
How is interest charged on a working capital loan?
Interest on a cash credit or overdraft limit is charged only on the amount you actually use, usually monthly.
Business Reports is an independent information website. We are not affiliated with, endorsed by or acting for any government department, bank, NBFC, KVIC, NABARD, SIDBI or MUDRA, and we do not provide loans or process applications. Figures are indicative; confirm details on official portals or with your bank. Read our disclaimer and advertising disclosure.