Muck Rack logo
Muck Rack Financial Model

Media/Gaming Startup Financials (Free Excel Download)

B2B SaaS platform for Public Relations Management (PRM) - media database, outreach, monitoring, and measurement in one integrated tool.

Free, no credit card required
Edit in Excel
Created by ex-finance
professionals from Deloitte
Loading...

Used by professionals from

About this model

Muck Rack is a public-relations management platform combining a media database, journalist outreach, monitoring, and measurement. Its continuously updated public journalist and creator profiles form a first-party data asset, while the integrated workflow connects discovery, outreach, monitoring, and reporting for PR teams.

The product serves in-house corporate communications teams and agencies, with an annual recurring subscription inferred from the enterprise SaaS positioning and expansion of existing accounts. The deck does not disclose pricing, ACV, seats, or revenue, but cites a qualitative claim of top-decile gross and net retention.

Thousands of brands and agencies reportedly rely on Muck Rack, including Spotify, Pfizer, Uber, Samsung, Golin, Headspace, PepsiCo, and FedEx. A model should build separate brand and agency ARR waterfalls, using new logos, seat or module expansion, churn, data and research costs, sales expense, and deferred revenue.

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 Muck Rack

muckrack.com
Read the pitch deck
Muck Rack pitch deck cover
View on makeslides.com
Total raised
$180.0M
Funding round
Series A
Founded
2022
Category
Media/Gaming
Customer
B2B
Geography
Not in deck. Client logos

How to build a detailed financial model for Muck Rack

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

Product & value proposition

Muck Rack is an integrated PRM platform - coined "PR Management" as a new software category (analogous to CRM / Salesforce). Core modules:

  • Media database: discover journalists, podcasters, newsletter writers, broadcasters.
  • Outreach: send personalised pitches and manage campaigns.
  • Media monitoring: automatic coverage tracking across digital, broadcast, print, podcasts, newsletters, social.
  • Measurement: dashboards, coverage reports, performance newsletters.
  • Collaboration: team activity tracking, single-source-of-truth system of record.
  • Journalist-side network: free auto-updating public profiles for journalists/creators (data flywheel / proprietary data moat).

Key differentiators vs. legacy incumbents:

  • First-party, proprietary journalist network (not scraped data).
  • Full-platform integration connecting discovery → outreach → monitoring → measurement in one workflow.
  • "Top decile gross and net retention" (qualitative claim; no number given).

Market

  • Earned media described as the "leading marketing strategy".
  • 90% of people believe authenticity is important; user-generated/earned content is most trusted.
  • Digital paid advertising is least trusted form of content.
  • "Category defining software has yet to emerge within PR landscape" - implying a greenfield market capture opportunity.

Revenue model

Not explicitly stated in deck. Based on product positioning:

  • Annual recurring subscription (SaaS ARR), likely per-seat or per-team/account model. Rationale: enterprise B2B SaaS with named accounts (Pfizer, Samsung, FedEx); PR software incumbents all use subscription; "expanding existing accounts" growth vector implies upsell/expansion revenue.
  • Two customer segments: (1) in-house corporate PR teams (brands), (2) PR agencies. Both confirmed by slide 7 logo mix (Golin, MSL = agencies; Spotify, Pfizer = brands).
  • No pricing tiers, ACV, or seat counts disclosed.

Traction & metrics

  • "Thousands of Brands and Agencies rely on Muck Rack" - no precise customer count.
  • Notable named logos: Spotify, Pfizer, Uber, Samsung, Golin, Headspace, Yelp, NBC Universal, Penguin Random House, PepsiCo, Duolingo, Reddit, Etsy, MSL, UNICEF, FedEx, VISA, American Airlines.
  • "Top decile gross and net retention" - no numerical values given.
  • No ARR, revenue growth, or churn figures disclosed.

Competition / moat

Competitors referenced only by implication:

  • "Legacy PR software incumbents fail to deliver a seamless, integrated experience" (Cision, Meltwater, PR Newswire implied but not named).
  • Moat sources:
  1. Proprietary journalist professional network - industry's first and only; creates a data flywheel unavailable to competitors.
  2. Full-platform integration (vs. point solutions) - workflow lock-in.
  3. Top-decile retention - high switching costs once embedded as system of record.
  4. Multiple growth vectors: market share capture from legacy vendors, account expansion, new geographies.

Team & funding ask / use of funds

Recommended financial model

  • Archetype + why: SaaS ARR model with two customer segments (brands vs. agencies). Muck Rack is a pure B2B SaaS subscription business with team/seat-based pricing, enterprise logos, and expansion revenue as a stated growth vector. Standard SaaS ARR waterfall (new ARR + expansion - contraction - churn) is the appropriate archetype.
  • Forecast horizon & granularity: 5-year annual model (Year 1–5), with Year 1 broken into monthly detail for cash flow / runway purposes.
  • Key drivers & assumptions:
DriverValueSource
Starting customer count-Mid-point of "thousands" claim
Segment split: brands vs. agencies60% brands / 40% agencieslogo mix on slide 7
Average ACV - brands$20,000–$40,000/yrenterprise B2B SaaS comps for PR software; Cision/Meltwater pricing benchmarks
Average ACV - agencies$10,000–$20,000/yragencies tend to have smaller seat footprints
Gross revenue retention (GRR)88–92%"top decile" claim; top-decile B2B SaaS GRR is ~90%+
Net revenue retention (NRR)110–120%top-decile NRR; expansion from seat add-ons and module upsells
New logo growth rate25–35% YoYearly-growth SaaS capturing fragmented legacy market
Gross margin75–80%SaaS-typical; data/research team as partial COGS
S&M as % of revenue35–45%growth-stage B2B SaaS; account-based selling to enterprise
R&D as % of revenue20–25%platform-building phase; journalist network maintenance
G&A as % of revenue10–12%standard
  • Scenarios (Base / Bull / Bear - which variables flex):
  • Base: NRR = 115%, new logo growth = 30%, GRR = 90%.
  • Bull: NRR = 125% (strong upsell), new logo growth = 40%, ACV expansion as new modules launch.
  • Bear: NRR = 105%, new logo growth = 15% (sales cycle elongates), legacy vendors respond competitively.
  • Primary flex variables: new logo growth, NRR, and ACV (pricing power).
  • Required sheets / outputs:
  1. Assumptions - all drivers with toggle cells.
  2. ARR Waterfall - beginning ARR + new + expansion − contraction − churn = ending ARR; split by segment (brands / agencies).
  3. Income Statement - revenue (ARR recognized on straight-line), COGS, gross profit, S&M, R&D, G&A, EBITDA, Net Income.
  4. Cash Flow - operating CF, CapEx (minimal for SaaS), free cash flow; monthly in Year 1.
  5. Balance Sheet - simplified; accounts receivable, deferred revenue, cash.
  6. Scenario toggle - Base / Bull / Bear switcher feeding all outputs.
  7. Dashboard - ARR growth chart, NRR trend, logo count, EBITDA margin walk.

Frequently asked

Is the Muck Rack financial model free?+

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

Go further

Build the financial model you need with Fina AI

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.

Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview
Career Principles

Learn Financial Modelling Skills with industry-leading Career Principles

Breaking into the finance industry? Explore courses in Excel, financial modeling, valuation, data analytics, and AI for business and finance.

Career Principles lesson on preparing a cash flow statement in Excel
Career Principles Financial Analyst Program
Career Principles Python for Data Analysis
Career Principles AI for Business and Finance course