Working Capital Calculator — Schedule III & Tandon Committee MPBF for FY 2025-26
This Working Capital Calculator computes Working Capital, Gross Working Capital, Working Capital Gap, Current Ratio, Quick Ratio and Net Capital Turnover Ratio aligned with Schedule III to the Companies Act, 2013. Two of the eleven mandatory Schedule III ratios — Current Ratio and Net Capital Turnover — are direct outputs. The unique feature is auto-computation of Tandon Committee MPBF under both Method 1 (75% of WC Gap) and Method 2 (75% of TCA less OCL — Chore Committee 1979 standard for ≥₹50 lakh limits), plus the Nayak Committee turnover method for MSME borrowers up to ₹7.5 crore. MSMED Act 45-day check, sector benchmarks across 8 industries, and 25% YoY variance flag included.
Calculate Your Working Capital
Enter Current Assets and Current Liabilities directly from your audited balance sheet under Schedule III Division II. The calculator computes Working Capital, all liquidity ratios, and Tandon/Nayak MPBF in one shot. All amounts in ₹ rupees.
Tandon Committee MPBF Assessment
Maximum Permissible Bank Finance computed under both methods. Method 2 is the Chore Committee 1979 standard for borrowers with WC limits ≥ ₹50 lakhs.
| Ratio | Numerator | Denominator | Current Year | Previous Year |
|---|
How to Use This Working Capital Calculator
Working Capital is the lifeblood of day-to-day business operations — the cash and short-term resources available to fund inventory, pay suppliers, meet payroll and absorb timing mismatches. The calculator uses the standard balance-sheet method aligned with the Institute of Chartered Accountants of India Guidance Note on Schedule III.
Step 1 — Pull Six Current Asset Lines from the Balance Sheet
Open your audited balance sheet under Schedule III Division II. Inventory captures raw materials, work-in-progress, finished goods, stock-in-trade, stores and spares — net of any obsolescence provision under Ind AS 2. Trade Receivables is net of provision for doubtful debts under Ind AS 109 expected credit loss. Cash and Cash Equivalents covers cash, bank balances, fixed deposits with original maturity under three months, and highly liquid instruments. Other Bank Balances includes earmarked balances and FDs over three months. Current Investments is mutual funds and money-market instruments. Other Current Assets is loans, prepaid expenses, GST input credit and advances.
Step 2 — Pull Six Current Liability Lines
Trade Payables must be split between MSE (Micro and Small Enterprise) and non-MSE under Schedule III mandatory disclosure. The MSE figure is critical because the MSMED Act 2006 caps payment to 45 days. Short-term Borrowings includes cash credit, overdraft, working capital demand loan and bills discounting. Current Maturities of Long-term Debt is the next-12-month portion of long-term loans. Other Current Liabilities covers statutory dues, accrued expenses and lease liabilities (current portion). Short-term Provisions includes tax, bonus, leave encashment and warranty provisions.
Step 3 — Enter Revenue and Industry Sector
Annual Revenue from Operations is needed to compute Net Capital Turnover Ratio (one of two Schedule III mandatory working-capital ratios). Industry sector is used for benchmark comparison — Current Ratio and Working Capital intensity vary sharply by industry. Optional: enter previous year's Working Capital to flag the 25% Schedule III variance threshold.
Step 4 — Read the Output Panel
Output shows headline Working Capital, Current Ratio, Quick Ratio, Net Capital Turnover, the full balance-sheet composition (visualized as horizontal bars), Tandon Committee MPBF under both Methods 1 and 2, comparison with existing short-term borrowings, MSMED Act check on MSE trade payables, sector benchmark verdict, and a Schedule III disclosure block with the two mandatory working-capital ratios. If turnover is under ₹30 crore (implying potential MSME borrower), the Nayak Committee turnover-method assessment is also shown.
Working Capital Formula and Components
Working Capital has three closely related definitions, each used in different contexts. Understanding the distinctions matters for ratio analysis, bank lending and Schedule III disclosure.
Gross Working Capital (GWC) = Total Current Assets
Working Capital Gap (WCG) = Current Assets − Other Current Liabilities
(OCL = CL excluding short-term bank borrowings)
Current Ratio = Current Assets ÷ Current Liabilities
Quick Ratio = (Current Assets − Inventory) ÷ Current Liabilities
Net Capital Turnover = Revenue ÷ Net Working Capital
The Three Working Capital Definitions Compared
| Definition | Formula | Used For |
|---|---|---|
| Net Working Capital | CA − CL | Liquidity assessment, Schedule III disclosure, financial planning |
| Gross Working Capital | Total Current Assets | Asset deployment view, total funding need before financing |
| Working Capital Gap | CA − OCL | Bank credit appraisal under Tandon Committee MPBF |
Worked Example — Indian Manufacturing Company
A mid-sized Indian manufacturer reports the following balance-sheet extracts (₹ in lakhs):
| Current Assets | ₹ Lakhs | Current Liabilities | ₹ Lakhs |
|---|---|---|---|
| Inventory | 1,200 | Trade Payables (MSE) | 200 |
| Trade Receivables | 1,100 | Trade Payables (Non-MSE) | 500 |
| Cash & Equivalents | 300 | Short-term Borrowings | 800 |
| Other Bank Balances | 100 | Current Maturities LT Debt | 200 |
| Current Investments | 200 | Other Current Liabilities | 250 |
| Other Current Assets | 100 | Short-term Provisions | 150 |
| Total Current Assets | 3,000 | Total Current Liabilities | 2,100 |
Computation: Net Working Capital = 3,000 − 2,100 = ₹900 lakhs. Current Ratio = 3,000 / 2,100 = 1.43. Quick Ratio = (3,000 − 1,200) / 2,100 = 0.86. Working Capital Gap = 3,000 − 1,300 (OCL = CL ex-borrowings = 2,100 − 800) = ₹1,700 lakhs. With annual revenue of ₹10,000 lakhs, Net Capital Turnover = 10,000 / 900 = 11.11×.
Schedule III — Two Mandatory Working Capital Ratios
The Companies Act, 2013 Schedule III was amended via Ministry of Corporate Affairs notification G.S.R. 207(E) dated 24 March 2021, effective from FY 2021-22. The amendment introduced eleven mandatory analytical ratios. Two of those eleven are direct working-capital metrics — Current Ratio and Net Capital Turnover Ratio.
The Two Working Capital Ratios in Schedule III
| Schedule III Ratio | Formula | What It Measures |
|---|---|---|
| Current Ratio | Current Assets ÷ Current Liabilities | Short-term liquidity coverage |
| Net Capital Turnover Ratio | Revenue from Operations ÷ Working Capital | Revenue generated per rupee of working capital |
Companion Ratios from the Same Inputs
While not separately mandatory under Schedule III, the following ratios can be computed from the same inputs and are commonly disclosed in MD&A by listed companies under SEBI LODR Reg 34(3): Quick Ratio (Current Assets less Inventory divided by Current Liabilities), Working Capital to Revenue (NWC divided by Revenue), and Cash Ratio (Cash and Equivalents divided by Current Liabilities). Inventory Turnover, Trade Receivables Turnover and Trade Payables Turnover (the three CCC-component ratios) are also Schedule III mandatory and appear in the Cash Conversion Cycle Calculator.
The 25% Variance Explanation Rule
If either Current Ratio or Net Capital Turnover Ratio changes by more than 25% compared to the preceding year, the company must provide a written explanation in the notes to accounts under Schedule III. Statutory auditors verify the explanation. Common explanations include: extended credit terms (lowers Current Ratio), inventory build-up before peak season (raises Current Ratio temporarily), debt-equity rebalancing (changes short-term borrowings), capital expenditure cycle, GST credit accumulation (raises Other Current Assets), or one-off transactions affecting balance-sheet items at year-end.
CA Tip: Current Ratio is sensitive to year-end window-dressing — companies sometimes pay off short-term borrowings just before March 31 to inflate the ratio and reverse the position in early April. Auditors are increasingly required to test the sustainability of the year-end position by comparing it with average levels through the year. Consistent month-end testing protects against this risk.
Tandon Committee MPBF — How Banks Size Working Capital Limits
The Tandon Committee Report on Working Capital, submitted to the Reserve Bank of India in August 1975, fundamentally reshaped how Indian banks lend for working capital. The committee proposed three methods to compute Maximum Permissible Bank Finance (MPBF). RBI accepted Methods 1 and 2 for general application. Method 3 is rarely used.
Tandon Method 1 — The Liberal Method
where OCL = Current Liabilities excluding bank borrowings
Borrower's margin: 25% of Working Capital Gap
Minimum Current Ratio achieved: 1:1
Method 1 requires the borrower to fund only 25% of the Working Capital Gap from long-term sources (equity or term debt). Banks fund 75%. The minimum current ratio under this regime is just 1:1 — barely solvent. RBI considered this too liberal for sustained adoption.
Tandon Method 2 — The Standard Method
Borrower's margin: 25% of Total Current Assets
Minimum Current Ratio achieved: 1.33:1
Method 2 requires the borrower to fund 25% of Total Current Assets from long-term sources, achieving a stronger minimum current ratio of 1.33:1. The Chore Committee in April 1979 recommended that all borrowers (except sick units) with working capital limits of ₹50 lakh and above be placed under Method 2. This recommendation became the operating standard for Indian commercial banks and remains so today.
Worked Example — MPBF Assessment
For the manufacturer in the earlier worked example (TCA ₹3,000 lakhs, CL ₹2,100 lakhs, ST Borrowings ₹800 lakhs, OCL = 2,100 − 800 = ₹1,300 lakhs):
| Method | Calculation | MPBF (₹ Lakhs) | Implied Min CR |
|---|---|---|---|
| Method 1 | 0.75 × (3,000 − 1,300) = 0.75 × 1,700 | 1,275 | 1.00:1 |
| Method 2 (Standard) | (0.75 × 3,000) − 1,300 = 2,250 − 1,300 | 950 | 1.33:1 |
Under Method 2 (standard practice), the company is eligible for ₹950 lakhs MPBF against existing ST borrowings of ₹800 lakhs — there is headroom of ₹150 lakhs for limit enhancement, subject to stock and book-debt margin compliance.
CA Tip: Banks require Credit Monitoring Arrangement (CMA) data for working capital appraisal — typically Form III (operating statement), Form IV (analysis of balance sheet), Form V (comparative balance sheet), Form VI (working capital assessment). The MPBF computation appears on Form VI. Always verify that your CMA submission matches the audited financials and that ratios match the Schedule III disclosure to avoid bank queries.
Need Help with CMA Data or Bank Limit Renewal?
Patron Accounting LLP supports CFO offices with Credit Monitoring Arrangement (CMA) data preparation, MPBF computation, working capital optimisation studies, bank facility renewal documentation, and Schedule III ratio disclosure — for Pune, Mumbai, Delhi, Gurugram and pan-India clients.
Nayak Committee Turnover Method — For MSME Borrowers
The Nayak Committee, headed by Shri P.R. Nayak in 1991, simplified working-capital appraisal for small borrowers. The RBI subsequently formalised the turnover method for SSI/MSME borrowers, which remains the standard simplified appraisal up to specified limits.
Turnover Method Formula
Bank Finance (MPBF) = 20% of Projected Annual Turnover (i.e. 4/5 of WC need)
Borrower's Margin = 5% of Projected Annual Turnover (i.e. 1/5 of WC need)
When the Nayak Method Applies
- SSI / MSME borrowers with working capital limits up to ₹5 crore from a single bank (or ₹7.5 crore in aggregate from the banking system in some bank policies)
- For non-MSME borrowers, the simplified turnover method applies up to ₹2 crore working capital limits
- Above these thresholds, banks revert to Tandon Method 2 for full CMA-based appraisal
- Banks have discretion to use Nayak method below threshold or Tandon method above — most public-sector banks default to Nayak below the limit for operational simplicity
Worked Example
An MSME borrower with projected annual turnover of ₹4 crore applies for a working capital limit:
| Component | Calculation | Amount |
|---|---|---|
| Projected Annual Turnover | Given | ₹4,00,00,000 |
| Working Capital Requirement | 25% × ₹4 Cr | ₹1,00,00,000 |
| Bank Finance (MPBF) | 20% × ₹4 Cr (4/5 of WC) | ₹80,00,000 |
| Borrower's Margin (Promoter Contribution) | 5% × ₹4 Cr (1/5 of WC) | ₹20,00,000 |
Note: The Nayak Method assumes a Cash Conversion Cycle of approximately 3 months (90 days), driving the 25% of turnover working-capital need. If your actual CCC is significantly longer (real-estate developers, EPC contractors), the Nayak Method will under-state working capital need — prefer Tandon Method 2 with detailed CMA data even if you are below the Nayak threshold.
Industry Benchmarks for Working Capital and Current Ratio
Working Capital intensity and Current Ratio vary dramatically by industry. The bands below reflect typical Indian listed-peer ranges for FY 2024-25 reported financials.
| Industry | Typical Current Ratio | WC as % of Revenue | Driver |
|---|---|---|---|
| IT Services / Software | 2.5 – 4.0 | 15% – 25% | Limited inventory, high cash, DSO-driven |
| FMCG | 1.0 – 1.5 | 5% – 12% | Tight inventory, brand-driven trade credit |
| Manufacturing | 1.3 – 2.0 | 15% – 30% | Inventory-heavy, B2B credit cycles |
| Pharma | 1.5 – 3.0 | 20% – 40% | Long distribution chain, regulatory inventory |
| Real Estate Developer | 1.5 – 4.0 | 50%+ (project-specific) | WIP inventory dominates, RERA escrow |
| Modern Retail | 0.8 – 1.2 | Negative to 5% | Negative WC by design — supplier credit funds operations |
| Trading / Distribution | 1.2 – 1.8 | 10% – 20% | Inventory and AR balanced by supplier credit |
| Telecom | 0.5 – 1.0 | Negative (post-Ind AS 116 lease impact) | Low CA, high lease liabilities |
| Capital Goods / EPC | 1.5 – 2.5 | 30% – 50% | Long-cycle projects, milestone billing |
Reading the Bands
Current Ratio above the high end of the band signals over-investment in working capital — excess inventory, slow receivables, or idle cash. Current Ratio below the low end signals liquidity stress — unless deliberately engineered as in modern retail, where supplier credit dominance produces structurally negative working capital. Use industry benchmarks as starting point, refine with three to five direct competitor comparisons.
CA Tip: When pulling competitor data for benchmarking, use the latest annual report's Schedule III note disclosure rather than secondary aggregator sources. Many secondary sources use different definitions (e.g., excluding GST credit from Other Current Assets), leading to inconsistent comparisons. The Schedule III note format ensures apples-to-apples comparison.
MSMED Act 2006 — Impact on Current Liabilities
Schedule III Division II requires separate disclosure of Trade Payables to Micro and Small Enterprises (MSE) versus other suppliers. The MSE figure is critical because the Micro, Small and Medium Enterprises Development Act, 2006 imposes hard regulatory consequences on delayed payments.
Three Statutory Consequences for Delayed MSE Payments
- Section 15 — 45-day cap. Buyers must pay MSE suppliers within the period agreed in writing, capped at 45 days from acceptance, or 15 days if no written agreement.
- Section 16 — Penalty interest. Compound interest with monthly rests at three times the RBI bank rate (≈ 19.5% annualised at current 6.50% bank rate).
- Section 43B(h) of Income Tax Act. Effective AY 2024-25 (per Finance Act 2023), tax deduction is allowed only on actual payment if MSE payment is delayed beyond Section 15 limit.
Form MSME-1 Half-Yearly Disclosure to MCA
All companies with MSE supplier dues outstanding beyond 45 days must file half-yearly returns to the Ministry of Corporate Affairs in Form MSME-1, disclosing outstanding dues and reasons for delay. From April 2025, MCA notification SO-1376(E) dated 25 March 2025 enhanced the disclosure requirements. Statutory auditors verify MSME-1 filing as part of audit completion procedures.
Working Capital Implication
A high MSE Trade Payables balance inflates Current Liabilities, suppressing Current Ratio and Working Capital. While this appears to free up working capital, it creates regulatory exposure under Section 15/16 and tax exposure under Section 43B(h). The economic cost of the implicit financing is approximately 21-25% per annum (compound interest at 3× RBI bank rate plus tax disallowance impact) — far higher than typical bank borrowing rates of 9-11%. Stretching MSE payables is the most expensive form of working-capital financing available.
For a deeper Cash Conversion Cycle view including DPO impact analysis, see the Cash Conversion Cycle Calculator.
How to Optimise Working Capital
Working Capital optimisation releases trapped cash without external borrowing. A 10% reduction on a ₹100 crore current asset base unlocks ₹10 crore of cash — significant capacity for capex or debt prepayment.
Reducing Current Assets
- Inventory rationalisation — ABC and FSN analysis, slow-moving provision, vendor-managed inventory, just-in-time sourcing
- Faster collections — tighter credit policy, early-payment discounts, TReDS factoring, dunning automation
- GST credit utilisation — match input credit with output liability, avoid accumulation in books
- Cash and bank balance review — sweep mechanism into liquid funds, avoid idle current account balances
- Receivable securitisation — for large concentrated receivable portfolios
Optimising Current Liabilities (Carefully)
- Renegotiate non-MSE supplier terms — push from 30 to 60 days during contract renewal
- Supply chain finance arrangements — bank pays supplier early, buyer pays bank later
- Avoid stretching MSE payables — Section 15/16/43B(h) penalties exceed working-capital benefit
- Optimise short-term borrowing mix — CC, OD, WCDL, commercial paper, supply chain finance
- Synchronise statutory payments — pay GST, TDS, EPF on due dates, not earlier
The Compounding Effect
A 5% reduction in inventory + 5-day reduction in DSO + 10-day extension in DPO (non-MSE only) typically compounds to a 12-15% reduction in Working Capital tied up. For a company with ₹500 crore annual revenue and 60-day CCC, this releases approximately ₹10-12 crore — enough to fund a year of capex or repay a meaningful tranche of high-cost short-term debt.
CA Tip: Set Working Capital efficiency as a board-level KPI for the CFO. Monitor monthly using flash data, with quarterly audited validation against Schedule III ratios. The most effective measure is "Working Capital Days" = (NWC × 365) ÷ Revenue. Track against same-industry listed peers and historical 12-quarter rolling trend for early-warning signals.