Working Capital Calculator — Turnover Method & MPBF (Nayak & Tandon)
This calculator covers the two standard methods banks in India use to assess working capital requirements: the Turnover Method (Nayak Committee) — mandatory for MSE borrowers with WC limits up to ₹5 crore — and the MPBF Method (Tandon Committee), the standard for larger borrowers. Both methods are used by credit officers in PSBs and private banks as part of every working capital appraisal.
- Turnover Method (Nayak): WC = 25% of projected turnover · Bank finance = 20% · Borrower margin = 5% · Mandatory for MSE up to ₹5 Cr WC limit
- MPBF Method I: MPBF = 75% × (TCA − CL excl. bank borrowings) · Min Current Ratio = 1.00 : 1
- MPBF Method II: MPBF = 75% × TCA − CL excl. bank borrowings · Min Current Ratio = 1.33 : 1 · PSB standard
- Method II is more restrictive — borrower must bring 25% of Total Current Assets as margin vs. 25% of WCG in Method I
- Both methods are computed in CMA data. Sanction is benchmarked to Method II in practice.
- MPBF deregulated by RBI w.e.f. April 15, 1997 — banks use it as per Board-approved credit policy
Enter projected turnover to compute the WC limit.
| Projected Annual Turnover | — |
| Working Capital Requirement (25% of turnover) | — |
| Less: Borrower's NWC Margin (5% of turnover) | — |
| Maximum Permissible Bank Finance (MPBF) | — |
Enter current assets and liabilities to compute MPBF.
| Total Current Assets (A) | — |
| Total CL excl. Bank Borrowings (B) | — |
| Working Capital Gap (A − B) | — |
| Working Capital Gap (WCG) | — |
| Borrower's Required Margin (25% of WCG) | — |
| MPBF — Method I | — |
| Implied Minimum Current Ratio | 1.00 : 1 |
| 75% of Total Current Assets (0.75 × A) | — |
| Less: Total CL excl. Bank Borrowings (B) | — |
| MPBF — Method II | — |
| Borrower's Required Margin (25% of TCA) | — |
| Implied Minimum Current Ratio | 1.33 : 1 |
| Total Current Assets (A) | — |
| Total Current Liabilities incl. MPBF II (B + MPBF) | — |
| Current Ratio | — |
| Required Minimum | 1.33 : 1 |
| Status | — |
Working Capital Assessment Methods Used by Indian Banks
Indian banks assess working capital requirements using two main frameworks, depending on the borrower’s size and the type of business. The method determines both the quantum of finance and the minimum Current Ratio the borrower must maintain.
Method 1 — Turnover Method (Nayak Committee, 1991)
The Nayak Committee recommended a simplified method for assessing working capital needs of small enterprises. The formula is straightforward: the bank assumes the business needs working capital equal to 25% of projected annual sales. The borrower must bring in at least 5% of turnover as their own contribution (NWC), and the bank finances the remaining 20%.
| Total WC Requirement | = Projected Annual Turnover × 25% |
| Borrower’s Margin (NWC) | = Projected Annual Turnover × 5% (minimum) |
| Bank Finance (MPBF) | = Projected Annual Turnover × 20% |
Method 2 — MPBF Method (Tandon Committee, 1974)
The Tandon Committee introduced a detailed balance-sheet approach where the bank calculates the Maximum Permissible Bank Finance (MPBF) from the borrower’s current assets and current liabilities. The committee proposed three methods; Method II is now the universal standard in Indian banking practice.
| Method | Formula | Min Current Ratio | Borrower’s Margin |
|---|---|---|---|
| Method I | MPBF = 75% × (TCA − CL*) | 1.00 : 1 | 25% of WCG |
| Method II PSB Standard | MPBF = 75% × TCA − CL* | 1.33 : 1 | 25% of TCA |
How to Choose Between Turnover Method and MPBF Method
| Borrower Type | WC Limit | Method to Use |
|---|---|---|
| MSE borrower | Up to ₹5 crore | Turnover Method (mandatory) |
| Non-MSE borrower | Up to ₹2 crore | Turnover Method (discretionary) |
| Any borrower | Above ₹5 crore | MPBF Method II (with CMA data) |
| Seasonal industries (sugar, tea, construction) | Any | Cash Budget Method |
| Large corporates (WC ≥ ₹150 Cr) | ≥ ₹150 crore | MPBF + mandatory loan component (RBI 2018-19) |
Frequently Asked Questions — Working Capital Calculator
What is the Turnover Method for working capital assessment?
The Turnover Method (also called Nayak Committee Method) is a simplified formula for assessing working capital needs. It assumes total WC requirement = 25% of projected annual turnover. The borrower must contribute at least 5% of turnover as Net Working Capital (NWC), and the bank finances the remaining 20%. It is mandatory for MSE borrowers with working capital limits up to ₹5 crore, as per the RBI Master Circular on Management of Advances. The method is simple, fast, and requires no detailed balance-sheet analysis — making it ideal for smaller MSME borrowers.
What is MPBF and how is it calculated under Method I and Method II?
MPBF stands for Maximum Permissible Bank Finance — the maximum working capital a bank will finance based on the Tandon Committee framework. Method I: MPBF = 75% × (TCA − CL excl. bank borrowings), where the borrower contributes 25% of the Working Capital Gap (WCG). Implied minimum Current Ratio = 1.00:1. Method II (standard in PSBs): MPBF = 75% × TCA − CL excl. bank borrowings, where the borrower contributes 25% of Total Current Assets. Implied minimum Current Ratio = 1.33:1. Method II is more restrictive because the borrower must bring a larger margin. All PSBs and large private banks use Method II as the benchmark.
What current assets are included in MPBF calculation?
Total Current Assets (TCA) for MPBF includes: Raw Materials and Stores/Spares inventory, Work-in-Progress (WIP), Finished Goods stock, Receivables/Book Debts (only within the permissible credit period — overdue and sticky debtors are excluded or haircut), advance payments made to suppliers, prepaid expenses, advance tax, and other short-term current assets. Current assets should be at ‘accepted’ levels — the bank moderates inflated figures based on industry holding period norms and the borrower’s own historical averages.
What is not included in current liabilities for MPBF?
MPBF is calculated on Current Liabilities excluding bank borrowings. This means you must exclude: existing Cash Credit (CC) and Overdraft (OD) limits from banks, short-term loans from banks, and the current year instalment of term loans (though some banks include this). What you do include: Trade creditors/sundry creditors, advance receipts from customers, statutory dues payable (GST, TDS, PF), outstanding salary and expenses. The logic is that bank borrowings are what we are trying to calculate — circular inclusion would distort the result.
What is the minimum Current Ratio required for working capital loans?
The minimum Current Ratio (CR) under the MPBF Method II framework is 1.33:1. This means for every ₹1 of current liabilities (including the new WC limit), the borrower must have ₹1.33 of current assets. This ratio is embedded in the Method II formula — when a borrower’s eligible MPBF is exactly the Method II figure, the resulting CR is exactly 1.33:1. For MSE borrowers, some banks relax this to 1.25:1. If a borrower’s CR falls below 1.33:1, the bank either reduces the limit or asks the borrower to infuse additional NWC to bring the ratio up.
Is MPBF still mandatory in Indian banks?
No. RBI deregulated the mandatory use of MPBF with effect from April 15, 1997. Banks are now free to use any method of working capital assessment as per their Board-approved credit policy. In practice, however, all major PSBs (SBI, PNB, Bank of Baroda, Canara Bank, Union Bank) and large private banks continue to use MPBF Method II as their standard for borrowers above ₹5 crore WC limit, because it provides a rigorous and auditable assessment framework. The Turnover Method remains mandatory for MSE borrowers up to ₹5 crore WC limit as per the RBI Master Circular.
What is CMA data and is it required for working capital assessment?
CMA stands for Credit Monitoring Arrangement — a standardised financial data format prescribed by RBI/IBA for all working capital proposals. It includes: (1) Balance Sheet data for last 2 years (audited), current year estimates, and next year projections; (2) Profit & Loss data; (3) Comparative Current Assets and Current Liabilities statement; (4) Computation of MPBF under both methods; (5) Fund Flow Statement. CMA data is mandatory for all working capital proposals above a threshold (typically ₹5–10 crore depending on bank policy). The calculator above is a quick estimation tool — for formal sanction, full CMA data must be prepared.