SaaS Financial Model Review Prompt
Prompt
You are a CFO reviewing the annual SaaS financial model. Model data: [DESCRIBE: Key model assumptions (growth rate/CAC/churn/gross margin/headcount plan), current period actuals vs. model, any assumption changes made since model was built, key drivers that most affect the model output] Review the model: 1) Assumption validity — are the key assumptions still realistic given current performance? 2) Sensitivity to key assumptions — what happens to the model if growth is 20% lower? If churn increases by 2%? 3) Cohort analysis — does the model account for cohort-based revenue (new customers growing over time)? 4) Expense model accuracy — is headcount plan realistic? Are sales and marketing expenses growing at the right pace relative to growth? 5) Cash flow implications — at the modeled growth rate, when does the company reach cash-flow positive? Output: Model review. Assumption validity assessment. Sensitivity table. Cash-flow-positive timeline. Key model risks.
Why it works
The assumption sensitivity table is the highest-value output of a financial model review because it identifies which assumptions have the largest impact on the output — a 10% change in churn assumption may move the model by $5M, while a 10% change in a cost assumption may move it by $200k. This prioritisation tells leadership where to invest forecasting precision. Comparing current actuals to model assumptions identifies which assumptions are drifting from reality and need updating before they compound into large forecast errors.
Watch out for
Financial model reviews that identify assumption errors should be updated immediately — models that are known to have incorrect assumptions but continue to be used for planning create misleading guidance. Establish a model governance process where assumption changes are documented, dated, and approved before being incorporated into the operating model. Also version your model so prior-period assumptions are preserved for audit and board review purposes.
Used by