Week 1: 51000.00 | Week 2: 52000.00 | Week 3: 53000.00 | Week 4: 54000.00 | Week 5: 55000.00 | Week 6: 56000.00 | Week 7: 57000.00 | Week 8: 58000.00 | Week 9: 59000.00 | Week 10: 60000.00 | Week 11: 61000.00 | Week 12: 62000.00 | Week 13: 63000.00 is the example result. Each weekly closing balance becomes the following week’s opening cash. A positive final balance can hide an earlier shortfall, so read the entire sequence.
Each weekly closing balance becomes the following week’s opening cash.
Keeping timing visible in cash decisions
Each weekly closing balance becomes the following week’s opening cash. A positive final balance can hide an earlier shortfall, so read the entire sequence. Profit does not state when money reaches the bank. Receivables, supplier payments and inventory can absorb cash while sales remain healthy. A cash comparison needs the payment window and outstanding balance, not only the invoice total.
What the model includes
For each of 13 weeks, closing cash = previous closing cash + inflow − outflow. The first week starts with opening cash. Report the closing cash for every week. Record whether amounts include tax, credit notes or disputed balances. Where a model converts annual flows into days, keep the balance and flow definitions consistent. Supplier terms and collection delays may move independently. Use the result to identify the next collection or payment question. A financing decision also needs contractual fees, settlement timing and repayment terms that may sit outside this model.
Example with the supplied inputs
Opening cash: 50000; Week 1 inflow: 10000; Week 1 outflow: 9000; Week 2 inflow: 10000; Week 2 outflow: 9000; Week 3 inflow: 10000; Week 3 outflow: 9000; Week 4 inflow: 10000; Week 4 outflow: 9000; Week 5 inflow: 10000; Week 5 outflow: 9000; Week 6 inflow: 10000; Week 6 outflow: 9000; Week 7 inflow: 10000; Week 7 outflow: 9000; Week 8 inflow: 10000; Week 8 outflow: 9000; Week 9 inflow: 10000; Week 9 outflow: 9000; Week 10 inflow: 10000; Week 10 outflow: 9000; Week 11 inflow: 10000; Week 11 outflow: 9000; Week 12 inflow: 10000; Week 12 outflow: 9000; Week 13 inflow: 10000; Week 13 outflow: 9000. Result: Week 1: 51000.00 | Week 2: 52000.00 | Week 3: 53000.00 | Week 4: 54000.00 | Week 5: 55000.00 | Week 6: 56000.00 | Week 7: 57000.00 | Week 8: 58000.00 | Week 9: 59000.00 | Week 10: 60000.00 | Week 11: 61000.00 | Week 12: 62000.00 | Week 13: 63000.00. The values are illustrative.
Compare one changed input
Opening cash changes from 50000 to 55000. The result becomes Week 1: 56000.00 | Week 2: 57000.00 | Week 3: 58000.00 | Week 4: 59000.00 | Week 5: 60000.00 | Week 6: 61000.00 | Week 7: 62000.00 | Week 8: 63000.00 | Week 9: 64000.00 | Week 10: 65000.00 | Week 11: 66000.00 | Week 12: 67000.00 | Week 13: 68000.00. All other inputs remain fixed.
Calculation rule
For each of 13 weeks, closing cash = previous closing cash + inflow − outflow. The first week starts with opening cash. Report the closing cash for every week.
Inputs and output
| Input | Example value | Entry convention |
|---|---|---|
| Opening cash | 50000 | Use opening cash on the currency and period basis shown by the formula. Keep gross amounts, net amounts and unit amounts distinct; the page does not fetch a price or exchange rate. |
| Week 1 inflow | 10000 | Use the source quantity represented by week 1 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 1 outflow | 9000 | Use the source quantity represented by week 1 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 2 inflow | 10000 | Use the source quantity represented by week 2 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 2 outflow | 9000 | Use the source quantity represented by week 2 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 3 inflow | 10000 | Use the source quantity represented by week 3 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 3 outflow | 9000 | Use the source quantity represented by week 3 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 4 inflow | 10000 | Use the source quantity represented by week 4 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 4 outflow | 9000 | Use the source quantity represented by week 4 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 5 inflow | 10000 | Use the source quantity represented by week 5 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 5 outflow | 9000 | Use the source quantity represented by week 5 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 6 inflow | 10000 | Use the source quantity represented by week 6 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 6 outflow | 9000 | Use the source quantity represented by week 6 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 7 inflow | 10000 | Use the source quantity represented by week 7 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 7 outflow | 9000 | Use the source quantity represented by week 7 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 8 inflow | 10000 | Use the source quantity represented by week 8 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 8 outflow | 9000 | Use the source quantity represented by week 8 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 9 inflow | 10000 | Use the source quantity represented by week 9 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 9 outflow | 9000 | Use the source quantity represented by week 9 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 10 inflow | 10000 | Use the source quantity represented by week 10 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 10 outflow | 9000 | Use the source quantity represented by week 10 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 11 inflow | 10000 | Use the source quantity represented by week 11 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 11 outflow | 9000 | Use the source quantity represented by week 11 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 12 inflow | 10000 | Use the source quantity represented by week 12 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 12 outflow | 9000 | Use the source quantity represented by week 12 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 13 inflow | 10000 | Use the source quantity represented by week 13 inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Week 13 outflow | 9000 | Use the source quantity represented by week 13 outflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
Output: Week 1: 51000.00 | Week 2: 52000.00 | Week 3: 53000.00 | Week 4: 54000.00 | Week 5: 55000.00 | Week 6: 56000.00 | Week 7: 57000.00 | Week 8: 58000.00 | Week 9: 59000.00 | Week 10: 60000.00 | Week 11: 61000.00 | Week 12: 62000.00 | Week 13: 63000.00 is the example result. Each weekly closing balance becomes the following week’s opening cash. A positive final balance can hide an earlier shortfall, so read the entire sequence. Use the formula to distinguish a cash amount, count, percentage or ratio.
How to use the page
Collect the inputs
Gather Opening cash, Week 1 inflow, Week 1 outflow. Use one period and the units shown in the form.
Run the calculation
Enter the values and select the action. The calculation rule above explains how the inputs produce the result.
Compare a scenario
Change Opening cash on its own, keeping the other inputs fixed. Read both results before changing another assumption.
Worked example
With the example inputs listed above, the result is Week 1: 51000.00 | Week 2: 52000.00 | Week 3: 53000.00 | Week 4: 54000.00 | Week 5: 55000.00 | Week 6: 56000.00 | Week 7: 57000.00 | Week 8: 58000.00 | Week 9: 59000.00 | Week 10: 60000.00 | Week 11: 61000.00 | Week 12: 62000.00 | Week 13: 63000.00.
Change Opening cash from 50000 to 55000 while keeping every other value fixed. The result becomes Week 1: 56000.00 | Week 2: 57000.00 | Week 3: 58000.00 | Week 4: 59000.00 | Week 5: 60000.00 | Week 6: 61000.00 | Week 7: 62000.00 | Week 8: 63000.00 | Week 9: 64000.00 | Week 10: 65000.00 | Week 11: 66000.00 | Week 12: 67000.00 | Week 13: 68000.00. This comparison isolates that input; it does not forecast how other variables will respond.
Check the stated formula, units and limits before using the result in a decision.
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026