Financial Models Blog

SaaS Financial Model Template - MRR, Churn & Unit Economic

tamir Financial Models Blog
SaaS Financial Model Template: MRR, Churn & Unit Economics Guide (2025)
Technology / SaaS Free Template Available Ph.D. Validated · 2026

SaaS Financial Model Template:
MRR, Churn & Unit Economics

The complete guide to building an investor-ready SaaS financial model — covering MRR waterfall, cohort churn, CAC/LTV analysis, and the Rule of 40. Built on 30 years of institutional finance experience.

Download Free SaaS Template Browse 100+ Models →
MRRCore Revenue Metric
CACCost to Acquire Customer
LTVLifetime Value
NRRNet Revenue Retention
R40Rule of 40

A SaaS financial model is fundamentally different from a traditional business model — and most generic Excel templates fail to capture that. Recurring revenue, cohort churn, expansion MRR, and unit economics require a dedicated architecture. This guide walks through every layer of a professional SaaS model, and links to a free institutional-grade template you can use immediately.

Why SaaS Modeling Is Different

Traditional businesses recognize revenue when they deliver a product. SaaS businesses earn revenue incrementally over a subscription period — which means the P&L alone tells an incomplete story. A SaaS company can be growing rapidly while appearing unprofitable, or generating excellent unit economics while reporting negative EBITDA due to upfront customer acquisition spend.

This disconnect between accounting reality and economic reality is why SaaS investors developed their own vocabulary and analytical framework. Understanding Annual Recurring Revenue (ARR), Monthly Recurring Revenue (MRR), cohort retention, and contribution margin requires a model specifically designed to surface these dynamics.

⚠️ Common mistake: Modeling SaaS revenue as a single "subscription revenue" line on the P&L. This collapses the MRR waterfall into a black box, making it impossible to understand the underlying drivers of growth — or to identify churn early enough to act on it.

The MRR Waterfall: The Foundation of Every SaaS Model

The MRR waterfall is the single most important structural element in a SaaS financial model. It decomposes month-over-month MRR change into five distinct components, each of which requires a separate driver and assumption set:

MRR Waterfall — Illustrative Example (Month-over-Month)
Beginning MRR
$360k
+ New Business
+$42k
+ Expansion MRR
+$24k
− Contraction MRR
−$9k
− Churned MRR
−$15k
= Ending MRR
$402k

A properly built SaaS template models each of these five components independently. New Business MRR is driven by your sales funnel (leads → trials → conversions × ACV). Expansion MRR is driven by upsell and cross-sell assumptions per cohort. Churned and Contraction MRR are driven by your gross and net retention rate assumptions.

Churn Modeling: Gross vs. Net Revenue Retention

Churn is the defining variable in any SaaS model — the lever that most dramatically separates great businesses from good ones. But "churn" is not a single number. A professional model distinguishes between:

MetricDefinitionFormulaBest-in-Class
Gross Revenue Retention (GRR) Revenue retained from existing customers, excluding expansion (Beginning MRR − Churn − Contraction) / Beginning MRR > 90%
Net Revenue Retention (NRR) Revenue retained including expansion from existing customers (Beginning MRR − Churn + Expansion) / Beginning MRR > 120%
Logo Churn Rate % of customers lost in a period Churned Customers / Beginning Customers < 5% annual
Quick Ratio Growth efficiency: new + expansion vs. churn (New MRR + Expansion MRR) / (Churned + Contraction MRR) > 4×

✅ NRR > 100% is the single most important indicator of SaaS business quality. It means the existing customer base is growing on its own — even without acquiring a single new customer. Businesses with NRR above 120% can afford to temporarily pause new customer acquisition and still grow.

Cohort-Based Churn Modeling

Sophisticated SaaS models use cohort analysis rather than a single blended churn rate. Each cohort (a group of customers acquired in the same month or quarter) is tracked separately through time, revealing whether churn is improving, worsening, or stable across different customer segments. This granularity is essential for identifying product-market fit issues before they compound into existential churn problems.

Unit Economics: CAC, LTV, and the Payback Period

Unit economics answer the question every SaaS investor asks first: "Do you make more from a customer than you spend to acquire them — and how long does it take?"

Core SaaS Unit Economics Formulas
CAC = Total Sales & Marketing Spend / New Customers Acquired
// Tip: use lagged spend (e.g. prior quarter's S&M) for more accurate attribution

LTV = ARPU × Gross Margin % / Monthly Churn Rate
// Or: Average Contract Value / Logo Churn Rate (annual)

LTV:CAC Ratio = LTV / CAC
// Target: > 3× for sustainable growth

CAC Payback Period = CAC / (ARPU × Gross Margin %)
// Target: < 12 months (best-in-class < 6 months)

SaaS Benchmark Reference: Unit Economics

> 3×
LTV:CAC Ratio
✓ Investable threshold
< 12mo
CAC Payback
✓ Capital efficient
70–80%
Gross Margin
✓ Infrastructure SaaS
> 120%
Net Revenue Retention
✓ Elite tier

The Rule of 40: Balancing Growth and Profitability

The Rule of 40 is the most widely used heuristic for assessing SaaS business health among growth-stage investors. It states that a healthy SaaS company's revenue growth rate plus EBITDA margin should sum to at least 40%.

Rule of 40 Formula
Rule of 40 Score = YoY Revenue Growth Rate (%) + EBITDA Margin (%)

Example A: 60% growth + (−20%) margin = 40 ✓ Passes
Example B: 25% growth + 20% margin = 45 ✓ Passes
Example C: 30% growth + (−15%) margin = 15 ✗ Fails

Importantly, the Rule of 40 is a balance — not a requirement that any one component be positive. Early-stage SaaS companies are expected to burn cash to acquire customers; what matters is that the growth rate earned by that burn is proportionate. A company growing at 80% with a −40% EBITDA margin scores 40 and still passes. A company growing at 15% with a −10% margin scores 5 and is burning capital inefficiently.

How to Structure a Professional SaaS Financial Model

A SaaS model should be modular, with clearly separated sheets for each functional area. Here is the architecture used in institutional-grade templates:

  1. Assumptions Dashboard

    All inputs in one place: pricing tiers, ACV, logo churn by cohort, gross margin, headcount plan, S&M efficiency ratios. Every number the model uses flows from here.

  2. MRR / ARR Waterfall Engine

    Month-by-month decomposition of Beginning MRR → New → Expansion → Contraction → Churn → Ending MRR. This is the heart of the model and should calculate automatically from Assumptions.

  3. Cohort Analysis Sheet

    Track each quarterly cohort of customers from acquisition through retention decay. Feeds NRR and LTV calculations. Essential for demonstrating product retention to investors.

  4. P&L (GAAP basis)

    Revenue (recognized per GAAP, not MRR), COGS, Gross Profit, S&M, R&D, G&A, EBITDA, Net Income. Deferred revenue schedule included to bridge MRR to recognized revenue.

  5. Unit Economics Module

    CAC, LTV, LTV:CAC, CAC Payback, Quick Ratio, NRR — all calculated dynamically from the Waterfall and P&L. Includes time-series charts showing improvement trajectory.

  6. Cash Flow & Runway

    Operating cash flow, capex, net burn rate, cash balance, and months of runway at current burn. Critical for fundraising conversations — investors always ask "when do you run out of cash?"

  7. Scenario & Sensitivity Analysis

    Base / Bull / Bear toggles with pre-loaded assumptions. Two-way sensitivity tables for ARR growth vs. churn rate, and for EBITDA margin vs. S&M efficiency. Rule of 40 score tracks across all scenarios.

SaaS Valuation: Revenue Multiples vs. DCF

SaaS companies are most commonly valued on a revenue multiple basis (EV/ARR or EV/NTM Revenue), with the multiple determined primarily by NRR and growth rate. However, as SaaS companies mature and move toward profitability, DCF analysis becomes increasingly relevant and accurate.

NRRGrowth RateTypical EV/ARR MultipleQuality Signal
> 130%> 60% 15–30× Elite — IPO-ready
110–130%30–60% 8–15× Series B/C quality
100–110%20–30% 4–8× Series A/B — improving
< 100%< 20% < 4× Structural concerns

📊 Our SaaS model template at financialmodels.net includes a built-in valuation module that calculates implied EV/ARR multiples across scenarios, alongside a DCF section for later-stage analysis. Download the free Explorer tier →

Frequently Asked Questions

What is the difference between MRR and ARR?
MRR (Monthly Recurring Revenue) is the normalized monthly value of all active subscriptions. ARR (Annual Recurring Revenue) is simply MRR × 12. ARR is used in investor conversations and valuation multiples because it annualizes the recurring revenue base and removes seasonality. MRR is used operationally because it shows month-over-month movement and lets you spot churn signals quickly.
Should I use GAAP revenue or ARR in my financial model?
Both, in different parts of the model. Your MRR/ARR waterfall operates on a billings/bookings basis and captures the true economic momentum of the business. Your GAAP P&L recognizes revenue ratably over the subscription period and is what auditors and public markets require. A professional SaaS template includes a deferred revenue schedule that reconciles the two.
What churn rate should I use in my SaaS financial model?
Use your actual historical churn rate as the base case, and build scenarios around it. If you're pre-revenue, benchmark against comparable public SaaS companies: enterprise SaaS typically sees 5–10% annual logo churn; SMB SaaS sees 15–25%. Never use a single blended rate — model churn separately by customer segment, as enterprise and SMB cohorts behave very differently.
How do I model a freemium SaaS business?
Freemium requires an additional layer in the funnel: free users → converted-to-paid users. Model this as a conversion rate applied to your free user base, which is itself driven by organic and paid acquisition. The cost of serving free users (infrastructure, support) should appear in COGS, reducing gross margin. Freemium models often show a J-curve — high early CAC that normalizes as the free-to-paid conversion engine matures.
How many months of forecast should a SaaS model include?
For fundraising purposes, investors typically want to see a 36-month operating model (monthly detail) and a 5-year strategic plan (annual). The 36-month model should be driver-based and highly granular; the 5-year plan can use simplified growth and margin assumptions. Our SaaS template supports both with a toggle between monthly and annual views.

Medical Clinic Financial Model Excel Template: Complete Guide for Physicians & Investors

tamir Financial Models Blog
Medical Clinic Financial Model Excel Template: Complete Guide for Physicians & Investors
🏥
Healthcare · Private Practice · Specialty Clinic

Medical Clinic Financial Model
Excel Template:
The Physician's Complete Guide

From patient volume projections to payer mix analysis — the exact financial framework banks, PE investors, and DSO buyers require before writing a check.

✍️ Tamir Levy, Ph.D. 📅 May 2026 ⏱ 14 min read 📊 Free Template Included
Download Free Template Browse Healthcare Models →
Benchmark Snapshot — Private Medical Practice
EBITDA Margin (Primary Care)15–25%
EBITDA Margin (Specialty)25–40%
Avg Revenue per Visit$150–$350
Net Collection Rate55–80%
Overhead Ratio55–65%
Physician Comp % Revenue25–40%
Typical EV/EBITDA Multiple5–12×
Home › Blog › Healthcare Models › Medical Clinic Financial Model Excel Template

A physician who can diagnose complex conditions but cannot build a financial model walks into every negotiation — with a bank, a PE investor, or a hospital buyer — at a structural disadvantage. This guide builds the financial architecture of a medical practice from first principles: patient volume, payer mix, revenue cycle, staffing, break-even, and the valuation metrics that determine what your clinic is actually worth.

Why Healthcare Financial Modeling Is Uniquely Complex

A medical clinic generates revenue through a system that no other industry shares: services are provided, billed at gross charges, then collected at negotiated rates that vary by payer — and that rate is almost never the number on the invoice. This gap between gross charges and net collected revenue is the defining feature of healthcare finance, and it requires a modeling architecture that most generic financial templates completely ignore.

The result is that two clinics with identical patient volumes and procedure mix can have dramatically different revenue — depending entirely on their payer mix. A practice serving primarily commercial insurance patients may collect 72% of gross charges. The same practice serving Medicaid patients may collect 38%. This single variable — payer mix — is the most important driver in any healthcare financial model.

🏥 Healthcare finance vocabulary: Understanding the difference between gross charges, contractual adjustments, net revenue, net collection rate, and days in AR is the prerequisite for any healthcare model. These terms are not interchangeable — conflating them is the most common and most costly error in clinic financial planning.

Step 1 — Payer Mix: The Most Important Assumption in Your Model

Before projecting a single dollar of revenue, your model must define the payer mix — the breakdown of your patient population by insurance type. Each payer class has a different reimbursement rate, billing complexity, and collection timeline. The four main categories:

Payer Mix — Illustrative Private Practice (by % of Visits)
Commercial / PPO 45% of visits
72–85% collection
Medicare 30% of visits
60–70% collection
Medicaid 15% of visits
35–50% collection
Self-Pay 10% of visits
20–40% collection
⚠️ Collection rates are expressed as % of gross charges, not net revenue. A practice billing $300/visit with a 68% blended net collection rate collects $204/visit in net revenue — before any operating expenses.

The blended net collection rate is calculated by weighting each payer's collection rate by its share of patient volume. A 10-percentage-point shift from Medicaid to commercial insurance can increase net revenue per visit by $40–$80 — the single most powerful lever in practice revenue growth, short of adding providers.

⚠️ Critical modeling rule: Never use a single revenue-per-visit assumption. Always model gross charges separately from net collection rates by payer class. A model that skips payer mix will systematically overestimate revenue for Medicaid-heavy practices and underestimate it for concierge or elective-care practices.

Step 2 — Building a Driver-Based Revenue Model

Healthcare revenue is most accurately modeled from four core drivers: number of providers, visits per provider per day, operating days per year, and net revenue per visit (after payer mix adjustment). This structure is auditable, defensible, and directly tied to operational levers that clinic management can actually control.

Healthcare Revenue Model — Annual (Illustrative, 3-Physician Practice)
Providers (FTE Physicians)3.0 FTE
× Visits per provider per day22 visits
× Operating days per year250 days
= Total Annual Patient Visits16,500 visits
× Gross Charge per Visit (avg)$285
= Gross Charges$4,702,500
− Contractual Adjustments (34%)($1,598,850)
− Bad Debt & Uncollectible (4%)($188,100)
= Net Patient Revenue$2,915,550
+ Ancillary Revenue (lab, imaging)$185,000
= Total Net Revenue$3,100,550
Key Healthcare Revenue Formulas
Net Revenue per Visit = Gross Charge × Blended Net Collection Rate
// Collection Rate = weighted avg across all payer classes

Blended Net Collection Rate = Σ (Payer % × Payer Collection Rate)
// Example: 45% × 78% + 30% × 65% + 15% × 43% + 10% × 30% = 62.1%

Visits per Provider per Day (VPPD) = Target productivity benchmark
// Primary care: 18–24 | Internal medicine: 16–20 | Dermatology: 28–35

Revenue per Physician (FTE) = VPPD × Net Rev/Visit × Operating Days
// Industry benchmark: $600k–$1.2M per FTE physician (specialty-dependent)

Step 3 — The Healthcare Cost Structure: Overhead Ratio is Everything

In medical practice finance, the equivalent of the restaurant's Prime Cost is the overhead ratio — total operating expenses as a percentage of net collected revenue. MGMA (Medical Group Management Association) benchmarks suggest that healthy practices maintain an overhead ratio below 60%, with physician compensation accounting for an additional 25–40% of net revenue.

Cost Category% of Net RevenueKey DriverBenchmark Signal
Physician Compensation & Benefits 25–40% wRVU productivity, specialty market rates Threshold: <40%
Staff Salaries (non-physician) 18–25% FTE:provider ratio, MA/NP mix Watch if >28%
Occupancy (rent, utilities) 6–10% $/sq ft, location, specialty space needs Target: <8%
Medical Supplies & COGS 5–12% Procedure mix, vaccine inventory, implants High for procedural specialties
Billing & Collections (RCM) 3–8% In-house vs. outsourced, denial rate Outsourced: 5–8% of collections
Malpractice Insurance 2–6% Specialty, state, occurrence vs. claims-made High for OB/GYN, surgery
Technology (EHR, billing software) 2–4% Vendor contracts, per-provider licensing Industry standard

Step 4 — The Staffing Model: Building by Provider and Role

Labor typically represents 45–65% of a clinic's total expenses — making the staffing model the most consequential component of the cost structure. A professional healthcare financial model builds staffing from the bottom up: by provider, by support role, and by the productivity ratios that determine when each role must be added.

👨‍⚕️ Physicians (MD/DO)
Comp: $220k–$600k (specialty)
Model: wRVU × conversion factor
Trigger: per FTE added
🩺 Advanced Practice (NP/PA)
Comp: $110k–$160k
Model: 65–85% of MD productivity
Trigger: volume overflow threshold
💉 Clinical Staff (MA/RN)
Comp: $38k–$75k
Model: 1.5–2.5 staff per provider
Trigger: provider FTE ratio
🖥️ Admin / Front Desk
Comp: $35k–$55k
Model: 1 per 600–800 monthly visits
Trigger: volume-based add
📋 Practice Manager
Comp: $65k–$95k
Model: fixed; add at 4+ providers
Trigger: scale milestone
💰 Billing / RCM
Comp: $45k–$65k
Model: or outsource at 5–8%
Trigger: in-house vs. vendor decision

✅ The wRVU model for physician compensation is the institutional standard: physicians are paid a fixed rate per Work Relative Value Unit (wRVU) — a CMS-defined measure of procedure complexity. This aligns physician compensation with productivity rather than collections, and is the framework used by hospital systems, PE-backed groups, and DSOs. Your Excel model should include a wRVU conversion table for each specialty.

Step 5 — Break-Even Analysis: Daily Visits and Minimum Provider Productivity

A healthcare break-even analysis translates fixed monthly overhead into the minimum daily patient volume required to cover costs. This is the number every lender asks for — and the number every new practice owner needs to understand before signing a lease.

Healthcare Break-Even Formula
Break-Even Revenue = Fixed Monthly Costs ÷ (1 − Variable Cost %)
// Fixed costs: rent, fixed salaries, insurance, subscriptions, loan service // Variable costs: billing fees (% of collections), medical supplies per visit

Example:
Fixed Monthly Costs = $58,000
Variable Cost % = 12% (billing 8% + supplies 4%)

Break-Even Revenue = $58,000 ÷ 0.88 = $65,909/month

Net Revenue per Visit = $285 gross × 62% collection = $177/visit
Break-Even Visits = $65,909 ÷ $177 = 373 visits/month = 15.5/day
// With 2 physicians: each needs 7–8 visits/day minimum → well below the 18–22 target

Translating break-even into visits per provider per day gives the model real operational meaning. A break-even of 7.5 visits per physician per day (VPPD) is easily achievable. A break-even of 19 VPPD leaves almost no room for ramp-up — meaning the practice is financially viable only at maximum productivity from day one.

Startup Costs for a Medical Clinic: What Your Model Must Include

Cost CategoryTypical RangeNotesCommonly Missed?
Leasehold Improvements$80–$250kExam rooms, waiting area, plumbing, electrical15–20% contingency required
Medical Equipment$50–$300kSpecialty-dependent; imaging most expensiveUsually included
EHR System (setup + training)$15–$50kImplementation + first-year licensingOften underestimated
Initial Medical Supplies$10–$30kFormulary, vaccines, consumablesFrequently omitted
Malpractice Insurance (tail)$5–$40kTail coverage if leaving prior employerAlmost always missed
Credentialing Costs & Timeline$0–$10k + 3–6 monthsCannot bill insurance until credentialedBiggest cash flow risk
Working Capital (pre-revenue period)3–5 months of OpExCovers costs before collections beginMost dangerous omission

🚨 The credentialing gap is the most dangerous financial risk in a clinic startup. A physician cannot collect insurance reimbursement until fully credentialed — a process that takes 90–180 days at most payers. During this period, the clinic incurs full operating expenses with zero insurance revenue. This gap must be explicitly funded in the startup model, or the practice will run out of cash before ever reaching sustainable operations.

KPIs by Clinic Type: What Good Looks Like

Healthcare performance benchmarks vary significantly by specialty and care model. Applying primary care benchmarks to a dermatology or orthopedics practice will produce a fundamentally misleading model. Use the correct peer group:

$750k
Revenue/FTE MD Primary Care
MGMA median
$1.2M+
Revenue/FTE MD Dermatology
Procedural premium
20–22
Target VPPD — Primary Care
Visits per provider/day
95%+
Clean Claim Rate
First-pass approval
<35
Days in AR
Billing efficiency
5–12×
EV/EBITDA at Exit
PE acquisition range

How to Build the Model: Step by Step

  1. Define your payer mix and collect contract rates

    For each payer class, document the contractual allowable as a % of your gross charge for your 10 most common CPT codes. This is your net collection rate by payer — the most important inputs in the entire model.

  2. Build the patient volume engine by provider

    Model each physician and APP separately: starting VPPD in ramp period (typically 50–70% of steady state), target VPPD at full productivity, operating days, and panel size cap if relevant. Sum across all providers for total annual visits.

  3. Calculate net revenue from gross charges

    Apply the payer mix weights and payer-specific collection rates to arrive at a blended net collection rate. Multiply total gross charges by the net collection rate. Add ancillary revenue (labs, imaging, procedures) as a separate line.

  4. Build the staffing model by role and trigger

    Staff up by provider FTE ratio and visit volume thresholds — not arbitrarily. Each hire should have a documented trigger (e.g., "add second MA when VPPD exceeds 18"). This is what distinguishes a defensible model from a guess.

  5. Model all operating expenses and the overhead ratio

    Build every expense line from first principles: rent from lease terms, malpractice from actual quotes, supplies as % of gross charges, RCM fees as % of net collections, EHR from vendor contracts. Calculate the running overhead ratio monthly.

  6. Run break-even in daily visits

    Calculate break-even monthly revenue, divide by net revenue per visit, then divide by operating days. This gives you break-even VPPD — compare directly against your ramp schedule to identify the month of cash flow breakeven.

  7. Build the 3-statement model and cash flow bridge

    Integrate P&L into a cash flow statement that accounts for the collections lag (30–45 days from service to payment). Build a balance sheet with accounts receivable, deferred revenue, and loan balances. This is the output that lenders and investors use.

  8. Add scenarios and sensitivity analysis

    Scenario 1: payer mix shifts 10% toward Medicaid. Scenario 2: VPPD 20% below target for 6 months. Scenario 3: credentialing delay of 90 days. Each scenario should show the cash impact and revised break-even timeline. This demonstrates financial sophistication to any reviewer.

📥 The healthcare financial model templates at financialmodels.net include specialty-specific models for private practices, urgent care centers, and multi-site clinic groups — pre-built with payer mix engines, wRVU compensation tables, RCM modeling, and investor-ready 3-statement outputs. Download the free Explorer tier →

Healthcare Practice Valuation: What Determines Your Exit Multiple

The private equity rollup of physician practices has fundamentally changed how medical clinics are valued. In high-value specialties — dermatology, ophthalmology, GI, orthopedics — PE buyers routinely pay 8–12× EBITDA for well-run practices. Understanding what drives your multiple is essential both for building projections and for structuring a business to maximize eventual exit value.

FactorValue-EnhancingValue-Reducing
Payer Mix High commercial mix (>60%) Medicaid-heavy (>40%)
Provider Concentration Multiple providers, no single-physician dependency Solo physician = all revenue at risk
Revenue Cycle Health Days in AR <30, clean claim rate >95% High denial rate, aging AR, billing backlogs
Growth Trajectory Consistent 10–20% revenue CAGR Flat or declining patient volume
Ancillary Revenue In-house labs, imaging, procedures Referral-only model with no ancillary
Technology & EHR Modern, integrated, scalable platform Legacy system requiring replacement capex

Frequently Asked Questions

What should a medical clinic financial model include?
A complete medical clinic financial model should include: startup cost schedule (with credentialing gap funding), payer mix assumptions by insurance class, patient volume projections by provider and service line, net revenue calculation from gross charges, staffing model by role with hiring triggers, operating expense forecast producing an overhead ratio, break-even analysis in daily visits, a 3-statement financial model (P&L, cash flow, balance sheet), and scenario analysis for payer mix shifts and volume shortfalls.
What is a good EBITDA margin for a medical clinic?
EBITDA margins vary significantly by specialty: primary care practices typically achieve 15–25%; internal medicine 15–22%; dermatology and ophthalmology 25–40%; ambulatory surgery centers (ASCs) 30–45%; and urgent care centers 12–20%. Margins depend heavily on payer mix (commercial-heavy practices have structurally higher margins), provider productivity (VPPD), and overhead management — particularly how efficiently the revenue cycle is managed.
How do you calculate revenue for a medical clinic?
Medical clinic net revenue = Total Visits × Average Gross Charge per Visit × Blended Net Collection Rate. The blended net collection rate is calculated by weighting each payer class's collection rate by its share of patient volume. For a practice with 45% commercial (78% collection), 30% Medicare (65%), 15% Medicaid (43%), and 10% self-pay (30%), the blended rate is approximately 62%. Multiply total gross charges by 62% to arrive at net patient revenue.
How long does it take for a new medical clinic to become profitable?
Most new private practice clinics reach operating cash flow breakeven in months 6–12, though the timeline varies significantly by payer mix, credentialing speed, and ramp rate. The credentialing lag (90–180 days to receive first insurance payments) is the primary driver of the pre-profitability cash burn period. Practices that are well-capitalized (with 3–5 months of operating expenses in reserve), have commercial-heavy payer mix, and start with an established patient panel will reach breakeven faster.
What is the difference between gross charges and net revenue in healthcare?
Gross charges are the "sticker prices" that clinics bill for services — almost no one pays these rates. Net revenue is what is actually collected after contractual adjustments (the difference between gross charges and what the insurance company has contracted to pay) and bad debt write-offs. For most practices, net revenue represents 55–75% of gross charges. This gap is why building a healthcare model from a single "revenue per visit" assumption without modeling payer mix produces systematically inaccurate projections.

Startup Financial Model

tamir Financial Models Blog
Startup Financial Model — Excel & Google Sheets Template | financialmodels.net
Ph.D. Certified Financial Architecture

Startup Financial
Model.

13 sheets. Zero guesswork.

A complete, institutional-grade financial model for high-growth startups. Revenue forecasting, unit economics, cash flow, sensitivity analysis — all interconnected, boardroom-ready, and 100% yours.

Download Model View Architecture
13 Model Sheets
54 Audit Checks
5yr Projection Horizon
startup_financial_model.xlsx — Income
Metric
Y1
Y2
Y3
Y4
MRR
$42k
$118k
$301k
$780k
ARR
$504k
$1.4M
$3.6M
$9.4M
Gross Margin
62%
68%
72%
76%
Burn Rate
-$89k
-$64k
-$22k
+$41k
LTV/CAC Ratio
2.1x
3.4x
4.8x
6.2x
ARR Growth Trajectory
Used by founders at
The Foundation

What Is a Startup
Financial Model?

A startup financial model is a structured spreadsheet that translates your business assumptions — pricing, growth rate, headcount, churn — into projected financial outcomes: revenue, expenses, cash flow, and profitability.

Unlike a static business plan, a financial model is dynamic. Change one input — say, your monthly churn rate from 3% to 5% — and every downstream metric recalculates instantly. You see exactly what it does to your runway, your LTV/CAC ratio, and your Series A narrative.

Investors expect to see one before writing a check. Boards expect one before approving a budget. This model gives you both — built to institutional standards from day one.

📈

Fundraising

Show VCs a credible 5-year projection. Answer "what's your path to $10M ARR?" with precision, not hand-waving.

🧭

Strategic Planning

Model hiring plans, pricing experiments, and go-to-market pivots before committing real money. The model is the sandbox.

📋

Board Reporting

Quarterly board decks in minutes. The model auto-produces board-ready summaries as your actuals flow in each month.

Preview · Assumptions Sheet

One place. Every input.

The Assumptions sheet is the control panel of your entire model. Every number in every other sheet traces back here — change a single cell and the whole model updates.

startup_financial_model.xlsx — financialmodels.net
Assumptions Income Expenses Cash Flow + 9 more
C8 = 0.03 ← Monthly churn rate — edit yellow cells only
A
B
C
D
E
F
REVENUE ASSUMPTIONS
Starting MRR
$
5,000
per month
Monthly Growth Rate
%
12%
MoM
Monthly Churn Rate
%
3%
selected cell
UNIT ECONOMICS
Customer Acq. Cost
$
420
per customer
LTV/CAC →
3.8x
Avg. Contract Value
$
199
per month
Payback →
2.1 mo
Yellow cells = editable inputs. All other cells are formula-protected.
Sheet-by-Sheet Guide

What Every Sheet Does.
In Plain English.

13 sheets. Each one has a job. Here's exactly what you get — and why it matters to investors.

Sheet 01 · Free
Description

The model's welcome page. Explains the overall architecture, how data flows between sheets, and what each input cell expects. Essential reading before your first edit — saves hours of trial and error.

Model overview Setup guide
Sheet 02 · Free
Explanation

Methodology documentation. Every formula is explained in plain language — what it calculates, why it's structured that way, and how investors typically interpret the output. Doubles as a study guide for founders new to financial modeling.

Formula documentation Ph.D. methodology
Sheet 03 · Free
Assumptions

The central control panel. Every input that drives the model lives here — pricing, growth rates, churn, CAC, headcount plan, gross margin. Change a cell here; the entire model recalculates. Yellow cells are editable; everything else is formula-protected.

Revenue drivers Churn & growth Headcount plan
Sheet 04 · Free
Income

Your core P&L statement. Tracks MRR, ARR, gross margin, and operating profit month-by-month for 5 years. Revenue is broken into new MRR, expansion MRR, and churned MRR — the three numbers every SaaS investor asks about first.

MRR/ARR Gross margin Operating profit
Sheet 05 · Free
Expenses

Full cost structure across COGS, R&D, Sales & Marketing, and G&A. Each line item is driven by your Assumptions inputs — headcount, contractor rates, software costs, office expenses. Burn rate and runway calculated automatically.

COGS breakdown Burn rate Runway
Sheet 06 · Free
Charts

Auto-generated visual dashboard. ARR growth curve, monthly burn waterfall, LTV/CAC ratio over time, and gross margin trend — all updating live as you edit assumptions. Copy any chart directly into your pitch deck.

Live charts Pitch-deck ready
Starter & Professional — Paid Sheets
Sheet 07 · Starter+
Extended Income

Cohort-level revenue breakdown. See how each monthly acquisition cohort contributes to MRR over time — which cohorts retain well, which churn fast, and where your net revenue retention is heading. The data that separates Series A-ready from the rest.

Cohort analysis NRR tracking Expansion MRR
Sheet 08 · Starter+
Extended Expenses

Department-level OpEx with a full hiring plan. Model each role by start date, salary, and department. Automatically rolls up to headcount cost by team — engineering, sales, marketing, operations, G&A. Includes employer taxes and benefits burden.

Hiring plan Dept. breakdown Benefits burden
Sheet 09 · Starter+
Cash Flow

Three-statement cash flow: operating, investing, and financing activities. Tracks cash-on-hand month by month, shows when you hit zero (your drop-dead date), and models the impact of a new funding round on runway. The number investors stare at hardest.

Operating CF Runway date Funding impact
Sheet 10 · Starter+
Yearly Summary

Annual KPI rollup condensing 60 months of detail into a clean 5-year table. ARR, headcount, burn multiple, gross margin, and net income — side by side across all five years. The one-page summary VCs screenshot into their investment memos.

5-year summary VC memo-ready
Professional Only
Sheet 11 · Professional
Investor Returns

IRR, MOIC, and waterfall distribution across multiple funding rounds. Model your Series A through Series C, set liquidation preferences, and see exactly what each investor class receives at different exit valuations. Answers "what do I need to build to return the fund?" with a number.

IRR & MOIC Waterfall model Exit scenarios
Sheet 12 · Professional
Quarterly Summary

Board-meeting-ready quarterly view. Q1–Q20 across 5 years with the metrics your board expects: ARR, NRR, gross margin, CAC payback, and burn multiple. One tab to paste into your board deck — formatted for readability, not just accuracy.

Board-ready Q1–Q20
Sheet 13 · Professional
Sensitivity Analysis

25-scenario stress-test matrix. Simultaneously vary two key inputs (e.g., churn rate vs. growth rate) and see Year 3 ARR across 25 combinations in a heat map. Shows investors you've thought through the downside — and proves your upside isn't just optimism.

25-scenario matrix Heat map Stress testing
Sheet 14 · Professional
Insights

Automated flags and commentary. Conditional logic scans your model and surfaces warnings — "CAC payback exceeding 12 months," "burn multiple above 2x," "churn offsetting new MRR." The model tells you what to fix before your investors find it first.

Auto-warnings 54 audit checks KPI health score
Preview · Cash Flow Sheet

Know exactly when you run out of money.

The Cash Flow sheet tracks every dollar in and out, month by month — so you're never surprised by your runway.

Cash Flow — Year 1 Detail
Metric
Jan
Feb
Mar
Apr
May
Jun
Cash In — Revenue
42k
47k
53k
59k
66k
74k
Cash Out — OpEx
(131k)
(134k)
(138k)
(142k)
(149k)
(155k)
Net Burn
(89k)
(87k)
(85k)
(83k)
(83k)
(81k)
Cash on Hand
1.41M
1.32M
1.24M
1.15M
1.07M
989k
Months of Runway
15.9
15.2
14.6
13.9
12.9
12.2
Common Questions

Frequently Asked
Questions.

What exactly is a startup financial model? +

A startup financial model is a dynamic spreadsheet that translates your business assumptions into financial projections. You input your pricing, growth rate, churn, and headcount plan — the model produces your revenue forecast, P&L, cash flow statement, and key investor metrics. Unlike a static forecast, every cell is linked: change one assumption and the entire 5-year model recalculates instantly.

Does it work in Google Sheets and Excel? +

Yes. The model is delivered as a native .xlsx file and is fully compatible with Google Sheets. All formulas, conditional formatting, and charts render correctly in both. Your data never touches a cloud server — it's a local file you own completely.

Do I need an accounting background to use it? +

No. The Assumptions sheet is designed to be filled in by any founder — you only ever touch yellow cells. The model handles all the accounting logic. The included Explanation sheet documents every formula in plain language if you want to understand what's happening under the hood.

Is this suitable for pre-revenue startups? +

Yes. The model is designed for the full startup lifecycle — from pre-seed through Series B. For pre-revenue companies, the Assumptions sheet lets you input target pricing and anticipated launch dates. The model will project forward from there. Many founders use it to build their first financial narrative before they have a single customer.

What's the difference between the free and paid tiers? +

The free Explorer tier (6 sheets) gives you the full core model — Assumptions, Income, Expenses, and Charts. It's genuinely useful for internal planning. The paid tiers add Cash Flow, cohort-level Extended Income, a department-level hiring plan, and — in the Professional tier — Investor Returns (IRR/MOIC), Sensitivity Analysis, and the 54-point audit dashboard that flags model errors automatically.

Complete Architecture

13 Interconnected Sheets.
Three Tiers.

Every sheet feeds into the next. Change one assumption in the foundation, watch the waterfall cascade through P&L, cash flow, and investor returns automatically.

Explorer · Free
6
Core Sheets
Core Foundation
Essential building blocks — included free
  • 📋 Description
  • 📖 Explanation
  • ⚙️ Assumptions
  • 💰 Income
  • 💸 Expenses
  • 📊 Charts
Starter · Paid
10
+ 4 Extended Sheets
Extended Reporting
Professional breakdowns for investor review
  • 📈 Extended Income
  • 📉 Extended Expenses
  • 💧 Cash Flow
  • 📅 Yearly Summary
  • 📊 Investor Returns 🔒
  • 🔬 Sensitivity Analysis 🔒
Professional · Full
13
All Sheets Unlocked
Strategic Analysis
Complete institutional framework
  • 📊 Investor Returns
  • 📆 Quarterly Summary
  • 🔬 Sensitivity Analysis
  • 💡 Insights
  • ✅ 54-pt Audit Dashboard
  • 🎯 + All 9 Previous Sheets
Full Sheet Index
Sheet
Explorer
Starter
Professional
Core Foundation
DescriptionOverview & setup guide
ExplanationMethodology documentation
AssumptionsCentral input dashboard
IncomeRevenue streams & MRR/ARR
ExpensesCost structure & burn
ChartsVisual summaries
Extended Reporting
Extended IncomeCohort & segment breakdown
Extended ExpensesDepartment-level OpEx
Cash FlowOperating, investing, financing
Yearly SummaryAnnual KPI rollup
Strategic Analysis
Investor ReturnsIRR, MOIC, waterfall
Quarterly SummaryBoard-ready quarterly view
Sensitivity AnalysisScenario & stress testing
InsightsAI-driven flags & commentary
54
Audit Checkpoints

Built-in error detection flags formula breaks, balance sheet mismatches, and logic violations before you share with anyone.

5yr
Projection Horizon

Monthly granularity for years 1–2, quarterly for years 3–5. The right resolution for every conversation.

0
Cloud Exposure

Native Excel & Google Sheets file. Your data never leaves your machine. No SaaS, no subscriptions, no privacy risk.

∞
Scenario Iterations

Duplicate tabs for bull, base, and bear cases. Sensitivity matrix shows outcomes across 25 variable combinations simultaneously.

What Is a Financial Model — and Why Does Quality Matter?

tamir Financial Models Blog
What Is a Financial Model? | Ph.D. Finance
Ph.D. Finance Blog · Financial Modeling

What Is a Financial Model — and Why Does Quality Matter?

A rigorous look at the core architecture behind institutional decision-making, and what separates a model built to survive due diligence from one that doesn't.

Tamir Levy, Ph.D. April 2026 8 min read

Beyond the Spreadsheet

The term "financial model" gets used loosely — sometimes to describe a tab of revenue assumptions, sometimes a back-of-envelope DCF. In institutional finance, the definition is considerably more demanding. A financial model is a dynamic, structured representation of a real-world financial situation: a tool that lets executives, investors, and credit committees forecast performance, stress-test assumptions, and arrive at defensible decisions.

Think of it as a digital twin for your business. A static balance sheet tells you where you are today. A well-built financial model tells you where you could be — under every plausible market scenario — and why.

"In institutional finance, the model is the argument. If the math doesn't hold up under scrutiny, neither does the deal."

The Three Pillars of Model Architecture

Every rigorous financial model rests on the same three foundational pillars. Understanding how each is handled — and how they interact — is what separates institutional-grade work from a template downloaded off the internet.

📈
Revenue
Institutional revenue modeling requires cohort-based analysis and unit economic decomposition — not just a top-line growth rate. For a SaaS business, that means separating Gross Revenue Retention from Net Revenue Retention across distinct customer segments.
💳
Expenses
Fixed, variable, and semi-variable costs are separated with precision. Operating leverage is mapped explicitly, and scaling milestones are modeled so the cost structure responds dynamically to growth — not just linearly.
🏦
Cash Flow
The ultimate solvency metric. Institutional models reconcile Net Income to Operating Cash Flow via indirect method adjustments, and track Free Cash Flow to Firm (FCFF) as the core valuation input. For PE, Cash-on-Cash return and IRR are the scoreboard.

The Workflow: Inputs, Calculations, Outputs

One of the most common structural failures in financial modeling is allowing outputs to feed back into inputs — creating circular references that corrupt the math silently. A properly architected model follows a strict linear, non-circular workflow:

Phase 01 · Inputs
  • Macro assumptions
  • Operational drivers
  • Financing terms
Phase 02 · Calculations
  • Supporting schedules
  • 3-statement integration
  • Debt sculpting
Phase 03 · Outputs
  • Executive dashboard
  • Sensitivity tables
  • Valuation summary

This separation is not stylistic — it is structural. When a model is organized this way, any analyst (or auditor) can trace any output back to its source assumption in under a minute. That traceability is what makes a model boardroom-ready.

Sensitivity Analysis: The Institutional Standard

Single-variable sensitivity analysis — "what happens if revenue grows 5%?" — is a starting point, not a conclusion. Institutional practice demands simultaneous multi-scenario stress testing: understanding what enterprise value looks like when market volatility rises by 10% while labor costs increase by 15% at the same time.

This is achieved through Excel Data Tables for defined scenario matrices, or Monte Carlo simulations when you need a full probability distribution of outcomes. The goal isn't to find the most optimistic scenario — it's to understand the full range of risk the business is exposed to.

"We don't ask 'what if revenue grows 5%?' We ask what enterprise value looks like when volatility spikes and cost pressures converge simultaneously."

Audit-Readiness: The Standards That Matter

Every model published through the Ph.D. Finance Marketplace is built against a rigorous set of quality standards — the same principles embedded in the audit sheets that ship with every workbook. The goal is simple: zero ambiguity for any analyst who opens the file.

Formula Integrity
  • ✓ No hard-coded numbers inside formulas
  • ✓ Uniform formula structure across rows
  • ✓ Circular references strictly prohibited
Transparency
  • ✓ Color-coded inputs (blue for hard-codes)
  • ✓ Documented assumption sources
  • ✓ Dedicated audit sheet per workbook

Each workbook also includes a built-in audit sheet that flags errors automatically — not as an afterthought, but as a first-class feature of the architecture. When a model passes these standards, it isn't just mathematically correct; it's defensible under due diligence.

The Ph.D. Finance Standard

The models in the Ph.D. Finance Marketplace aren't calculators — they are strategic assets built on 30 years of institutional experience, validated by Tamir Levy, Ph.D. They run locally on your machine, keep your data private, and are architected to be AI-ready: structured well enough that any AI tool can interpret the logic and generate boardroom-grade narratives from your numbers. Math you can trust, ready for every stage of the deal.

The Institutional Finance Glossary

tamir Financial Models Blog

Financial Model Guide

tamir Financial Models Blog
Financial Model Guide | financialmodels.net
Foundations Beginner

What Is a Financial Model?
A Complete Operational Guide

Master the three operational engines — Revenue, Expenses, and Cash Flow — and understand how they interlock to drive every business decision.

$4.2M
Revenue
→
$2.8M
Expenses
→
$1.4M
Free Cash Flow

Simplified 3-pillar model flow

A financial model is a dynamic quantitative representation of a business's operations, structured so that changing a single assumption — say, price per unit — automatically flows through to revenue, then to gross profit, then to net income, and finally to cash. That cascade is what separates a true model from a static spreadsheet.

This guide focuses on the three operational pillars every model must get right before anything else: how money comes in (Revenue), how money goes out (Expenses), and how much actually remains as liquid capital (Cash Flow). Valuation is briefly covered at the end — it's downstream of these three.

trending_up

1. Revenue Modeling

Revenue is the top line — the starting point from which every other figure is derived. A weak revenue model contaminates everything downstream. Getting this right means choosing the correct driver structure for your business type.

Revenue Driver Frameworks

Retail / E-commerce / Manufacturing

The most fundamental revenue structure. You multiply volume by price. Every other model is a variation of this.

Revenue = Units Sold × Average Selling Price (ASP)
Key Input
Volume (Units)
Driven by market size × penetration rate × seasonality. Model monthly or quarterly.
Key Input
Pricing (ASP)
Segment by SKU or tier. Include discount rates, promotional periods, and blended averages.
⚠ Common Mistake: Modelers often apply a single flat growth rate to total revenue. Better practice: model volume and price separately — they respond differently to market shocks.
SaaS / Media / Insurance

Recurring revenue is modeled as a cohort waterfall: you track new subscribers, upgrades, downgrades, and churn each period.

MRR = (Beginning MRR) + New MRR + Expansion MRR − Churned MRR
New MRR
Revenue from newly acquired customers this period.
Expansion MRR
Upsells and tier upgrades from existing base.
Churned MRR
Revenue lost to cancellations or downgrades.
ARR = MRR × 12   |   Net Revenue Retention (NRR) = (End MRR − New MRR) / Begin MRR × 100
ℹ Benchmark: Best-in-class SaaS businesses target NRR > 120%, meaning the existing base grows even without new customers.
Payments / Marketplaces / Brokers

Revenue is a percentage of underlying transaction volume (Gross Merchandise Value or GMV). The model lives or dies on take rate and volume.

Revenue = GMV × Take Rate (%)
GMV Drivers
  • Number of active buyers × average order value
  • Transaction frequency per buyer per period
  • Geographic or category expansion
Take Rate Pressures
  • Competitive pricing compression over time
  • Volume discounts for enterprise merchants
  • Product mix shift (higher / lower margin items)
Airlines / Hotels / Clinics / Consulting

Revenue is constrained by physical or human capacity. The core lever is utilization rate.

Revenue = Total Capacity × Utilization Rate × Rate per Unit
✓ Modeling Tip: Always cap utilization at a realistic maximum (e.g., 85% for a hotel to account for maintenance, blocks, and no-shows). 100% utilization is operationally impossible to sustain.

Essential Revenue KPIs

Gross Revenue Top Line
Units × Price (before any deductions)

Total invoiced amount. Do not use this for profitability analysis — it includes returns, allowances, and discounts.

Net Revenue Recognized
Gross Revenue − Returns − Discounts − Allowances

The real revenue figure used in financial statements and profitability ratios.

Revenue Growth Rate Momentum
(Revenue_t − Revenue_t-1) / Revenue_t-1 × 100

Model both YoY (annual strategy) and MoM (operational pulse). Investors benchmark against sector medians.

Revenue per Employee Efficiency
Net Revenue / FTE Headcount

Measures operational leverage. Software companies often exceed $500K/employee; services firms typically $100–250K.

payments

2. Expense Modeling

Expenses are not simply costs to minimize — they are investments in revenue. A great expense model separates costs by their behavior (fixed vs. variable), their function (COGS vs. OpEx), and their timing (period vs. capital).

The Full Expense Stack

Net Revenue
$4,200K
− COGS
$2,310K
= Gross Profit
$1,890K (45%)
− OpEx (S&M, G&A, R&D)
$1,260K
= EBITDA
$630K (15%)
− D&A
$210K
= EBIT
$420K (10%)

Fixed vs. Variable Cost Behavior

horizontal_rule

Fixed Costs

Do not change with output volume within a relevant range. They create operating leverage — great when scaling up, dangerous when scaling down.

Rent / LeaseMonthly, contractual
Base SalariesHeadcount-driven
InsuranceAnnual premium
Software LicensesPer seat or flat
Operating Leverage = % Change in EBIT / % Change in Revenue
show_chart

Variable Costs

Scale directly with revenue or units produced. Model as a percentage of revenue (for simplicity) or per-unit cost (for precision).

Direct Materials$ per unit
Sales Commissions% of deal value
Payment Processing% of GMV
Shipping / FulfillmentPer order / weight
Contribution Margin = Revenue − Total Variable Costs

COGS Deep Dive

Cost of Goods Sold (COGS) represents the direct costs of producing your product or delivering your service. Getting COGS right is essential — it drives gross margin, the single most important profitability metric for investors.

Includes: raw materials, direct labor, manufacturing overhead (machine depreciation, factory utilities), inbound freight, and packaging.

COGS = Beginning Inventory + Purchases − Ending Inventory

Model COGS as a % of revenue but validate with a bottom-up bill-of-materials (BOM) for each SKU. Gross margin benchmarks: consumer goods 30–50%, industrials 20–35%.

Includes: hosting / cloud infrastructure (AWS, GCP), third-party API costs, customer support headcount, onboarding costs, and amortization of acquired technology.

Gross margin benchmarks: top-tier SaaS 70–80%+. Below 60% suggests infrastructure or support inefficiencies.

Key ratio: track hosting cost as % of revenue monthly — it should decrease as you gain scale (economies of density).

Primarily billable labor — the compensation cost of employees or contractors directly delivering client work. Also includes subcontractor fees and project-specific tools.

Gross Margin = (Billing Rate − Cost Rate) / Billing Rate

Model by tracking utilization rate (billable hours / total available hours). A team at 70% utilization vs 85% is a significant margin difference.

Operating Expense Categories (OpEx)

S&M

Sales & Marketing

  • Sales rep salaries + OTE
  • Paid digital ads (CAC driver)
  • Events, PR, brand spend
  • CRM and sales tools
  • Content and SEO programs
Key Ratio: S&M as % of revenue. Early-stage: 30–50%. Scale-stage: 15–25%.
G&A

General & Administrative

  • Executive and back-office salaries
  • Rent and facilities
  • Legal and accounting fees
  • HR systems, IT infrastructure
  • Insurance and compliance
Key Ratio: G&A as % of revenue. Mature companies: 5–10%. Startups often run 15–25%.
R&D

Research & Development

  • Engineering and product salaries
  • Development tools and cloud costs
  • Lab equipment and materials
  • Patents and IP costs
  • External research contracts
Key Ratio: R&D as % of revenue. Software: 15–25%. Biotech/pharma: 40–80%.

Capital Expenditure (CapEx)

CapEx is not expensed immediately on the income statement — it is capitalized on the balance sheet and depreciated over its useful life. This distinction is critical for modeling both profitability and cash flow accurately.

Maintenance CapEx

Spending required to maintain current capacity. Treat as a recurring cost; model as % of existing PP&E (typically 3–8% annually). Buffett's FCF definition subtracts only this.

Growth CapEx

Spending to expand capacity or capability. Discretionary and linked to revenue growth assumptions. New factory line, data center, or fleet expansion.

Annual Depreciation (Straight-Line) = (Cost − Salvage Value) / Useful Life (years)
account_balance

3. Cash Flow Modeling

"Revenue is vanity, profit is sanity, but cash flow is reality." A company can be profitable on the income statement and still run out of cash. Modeling cash flow separately is not optional — it is the difference between a financial model and a financial disaster.

The Cash Flow Statement: 3 Sections

CFO — Operations

Net Income ± working capital changes + D&A (non-cash add-back). This is the core engine.

Positive = self-funding business
CFI — Investing

CapEx outflows, acquisitions, asset sales, investment purchases/maturities.

Usually negative in growth phase
CFF — Financing

Debt raises/repayments, equity issuance/buybacks, dividends paid.

Bridge for funding gaps
Net Change in Cash = CFO + CFI + CFF  →  Ending Cash = Beginning Cash + Net Change

Working Capital: The Hidden Cash Drain

Even a profitable business can have negative operating cash flow if working capital is poorly managed. The cash conversion cycle measures how long cash is tied up in operations.

Days Sales Outstanding (DSO)
Accounts Receivable / (Revenue / 365)

How long to collect cash after invoicing. Lower is better. B2B businesses often run 30–60 days.

Days Inventory Outstanding (DIO)
Inventory / (COGS / 365)

How long inventory sits before sale. Lower is better. Fast-moving goods target <30 days.

Days Payable Outstanding (DPO)
Accounts Payable / (COGS / 365)

How long before you pay suppliers. Higher is better — you use their money longer.

Cash Conversion Cycle (CCC) = DSO + DIO − DPO

A negative CCC (like Amazon) means you collect cash before you have to pay suppliers — the business self-funds growth. A high positive CCC means growth consumes cash, requiring external funding.

Model working capital as changes in balance sheet accounts, not income statement items. A $1M revenue increase might reduce cash if DSO is 60 days.

Free Cash Flow (FCF) — The Investor's Metric

FCF represents the cash a business generates after maintaining and growing its asset base. It is the foundation of intrinsic value and the primary metric sophisticated investors use to evaluate businesses.

Standard

Unlevered Free Cash Flow (UFCF)

UFCF = EBIT × (1 − Tax Rate) + D&A − ΔWorking Capital − CapEx

Used in DCF valuation. Capital-structure neutral — excludes the impact of debt. Represents cash available to all capital providers (debt + equity).

Equity Investors

Levered Free Cash Flow (LFCF)

LFCF = Net Income + D&A − ΔWorking Capital − CapEx − Debt Repayment

Cash available to equity holders after debt obligations. The basis for dividend capacity and buyback programs.

Operational

Owner Earnings (Buffett Method)

Owner Earnings = Net Income + D&A − Maintenance CapEx ± WC Changes

Excludes growth CapEx. Represents the economic reality of what a business earns for its owner annually, stripped of accounting distortions.

Cash Flow Bridge (Illustrative)

Net Income
+$420K
+ D&A Add-back
+$140K
− ΔWorking Capital
−$84K
= CFO
$476K
− CapEx
−$126K
= FCF
$350K
✓ Rule of 40: For SaaS, a healthy business satisfies: Revenue Growth Rate (%) + FCF Margin (%) ≥ 40. A company growing 30% with 15% FCF margin scores 45 — excellent.
show_chart

4. Valuation (Overview)

Valuation is downstream of the three operational pillars above. You cannot value what you haven't modeled. Here's a brief map of the major approaches — each with a dedicated guide on this platform.

DCF

Intrinsic value from discounted future free cash flows. Requires a well-built FCF model (above) and a defensible WACC.

Full DCF Guide arrow_forward

Comparable Companies (Comps)

Apply market multiples (EV/Revenue, EV/EBITDA, P/E) from peer companies. Fast but dependent on comparable set quality.

Full Comps Guide arrow_forward

LBO Analysis

Private equity acquisition using significant leverage. IRR-driven model focused on entry/exit multiples and debt paydown schedule.

Full LBO Guide arrow_forward
menu_book

Glossary of Key Terms

Top 5 Common Mistakes When Building Your First Financial Model

tamir Financial Models Blog

Learn what are the Top 5 Common Mistakes When Building Your First Financial Model

100+ Financial Model Templates |
Ph.D. Excel, Word & PPT Marketplace

Financial Model Blog

Legal