Snapshot

The Snapshot sheet answers one question: what does the business look like at a particular point in time? The rest of the Standard Financial Model runs across the whole timeline, month after month for five years. Snapshot picks one month and holds it still.

Select a date and the sheet reports the cash you'd have in the bank at the end of that month, the runway from that point, the revenues expected in the surrounding quarter, and a table and chart of the major movements in cash in the months on either side of the date. It's the view I'd want before a board meeting, a fundraise conversation, or a monthly check-in: not the whole forecast, one moment in it.

How it works

The sheet is a single-period cash flow detail. It starts with cash at the beginning of the selected period, then steps through revenues, gross margin, other income and expenses, corporate taxes, changes in working capital, and net cash flows from investing and financing, and ends at cash at the end of the period. Every line is pulled from Forecast and Statements for the month you picked, so the walk always reconciles to the statements for that month.

Because it reads from the merged actuals-plus-forecast block on Forecast, the snapshot works whether the selected month is historical or projected. If you've linked in actual financials, a past month shows what happened. A future month shows the forecast. Nothing on the sheet knows or cares which it is.

Inputs

One input: the "As of" dropdown near the top of the sheet, which selects the base month for the snapshot. Every other cell on the sheet is a formula. Change the date and the whole sheet re-reports.

Common modifications

The point of any reporting sheet is to surface what matters for a decision, and what matters differs by company. The prebuilt lines cover the cash story, which is the story most early-stage companies need told. Founders often add lines for the metrics they report to their board: headcount at the date, MRR or ARR, customers or active users, or the current month's burn against the plan. All of those already exist elsewhere in the model, on Key Metrics, Forecast or Hiring Plan, so adding them is a matter of referencing the right row for the selected month rather than building anything new.

If you want the same view at several dates side by side (say, quarter-ends), duplicate the sheet and change the "As of" date on each copy. The formulas carry over unchanged.

Snapshot is an output sheet. Hiding or deleting it has no effect on the rest of the model.