Connected monthly cash-flow planning estimate
Customer collections · inventory · supplier payments · operating and financing movements
Opening position and customer inputs
| Opening bank and cash | ₹1,00,000 |
|---|---|
| Expected sales for month | ₹4,00,000 |
| Sales made on credit | 75.0% |
| Opening customer receivables | ₹3,00,000 |
| Expected collection days (DSO) | 45.0 days |
Inventory and supplier inputs
| Cost of sales for month | ₹2,20,000 |
|---|---|
| Opening inventory | ₹1,80,000 |
| Target closing inventory | ₹2,00,000 |
| Inventory purchases required | ₹2,40,000 |
| Opening supplier payables | ₹1,50,000 |
| Supplier payment days (DPO) | 30.0 days |
Operating, investment and financing inputs
| Payroll and staff payments | ₹70,000 | New loan received | ₹0 |
|---|---|---|---|
| Tax and statutory payments | ₹20,000 | Loan principal and interest paid | ₹10,000 |
| Other operating expenses | ₹45,000 | Owner capital introduced | ₹0 |
| Capital expenditure payments | ₹0 | Other cash coming in / going out | ₹0 / ₹15,000 |
Cash-flow summary
| Customer cash expected | ₹2,50,000 |
|---|---|
| Supplier cash payments | ₹1,50,000 |
| Total cash coming in | ₹2,50,000 |
| Total cash going out | ₹3,10,000 |
| Net cash movement | -₹60,000 |
| Estimated closing cash | ₹40,000 |