Financial Review Workshop
Colin King, CPA, CFA
Where we are
2
Step 2 of the Financial Operating System.
1
Plan properly
2
Monitor financial position
3
Cost structure (price, volume, cost)
4
Manage cash flow
5
Manage growth
6
Capital management
7
Plan for transition
Quick poll: what's in your review process?
3
Hands up for the one that sounds most like you.
A
I don't really have one
I check the bank balance and my gut.
B
I look at the P&L
Usually when the bookkeeper or CPA sends it.
C
I compare periods
This month vs. last month, or vs. last year.
D
I track a scorecard
A set of metrics I review every month.
Goals for today
4
01
Read
the financials
Understand what each statement measures and how they’re connected
02
Interpret
the financials
Spot what's going well and what's going poorly (the “story” behind the numbers)
03
Use
the financials
Turn what you find into actions that fix problems and add value
Reading the financials
5
6
"If you don't understand the accounting, you don't understand the business."
Charlie Munger
How to read financials
7
Assets = Liabilities + Net Worth
Sales�
Net Profit
Uses of Profits:
Efficiency
Balance Sheet
Income Statement
The Financial Operating Cycle
The Financial Operating Cycle
8
How money moves through every business.
Assets
Buy things (assets) to drive sales
Liabilities & Equity
Pay for assets with liabilities/equity
Sales
Turn assets into sales
Use profits
Buy assets, pay debt, pay owners
Measure efficiency of each step and repeat
Net profit
Turn sales into profit
Anatomy of the Income Statement (P&L)
9
Measures a period of time (month, quarter, year, YTD, etc.)
1
2
3
Measures of Profitability:
(1) Gross Profit = is each sale making money
(2) Operating Profit = core business (before one-off, non-recurring expenses, interest, etc.)
(3) Net Profit = entire business including everything (what’s left for the owners)
Direct costs (COGS) = make or deliver
Indirect costs (overhead)
Anatomy of the Balance Sheet
Retained Earnings = cumulative lifetime profitability (net profit)
Measures a point in time (single day)
Current Assets = cash or expected to turn into cash within next 12 months
Current Liabilities = expect to pay within the next 12 months
Assets = revenue-generating
Liabilities & Equity = funding sources
Fixed Assets = property, equipment, machinery, vehicles, etc. over a certain $$ amount expected to last more than a year
Anatomy of the Cash Flow Statement
Measures a period of time (month, quarter, year, YTD, etc.)
3 Sections:
(1) Operating = cash produced from core business activity (starts with profit)
(2) Investing = purchases (or sales) of long-term assets
(3) Financing = borrowings or repayments from loans; and contributions or distributions from owners
These add up to your “net change in cash” or net cash flow
Reconciles net profit and cash flow
Commonly overlooked aspects
12
Lots of time periods to choose from
Statements are related, activity in one will likely impact another
Principal payments on loans will never show up on your P&L
Owner distributions will never show up on your P&L
Depreciation is non-cash, leave it below the operating profit line
Anatomy of the P&L
13
Measures a period of time: a month, quarter, year, or year to date.
THREE MEASURES OF PROFIT
1. Gross profit
Is each sale making money?
2. Operating profit
Is the core business making money? Before one-offs and interest.
3. Net profit
Everything included. What's left for the owners.
WHERE COSTS GO
Anatomy of the balance sheet
14
Measures a single point in time: one day.
WHAT'S ON IT
Current assets
Cash, or expected to turn into cash within 12 months.
Fixed assets
Property, equipment, vehicles. Expected to last more than a year.
Current liabilities
Expected to be paid within 12 months.
Retained earnings
Cumulative lifetime profit, less distributions.
HOW TO THINK ABOUT IT
Anatomy of the cash flow statement
15
Measures a period of time and reconciles profit to cash.
THREE SECTIONS
1. Operating
Cash from core business activity. Starts with net profit.
2. Investing
Purchases or sales of long-term assets.
3. Financing
Loans, repayments, owner contributions and distributions.
WHY IT MATTERS
How it works
16
# | What happened | P&L | Balance sheet | Cash balance |
1 | We start a business with $50,000 | No impact | Cash +50k (A) / Equity +50k (E) | $50,000 |
How it works
17
# | What happened | P&L | Balance sheet | Cash balance |
1 | We start a business with $50,000 | No impact | Cash +50k (A) / Equity +50k (E) | $50,000 |
2 | Borrow $30,000 and buy a $40,000 truck | No impact | Cash +10k (A) / Truck +40k (A) / Loan +30k (L) | $40,000 |
3 | Buy $20,000 of inventory on 30-day terms | No impact | Inventory +20k (A) / Payables +20k (L) | $40,000 |
How it works
18
# | What happened | P&L | Balance sheet | Cash balance |
1 | We start a business with $50,000 | No impact | Cash +50k (A) / Equity +50k (E) | $50,000 |
2 | Borrow $30,000 and buy a $40,000 truck | No impact | Cash +10k (A) / Truck +40k (A) / Loan +30k (L) | $40,000 |
3 | Buy $20,000 of inventory on 30-day terms | No impact | Inventory +20k (A) / Payables +20k (L) | $40,000 |
4 | Sell half the inventory for $25,000 on credit | Sales +25k / COGS (10k) | Receivables +25k (A) / Inventory (10k) (A) | $40,000 |
5 | Pay $8,000 of wages and rent | Expenses (8k) | Cash (8k) (A) | $32,000 |
How it works
19
# | What happened | P&L | Balance sheet | Cash balance |
1 | We start a business with $50,000 | No impact | Cash +50k (A) / Equity +50k (E) | $50,000 |
2 | Borrow $30,000 and buy a $40,000 truck | No impact | Cash +10k (A) / Truck +40k (A) / Loan +30k (L) | $40,000 |
3 | Buy $20,000 of inventory on 30-day terms | No impact | Inventory +20k (A) / Payables +20k (L) | $40,000 |
4 | Sell half the inventory for $25,000 on credit | Sales +25k / COGS (10k) | Receivables +25k (A) / Inventory (10k) (A) | $40,000 |
5 | Pay $8,000 of wages and rent | Expenses (8k) | Cash (8k) (A) | $32,000 |
6 | Collect $25,000 from customer, pay supplier $20,000 | No impact | Cash +5k (A) / Receivables (25k) (A) / Payables (20k) (L) | $37,000 |
7 | Record $1,000 of truck depreciation | Depreciation (1k) | Truck (1k) (A) | $37,000 |
8 | Pay $3,000 loan principal, take a $2,000 owner draw | No impact | Cash (5k) (A) / Loan (3k) (L) / Equity (2k) (E) | $32,000 |
How it works
20
Ending financial statements after those 8 days
P&L
Sales
25,000
COGS
(10,000)
Gross profit
15,000
Wages and rent
(8,000)
Depreciation
(1,000)
Net profit
6,000
CASH FLOW
Collected
25,000
Cash expenses
(28,000)
Capex
(10,000)
Cash flow
(18,000)
BALANCE SHEET
Cash
32,000
Inventory
10,000
Truck, net
39,000
Loan
27,000
Equity
54,000
Assets = L + E
81,000
Loan principal
(3,000)
Distributions
(2,000)
The Monthly Financial Review
21
The Monthly Financial Review (MFR)
22
A Monthly Financial Review (MFR) in three steps.
Step 1
Prep
The right reports in the right format with the right visuals
A clean view of the numbers.
Step 2
Trends
Read across time and within each period.
Your trends tell the story.
Step 3
Scorecard
10 to 15 metrics on one page.
Your ratios tell you the health.
Step 1: Prep
23
The Right Reports
24
Every view has a use case; use them all.
View | What it shows | Use it for |
Monthly P&L | Single month data | Short-term trends (what’s happening right now) |
Rolling 12 months (TTM) | The last 12 months, updated monthly | Your primary view. Medium-term view. Smooths seasonality & lumpy revenue/expenses |
Annual P&L & B/S | Full fiscal years side by side | Long-term business and industry cycle trends |
Common-size P&L | Every line as a % of revenue | Comparing margins across periods and company sizes |
Common-size balance sheet | Every line as a % of revenue | See changes in capital intensity across periods |
The Right Format
25
From dozens of accounts down to 7 to 10 lines. Easy to read, easy to spot trends.
BEFORE
60+ accounts
Six kinds of payroll
Four kinds of insurance
Software split across five lines
...
AFTER: CONDENSED P&L ($000S, EXAMPLE)
| 2024 | 2025 | TTM Sep 26 |
Revenue | 2,400.25 | 2,650.80 | 2,880.50 |
Cost of goods sold | (1,416.10) | (1,590.35) | (1,757.18) |
Gross profit | 984.15 | 1,060.45 | 1,123.32 |
Payroll (overhead) | (420.18) | (470.25) | (530.40) |
Sales and marketing | (120.05) | (135.12) | (150.22) |
Occupancy | (96.12) | (96.15) | (120.10) |
General and admin | (108.30) | (115.40) | (125.15) |
Operating profit | 239.50 | 243.53 | 197.45 |
The Right Reports
26
From dozens of accounts down to 7 to 10 lines. Easy to read, easy to spot trends.
BEFORE
60+ accounts
Six kinds of payroll
Four kinds of insurance
Software split across five lines
...
AFTER: CONDENSED P&L ($000S, EXAMPLE)
| 2024 | 2025 | TTM Sep 26 |
Revenue | 2,400 | 2,650 | 2,880 |
Cost of goods sold | (1,416) | (1,590) | (1,757) |
Gross profit | 984 | 1,060 | 1,123 |
Payroll (overhead) | (420) | (470) | (530) |
Sales and marketing | (120) | (135) | (150) |
Occupancy | (96) | (96) | (120) |
General and admin | (108) | (115) | (125) |
Operating profit | 240 | 244 | 198 |
The Right Format
27
Take this…
And turn into this…
Make everything easier to read. Spot trends & patterns quickly.
28
Zooming out
When running a business, you need to fly around at 30,000 feet to see the big picture…
Take the plane lower to get a closer look, then land the plane to fix specific problems you’ve discovered.
The Right Visuals
Pictures make it easier to spot trends & patterns.
The Right Visuals
30
REVENUE GROWTH, YEAR OVER YEAR
FIXED COSTS, MONTHLY
Pictures make it easier to spot trends & patterns.
Step 2: Trends
31
Horizontal & vertical analysis
32
Horizontal
Left-to-right ($ & %)
Allows us to compare dollar trends, margin (%) trends, and growth rates over time (direction of business).
Vertical
Up-and-down (%)
Allows us to compare different time periods (i.e. 2019 vs. 2025) or different company sizes ($1 million revenue vs. $10 million revenue).
Horizontal & vertical analysis
33
The story: revenue increased, but now falling. Operating margins (EBITDA) continue expanding (increased efficiency), but profit dollars (EBITDA) ~flat.
Find your baseline
34
Your numbers will NOT be perfectly linear. Don’t stress over precision; instead, find your baseline performance levels.
Example: gross margin between 40% and 45%.
30%
35%
40%
45%
50%
55%
Healthy
Investigate
Investigate
Outside the range in either direction is a signal to investigate.
What to look for
35
Growth
Sales, gross profit, operating profit, net profit
Margin trends
Are you getting more or less efficient?
Operating leverage
What are the fixed cost trends?
Net working capital
Receivables, inventory, payables
Debt
How much, and is it comfortably serviced?
Cash flow
Does profit turn into cash?
Top expense accounts
What changed, and did it help or hurt?
Why is it so important to know your fixed costs?
36
Fixed vs. variable costs
37
Variable costs
Move up and down with sales.
Fixed costs
Stay about the same whatever you sell.
Fixed vs. variable costs
38
In dollar ($) terms:
In percentage (%) terms:
Why is this so powerful?
39
Profitability Across Various Sales Levels | ||||
Sales | $1.7m | $2.2m | $2.8m | $3.3m |
VC | $280k | $350k | $430k | $530k |
FC | $1.2m | $1.5m | $1.6m | $1.6m |
Profit | $190k | $350k | $770k | $1.2m |
Margin | 11% | 16% | 28% | 35% |
Operating leverage
How much is fixed?
High fixed-cost businesses grow profits at a faster rate as revenue grows
Profit also falls at a faster rate as revenue declines
Operating leverage
40
Two businesses with $1M revenue, $100K profit, and varying cost structures. What happens as sales grow?
| Variable costs | Fixed costs | Sales -10% | Today | Sales +10% |
Business A: low fixed costs | 70% | $200K | $70K (-30%) | $100K | $130K (+30%) |
Business B: high fixed costs | 30% | $600K | $30K (-70%) | $100K | $170K (+70%) |
Is your business a high fixed cost business or a low one?
Let’s practice…
41
Income statement
42
Income statement
43
Income statement
44
Income statement
45
Where’s the leak?
46
| Year 1 | Year 2 | Year 3 |
Sales | $1,520,000 | $1,670,000 | $2,160,000 |
Fixed Costs | $247,000 | $256,300 | $346,200 |
% | 16.3% | 15.3% | 16.0% |
Variable Costs | $1,200,000 | $1,336,000 | $1,760,000 |
% | 79.0% | 80.0% | 81.5% |
Leaks are always identifiable!
2.5%
x $2.2m
= $55,000
Does this business have a fixed cost or variable cost problem?
Balance sheet
47
Balance sheet
48
Balance sheet
49
Balance sheet
50
One more…
51
Income statement
52
Income statement
53
Income statement
54
Income statement
55
56
“Never forget what it is you’re trying to do.”
Charlie Munger
Find your “most important thing”
57
What are the 3 to 5 key financial factors for your company right now?
IF YOU'RE...
High debt
Watch: Liquidity and solvency
IF YOU'RE...
Growing fast
Watch: sales and marketing, efficiency, working capital
IF YOU'RE...
Unprofitable
Watch: Cost structure and breakeven point
IF YOU'RE...
Mature business
Watch: Earnings power and working capital
Step 3: Scorecard
58
The ratio scorecard
59
One pager with 10-15 “most important” metrics which measure the financial health of your business.
SAMPLE
Metric | Y1 | Y2 | Y3 | Baseline |
Revenue growth | 8.0% | 6.5% | 4.1% | 5% to 10% |
Gross margin | 41.2% | 40.5% | 39.0% | 40% to 45% |
Operating margin | 9.8% | 8.9% | 6.9% | 8% to 12% |
Current ratio | 1.8x | 1.6x | 1.5x | 1.5x to 2.0x |
Receivable days | 38 | 41 | 47 | 30 to 40 |
Debt to equity | 0.9x | 1.0x | 1.1x | Under 1.5x |
Metrics tie the statements together
60
A ratio is a relationship between two numbers, often from two different statements.
%
Percentage
Gross margin = gross profit / sales
x
Multiple
Current ratio = current assets / current liabilities
$
Dollars
Revenue per employee
d
Days
Receivable days = receivables / sales x 360
Reading a multiple: for every $1 of the bottom number, there's $X of the top number. A 2.0x current ratio means $2 of current assets for every $1 due this year.
How to build it
61
Gather your financial reports from Step 2
01
Pick your ratios
Write down your most important thing(s), then circle the 6 to 10 metrics to measure them.
02
Track monthly
Update each month and identify a normal range (baseline) for each ratio.
03
Add peer benchmarks
If available, add benchmark ratios to compare against your own.
04
Investigate issues
When ratios fall outside your baseline (or peer benchmarks), investigate for potential causes.
Which metrics to use?
Earnings power
Growing and profitable?
Sales growth
Sales ÷ last year sales
Profit growth
Profit ÷ last year profit
Gross margin
Gross profit ÷ sales
Operating margin
Operating profit ÷ sales
Contribution margin
Contribution margin ÷ sales
Net margin
Net profit before tax ÷ sales
Staying power
Can it pay bills and debt?
Current ratio
Current assets ÷ current liabilities
Quick ratio
(Cash + A/R) ÷ current liabilities
Debt to equity
Total liabilities ÷ equity
Leverage
Total liabilities ÷ operating profit
Interest coverage
Operating profit ÷ interest
DSCR
Operating profit ÷ debt service
Efficiency
Are resources productive?
Return on assets
NPBT ÷ assets
Return on equity
NPBT ÷ equity
Return on invested capital
Op. profit ÷ (debt + equity)
Asset turnover
Sales ÷ assets
Labor efficiency ratio
Gross profit ÷ direct labor
ROAS
Ad spend ÷ attributed sales
Marketing efficiency
Marketing ÷ sales
Discount rate
Discounts ÷ gross sales
Working capital
How long is cash tied up?
Receivables turnover
Credit sales ÷ receivables
Days sales outstanding
360 ÷ receivables turnover
Inventory turnover
COGS ÷ inventory
Days inventory on hand
360 ÷ inventory turnover
Payables turnover
COGS ÷ payables
Days payable outstanding
360 ÷ payables turnover
Cash conversion cycle
DSO + DOH − DPO
List of core ratios
10 metrics to start with (starter kit)
63
Not the only 10. A starter kit you'll tailor to your most important thing.
EARNINGS POWER
1 Revenue growth
2 Gross margin
3 Operating margin
LIQUIDITY AND SOLVENCY
4 Current ratio
5 Quick ratio
6 Debt to equity
WORKING CAPITAL AND EFFICIENCY
7 Receivable days
8 Inventory days
9 Payable days
10 Sales to assets
Earnings power
64
1
Revenue growth
(This period - last period) / last period
Direction of the business. Compare to inflation and your market.
2
Gross margin
Gross profit / revenue
Is each sale making money? Pricing, buying, and labor show up here first.
3
Operating margin
Operating profit / revenue
Is the core business profitable after overhead?
Liquidity and solvency
65
4
Current ratio
Current assets / current liabilities
Can you pay the next 12 months of bills? Below 1.0x is a warning.
5
Quick ratio
(Cash + receivables) / current liabilities
Same test without inventory. Can you pay bills without selling stock?
6
Debt to equity
Total liabilities / equity
Who's funding the business: lenders or owners? Higher means more risk.
Working capital and efficiency
66
7
Receivable days
Receivables / revenue x 360
How long customers take to pay you.
8
Inventory days
Inventory / COGS x 360
How long product sits before it sells.
9
Payable days
Payables / COGS x 360
How long you take to pay suppliers.
10
Sales to assets
Revenue / total assets
How hard your assets work. Revenue per $1 of assets.
Add benchmarks
67
Your history tells you if you're improving. Benchmarks tell you if you're competitive.
Industry composites
Published financial ratios by industry and company size, such as RMA Annual Statement Studies. Your banker likely has access.
Trade associations
Many publish member surveys on margins, payroll, and pricing.
Peers
Your forum and peer groups. Trade ranges, not exact numbers.
Public companies
Larger competitors file their financials. Good for direction, not size.
Building a scorecard
68
Ratio scorecard
69
LAYER 1 OF 5: ANCHOR
Start with overall performance
Scorecard | FY2023 | FY2024 | FY2025 | Mar 2026 |
Revenue | $619,000 | $700,000 | $758,000 | $769,000 |
Operating profit | ($56,300) | ($3,500) | $27,100 | $26,400 |
Net profit | ($86,300) | ($33,400) | $21,000 | $19,600 |
Ratio scorecard
70
LAYER 2 OF 5: EARNINGS POWER
Growth and profitability
Scorecard | FY2023 | FY2024 | FY2025 | Mar 2026 |
Revenue | $619,000 | $700,000 | $758,000 | $769,000 |
Operating profit | ($56,300) | ($3,500) | $27,100 | $26,400 |
Net profit | ($86,300) | ($33,400) | $21,000 | $19,600 |
Earnings power | ||||
Sales growth (YoY) | n/a | 13.1% | 8.9% | 7.4% |
Gross margin | 38.0% | 41.4% | 42.1% | 41.0% |
Operating margin | -9.1% | -0.5% | 3.6% | 3.4% |
Ratio scorecard
71
LAYER 3 OF 5: STAYING POWER
Overall balance sheet health
Scorecard | FY2023 | FY2024 | FY2025 | Mar 2026 |
Revenue | $619,000 | $700,000 | $758,000 | $769,000 |
Operating profit | ($56,300) | ($3,500) | $27,100 | $26,400 |
Net profit | ($86,300) | ($33,400) | $21,000 | $19,600 |
Earnings power | ||||
Sales growth (YoY) | n/a | 13.1% | 8.9% | 7.4% |
Gross margin | 38.0% | 41.4% | 42.1% | 41.0% |
Operating margin | -9.1% | -0.5% | 3.6% | 3.4% |
Balance sheet | ||||
Cash on hand | $47,000 | $27,900 | $19,600 | $19,200 |
Current ratio | 5.3x | 4.7x | 2.5x | 1.9x |
Loans outstanding | $130,000 | $126,800 | $102,700 | $98,400 |
Leverage | n/a | n/a | 3.8x | 3.7x |
Interest coverage | n/a | n/a | 2.7x | 2.8x |
Ratio scorecard
72
LAYER 4 OF 5: EFFICIENCY
Productivity
Scorecard | FY2023 | FY2024 | FY2025 | Mar 2026 |
Revenue | $619,000 | $700,000 | $758,000 | $769,000 |
Operating profit | ($56,300) | ($3,500) | $27,100 | $26,400 |
Net profit | ($86,300) | ($33,400) | $21,000 | $19,600 |
Earnings power | ||||
Sales growth (YoY) | n/a | 13.1% | 8.9% | 7.4% |
Gross margin | 38.0% | 41.4% | 42.1% | 41.0% |
Operating margin | -9.1% | -0.5% | 3.6% | 3.4% |
Balance sheet | ||||
Cash on hand | $47,000 | $27,900 | $19,600 | $19,200 |
Current ratio | 5.3x | 4.7x | 2.5x | 1.9x |
Loans outstanding | $130,000 | $126,800 | $102,700 | $98,400 |
Leverage | n/a | n/a | 3.8x | 3.7x |
Interest coverage | n/a | n/a | 2.7x | 2.8x |
Efficiency | ||||
Marketing efficiency | 6.7% | 4.8% | 4.8% | 5.0% |
Direct labor margin | 44.0% | 41.1% | 40.3% | 40.8% |
Indirect labor margin | 15.0% | 17.1% | 16.0% | 16.4% |
Ratio scorecard
73
LAYER 5 OF 5: COST STRUCTURE
Expense management
Scorecard | FY2023 | FY2024 | FY2025 | Mar 2026 |
Revenue | $619,000 | $700,000 | $758,000 | $769,000 |
Operating profit | ($56,300) | ($3,500) | $27,100 | $26,400 |
Net profit | ($86,300) | ($33,400) | $21,000 | $19,600 |
Earnings power | ||||
Sales growth (YoY) | n/a | 13.1% | 8.9% | 7.4% |
Gross margin | 38.0% | 41.4% | 42.1% | 41.0% |
Operating margin | -9.1% | -0.5% | 3.6% | 3.4% |
Balance sheet | ||||
Cash on hand | $47,000 | $27,900 | $19,600 | $19,200 |
Current ratio | 5.3x | 4.7x | 2.5x | 1.9x |
Loans outstanding | $130,000 | $126,800 | $102,700 | $98,400 |
Leverage | n/a | n/a | 3.8x | 3.7x |
Interest coverage | n/a | n/a | 2.7x | 2.8x |
Efficiency | ||||
Marketing efficiency | 6.7% | 4.8% | 4.8% | 5.0% |
Direct labor margin | 44.0% | 41.1% | 40.3% | 40.8% |
Indirect labor margin | 15.0% | 17.1% | 16.0% | 16.4% |
Cost structure | ||||
Fixed costs | $250,000 | $259,300 | $255,900 | $255,400 |
Breakeven | $798,700 | $709,700 | $684,800 | $710,300 |
One more
74
Eight periods of a young, fast-growing business. What story does it tell?
| P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 |
Revenue | 278,000 | 297,000 | 316,000 | 336,000 | 354,000 | 375,000 | 397,000 | 416,000 |
Operating profit | (5,500) | (3,900) | (1,800) | 3,200 | 13,200 | 19,400 | 23,900 | 22,800 |
Net profit | (22,700) | (22,300) | (14,300) | (9,700) | (7,900) | (4,900) | (3,300) | (1,200) |
Earnings power | ||||||||
Sales growth (YoY) | 118% | 91% | 87% | 95% | 91% | 131% | 128% | 119% |
Gross margin | 40% | 39% | 38% | 38% | 39% | 39% | 39% | 38% |
Operating margin | -2% | -1% | -1% | 1% | 4% | 5% | 6% | 5% |
Balance sheet | ||||||||
Cash on hand | 1,900 | 2,300 | 3,200 | 2,500 | 1,500 | 3,500 | 100 | 200 |
Loans outstanding | 35,700 | 33,000 | 33,800 | 30,800 | 31,500 | 30,200 | 48,200 | 44,700 |
Loan payments (annual) | 19,900 | 18,700 | 17,400 | 16,200 | 15,000 | 13,900 | 19,100 | 18,000 |
Efficiency | ||||||||
Labor margin (monthly) | 44% | 40% | 45% | 40% | 46% | 46% | 45% | 51% |
Marketing efficiency | 4% | 4% | 7% | 7% | 5% | 5% | 5% | 5% |
Cost structure | ||||||||
Fixed costs (monthly) | 11,400 | 10,900 | 10,600 | 11,200 | 11,100 | 10,300 | 14,700 | 13,800 |
Breakeven (annual) | 386,000 | 372,000 | 403,000 | 427,000 | 388,000 | 364,000 | 513,000 | 496,000 |
Practice
75
Case 1: Quest Resource Holding (QRHC)
76
A real public company. Nasdaq listed. Results from its SEC filings.
THE BUSINESS
YOUR JOB
QRHC P&L (2013-2016)
77
$000s, years ended December 31.
| 2013 | 2014 | 2015 | 2016 |
Revenue | 67,505 | 174,454 | 170,139 | 183,811 |
Revenue growth | n/a | n/m | (2.5%) | 8.0% |
Gross profit | 5,074 | 14,268 | 13,641 | 14,409 |
Gross margin | 7.5% | 8.2% | 8.0% | 7.8% |
SG&A | (12,661) | (14,384) | (16,300) | (18,170) |
Depreciation and amortization | (1,818) | (3,827) | (4,568) | (4,044) |
Operating profit | (12,805) | (3,943) | (7,227) | (7,805) |
Net profit | (17,799) | (9,898) | (7,446) | (8,046) |
LOOK FOR
Source: Quest Resource Holding Corp. Form 10-K for 2014, 2015 and 2016; Form 8-K for Q4 2014. 2013 includes Quest only after its July 2013 acquisition, so 2014 growth is not meaningful; 2013 operating loss also includes $3.4M of other expenses not shown. Net profit includes interest and other items.
QRHC balance sheet (2013-2016)
78
$000s, December 31.
| 2013 | 2014 | 2015 | 2016 |
Cash | 2,677 | 3,155 | 2,990 | 1,328 |
Receivables | 20,849 | 29,632 | 33,299 | 34,828 |
Total current assets | 23,931 | 33,471 | 37,235 | 38,827 |
Goodwill and intangibles | 75,974 | 73,453 | 70,165 | 66,827 |
Total assets | 100,647 | 107,677 | 109,009 | 108,069 |
Payables and accrued | 26,264 | 26,622 | 34,847 | 35,306 |
Total current liabilities | 29,290 | 32,154 | 35,176 | 35,712 |
Line of credit | 2,750 | 5,250 | 4,000 | 4,750 |
Total liabilities | 46,666 | 32,199 | 39,517 | 40,797 |
Equity | 53,981 | 75,478 | 69,492 | 67,272 |
LOOK FOR
Source: Quest Resource Holding Corp. SEC filings (Form 10-K, 10-Q, 8-K). Some smaller line items not shown, so lines won't sum exactly.
Your turn: what would you do?
79
10 minutes at your table. Be ready to share one answer for each.
Trends
What are the three most important trends?
Most important thing
If you could only fix one number, which one?
Action
What would you do in the next 12 months?
Risk
What could go wrong with your plan?
What happened next
80
Revenue fell 44% from 2016 to 2018. Gross profit went up.
Source: Quest Resource Holding Corp. SEC filings, 2014 to 2018.
QRHC scorecard (2014-2018)
81
| 2014 | 2015 | 2016 | 2017 | 2018 |
Revenue ($000s) | 174,454 | 170,139 | 183,811 | 138,346 | 103,806 |
Revenue growth | n/a | (2.5%) | 8.0% | (24.7%) | (25.0%) |
Gross margin | 8.2% | 8.0% | 7.8% | 11.4% | 16.2% |
SG&A % of revenue | 8.2% | 9.6% | 9.9% | 12.3% | 15.6% |
Operating margin | (2.3%) | (4.2%) | (4.2%) | (3.9%) | (1.9%) |
Current ratio | 1.04x | 1.06x | 1.09x | 1.29x | 1.25x |
Debt to equity | 0.43x | 0.57x | 0.61x | 0.34x | 0.35x |
Receivable days | 61 | 70 | 68 | 42 | 58 |
Payable days | 60 | 80 | 75 | 42 | 65 |
Calculated from SEC filings. Adjusted EBITDA as reported by the company: ($1.5M) in 2016, $0.8M in 2017, $2.3M in 2018. Days use a 360-day year.
Case 2: Nike today
82
$ millions, fiscal years ended May 31.
| FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
Revenue | 46,710 | 51,217 | 51,362 | 46,309 | 46,398 |
Revenue growth | 4.9% | 9.6% | 0.3% | (9.8%) | 0.2% |
Gross profit | 21,479 | 22,292 | 22,887 | 19,790 | 19,911 |
Gross margin | 46.0% | 43.5% | 44.6% | 42.7% | 42.9% |
Marketing | (3,850) | (4,060) | (4,285) | (4,689) | (4,754) |
Operating overhead | (10,954) | (12,317) | (12,291) | (11,399) | (11,360) |
Operating profit | 6,675 | 5,915 | 6,311 | 3,702 | 3,797 |
Operating margin | 14.3% | 11.5% | 12.3% | 8.0% | 8.2% |
Net income | 6,046 | 5,070 | 5,700 | 3,219 | 3,108 |
YOUR JOB
Source: NIKE, Inc. FY2023 Form 10-K; Q4 FY2025 and Q4 FY2026 earnings releases (Form 8-K). Operating profit = gross profit less demand creation and operating overhead.
Nike: condensed scorecard
83
THE TWISTS
Source: NIKE, Inc. FY2023 Form 10-K and Q4 FY2026 earnings release. Nike says a $986M IEEPA tariff recovery added about 900 basis points to Q4 gross margin. Days use a 360-day year.
| FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
Gross margin % | 46.0% | 43.5% | 44.6% | 42.7% | 40.8% |
Marketing % of revenue | 8.2% | 7.9% | 8.3% | 10.1% | 10.2% |
Current ratio | 2.63x | 2.72x | 2.40x | 2.21x | 1.96x |
Receivable days | 36 | 29 | 31 | 37 | 46 |
Inventory days | 120 | 105 | 95 | 102 | 102 |
Payable days | 48 | 36 | 36 | 47 | 49 |
Total debt ($M) | 9,420 | 8,927 | 8,903 | 7,961 | 7,942 |
Debt due within a year ($M) | 500 | 0 | 1,000 | 0 | 2,000 |
Key takeaways
84
01
Financial Operating Cycle
The flow of money through your business.
02
Monthly Financial Review
Prep, trends, scorecard. Repeat monthly.
03
Find the most important thing
3 to 5 factors that matter most right now.
04
Scorecard
10 to 15 metrics with healthy ranges.
05
Look closer
Headlines hide trends… keep asking “why” until you find the cause.
Workshop 2: Cash Flow
Up next
Colin King, CPA, CFA