How long will your cash last, and what happens if sales come in 20% lower? I build a 24-month revenue and cash forecast for online stores in Google Sheets or Excel, with live formulas you can update yourself.

Scope: revenue built from your drivers (sessions, conversion, order value, returns), gross margin, marketing and fixed costs, cash at the end of each month; downside, base and upside scenarios side by side; break-even month and the funding you need to keep a cash buffer; 2 rounds of revisions.

Every number is traceable: inputs on one tab, formulas visible, no hard-coded results. This is an operational forecast for running the business, not a three-statement model for investors or tax filing. Not tax or accounting advice.

Background: pricing and sourcing analysis at Auto1 Group, nine years in investment analysis, 10+ years in data and business analysis.

The cover image is a case study built on synthetic data.