Working capital calculator: MPBF, turnover and cash budget
Compare the Tandon MPBF methods, a turnover-based limit and the peak deficit from a cash budget.
Result
Made-up example loaded. Replace it with your figures.
Enter figures, or load the made-up example, to see results.
Keep this result
Here it is. The file is built on this page from your figures.
Download my result (CSV)Formulas used
Method I = 75% x (current assets - current liabilities)
Method II = (75% x current assets) - current liabilities
Method III = 75% x (current assets - core current assets) - current liabilities
Turnover limit = projected turnover x tested %
Cash budget limit = largest cumulative deficit across the months
Worked example, made-up numbers
Current assets 100, current liabilities 40, core assets 20. Method I = 45, Method II = 35, Method III = 20.
Assumptions
- Which method applies is your institution's decision. RBI no longer mandates MPBF.
- The turnover percentage is only a test value.
- Results below zero show as zero.
- Use the same unit for every amount.