1 of 85

Financial Review Workshop

Colin King, CPA, CFA

2 of 85

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

3 of 85

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.

4 of 85

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

5 of 85

Reading the financials

5

6 of 85

6

"If you don't understand the accounting, you don't understand the business."

Charlie Munger

7 of 85

How to read financials

7

Assets = Liabilities + Net Worth

Sales�

Net Profit

Uses of Profits:

  1. Pay for new assets
  2. Pay off debt
  3. Pay out to owners

Efficiency

Balance Sheet

Income Statement

The Financial Operating Cycle

8 of 85

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

9 of 85

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

  • Freight
  • Materials
  • Direct labor
  • Subcontractors
  • Credit card fees

Indirect costs (overhead)

  • Sales & marketing
  • Administrative payroll
  • Rent
  • Insurance
  • Software
  • Professional fees

10 of 85

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

11 of 85

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

12 of 85

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

13 of 85

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

  • Direct costs (COGS): what it takes to make or deliver. Materials, freight, direct labor, subcontractors, card fees.
  • Indirect costs (overhead): what it takes to run the company. Admin payroll, rent, insurance, software, marketing, professional fees.

14 of 85

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

  • Assets are revenue-generating tools.
  • Liabilities and equity are how you paid for them.
  • Retained earnings is your lifetime scoreboard.

15 of 85

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

  • The three sections add up to your net change in cash.
  • It explains why profit and cash don't match.
  • We'll build a simpler version in Workshop 3.

16 of 85

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

17 of 85

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

18 of 85

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

19 of 85

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

20 of 85

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)

21 of 85

The Monthly Financial Review

21

22 of 85

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.

23 of 85

Step 1: Prep

  • The right reports
  • The right format
  • The right visuals

23

24 of 85

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

25 of 85

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

26 of 85

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

27 of 85

The Right Format

27

Take this…

And turn into this…

Make everything easier to read. Spot trends & patterns quickly.

28 of 85

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.

29 of 85

The Right Visuals

Pictures make it easier to spot trends & patterns.

30 of 85

The Right Visuals

30

REVENUE GROWTH, YEAR OVER YEAR

FIXED COSTS, MONTHLY

Pictures make it easier to spot trends & patterns.

31 of 85

Step 2: Trends

  • Horizontal & vertical analysis
  • Establish your baseline
  • Operating leverage

31

32 of 85

Horizontal & vertical analysis

32

Horizontal

Left-to-right ($ & %)

Allows us to compare dollar trends, margin (%) trends, and growth rates over time (direction of business).

  • Left & right
  • Direction

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).

  • Up & down
  • Efficiency
  • Benchmark

​

33 of 85

Horizontal & vertical analysis

33

The story: revenue increased, but now falling. Operating margins (EBITDA) continue expanding (increased efficiency), but profit dollars (EBITDA) ~flat.

34 of 85

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.

35 of 85

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?

36 of 85

Why is it so important to know your fixed costs?

36

37 of 85

Fixed vs. variable costs

37

Variable costs

Move up and down with sales.

  • Materials and freight
  • Direct labor and subcontractors
  • Sales commissions
  • Card processing fees

Fixed costs

Stay about the same whatever you sell.

  • Rent and insurance
  • Salaries and admin payroll
  • Software subscriptions
  • Loan payments

38 of 85

Fixed vs. variable costs

38

In dollar ($) terms:

In percentage (%) terms:

39 of 85

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

40 of 85

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?

  • High fixed costs magnify results (both up & down).
  • Sales growth “drops to the bottom line,” and so does a decline. Know your cost structure before scaling overhead.

41 of 85

Let’s practice…

41

42 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)

42

43 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)
  • Identify direction of gross profit and net profit

43

44 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)
  • Identify direction of gross profit and net profit
  • Which costs took biggest bite out of profitability?

44

45 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)
  • Identify direction of gross profit and net profit
  • Which costs took biggest bite out of profitability?
  • Common-sizing = different view

45

46 of 85

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?

47 of 85

Balance sheet

  • Cash flow problems?

47

48 of 85

Balance sheet

  • Cash flow problems?
  • Where did it go?

48

49 of 85

Balance sheet

  • Borrowed money to pay for assets
  • Funded growth through suppliers

49

50 of 85

Balance sheet

  • Borrowed money to pay for assets
  • Funded growth through suppliers
  • Reinvested some profits, but smaller amounts
  • No dividends 😔

50

51 of 85

One more…

51

52 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)

52

53 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)
  • Identify direction of EBITDA and net profit

53

54 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)
  • Identify direction of EBITDA and net profit
  • Which costs took biggest bite out of profitability?

54

55 of 85

Income statement

  • Identify direction of revenue (growing, declining, or stable)
  • Identify direction of EBITDA and net profit
  • Which costs took biggest bite out of profitability?
  • Common-sizing = different view

55

56 of 85

56

“Never forget what it is you’re trying to do.”

Charlie Munger

57 of 85

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

58 of 85

Step 3: Scorecard

  • Picking the right ratios
  • Using your scorecard

58

59 of 85

The ratio scorecard

59

One pager with 10-15 “most important” metrics which measure the financial health of your business.

  • Built around your “most important thing(s)”
  • Use in tandem with trends review
  • Find your baseline performance
  • Everything on a single page
  • Updated every month

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

60 of 85

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.

61 of 85

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.

62 of 85

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

63 of 85

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

64 of 85

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?

65 of 85

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.

66 of 85

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.

67 of 85

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.

68 of 85

Building a scorecard

68

69 of 85

Ratio scorecard

69

LAYER 1 OF 5: ANCHOR

Start with overall performance

  1. A high-level view of the trend in revenue and profit.
  2. Here, the trend is improving.

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

70 of 85

Ratio scorecard

70

LAYER 2 OF 5: EARNINGS POWER

Growth and profitability

  1. Is revenue growing or declining?
  2. Are profits growing or declining?

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%

71 of 85

Ratio scorecard

71

LAYER 3 OF 5: STAYING POWER

Overall balance sheet health

  1. Can you pay the bills?
  2. Can you pay the loans?
  3. How much debt is there?

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

72 of 85

Ratio scorecard

72

LAYER 4 OF 5: EFFICIENCY

Productivity

  1. Are marketing dollars working?
  2. How productive are direct and overhead employees?

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%

73 of 85

Ratio scorecard

73

LAYER 5 OF 5: COST STRUCTURE

Expense management

  1. How well are fixed costs being managed?
  2. How is breakeven changing over time?

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

74 of 85

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

75 of 85

Practice

75

76 of 85

Case 1: Quest Resource Holding (QRHC)

76

A real public company. Nasdaq listed. Results from its SEC filings.

THE BUSINESS

  • Manages waste and recycling programs for large national customers
  • Uses a network of independent vendors to do the hauling
  • Bills the customer, pays the vendor, collects a fee

YOUR JOB

  1. It's early 2017. Here are the last three years.
  2. What are the key trends?
  3. What's the most important thing?
  4. What would you do?

77 of 85

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

  • Revenue direction
  • Gross margin trend
  • Overhead vs. gross profit
  • Profit direction

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.

78 of 85

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

  • Cash trend
  • Receivables vs. payables
  • What makes up total assets
  • What's happening to equity

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.

79 of 85

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?

80 of 85

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.

81 of 85

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.

82 of 85

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

  1. What are the key trends?
  2. Which ratios worry you?
  3. What would you do?

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.

83 of 85

Nike: condensed scorecard

83

THE TWISTS

  • What trends concern you most?
  • What actions would you be taking today?
  • What does Nike need to investigate further?

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

84 of 85

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.

85 of 85

Workshop 2: Cash Flow

Up next

Colin King, CPA, CFA