Startup cash runway forecast with PL BS CF
A startup cash runway forecast answers one practical question: how many months of cash remain under the current hiring, revenue, collection, and payment assumptions. A linked PL, BS, and CF model is useful because runway is not only a profit-and-loss question. Receivables, payables, capex, loan draws, and beginning cash all change the answer.
How do I forecast startup cash runway?
Start with opening cash and other balance sheet items, then add monthly transactions. Use revenue assumptions for sales, expense assumptions for burn, payroll for hiring plans, collection lag for cash receipts, and payment lag for vendor cash outflow. The key metric is ending cash by month.
1) Start from opening cash and working capital
Opening cash is the first runway anchor. If your company already has accounts receivable, accounts payable, debt, or prepaid items, include them in opening BS so the cash flow forecast starts from a realistic position.
2) Separate burn rate from cash timing
Burn rate is often discussed as monthly expenses minus revenue, but cash runway can move differently when sales are collected later or vendors are paid later. A monthly cash runway model should therefore include both PL activity and BS timing.
3) Add hiring and recurring expense assumptions
Hiring plans usually create step changes in payroll. Enter each hiring wave as a recurring payroll or expense transaction, then review whether ending cash crosses your minimum cash threshold before the next funding or revenue milestone.
4) Review runway before Excel export
Use the free web forecast to inspect cash trend, net income, and balance checks first. Export Excel only when you need a formula-linked workbook for investors, board review, lender discussions, or internal handoff.