Cash Flow Planner
Subtract the entered cash outflows from inflows and add the movement to opening cash to estimate ending cash.
Subtract the entered cash outflows from inflows and add the movement to opening cash to estimate ending cash.
What this tool does
Subtract the entered cash outflows from inflows and add the movement to opening cash to estimate ending cash.
Review the output before the next step
Use cash expected to move in the stated period rather than accounting revenue. This model has no dated payment schedule. The fields available on this page are Opening cash, Expected monthly inflow, Fixed monthly costs, Variable monthly costs, Other outflows. Subtract the entered cash outflows from inflows and add the movement to opening cash to estimate ending cash.
How it works
Subtract the entered cash outflows from inflows and add the movement to opening cash to estimate ending cash.
Inputs
| Field | Example | Definition |
|---|---|---|
| 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. |
| Expected monthly inflow | 30000 | Use the source quantity represented by expected monthly inflow. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Fixed monthly costs | 12000 | Use fixed monthly costs 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. |
| Variable monthly costs | 6000 | Use variable monthly costs 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. |
| Other outflows | 2000 | Use the source quantity represented by other outflows. Keep the counted population fixed and avoid mixing a unit value with a period total. |
Step-by-step guide
Prepare the source
Supply Opening cash, Expected monthly inflow, Fixed monthly costs. Keep the original material so the output can be compared with it.
Build cash plan
Check Opening cash, Expected monthly inflow, then select Build cash plan.
Use the result
Compare the cash flow planner result with the unchanged source before copying or downloading it.
When to use it
Subtract the entered cash outflows from inflows and add the movement to opening cash to estimate ending cash. Use cash expected to move in the stated period rather than accounting revenue. This model has no dated payment schedule.
Example and scope
Example inputs: Opening cash: 50000; Expected monthly inflow: 30000; Fixed monthly costs: 12000; Variable monthly costs: 6000; Other outflows: 2000.
Use cash expected to move in the stated period rather than accounting revenue. This model has no dated payment schedule.
Worked output
Period: Opening cash: 50000.00 Expected inflows: 30000.00 Expected outflows: 20000.00 Projected movement: 10000.00 Projected ending cash: 60000.00 Owner: Action owner:
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.