Using Financial Statements for Better Credit Decisions
Profit Mastery®
Colin King, CPA, CFA
www.profitmastery.net
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Colin King, CPA, CFA
2
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
About Profit Mastery
3
Comprehensive financial education for business owners since 1983.
1983
Founded
1M+
Alumni
40+
Years
How We Help:
Financial Training • Community • Accounting
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
My Story
4
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
My first business
In 2018, we bought our first company (parts delivery)
Operated from midnight to 10am, five days a week
Knew everything about analyzing financials, but no idea how to run them
The business turned out to be…
A complete disaster
Why?
5
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
My first business
6
Daily ops challenges
Daily people challenges
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Adding to the problems…
Which of these is easiest to understand?
7
Numbers are HARD to understand� +� Most owners are NOT accountants
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
What’s the point here?
8
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Every business needs a �Financial Operating System
9
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
What is a “Financial Operating System”
System: a set of principles or procedures according to which something is done; an organized framework or method.�
FOS: An “organized framework” strictly for the financial side of your business
10
When to look�(CADENCE)
What to do�(ACTIONS)
What to look at�(TOOLS)
Profit Zone
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Agenda
Our goals for today:
11
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
The Profit Mastery System
12
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
How a Business Works
13
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Why do you need this?
“If you don’t understand the accounting, you don’t understand the business.” � — Charlie Munger
14
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
How to Read Financial Statements
The Financial Operating Cycle
15
Assets = Liabilities + Net Worth
Revenue�
Net Profit
Uses of Net Profit:
Efficiency
Balance Sheet
Income Statement
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Financial Operating Cycle Takeaways
16
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Reviewing The Numbers
17
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
The “Financial Review”
Situation: It’s the end of the month and financials are ready; what should you do next?
Solution: This is the financial review process → basic steps/checklist for reviewing the numbers to identify actions to take. What to look at, what to look for, what to do about it.
18
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
What to do?
“All I want to know is where I’m going to die…
…so I’ll never go there.”
– Charlie Munger
19
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
3 Step Process
20
Ratio
Your ratios tell the overall health of your business
Prep
A clean view of the numbers�(mise en place)
Trend
Your trends tell the story of your business
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Step #1 → Prep
21
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Step #1 – Prep Your Financials
We need a clean view of the numbers before starting:
22
Prep → Trends → Ratios
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Condense = easy to read
23
Take this…
And turn into this…
From dozens of accounts down to 7-10
Easy to read, easy to spot trends, more reliable data
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Format and common-size
Always review multiple time periods �(year, quarter, month, etc.)
Common-sized P&L = divide by same period revenue
24
$130
$1,440
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Step #2 → Trends
25
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Looking at trends
There are 2 ways to look at trends in numbers…
26
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Horizontal & Vertical
Horizontal = left-to-right
Vertical = common-sized P&L
27
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Horizontal & Vertical
Horizontal = left-to-right
Vertical = common-sized P&L
28
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
What Should We Look For?
Consider this a trend analysis “starter kit”
29
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Let’s try it…
30
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Income Statement
Identify direction of revenue (growing, declining, or stable)
31
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Income Statement
Identify direction of revenue (growing, declining, or stable)
Identify direction of EBITDA and net profit
32
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
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?
33
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
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
34
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Where’s the leak?
Do we have a fixed cost problem or a variable cost problem here?
35
| Year 1 | Year 2 | Year 3 |
Sales | $1,520,000 | $1,670,000 | $2,160,000 |
Fixed Costs | $1,054,000 | $1,130,000 | $1,375,000 |
% | 69.3% | 67.7% | 63.7% |
Variable Costs | $263,800 | $304,200 | $450,400 |
% | 17.4% | 18.2% | 20.9% |
Leaks are always identifiable!
3.5%
(x) $2.2m
= $76,000
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Balance Sheet
Cash flow problems?
36
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Balance Sheet
Cash flow problems?
Where did it go?
37
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Balance Sheet
Borrowed money to pay for assets
38
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Balance Sheet
Borrowed money to pay for assets
Funded growth through suppliers
39
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Balance Sheet
Borrowed money to pay for assets
Funded growth through suppliers
Reinvested some profits, but smaller amounts
No dividends 😔
40
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Step #3 → Scorecard
41
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Step #3 – Ratio Scorecard
Problem: Effectively reading financials
Solution: Convert your financials into a single page with only the most important information for your business and your financial situation.
Ratio Scorecard = One-page document with key ratios for your business.
42
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
What is a Ratio?
Ratio = Relationship
Linking the financial statements
Example:
Ways we can use this:
43
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Ratios measure different areas of a business
44
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Steps
How do we build a ratio scorecard?
45
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Our Ratio Scorecard
46
Anchor your scorecard with overall financial performance at the top…
Gives us a high level view of TRENDS (sales, gross profit, net profit) over several years.
Trend = increasing
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Our Ratio Scorecard
47
Growth trends are next:
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Our Ratio Scorecard
48
A complete picture of margins covering different parts of the business:
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Our Ratio Scorecard
49
Staying power metrics track our total debt & ability to pay
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Our Ratio Scorecard
50
Efficiency ratios measuring the entire business, marketing spend, and people:
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
A Completed Scorecard
51
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Fine Tuning…
Add charts and visuals to spot trends easier (pictures > numbers)
52
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Smoothing results
If results are lumpy or seasonal, then try “rolling” metrics
53
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Recap
54
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
Key Takeaways
55
Financial Operating Cycle – flow of money in your business
Prep Financials – condense & common-size the data
Review Trends – lagging view of business trends & performance
Ratio Scorecard – key metrics to measure financial health & trends
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Questions?
gsb.org
Educating Professionals, Creating Leaders
gsb.org
Educating Professionals, Creating Leaders