Skip to main content
Office desk with a smartphone and financial charts

Table Of Contents

BFM: a 13-month financial model you can read like a time-lapse

Disclosure: City Profit builds the BFM method and sells services based on it. The slider is a simplified teaching model. The table below it is a real tab from our own financial model.

BFM is the Big Financial Model: one table with a column for every month, where every sales channel is its own funnel. Each funnel improves a little each month until it hits a ceiling. Read it left to right and you watch a business grow, or fail to, before it exists.

Hands typing on a laptop that shows a data spreadsheet

Watch one funnel for thirteen months

Drag the slider. Reach grows every month, each conversion rate climbs toward its ceiling, and product B switches on in month 3. The numbers follow the SEO channel of our own model, simplified.

–Reach: people who see you per month

↓ – visit the site

–Traffic: site visitors

↓ – show interest

–Interest: take the free checklist

↓ – buy the cheap product C$

–C$ buyers

↓ – buy B (from month 3)

–B buyers
–revenue from this channel in the month

Three things to notice. The top grows slowly. The conversion rates grow too, so the effects multiply. And revenue bends upward because both grow at once. That bend is what investors pay for, and it is also what a spreadsheet can fake, which is why the real tab uses ceilings.

Now the real tab

Below is the first channel of the BFM tab of the model we built for our own product. The full tab has four channels and 25 columns.

MOMO – Financial Model (EN).xlsx
Ceiling1Kpr 2-132Kpr 14+MetricM1M2M3M4M5M6
8MOMO – CHANNEL 1: SEO
97%3%Reach, people/mo36 0006 4206 8697 3507 8658 415
1010%1%0%Traffic (reach to site), %5%5%6%6%7%8%
11Traffic, people270327392463543631
127%0%0%CF interest (= takes the checklist), %3%3%4%4%4%5%
13CF taken, units81014182228
1520%1%0%C$ conversion (of interest), %9%10%11%11%12%13%
16C$ sold, units001223
17C$ revenue, EUR008161624
185%0%0%B conversion (from month 3), %40%0%1%1%2%2%
21SEO channel revenue, EUR008161624
SUPABCRFunnelsBFMPOSCO
Shortened: the full tab continues to M25 and adds three more channels. Green cells are the inputs, yellow cells the ceilings.
  1. The ceiling column is reality. Search traffic never exceeds about 10% of reach. A rate may not climb past its ceiling, whatever the growth rate says.
  2. Kpr is the monthly growth of a rate. One value for months 2 to 13, a lower one after. Green means you type it.
  3. The funnel runs down the page. Reach, traffic, interest, buyers. Every line is the line above times a rate.
  4. B switches on in month 3. The model refuses to sell the main product before trust exists. That rule alone stops most fantasy forecasts.

Why every rate has a ceiling

Spreadsheet optimism

Growth of 5% a month for six years multiplies a number by 33. A hundred customers become 3,300. Nothing in the real world grows like that.

BFM

Every rate grows until its ceiling and stops. The channel then grows only by reach, which is slow and honest. Investors read the ceiling column first.

Try the difference yourself. The calculator runs two scenarios from the same starting point: a base growth and a faster one. Defaults use the break-even point of the SUP sheet.

Base case or scale case?

Customers (B equivalents) grow by a monthly percentage. Profit = customers x margin minus fixed costs.

–break-even month, base
–break-even month, scale
–month 13 profit, base
–month 13 profit, scale
–cumulative by month 13, base
–cumulative by month 13, scale
The base case pays back inside 13 months. Plan the scale case as an upside, not as the promise. Only the scale case pays back. That means the plan depends on faster growth than you can prove. Find a cheaper way or a higher margin. Neither case pays back in 13 months. Revisit price, costs or the number of customers in month 1.

Build yours in an afternoon

  1. List your channelsSearch, social, outreach, partners. Each channel is one funnel with its own numbers.
  2. Fill month 1 from a pilotUse a week of real data, or the nearest competitor, never a hope.
  3. Set the ceilings firstAsk what the best business in your field achieves. That is the ceiling.
  4. Choose the monthly growthSmall numbers, 3 to 8%. If it takes a miracle to hit the target, the target is wrong.
  5. Switch products on in orderThe cheap product from month 1, the main one from month 3, the big one when capacity allows. See ABCR.
  6. Sum, subtract, find the crossingAdd the channels, subtract the SUP costs, and find the month where the line crosses zero.

BFM next to the models you know

Model
What it does
Where BFM differs
Bottom-up revenue model
Builds revenue from units and prices.
BFM puts a funnel under every channel and caps each rate.
Three-statement model
Links income, balance sheet and cash flow.
BFM is the first layer under it: the revenue line the three statements need.
Cohort model
Follows groups of customers over time.
BFM tracks channels first. Cohorts matter once you have retention data.
Scenario budget
Base, upside and downside cases.
BFM scenarios differ by growth and ceilings, not by a single fudge factor.

The funnel under each channel is explained in Funnels and Motivations. The finished model feeds the pitch deck and the market and the ask. We build BFM files for clients at Bizon Planner and teach the method at mdopen.pro.

The City Profit technologies series

Previous: ABCR | Next: ICP and channels | Overview: the seven-step go-to-market guide | All technologies

FAQ

What does BFM stand for?

Big Financial Model: a month-by-month table, usually 13 or 25 months, where each sales channel is a funnel and the sum minus costs gives profit.

Why 13 months and not 12?

Thirteen months lets you compare month 13 with month 1 and see a full year of growth. Longer models, like our 25-month ones, are for investors.

How do I choose the ceilings?

Look at the best result in your field: search click-through, email conversion, close rate. Use the best as the ceiling, never the average of dreams.

Can I build it in Excel or Google Sheets?

Yes. Our models are plain spreadsheets. The discipline matters more than the tool: inputs in one colour, ceilings in another, one funnel per channel.

What should I do with the result?

Put the profit line on the roadmap slide of your pitch deck and use the break-even month in your funding ask.

Sources and further reading

  1. Financial modeling (Wikipedia)
  2. Marketing funnel (Wikipedia)
  3. Cohort analysis (Wikipedia)
  4. Overview: how to build a B2B offer and go-to-market strategy

Want this done on your numbers? Book a free 30-minute audit with Volodymyr Pimenov.

Book the free auditSee City Profit services

More materials by CITY PROFIT.

CITY PROFIT TRADEMARK. 3080422932. UA