Posthog Financial Model
Dev Tools Startup Financials (Free Excel Download)
Open-source product analytics platform built for engineers and product teams, with self-hosted deployment and a complementary paid cloud tier.
professionals from Deloitte
Used by professionals from
About this model
PostHog is a self-deployable open-source product-analytics platform with trends, retention, funnels, paths, dashboards, session replay, feature flags, and heatmaps. It targets technical product teams that want a unified, extensible tool without data silos, SQL dependency, or surrendering usage data to third parties.
Free self-hosted software is the acquisition engine. Cloud hosting and enterprise self-hosted tiers add scalability, permissions, support, and service levels, using flat pricing. Community evangelism, content, and open-source contributions generate inbound paid demand, but the deck does not provide tiers, ARR, or ARPU.
Thousands of companies were using PostHog, alongside about 6,500 community developers and 100 contributors, with less than $25,000 total marketing spend. Target users had 50% one-month free-product retention. The model should forecast deployments, cloud conversion, usage, enterprise upgrades, hosting cost, expansion, and churn.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
About Posthog
posthog.com
How to build a detailed financial model for Posthog
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Posthog model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Product analytics platform (trends, retention, funnels, paths, dashboards, session replay, feature flags, heatmaps) in a single self-deployable tool.
- Core proposition: eliminates data silos and the need for multiple stitched-together tools; no SQL required; flat pricing.
- Self-host option is the primary differentiator - addresses GDPR/privacy needs and avoids sending user data to third parties.
- Plugin/event-pipeline architecture allows data export/import and extensibility (CDP capability).
- Target persona: technical PMs and senior engineers at companies where product usage is strategic; "visionaries" who want control and extensibility without being sold to.
Market
- No TAM/SAM/SOM figures given in deck.
- Market framing: existing product analytics tools (Mixpanel, Amplitude etc.) were not built for engineering teams and create data silos.
- Two segments identified: (1) Startups - broad, shallow, well-defined needs; (2) Scale-ups & Enterprise - high volume + privacy + product-led = "very badly served".
- Market thesis: product-led growth becoming mainstream; every team will eventually need a clear view of user behavior.
Revenue model
- Open-source core (self-hosted, free) drives top-of-funnel adoption.
- Paid product: cloud-hosted tier and enterprise self-host with permissioning, scalability, support, and SLAs.
- Pricing model: "flat pricing" referenced as a differentiator.
- Go-to-market: community-led (developer evangelism, content, open-source contributions) → inbound paid enquiries → enterprise upsell as product matures.
- No ARR, MRR, ARPU, or pricing tiers disclosed numerically in deck.
Traction & metrics
- Deployments: "Thousands of companies are using us" - chart shows steep J-curve from ~early 2020 to late 2020; no Y-axis labels visible.
- Deployment growth rate: increasing month-on-month; chart of deployments/month shows acceleration in most recent period (month shown as incomplete with projection).
- Monthly events (cloud only): exponential growth Jan–November 2020; sharp near-vertical inflection from October to November 2020. No absolute values on Y-axis.
- Inbound demand: separate chart (Apr 2020 – Jan 2021) shows near-zero until ClickHouse enabled (~Oct 2020), then near-vertical growth through Jan 2021.
- Community: ~6,500 developers across Slack, GitHub, Twitter, and product; ~100 contributors across all repos (up from 0 in February 2020).
- Marketing spend: <$25K total marketing spend over all time.
- Retention (free product): 50% one-month retention for target persona (technical PM / senior engineer); 33% for other profiles.
Unit economics
- Retention: 50% M1 for core persona vs. 33% for others.
- CAC: effectively near-zero for self-serve / community channel; <$25K total marketing spend to acquire thousands of companies.
- No LTV, payback period, gross margin, or ARPU figures in deck.
Competition / moat
- Named competitors (implicit): Mixpanel, Amplitude - "not built for teams, engineers left out".
- Moat sources: open-source community (100 contributors, 6,500+ developers); self-host option enabling privacy/GDPR compliance; extensibility via plugins; flat pricing vs. event-based pricing of incumbents.
- Competitive positioning: incumbents serve enterprise well; startups are underserved on the whole-product dimension. PostHog targets visionaries first, then pragmatists as product matures.
Team & funding ask / use of funds
- Use of funds: Implied by roadmap - expand value proposition, grow community (developer evangelism, DX), take plugins out of beta, build inbound sales process for enterprise.
Recommended financial model
- Archetype + why: Open-source SaaS - usage-based / freemium ARR model. PostHog has two distinct layers: (1) a free self-hosted OSS product that drives community and deployment growth, and (2) a paid cloud + enterprise tier. The model should track free deployments as a top-of-funnel lead pool converting to paid cloud seats or enterprise contracts. This is analogous to a PLG (product-led growth) SaaS model with a free-to-paid conversion funnel.
- Forecast horizon & granularity: 3 years (2021–2023), monthly for Year 1, quarterly for Years 2–3.
- Key drivers & assumptions:
- Monthly new deployments (free self-hosted): thousands already deployed; rate accelerating month-on-month. Model ~500–1,000 new deployments/month at deck date, growing 15–20% MoM - rationale: steep J-curve visible in slide 9/10 images with no Y-axis labels to anchor absolute figure.
- Free-to-paid conversion rate (cloud): 2–5% of free deployments convert to cloud paid plan - rationale: typical OSS-to-SaaS conversion range; deck shows "swamped with paid enquiries" but no conversion % given.
- ARPU (cloud paid): $500–$2,000/month - rationale: "flat pricing" model, developer-tool comps (Segment, Amplitude SMB tier), no pricing disclosed.
- Enterprise ACV: $20,000–$100,000/year - rationale: enterprise self-host with permissioning/scalability support, consistent with dev-tools enterprise pricing; no figures in deck.
- M1 retention (free): 50% for core persona, 33% for others. Blended ~40% assumed for modeling.
- Paid churn (monthly): 2–3% gross - rationale: strong testimonials, "can't survive without PostHog" quotes; early-stage so some involuntary churn expected.
- CAC (community/inbound): near-zero for self-serve; $5,000–$15,000 for enterprise sales-assisted - rationale: <$25K total marketing to date for thousands of deployments.
- Gross margin: 70–80% - rationale: cloud hosting + support costs offset by high software margins; self-host has near-zero COGS.
- Headcount growth: seed-stage team, 10–20 people at deck date; scale in engineering and growth engineering per roadmap focus 2021.
- Scenarios (Base / Bull / Bear - which variables flex):
- Base: 15% MoM deployment growth, 3% free-to-paid conversion, $800 ARPU, 2.5% monthly paid churn.
- Bull: 25% MoM deployment growth, 6% conversion, $1,200 ARPU, 1.5% churn - driven by accelerating ClickHouse-enabled inbound and enterprise deals.
- Bear: 8% MoM deployment growth, 1.5% conversion, $500 ARPU, 4% churn - community plateaus, enterprise sales cycle longer than expected.
- Required sheets / outputs:
- Assumptions dashboard (all drivers in one place, color-coded)
- Deployment funnel (free installs → active → paid cloud → enterprise)
- ARR bridge (new, expansion, churn, net new ARR by month)
- P&L (revenue, COGS, gross profit, S&M, R&D, G&A, EBITDA)
- Headcount plan (by department)
- Cash / runway (burn rate, months runway)
- KPI summary (deployments, DAU/MAU, conversion rate, NRR, CAC, LTV, LTV:CAC)
Frequently asked
Is the Posthog financial model free?+
Yes. The Posthog model is a free Excel (.xlsx) download with live formulas. Sign up with your email and the workbook is yours to keep, review, and edit.
What's included in the model?+
A 5-year monthly forecast with P&L, cash flow and runway, valuation (exit multiple plus a DCF cross-check), MOIC/IRR returns, and unit economics, with live formulas throughout.
How was this model built?+
It was built from Posthog's pitch deck and publicly available information, then structured to investment-banking standards as a fully editable Excel model.
Can I change the assumptions?+
Yes. You can change assumptions and the live formulas will recalculate in the downloadable Excel model.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Dev Tools Startup Financial Models
Browse another startup in the same category.
8base
Low-code/no-code platform providing backend and frontend development tools for building digital products, internal apps, and SaaS.
Ably
Enterprise realtime messaging infrastructure (pub/sub) delivered as a cloud-native platform, enabling developers to build scalable live experiences without managing complex realtime infrastructure.
Amplitude
Mobile analytics SaaS platform giving app developers real-time behavioral analytics, funnel/retention analysis, and raw data warehouse access at scale.
Anima
Automated design-to-code platform - designers export production-ready code from their design tools with one click.
Apollo
Apollo builds and sells an enterprise "data graph" platform (powered by GraphQL) that sits as a unified API layer between frontend apps and backend microservices.
BrowserStack
Cloud-based cross-browser and mobile app testing platform used by 50,000+ customers across 135 countries.
CodeSandbox
Cloud-native collaborative web IDE that lets entire product teams (not just developers) code, review, and iterate together in the browser.
CommandBar
SaaS SDK that embeds a search-based command bar into web apps, improving UX, onboarding, and retention for B2B software companies.
