Week 05

25 Finance & Accounting Templates

Josh Aharonoff

Apr 6, 2023

Welcome to this weeks edition of CFO insights - it’s great to have you here!

Each week I share Finance & Accounting content geared to help you grow in your career, and understand more about business.

If we haven’t already connected - I’d love to hear from you! Simply send an email with a hi 👋

What we’ll be covering in this edition:

25 Finance & Accounting templates
130+ MEGA guide on Startups & Fundraising
Everything you need to know about EBITDA
Understand Financial Statements in less than 2 minutes
Free Accounting 101 Course

OK, let’s begin!

I'm giving away a compilation of all the templates I've created over the last 18 months, which includes many that will be part of courses I'll charge $100s for.

It's hard to believe, but for the next 7 days, they are all free.

1 Startup Dashboard: https://lnkd.in/dddH2yJs

2 Reconcile Deferred Revenue in 43 characters: https://lnkd.in/dcjyH32G

3 Chart of Accounts: https://lnkd.in/d5edWWnu

4 Budget vs Actuals: https://lnkd.in/dGH63FWa

5 Forecast Headcount: https://lnkd.in/dGF3zmqT

6 Break Even Point: https://lnkd.in/dMqb8MqS

7 Forecast cash flows: https://lnkd.in/diUpCgfU

8 Build a 3 statement model: https://lnkd.in/dD2q5vCT

9 The 3 financial statements: https://lnkd.in/dqZbrBa5

10 Month over Month Dashboard: https://lnkd.in/dCXUkuHy

11 Management Reporting Dashboard: https://lnkd.in/dnFP2kA7

12 Retained Earnings: https://lnkd.in/dt59ShR8

13 Gross Profit & Gross Margin: https://lnkd.in/d74aXQb2

14 10 CEO KPIs dashboard: https://lnkd.in/dD5jnfmd

15 Forecast revenue with sales reps: https://lnkd.in/dQ69gjk6

16 Forecast revenue with digital marketing: https://lnkd.in/dK2PYVqx

17 Create a revenue waterfall: https://lnkd.in/dFfX7FgQ

18 Forecast SaaS MRR & ARR: https://lnkd.in/dqGYC-Hn

19 100 Excel Shortcuts: https://lnkd.in/dauhpmhA

20 Startup Pitch Deck: https://lnkd.in/d72auvzb

21 Cash out Dashboard: https://lnkd.in/dcyd5Vfi

22 Scenario Planning & Analysis: https://lnkd.in/dxZcY8KK

23 MRR Dashboard: https://lnkd.in/d8Te8-Ag

24 Calculate Depreciation - (click the image below to download)

25 Startup Board Reporting - (click the image below to download)

Get a copy of this excel file with the linkedin posts + download pages by clicking the image below

This comprehensive guide encompasses nearly all my knowledge on Startups and Fundraising.

It took me countless hours to curate this content, with the sole purpose of helping you gain a deep understanding of how startups function and how to secure capital from investors.

Here's what you can expect to learn from this guide:

➡️ How VC Works

◼️ How do startups get funding?

▪️ Founders

▪️ Friends & Family

▪️ Angel Investors

▪️ Venture Capitalists (VCs)

▪️ Other Lenders)

◼️ How do Startup Funding Stages Work?

▪️ Early Stage

▪️ Mid / Growth Stage

▪️ Late Stage

▪️ Bridge Round

▪️ IPO / Exit

➡️ How to raise capital

◼️ How to prepare a pitch deck

▪️ What are startup pitch decks?

▪️ What’s commonly included in a startup pitch deck?

◼️ How to Raise Capital with Proper Finance & Accounting

▪️ What Does the Fundraising Process look like?

▪️ Commonly Requested Finance & Accounting Materials

◼️ Top 10 VC Metrics

▪️ MRR / ARR

▪ ️ACV / ARPU

▪ ️CAC

▪ ️LTV

▪ ️CAC Payback

▪️ Churn

▪ ️Net Dollar Retention

▪ ️Cash Burn

▪ ️Expansion / Contraction

▪️ Gross Profit

Click the image below to be taken to the guide

EBITDA just may be the 6 sexiest letters in Finance & Accounting

There is so much emphasis on this metric, yet it is so often misunderstood

Let's start with:

➡ What is EBITDA?

EBITDA's literal definition is

Earnings

Before

Interest

Taxes

Depreciation

Amortization

➡ How is EBITDA calculated?

Like the name implies..

Take your net income

[+] Interest Expenses

[-] Interest Income

[+] Taxes

[+] Depreciation & Amortization

➡ Why is EBITDA so important?

Well.. a number of reasons...the 2 biggest being:

1️⃣ EBITDA is commonly used to value businesses

2️⃣ EBITDA is commonly referenced on a number of ratios

➡️ What are some common misconceptions with EBITDA?

1️⃣ EBITDA is not a GAAP metric

That’s right…for that reason, you won’t find it on a profit and loss

2️⃣ EBITDA does not equate to cash flows

Your cash flows can wildly differ from period to another when compared to EBITDA, depending on how things like accounts receivable / payable, and fixed assets come into the mix (to name a few)

3️⃣ EBITDA is not the same as net operating income

While in many cases these 2 items may be the same, for some companies, it can differ

An example can be if a Fixed Asset is necessary in order to carry our revenue, in which case Depreciation would be included in cost of goods sold

Those are just a few things to note about EBITDA - there is so much more to it

Click the image below to be taken to the guide

📄 Income Statement

💡This shows you what you’re earning vs what you are consuming

Revenue ➡️ this is what you’re earning

COGS ➡️ this is what it costs to carry out your revenue

Gross Profit ➡️ this is what your net earnings are on each sale

Operating Expenses ➡️this is all other expenses that related to the business, but aren’t related to COGS

Net operating income ➡️ this is what you’re net earnings are after subtracting out your operating expenses

Net other income ➡️ this represents additional earnings / expenses not related to your core business

Net income ➡️ this is what’s leftover after all expenses are subtracted from all earnings

📄Balance Sheet

💡 This shows you the net worth of your company

Assets ➡️ this represents the economic value you possess

Liabilities ➡️ this is what you owe creditors and are CAPPED

Owners equity ➡️ this is what you owe to owners and is UNCAPPED

How it’s connected 🔄 via an account called Retained Earnings, which comes from the income statement

📄 Statement of Cash flows

💡This shows you how your cash is moving

Cash from operating activities ➡️ this shows the cash impact from your current assets & liabilities

Cash from investing activities ➡️ this shows the cash impact from your long term assets & liabilities

Cash from Financing activities ➡️ this shows the cash impact from all debt / equity transactions

How it’s connected 🔄 it pulls net income from the income statement, and the ▲ in balance sheet accounts (under the indirect method)

That’s my take on the financial statements - what would you add?

PS: If you enjoyed this, you’ll love my course on intro to 3 statement modeling where we build each of these statements, and learn how to forecast with each. Check out the link in my profile to learn more

Click the image below to watch the complete video on TikTok