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.
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.
↓ – visit the site
↓ – show interest
↓ – buy the cheap product C$
↓ – buy B (from month 3)
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.
| Ceiling1 | Kpr 2-132 | Kpr 14+ | Metric | M1 | M2 | M3 | M4 | M5 | M6 | |
| 8 | MOMO – CHANNEL 1: SEO | |||||||||
| 9 | 7% | 3% | Reach, people/mo3 | 6 000 | 6 420 | 6 869 | 7 350 | 7 865 | 8 415 | |
| 10 | 10% | 1% | 0% | Traffic (reach to site), % | 5% | 5% | 6% | 6% | 7% | 8% |
| 11 | Traffic, people | 270 | 327 | 392 | 463 | 543 | 631 | |||
| 12 | 7% | 0% | 0% | CF interest (= takes the checklist), % | 3% | 3% | 4% | 4% | 4% | 5% |
| 13 | CF taken, units | 8 | 10 | 14 | 18 | 22 | 28 | |||
| 15 | 20% | 1% | 0% | C$ conversion (of interest), % | 9% | 10% | 11% | 11% | 12% | 13% |
| 16 | C$ sold, units | 0 | 0 | 1 | 2 | 2 | 3 | |||
| 17 | C$ revenue, EUR | 0 | 0 | 8 | 16 | 16 | 24 | |||
| 18 | 5% | 0% | 0% | B conversion (from month 3), %4 | 0% | 0% | 1% | 1% | 2% | 2% |
| 21 | SEO channel revenue, EUR | 0 | 0 | 8 | 16 | 16 | 24 | |||
- 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.
- Kpr is the monthly growth of a rate. One value for months 2 to 13, a lower one after. Green means you type it.
- The funnel runs down the page. Reach, traffic, interest, buyers. Every line is the line above times a rate.
- 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
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.
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.
Build yours in an afternoon
- List your channelsSearch, social, outreach, partners. Each channel is one funnel with its own numbers.
- Fill month 1 from a pilotUse a week of real data, or the nearest competitor, never a hope.
- Set the ceilings firstAsk what the best business in your field achieves. That is the ceiling.
- Choose the monthly growthSmall numbers, 3 to 8%. If it takes a miracle to hit the target, the target is wrong.
- Switch products on in orderThe cheap product from month 1, the main one from month 3, the big one when capacity allows. See ABCR.
- 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
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
- B2B niche, Step 1: who and which problem
- Core Offer, Step 2: the one sentence
- POSCO, Step 3: pricing by scoring
- SUP, Step 4: break-even math
- ABCR, Step 5: the product ladder
- BFM, Step 6: the monthly forecast (you are here)
- ICP and channels, Buyer and channels
- Funnels and Motivations, Steps and reasons to buy
- Pitch Deck and Roadmap, The presentation
- International Metrics, Market size and the ask
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
- Financial modeling (Wikipedia)
- Marketing funnel (Wikipedia)
- Cohort analysis (Wikipedia)
- 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 servicesMore materials by CITY PROFIT.
Pitch deck: seven real slides from our own deck and the question each must answer
Sales funnel with Motivations: a funnel is a list of numbers with an owner
ICP and channels: two buyers, two roads and one owner for each
B2B niche: how to find a niche that sells, starting from your own SWOT
BFM: a 13-month financial model you can read like a time-lapse
SUP: the break-even sheet that turns a business idea into a number of customers