Ardoq logo
Ardoq Financial Model

Enterprise/Security Startup Financials (Free Excel Download)

Cloud-native Enterprise Architecture (EA) SaaS platform that helps large enterprises navigate digital transformation through automated data collection, graph-based architecture modelling, and change impact analysis.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

Ardoq is a cloud-native enterprise architecture platform built around an intelligence graph. It helps IT and business leaders collect architecture data, map dependencies, rationalise application portfolios, and understand the impact of technology change.

The company lands with an operational use case such as application portfolio optimisation and expands across projects, business units, and strategic planning. Its deck reported $11.1 million of ARR at Q3 2021, 83% gross margin, and growth in North America and the UK.

The financial model uses quarterly cohort logic for new ARR, expansion ARR, churn, and ending ARR. Sales hiring and deal conversion determine new logos, while adoption of additional modules and use cases drives expansion; gross margin, operating costs, and cash runway complete the forecast.

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 Ardoq

ardoq.com
Read the pitch deck
Ardoq pitch deck cover
View on makeslides.com
Total raised
$125.0M
Funding round
Series D
Founded
2022
Category
Enterprise/Security
Customer
B2B
Geography
Global. Nordic 37%

How to build a detailed financial model for Ardoq

A complete walkthrough of the business, drivers, and assumptions behind the downloadable Ardoq model - distilled from its pitch deck and publicly available information.

Product & value proposition

  • SaaS platform built on a graph database ("Ardoq Intelligence Graph") for Enterprise Architecture management.
  • Core use case: Application Portfolio Optimisation - reduces time to identify rationalisation candidates from ~5 months (traditional consultants + Excel) to ~3 weeks.
  • Claimed customer value: mid-sized company saves ~$0.5–1M annually in application portfolio cost + ~$400K from a more efficient analysis process.
  • Quote from Fortune 100 Cable & Entertainment customer: "We could save over $10M in the first year through rationalisation. Easily.".
  • Modular add-ons: Insights Generator, Engagement Platform, Scenarios, plus partner-built use-case packs.
  • Integrations: AWS, ServiceNow, Docker, Zapier, REST API, Azure.
  • Land-and-expand journey: Operational (Application Portfolio Optimisation) → Tactical (change project execution, Functional Gap Analysis) → Strategic (Digitalisation Roadmaps, CxO engagement).

Market

  • "New" EA market (companies kick-starting EA practice): >$2B.
  • "Legacy" EA market (companies replacing legacy tools): $300M–$500M.
  • Market CAGR: 10–12% from 2020 to 2025 (source: Gartner, growth of overall Enterprise Software category).
  • Adjacent markets cited (not directly addressable, illustrative of ecosystem): Enterprise Governance, Risk & Compliance ~$36B; Master Data Management Software ~$1.5B; Cyber Security and Risk Management ~$150B.

Revenue model

  • ARR-based SaaS subscription. Pricing tiers/per-seat pricing not disclosed in deck.
  • Land-and-expand: initial land typically via Application Portfolio Optimisation use case, then expand across business units and use cases.
  • Partner channel exists (deals through partner channel excluded from ARR chart footnote).
  • Direct sales motion implied by blue-chip enterprise customer base; no self-serve or PLG signals in deck.

Traction & metrics

All figures as of Q3 2021 unless noted.

  • ARR: $11.1M as of Q3 2021.
  • ARR Q3 2020: $6.1M (implied from +82% YoY and +$5.0M absolute add).
  • ARR Q3 2019: $3.8M (implied from +59% YoY and +$2.3M absolute add).
  • ARR Growth YoY (Q3 21): 82%.
  • ARR Growth YoY (Q3 20 vs Q3 19): 59%.
  • ARR history: quarterly ARR bar chart runs from Q3 2016 to Q3 2021, showing consistent growth trajectory.
  • North America ARR growth LTM: 102%.
  • UK ARR growth LTM: 172%.
  • Gross margin YTD (2021): 83%.
  • LTV/CAC: 5.5x.
  • Gartner Peer Insights rating: 4.6 stars, 85 reviews (all-time, as of deck date).
  • Gartner Peer Insights Customers' Choice 2021.
  • Positioned in Gartner Magic Quadrant for Enterprise Architecture Tools (November 2021) and Forrester Wave: Enterprise Architecture Management Suites (March 2021) as a Strong Performer/Visionary.

Unit economics

  • LTV/CAC: 5.5x.
  • Gross margin: 83% YTD 2021.

Competition / moat

  • Fragmented market: legacy players (MEGA International, Software AG, BIZZdesign, Orbus Software, QualiWare, Planview) founded in 1990s–2000s vs. digital-native platforms (LeanIX, Capsifi, Ardoq) founded 2010s.
  • Ardoq positioned as "Visionary" in Gartner MQ and in Forrester Wave "Strong Performers" quadrant.
  • Gartner Peer Insights Customers' Choice 2021 - differentiates on customer satisfaction vs. larger legacy incumbents.
  • Stated key differentiator: graph database-native platform ("ultra-flexible"), automated data collection, add-on module architecture.
  • Thesis: "New leaders will be digital-native platforms with a SaaS business model and data-driven approach".
  • Main named competitors: LeanIX, BIZZdesign, Software AG, MEGA International, Orbus Software, Planview, Avolution, BOC Group, erwin by Quest, QualiWare, ValueBlue, Capsifi.

Team & funding ask / use of funds

  • CEO/Co-Founder: Erik Bakstad.

Recommended financial model

  • Archetype + why: SaaS ARR model with quarterly granularity and land-and-expand cohort logic. Ardoq is a pure-play B2B SaaS business with ARR as the primary KPI, a clear land-and-expand motion across use cases, high gross margins (83%), and a disclosed LTV/CAC ratio. A cohort-based ARR waterfall (new ARR, expansion ARR, churn ARR → net new ARR → ending ARR) is the right frame. Revenue = ARR / 4 per quarter (or build monthly ARR and sum). Gross profit flows directly from gross margin assumption.
  • Forecast horizon & granularity: 5 years (2021A–2026E), quarterly for years 1–2, annual for years 3–5. Use Q3 2021 ($11.1M ARR) as the anchor.
  • Key drivers & assumptions:
  • Starting ARR: $11.1M as of Q3 2021
  • ARR Growth YoY (base): 82% in Q3 2021; trajectory decelerating - 59% in Q3 2020, 82% in Q3 2021 (re-acceleration noted in deck). Base case applies gradual deceleration: ~70% Y1 → 55% Y2 → 40% Y3 → 30% Y4 → 22% Y5, consistent with comparable high-growth enterprise SaaS at this scale.
  • Gross margin: 83% YTD 2021; stable at 82–84% as scale offsets inflationary CoGS pressure.
  • LTV/CAC: 5.5x; used to back-solve implied CAC payback and S&M spend calibration.
  • Logo churn: ~5% gross logo churn annually - enterprise EA tools are sticky once embedded.
  • S&M % of revenue: ~50–60% in near term (growth-mode), declining toward 35–40% at scale - typical for enterprise SaaS at this ARR level.
  • R&D % of revenue: ~25–30%, consistent with platform-centric SaaS.
  • G&A % of revenue: ~15–20% at current scale, declining to ~10% at maturity.
  • Geographic mix: Nordic 37%, Europe 27%, USA 25%, RoW 11%; USA + UK growing fastest (102% / 172% LTM ARR growth) - USA share expands to ~40% by Y5 as GTM investment follows growth.
  • Partner channel: Present but excluded from ARR chart; model direct channel only unless partner ARR data becomes available.
  • Scenarios (Base / Bull / Bear - which variables flex):
  • Bull: NRR 125%, ARR growth stays above 70% for 2 years, USA expansion succeeds, gross margin improves to 85%+ with scale.
  • Base: NRR 117%, ARR growth decelerates per schedule above, gross margin stable at 83%.
  • Bear: NRR 105% (expansion stalls), ARR growth drops to ~40% in Y1 (macro/competition), gross margin compresses to 78% on sales team build-out.
  • Required sheets / outputs:
  1. Assumptions - all drivers, scenario toggles
  2. ARR Waterfall - beginning ARR, new logo ARR, expansion ARR, churn ARR, ending ARR (quarterly Y1–Y2, annual Y3–Y5)
  3. P&L - Revenue, COGS, Gross Profit, S&M, R&D, G&A, EBITDA, EBIT, Net Income
  4. Cash Flow (simplified) - EBITDA → capex → working capital → cash burn / runway
  5. Unit Economics - LTV/CAC bridge, CAC payback, implied cohort-level economics
  6. Geography Mix - ARR by region (Nordic, Europe, USA, RoW) to model regional growth differentials
  7. KPI Summary / Dashboard - ARR, growth rate, gross margin, LTV/CAC, NRR, Rule of 40, cash burn

Frequently asked

Is the Ardoq financial model free?+

Yes. The Ardoq 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 Ardoq'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

Alex Tapio, ex-Deloitte financial modelling expert

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 Enterprise/Security Startup Financial Models

Browse another startup in the same category.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview