Josh (Your CFO Guy) Profile picture
May 10, 2024 22 tweets 8 min read Read on X
Learn about the 3 financial statements, and how they are all connected

In just a few minutes, I'm going to teach you the most important concepts behind the Financial Statements...

and we're going to have a TON of fun along the way... Image
The 3 financial statements are:

1. The Profit & Loss
2. The Balance Sheet
3. The Statement of Cash Flows

You may also hear of the Statement of Changes in Equity, and Notes to the financial statements, but those aren't as commonly included
Before we dive into each statement...

It's important to understand the difference between:

the CASH basis
→ treats money in as income
→ money out as expenses

the ACCRUAL basis
→ treats amounts EARNED as income
→ amounts INCURRED as expenses Image
Statement #1: The Profit & Loss

Also referred to as the Income Statement

This tells you what you about your

INCOME
EXPENSES
and PROFITS

it sums up the data from the start & end date selected

Let's do a deep dive on each section 👇 Image
Revenue

This is how much you are generating in income from your customers

Under the accrual basis of accounting, this reflects the amounts EARNED by delivering your product or service

Under the cash basis, this would reflect amounts RECEIVED from customers Image
Cost of Goods Sold (COGS)

This represents the cost to produce & deliver your product or service

If you sell widgets, this would be the cost associated with producing the widget

If you sell software, this would include the cost to host your tech Image
Gross Profit

Now we get to our first profitability metric...Gross profit

Formula → Revenue - COGS

This tells you how much you are netting after each sale

The higher the gross profit, the more you can invest into all other areas of your business Image
Operating Expenses (opex)

These represent the cost to operate your business

Most common ones are payroll, rent, and sales & marketing Image
Net Operating Income

Here comes our 2nd profitability metric

Formula → Gross Profit - Opex

This shows how much is left over from your sales after subtracting out the costs to operate your business Image
Other Income / Other Expense

Now we get to our "other" items

These are income & expense items that don't relate to your core business, but still are part of your business activity

Together, they make up your net operating income

Formula → Other Income - Other Expense Image
Net Income

Here comes the grand daddy profitability metric

This shows you your total income - your total expenses

it can be shown before tax, or after tax

and this feeds into your retained earnings (more on that soon) Image
Statement #2: The Balance Sheet

Also referred to as the Statement of Financial Position

this shows you a SNAPSHOT of your business, and it's net worth

It is shown on a CUMULATIVE basis...

and is separated by:
Assets
Liabilities
Owners Equity

Let's dive into each 👇 Image
Assets

These are items of ECONOMIC VALUE (physical and intangible)

that the business OWNS

or substantially CONTROLS Image
Liabilities

These are amounts owed to CREDITORS

These creditors can be:
→ vendors (IE, you purchased something)

→ customers (IE, you owe them your product / service)

→ employees (IE, payroll)

→ owners (IE, if it's a loan) Image
Owners Equity

The final section of the balance sheet

Shows you what you owe to the OWNERS of the business based off of:

→ amounts contributed
→ prior earnings & losses not yet distributed

the key thing is that Owners Equity is UNCAPPED....

while Liabilities are CAPPED Image
3rd statement: Statement of Cash Flows

This statement has one purpose:

To tell you where your cash went

It can be presented based off of:
the DIRECT method
and the INDIRECT method

and is split between cash from:
OPERATING activities
INVESTING activities
FINANCE activities Image
Direct method vs Indirect Method

DIRECT method → easy to understand format, but is very difficult to produce

INDIRECT method → less intuitive format, but way easier to produce

Indirect method is most commonly used, and just requires your P&L and BS to produce Image
Sections of the Statement of Cash Flows

Operating → cash movements related to operating your business

Investing → cash movements from assets you've invested in long term

Financing → cash movements from debt or fundraises Image
How all 3 statements are connected

The Balance Sheet PULLS from the P&L

Net Income from P&L → goes to Retained Earnings on Balance Sheet

There are also a number of shared journal entries...

such as depreciation / accumulated depreciation (more in the infographic below) Image
The Statement of Cash Flows PULLS from both the

Balance Sheet → all accounts other than cash, accumulated depreciation / amortization, and retained earnings

Income Statement → Net Income, Depreciation, and Amortization

More details in the infographic below Image
TL;DR

The 3 statements are the:

Profit & Loss → shows your income / expenses / net profits

Balance Sheet → shows your cumulative net worth

Statement of Cash flows → shows where your cash is going

See infographic below on how they are all connected Image
𝗔𝗻𝗱 𝘁𝗵𝗮𝘁'𝘀 𝗮 𝘄𝗿𝗮𝗽! 🚩🚩

𝗠𝗮𝗻...𝘁𝗵𝗮𝘁 𝘁𝗼𝗼𝗸 𝗮 𝗟𝗢𝗡𝗚 𝘁𝗶𝗺𝗲 𝘁𝗼 𝗽𝗿𝗼𝗱𝘂𝗰𝗲

𝗜𝗳 𝘆𝗼𝘂 𝗲𝗻𝗷𝗼𝘆𝗲𝗱 𝘁𝗵𝗶𝘀, 𝗰𝗼𝗻𝘀𝗶𝗱𝗲𝗿 j𝗼𝗶𝗻𝗶𝗻𝗴 𝗺𝘆 𝗻𝗲𝘄𝘀𝗹𝗲𝘁𝘁𝗲𝗿 yourcfoguy.com/newsletter

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Josh (Your CFO Guy)

Josh (Your CFO Guy) Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @YourCFOGuy

May 22
I use these Excel functions EVERY single day in my fractional CFO work 💼

While there are hundreds of Excel functions available, there are only a select few that I use almost every day...9 to be exact.

Today, we're going to do a deep dive on these 9 functions, and how you can use them in your work too. 👇Image
➡️ SUMIFS

This one is my go-to, and is what it sounds like. It "SUMS" data in a range "IF" it meets a certain level of criteria.

For example…I'll often times condense a profit & loss into a summarized profit and loss using SUMIFS. Image
➡️ INDEX MATCH

The Dynamic Duo

It in essence combines both the Index and the Match value, allowing you to have complete flexibility over your range with dynamic inputs.

Many feel that XLOOKUP is superior, and I won't fight it - it's all a matter of personal preference! Image
Read 11 tweets
Jan 24
Dashboards are my favorite thing to create in Microsoft Excel...

and when set up correctly, they add a ton of value to a presentation

Here is how I build Dashboards using just 8 steps... Image
Step 1: Import your data

This can be anything...

but most commonly, it involves your:

1. Profit & Loss
2. Balance Sheet

from there you can get your cash flows via the indirect method

other areas to import can be revenue, headcount, and other KPIs Image
Step 2: Clean with Power Query

Before you can work with your data in a flexible & dynamic way…

it needs to be structured correctly.

That’s where Power Query comes in.

If you haven’t used Power Query….oh boy…you are missing out. Image
Read 10 tweets
Jun 22, 2024
Two elements can fund your business...

but each has their tradeoffs

𝗗𝗲𝗯𝘁 𝘃𝘀 𝗘𝗾𝘂𝗶𝘁𝘆

Learn more about them here... Image
𝗪𝗵𝗮𝘁 𝗮𝗿𝗲 𝘁𝗵𝗲𝘆?

𝗗𝗲𝗯𝘁 ➡️ Money lent by creditors who will eventually be paid back with interest

𝗘𝗾𝘂𝗶𝘁𝘆 ➡️Money invested in exchange for ownership in the company Image
𝗪𝗵𝗲𝗿𝗲 𝗱𝗼 𝘁𝗵𝗲𝘆 𝘀𝗵𝗼𝘄 𝘂𝗽?

𝗗𝗲𝗯𝘁 ➡️ On the liabilities section of the balance sheet

𝗘𝗾𝘂𝗶𝘁𝘆 ➡️On the Equity section of the balance sheet Image
Read 8 tweets
May 25, 2024
Dashboards are my favorite thing to create in Microsoft Excel...

and when set up correctly, they add a ton of value to a presentation

Here is how I build Dashboards using just 8 steps... Image
Step 1: Import your data

This can be anything...

but most commonly, it involves your:

1. Profit & Loss
2. Balance Sheet

from there you can get your cash flows via the indirect method

other areas to import can be revenue, headcount, and other KPIs Image
Step 2: Clean with Power Query

Before you can work with your data in a flexible & dynamic way…

it needs to be structured correctly.

That’s where Power Query comes in.

If you haven’t used Power Query….oh boy…you are missing out. Image
Read 10 tweets
May 24, 2024
This post contains EVERYTHING you can do in excel 😱👇

Excel continues to be the #1 tool used for Finance & Accounting professionals…

and for good reason.

With excel, there are pretty much no limits to what you can accomplish.

Let’s do a walk through it all 👀 : Image
📁 File → access & manage key areas of your workbook

This is where most people start out when they open an excel file…

here you can create a new file…open an existing file..

access a template…or access key options. Image
🏠 Home → access your clipboard, font, alignment, number format, cell styles, and filters

My favorite tools here are:

• Set paste options

• Control cell aesthetics

• Change cell format

• Formatting cells Image
Read 12 tweets
Apr 18, 2024
The ABCs of Excel 🔠

Sing along with me and learn Excel... 🎶 Image
A
Alt
Press "Alt" to access Excel's Ribbon shortcuts for quick navigation and task execution.

B
Bar Chart
One of the most popular ways to display data via a chat with an X and Y-axis

C
Conditional Formatting
Automatically formats cells based on specified criteria Image
D
Donut chart
A popular chart showing proportionate parts of a whole, with a center cutout

E
Excel
The most powerful tool on the planet

F
Function
Predefined formula that performs calculations using arguments Image
Read 12 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(