Monthly Cash Flow Calculator · Calculation guide

Compare income and expenses on a common monthly basis.

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.

CF_month=ΣY_month−ΣE_month; CF_week→month=CF_week·52/12

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

AmountCash typePeriod
50,000IncomeMonthly
30,000ExpenseMonthly

Formula:

CF_month=ΣY_month−ΣE_month; CF_week→month=CF_week·52/12

Monthly net cash flow = 20000.0000000000

ResultValue
Monthly net cash flow20,000
Monthly income50,000
Monthly expenses30,000
Item 150,000
Item 230,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Amount (row 1)50,00055,000Monthly net cash flow20,00025,000
Cash type (row 1)IncomeExpenseMonthly net cash flow20,000-80,000
Period (row 1)MonthlyWeeklyMonthly net cash flow20,000186,666.666667
Monthly Cash Flow Calculator →