Lesson 1.9: Building a Simple Financial Model

Lesson Overview

A financial model is a structured way to answer “what if?” questions. What if sales grow faster? What if costs rise? What if customers pay slower? What if interest rates increase? Models help you translate assumptions into numbers, then evaluate how those numbers affect profit, cash, and risk.

In this lesson, you’ll learn how to build a simple model that connects the three financial statements. You’ll also learn a practical modeling mindset: keep it clear, keep it consistent, and stress-test the drivers that matter most.

Learning Objectives

• Define what a financial model is and what it is used for.
• Identify the difference between inputs (assumptions) and outputs (results).
• Build a simple forecast for the income statement using key drivers.
• Link balance sheet items to operating assumptions (working capital and CapEx).
• Produce a basic cash flow forecast and estimate free cash flow.
• Run scenario and sensitivity analysis to understand risk.

What a Financial Model Is (and What It Isn’t)

A model is not a prediction machine. It’s a structured way to explore outcomes based on assumptions. The output is only as good as the inputs—and the clarity of the logic linking them.

• A model is: transparent, driver-based, and testable.
• A model is not: a pile of random formulas, a copy-paste spreadsheet, or a guaranteed forecast.

The Modeling Mindset: Drivers & Assumptions

Great models focus on a handful of “big drivers.” Examples include:

• Volume (units sold, customers, occupancy)
• Price (average selling price, subscription price)
• Costs (COGS %, labor costs, marketing spend)
• Working capital (how fast customers pay; how fast you pay suppliers)
• CapEx (how much you invest in equipment/technology)
• Financing (debt levels, interest rate, dividends)

If you can explain your model in a few sentences, it’s probably understandable. If you can’t, it’s probably too complex.

Model Layout (Simple and Clean)

A beginner-friendly layout that scales well:

1. Inputs (assumptions, clearly labeled, easy to change)
2. Income Statement (forecast period)
3. Balance Sheet (linked items, especially working capital and debt)
4. Cash Flow Statement (derived from the other two)
5. Outputs (key metrics, charts, and checks)
6. Scenarios (base / upside / downside)

Step 1: Forecast the Income Statement

Start with revenue drivers and then build the rest in layers.

Revenue Forecast (Two Common Approaches)

• Growth approach: Revenue(t) = Revenue(t-1) × (1 + Growth Rate)
• Units × Price: Revenue = Units Sold × Average Price

Costs and Margins

• COGS: often modeled as a % of revenue (or per-unit cost × units)
• Operating expenses: can be fixed, variable, or a blend
• EBIT / Operating income: Revenue − COGS − OpEx
• Taxes: a % of pre-tax income (simplified)

Step 2: Link the Balance Sheet (The “Glue”)

A model becomes useful when the balance sheet is connected to operations. Two high-impact areas:

Working Capital (Simple Driver Method)

• Accounts Receivable driven by DSO (days sales outstanding)
• Inventory driven by DIO (days inventory outstanding)
• Accounts Payable driven by DPO (days payables outstanding)

Fixed Assets and Depreciation

• CapEx increases PP&E (cash out today)
• Depreciation reduces book value over time (non-cash expense)

Tip: for a simple model, you can approximate depreciation as a % of prior-period PP&E or use a straight-line assumption.

Step 3: Build the Cash Flow Statement (Indirect Method)

Many models calculate cash flow using the indirect approach:

1. Start with net income
2. Add back non-cash items (depreciation/amortization)
3. Adjust for working capital changes (A/R, inventory, A/P)
4. Subtract CapEx (investing cash flow)
5. Add financing flows (debt issued/paid, equity changes, dividends)
6. Reconcile to ending cash

Key Outputs to Track

• Revenue growth and margins (gross, operating, net)
• Operating cash flow and free cash flow
• Working capital intensity (CCC, A/R as % of revenue)
• Leverage (debt levels; interest coverage)
• Liquidity (cash balance; current ratio)

Scenario Analysis: Base, Upside, Downside

A scenario is a set of assumptions that move together. For example:

• Base case: expected growth, normal margins, stable working capital
• Upside case: faster growth, better margins, faster collections
• Downside case: slower growth, margin compression, slower collections, higher CapEx

Scenarios help you understand the range of possible outcomes—not just a single point estimate.

Sensitivity Analysis: One Variable at a Time

Sensitivity tests isolate one assumption and ask: “If this changes, how much does it matter?”

• What if gross margin is 2% lower?
• What if DSO increases by 15 days?
• What if CapEx is $1M higher?
• What if interest rate rises by 150 bps?

Sensitivity analysis tells you what to pay attention to: the variables that move outcomes the most.

Model Quality Checks (Non-Negotiables)

• Balance sheet balances: Assets = Liabilities + Equity (every forecast period)
• Cash reconciles: beginning cash + net change = ending cash
• Reasonable trends: margins and working capital shouldn’t jump without a reason
• No hard-coded outputs: outputs should flow from inputs
• Clear labeling: anyone should understand your drivers in minutes

Practice: Build a 1-Year Mini Model (Conceptual)

1. Choose a revenue driver (growth rate or units × price).
2. Set COGS as a % of revenue and OpEx as a % of revenue.
3. Estimate net income using a simple tax rate.
4. Set DSO, DIO, and DPO to model working capital changes.
5. Set CapEx for the year and compute free cash flow.
6. Create two alternative scenarios (upside and downside) and compare results.

Mini-Case: The “Hidden Cash Risk”

A company forecasts 20% revenue growth and stable margins. Investors are excited. But the company is expanding into customers who pay slowly, increasing DSO from 35 days to 70 days.

• What happens to cash from operations as receivables grow?
• How could the company finance that working capital need?
• Why might a “profitable growth” story still be risky?

What’s Next?

In Lesson 1.10: Reading Financial Statements Like an Analyst