Citylitics Financial Model
Hardware/Deep-tech Startup Financials (Free Excel Download)
B2B SaaS intelligence platform that aggregates and curates public-sector infrastructure procurement data for private-sector vendors, suppliers, and consultants.
professionals from Deloitte
Used by professionals from
About this model
Citylitics provides B2B intelligence on public-sector infrastructure procurement for vendors and consultants. It aggregates and curates opportunity data so companies selling into infrastructure markets can identify relevant projects and make better sales, market-entry, and account-prioritisation decisions.
The product is a data business sold to organisations with complex enterprise sales motions, not a public procurement marketplace taking a transaction fee. Its value depends on the breadth, freshness, and usefulness of the underlying opportunity dataset, while seats and product access can expand across commercial teams.
Model enterprise subscribers, seats, average contract value, data products, implementation, expansion, renewals, and churn. Include data acquisition, research, quality control, delivery infrastructure, customer success, and sales costs. New-logo growth, seat expansion, data coverage, pricing, net retention, and sales-cycle length should drive scenarios.
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 Citylitics
citylitics.com
How to build a detailed financial model for Citylitics
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Citylitics model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Proprietary web crawler aggregates millions of public documents from 30,000+ city, utility, and public agency websites every 2 weeks.
- ML classifies and stores fragmented documents in a data warehouse; NLP extracts relevant content.
- Output delivered via an "intuitive UX" - customers browse, action, and rate intelligence; ratings feed back into a personalisation model (described via Netflix analogy).
- Roadmap layers: Data Foundation → Intelligence Platform → Integrated Insights → Infrastructure Marketplace (cities and solution providers connect online).
- Value prop to buyers: early-stage pre-positioning before RFP, precision targeting of sales efforts, real-time market direction vs. stale legacy data providers.
Market
- Global infrastructure spend: $5.7T per year.
- US infrastructure industry size: $2.1T.
- Comp platform revenue benchmarks cited as aspirational ceiling:
- Bloomberg (Finance / $20T market): $10B/yr revenue
- S&P Capital IQ (PE / $4.6T market): $7.4B/yr revenue
- CoStar Group (Real Estate / $2.7T market): $1.4B/yr revenue
- ZoomInfo (B2B Sales / $1.6T market): $0.5B/yr revenue
- No explicit SAM or SOM figure given; no CAGR cited.
- Government stimulus tailwind: "Trillions of dollars in infrastructure investments planned in 2022 and beyond".
Revenue model
- Implied B2B SaaS subscription (data/intelligence platform sold to infrastructure vendors); pricing, tiers, contract length not disclosed in deck.
- Customers are private-sector firms: manufacturers, suppliers, engineering, construction, and consulting companies.
- No transactional, marketplace, or per-seat pricing details provided.
- Future roadmap includes an Infrastructure Marketplace (connecting cities with solution providers), which could add a transaction/listing revenue layer.
Traction & metrics
- Large named customer base shown: 40+ logos including ABB, Jacobs, McKinsey & Company, Tetra Tech, Xylem, DuPont, Suez, Atlas Copco, GHD, and others.
- "Growth trajectory is accelerating every quarter" - no specific ARR, MRR, revenue, or customer count figures disclosed.
- No revenue numbers, growth percentages, NRR, churn, or headcount metrics provided in deck.
Competition / moat
- Legacy data providers described as delivering "stale, outdated, inaccurate data".
- Moat framed as: (1) proprietary crawler covering 30,000+ public agency sites; (2) ML/NLP categorisation pipeline; (3) user-rating feedback loop creating a personalised intelligence model that improves with use (data network effect, Netflix analogy).
- Competitive positioning: positioned as the "Bloomberg/CoStar/ZoomInfo equivalent" for infrastructure - category-defining data platform with no direct incumbent named.
Team & funding ask / use of funds
Recommended financial model
- Archetype + why: B2B SaaS ARR model. Revenue is subscription-based (intelligence platform sold to corporate buyers); the relevant KPIs are ARR, logo count, ACV, NRR, and gross margin. The comp set (Bloomberg, CoStar, ZoomInfo) all operate as data subscription businesses.
- Forecast horizon & granularity: 5 years (2022–2026), quarterly for Year 1–2, annual thereafter. Early quarters matter for burn/runway visibility.
- Key drivers & assumptions:
| Driver | Value | Source |
|---|---|---|
| Starting ARR | Unknown | - |
| Starting logo count | ~40+ visible on deck | (exact paying customer count not given) |
| Average contract value (ACV) | $25k–$50k/yr; typical for mid-market B2B data/intelligence products at this stage | - |
| ARR growth rate | 80–120% YoY in early years, decelerating to 40% by Year 5; consistent with early-stage SaaS data co's pre-Series B | - |
| Net revenue retention (NRR) | 110–120%; data platforms with embedded feedback loops typically see expansion | - |
| Gross margin | 70–75%; data/SaaS mix - crawler infrastructure and analyst headcount create modest COGS vs. pure SaaS | - |
| S&M % of revenue | 50–60% in early years, declining as brand/word-of-mouth builds | - |
| R&D % of revenue | 25–30%; ML/NLP pipeline ongoing investment | - |
| G&A % of revenue | 15% early, declining to 10% at scale | - |
| Headcount growth | tied to ARR per FTE benchmarks (~$150–200k ARR/FTE at seed/Series A) | - |
- Scenarios (Base / Bull / Bear - which variables flex):
- Bear: ARR growth 50% YoY; NRR 100%; ACV pressure from competition; slower marketplace launch.
- Base: ARR growth 90% YoY Years 1–2, decelerating; NRR 115%; ACV at midpoint; marketplace revenue begins Year 4.
- Bull: ARR growth 130%+ YoY early; NRR 125%; rapid ACV expansion into enterprise; government stimulus drives accelerated demand.
- Required sheets / outputs:
- Assumptions dashboard (all drivers in one place, scenario toggles)
- ARR bridge (new logo ARR, expansion ARR, churn ARR, net new ARR)
- Income statement (Revenue, COGS, Gross Profit, S&M, R&D, G&A, EBITDA, Net Income)
- Headcount plan by function
- Cash flow & runway (given pre-profitability stage)
- SaaS KPI summary (ARR, MRR, logo count, ACV, NRR, LTV/CAC, payback period)
- Comp benchmarking tab (Bloomberg, CoStar, ZoomInfo, S&P CIQ revenue multiples vs. industry size for sanity-check on long-run TAM capture)
Frequently asked
Is the Citylitics financial model free?+
Yes. The Citylitics 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 Citylitics'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 Hardware/Deep-tech Startup Financial Models
Browse another startup in the same category.
ANYbotics
ANYbotics builds and sells autonomous legged inspection robots (ANYmal) for industrial facilities, targeting oil & gas, chemicals, power, offshore, mining, and manufacturing sectors.
Awake Security
Awake Security - AI-driven Network Detection & Response (NDR) platform for the hybrid cloud, positioning as the "intent detection" layer of the SOC visibility triad.
Beem
AR communications platform that overlays full-body "hologram" video of a person into the recipient's physical space via smartphone or web.
Blue White Robotics
Autonomous robotics platform converting existing farm equipment to self-driving tractors for permanent-crop growers, sold as Robots-as-a-Service.
Cambridge GaN Devices
Fabless semiconductor startup commercialising self-protected GaN power transistors (HiGaN) that replace silicon and standard GaN with higher efficiency and no external protection circuitry.
Canix
Cannabis-focused ERP (inventory tracking, compliance automation, sales management, yield forecasting) sold as SaaS to cannabis cultivators, manufacturers, and distributors.
Chobani
Chobani is the US market leader in Greek yogurt; TPG invested $671M in April 2014 for a 35% stake via a structured second lien + equity deal
Cipher Skin
Wearable sensor mesh platform that collects dense multi-modal data from human bodies and industrial objects to predict structural and functional failure before it occurs.
