Forecasts & financial models
Revenue forecasts, budgets, pricing and cash-flow models in clean, traceable spreadsheets.
| Quarter | Opening ARR | New | Expansion | Churn | Closing ARR |
|---|---|---|---|---|---|
| Q1 | $12,400 | +$1,150 | +$620 | −$310 | $13,860 |
| Q2 | $13,860 | +$1,280 | +$690 | −$347 | $15,483 |
| Q3 | $15,483 | +$1,410 | +$775 | −$387 | $17,281 |
| Q4 | $17,281 | +$1,560 | +$865 | −$432 | $19,274 |
Driver-based models where every assumption is on one tab, every output ties to it, and a variance review takes minutes instead of an afternoon. Analysis only: no accounting, tax or audit work.
What you get
Every engagement is scoped in writing before work starts. These are the usual deliverables; take the ones you need.
Revenue forecastExcel or Google Sheets
Bookings-to-revenue by product, segment and region, with scenarios you can switch between.
IncludedBudget and variance modelModel plus monthly review tab
Plan versus actual by department with the driver behind each variance explained, not just the number.
IncludedPricing and margin modelModel
Unit economics, discount impact and break-even by product or deal.
IncludedCash-flow projectionModel
Thirteen-week or twelve-month cash view built from receivables, payables and the forecast.
IncludedWhy this is a known quantity
The founder's in-house record on this exact work, before Known Quantity existed.
How it goes
- Step 1 of 3
Scope it in writing
A few emails to pin down the problem, the data and what "done" looks like. You get a written scope and a price before anything starts.
The full process - Step 2 of 3
Build on your real data
Days, not months, for most projects. We say which parts were automated and which were checked by hand.
How we use automation - Step 3 of 3
Hand it over, documented
Files, logic and a walkthrough. Nothing depends on us to keep running.
What that looks like
Questions people ask
Is this accounting?
No. We build analysis and planning models. Your accountant or CPA remains responsible for books, tax and audit.
How do you keep models from rotting?
One assumptions tab, named ranges, no merged cells, a change log and a short note on how to roll the model forward each period.
Related work
Sales compensation & quotas
Commission plans that pay the right amount, on time, with an audit trail reps can read.
Read moreReporting & dashboards
Reports that refresh on schedule and land in the right inbox, so nobody rebuilds the Monday file by hand.
Read moreCRM & ERP data quality
Clean, trusted records in Salesforce, Dynamics, NetSuite and Business Central, and the checks that keep them that way.
Read moreReady to scope forecasting work?
Send a few lines about the problem and the tools involved. You will have questions or a quote within one business day.