An open resource for founders, investors & operatorsPRIVATE MARKETS, EXPLAINED.
Cash & fundraisingFREE ACCESS

Monthly Cash Forecast Calculator

Project monthly collections and payments, including changing burn and a cash reserve.

6 min guideTransparent methodologyUSDGo to calculator ↓
01 / UNDERSTAND THE CONCEPT

Runway changes when your cash flows change.

A constant-burn runway is a useful starting point, but a business rarely stays at the same spending and collection rate. This monthly model compounds each flow separately and tracks the lowest month-end balance.

The required financing is the amount of opening cash needed to keep every modeled month-end at or above the chosen reserve. A later recovery does not erase an earlier funding gap. Negative balances show unfunded requirements, not an ability to spend without cash.

02 / THE MATHEMATICS

The formula, made clear.

Cash(0) = opening cash + immediate operating adjustment; Cash(t) = cash(t−1) + collections₁(1+gᵢ)^(t−1) − payments₁(1+gₒ)^(t−1)
Funding gap
max(0, required reserve − lowest modeled balance), including opening cash.
Cash-out month
First month-end at or below zero; intramonth timing is excluded.
03 / A WORKED EXAMPLE

Put the numbers in context.

With $1,000,000.00 opening cash, $40,000.00 collections and $100,000.00 payments, month one closes at $940,000.00. Growth applies from month two onward.

Illustrative scenario · USD
InputExample value
Opening cash$1,000,000.00
Month-one payments$100,000.00
Month-one collections$40,000.00
Monthly payment growth2%
Monthly collection growth5%
Forecast horizon24 months
Required cash floor$100,000.00
Immediate operating cash adjustment$0.00
Opening financing to preserve the reserve$362,106.29
MODEL BOUNDARIES

What this calculation assumes

End-of-month recurring movements and constant growth assumptions, no financing inflows. A separate one-off operating adjustment is assumed realized immediately before month one; do not also include it in recurring flows. Adjusted opening cash is included in the minimum balance. A gradual collections change requires a timed operating plan. Growth rates are scenarios, not forecasts of customer behavior.

FROM UNDERSTANDING TO ACTION

What to consider next.

Review the month-by-month balances and rerun a downside collection scenario. Add the financing requirement to the dilution model.

How we approach financial models →

Monthly cash forecast before new financing

The first opening balance includes the immediate operating cash adjustment. It is not repeated in monthly collections or payments.

-0.261TodayMonth 24
Cash before financing (USD, millions) Required cash floor: $100,000.00
Monthly cash forecast before new financing · monetary values in USD
MonthCollectionsPaymentsClosing cash
1$40,000.00$100,000.00$940,000.00
2$42,000.00$102,000.00$880,000.00
3$44,100.00$104,040.00$820,060.00
4$46,305.00$106,120.80$760,244.20
5$48,620.25$108,243.22$700,621.23
6$51,051.26$110,408.08$641,264.42
7$53,603.83$112,616.24$582,252.00
8$56,284.02$114,868.57$523,667.45
9$59,098.22$117,165.94$465,599.73
10$62,053.13$119,509.26$408,143.60
11$65,155.79$121,899.44$351,399.94
12$68,413.57$124,337.43$295,476.09
13$71,834.25$126,824.18$240,486.16
14$75,425.97$129,360.66$186,551.46
15$79,197.26$131,947.88$133,800.85
16$83,157.13$134,586.83$82,371.15
17$87,314.98$137,278.57$32,407.56
18$91,680.73$140,024.14-$15,935.85
19$96,264.77$142,824.62-$62,495.71
20$101,078.01$145,681.12-$107,098.82
21$106,131.91$148,594.74-$149,561.65
22$111,438.50$151,566.63-$189,689.78
23$117,010.43$154,597.97-$227,277.32
24$122,860.95$157,689.93-$262,106.29
TEST THE ASSUMPTIONS

Funding to maintain cash floor: sensitivity

First-month payments × monthly collections growth. The opening cash, forecast horizon and payment growth stay fixed. Other assumptions match the current calculation.

Columns: Month-one payments. Rows: Monthly collection growth. Results use USD. The outlined cell is the current base case. “—” means that combination is outside the model or has no finite result.

Funding to maintain cash floor by monthly collection growth and month-one payments
Monthly collection growth ↓ / Month-one payments$80,000.00$90,000.00$100,000.00$110,000.00$120,000.00
1%$454,810.40$759,029.03$1,063,247.65$1,367,466.28$1,671,684.90
3%$156,690.19$460,908.81$765,127.44$1,069,346.06$1,373,564.69
5%$0.00$57,887.67$362,106.29Current base$666,324.92$970,543.54
7%$0.00$0.00$0.00$142,658.62$423,949.95
9%$0.00$0.00$0.00$0.00$22,500.33
THE OAKSHORE NETWORK

Understand the mechanics.
Then enter the market.

Oakshore connects verified founders and investors through a private, thesis-aligned market network.

Explore Oakshore