Calculation guide
For people checking a money question using their own amounts and assumptions.
Use a consistent monthly basis except where a different period is explicitly entered. Allocation percentages must total 100%; rounded shares reconcile to the total. Ratios and reserve targets are editable assumptions rather than recommendations. A sinking fund must cover the earliest due date, not just an annual average. Runway reports no depletion under the assumptions when cash does not decline.
Inputs
Amount
Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.
Cash type
Choose income or expense; this determines the sign used in totals and budget variance.
Period
Time basis of this row. Weekly and annual amounts are converted to monthly equivalents.
Worked example
Cash items
| Amount | Cash type | Period |
|---|---|---|
| 50,000 | Income | Monthly |
| 30,000 | Expense | Monthly |
Formula:
CF_month=ΣY_month−ΣE_month; CF_week→month=CF_week·52/12
Monthly net cash flow = 20000.0000000000
| Result | Value |
|---|---|
| Monthly net cash flow | 20,000 |
| Monthly income | 50,000 |
| Monthly expenses | 30,000 |
| Item 1 | 50,000 |
| Item 2 | 30,000 |
Interpreting the result
Monthly income minus monthly expenses; a negative value uses cash reserves.
Income or spending converted to a common monthly amount.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Amount (row 1) | 50,000 | 55,000 | Monthly net cash flow | 20,000 | 25,000 |
| Cash type (row 1) | Income | Expense | Monthly net cash flow | 20,000 | -80,000 |
| Period (row 1) | Monthly | Weekly | Monthly net cash flow | 20,000 | 186,666.666667 |
