2:04
Now, the three statements, the income statement, the cash flow statement, and
the balance sheet are interrelated.
And so, for
instance, the income statement is not the same as the cash flow statement.
And the reason for
that is that under accounting conventions Income is not the same as cash.
So for instance, if you have spent cash
on inventory, that shows up on the cash flow statement but
doesn't show up anywhere on the income statement.
Because an inventory transaction isn't related to income.
So cash flow statement and income statement are not the same because
accounting, the way we do accounting in business cash is not the same as income.
Similarly, on the balance sheet,the balance sheet shows assets and
liabilities, not just cash.
So it will also show some things like debt, inventory, receivables,
shareholders equity, retained earnings.
A few other asset categories and liability categories that are not shown elsewhere.
So you really need these three distinct statements, the income statement,
the cash flow statement and the balance sheet.
These are also, as you probably know, exactly the same statements
that are used in reporting financial performance of companies and,
in particular, for public companies.
Now the questions that are answered by pro forma financial statements are these.
What do I believe this business could look like financially in the future?
And the reason that its important is you want to be able to show to yourself and
to investors what the future prospects for this business are.
And so, the pro forma financial analysis says hey, in year three,
this business could have this revenue and operate with this level of profit.
And that informs the question of, might this be a good investment,
might this company actually be quite valuable someday.
The second question the statements answer is what's
the relationship between my key performance indicators?
That is the things that I as a manager control and
the financial performance of the organization.
So for instance, it might show, what's the relationship between
the number of retailers that I've set up to sell my product and
the financial performance of the company?
The third question that's answered by the Pro Forma Financial Statements is how much
cash do I need, before I reach break-even?
So effectively, how much cash is required to support the negative cash
flow associated with the early months or years of starting up this business?
And then the last question that's answered by these statements is.
Is my operating plan that is what I say I'm going to go do over the next
months and years, is that consistent with my financial plan and
is it financially feasible?
I want to give you, use an example to illustrate the perform of financial
statements I'm a founder and
investor in a company called Belle-V Kitchen that sells kitchen products.
This is an example of a bottle opener that we sell.
And just for the sake of an example, I'm going to
imagine a company that's called Carl's Openers and we make two products.
We make a bottle opener and we also make a wine opener.
So Carl's Openers has two products: a bottle opener and a wine opener.
And I want to show you what the Pro Forma Financial Statements might look like for
that business and use it to underscore a few key points.
First thing I want to say is that you, the entrepreneur in preparing
this financial statements start with the Income Statement.
That's the place to start, so let's focus first on the Income Statement.
Now this is an example of a monthly analysis for
the first year of the business.
And so you've see it's just got 12 columns for the 12 months, and
then the last column is the annual total.
Which just sums up across the rows across the 12 months,
this is usually where you start.
And as you build the spreadsheet, you will use 36 columns,
which will be the 12 months for each of the next three years.
And then you'll provide an annual summary for each of those three years.
Let's just look at what's in the Income Statement.
The top portion of the income statement shows revenues, and
revenues are usually shown by product line or by service line.
So, in this example of Carl's openers I show,
we have two products, a bottle opener and a wine opener.
And so it shows the revenues for each of those two products separately and
then just sums them up as our total revenues.
The next category of items shown on the income statement are the cost of goods.
Sometimes known as cost of sales and sometimes referred to by the acronym
COGS which just refers to Cost of Goods Sold or COGS.
COGS are the cost that you incur in direct proportion to the number of units you sell
and usually the COGS are what you pay your supplier to provide you with the product.
What is your cost of that product?
Or what does it cost you to manufacture or deliver the service that you're providing?
Your actual cost associated with delivering a unit of product or service.
Those are your COGS, or cost of goods sold.
7:44
And of course the difference between the revenues and
the costs of goods sold is called your gross margin.
That's the difference between what you bring in and
the actual cost of providing that product, that's the gross margin.
The next category of items shown on the income statement is referred to as SG&A,
or Sales General and Administrative Costs.
And those are the things that are required to operate your business that
don't vary directly with sales.
So typical examples there would be administrative payroll, or
rent, or insurance.
Those are all things, utilities,
that don't vary directly with the quantity of product you sell.
And they're called SG&A or sales, general and administrative costs.
If you take the revenues minus the cost of goods that gives you gross margin,
gross profit.
If you subtract from that your SG&A you're left with what's called your EBITDA
which is your earnings before interest taxes depreciation and amortization.
You could think of this as your operating income before you paid the cost of
financing the business is based on the way that think about it.
And for many businesses, EBITDA is your actual earnings, for
businesses that have a lot of equipment or that have debt
It isn't exactly the same as your net income.
9:11
Usually, in your pro forma financial statements,
you will also show some ratios as a percentage.
For instance, it's usually, most people want to see what is
my gross profit percentage, or my gross margin percentage.
And that's simply the ratio of my gross profit to my revenues, and
similarly the other ratios are calculated as shown here.
The first point I want to make is to think about how to build this model, and.
As I said in the beginning, I'm not going to teach you enough about accounting
that if you know nothing about accounting you can build this financial statements.
But after you've learn some accounting,
I want to make this important point which is as you build the income statement.
You shouldn't just type the end to the income statement and
number through revenues.
Rather, you should build a spreadsheet model that calculates that
revenue based on some operating parameters of the business.
Let me give you a concrete example.
Shown here in this spreadsheet, I show revenue of $5,500 for
bottle openers for the month of January.
I shouldn't just typed in 5,500 because where does that number come from exactly?
Instead what I should do is put in some rows in that spreadsheet for
how many retailers do I expect to have in January.
How many openers do I expect to sell per store in January?
What's the average sales price of my product to that retailer?
And then I'll also have some rows for
how many units do I expect to sell directly to consumers?
Say, on my website.
What's my average direct selling price?
And I can use those five parameters to then calculate
11:01
what my total revenues are for bottle openers.
So the difference here is that if I model my spreadsheet using some
parameters that I can better understand like how many retailers do I have?
How many units do I expect to sell per retailer?
And what do I expect that average selling price to that retailer to be?
I have a more principled reason for coming up with that number, 5,500.
It's also much easier for me to modify this model.
It's also much clearer what my assumptions are.
And it links financial performance to the things that I,
as an entrepreneur, can directly control.
Like how many retailers do I have?
You do a similar thing with the cost.
What's my factory price per unit?
What's the freight per unit?
What duties do I pay per unit?
Enter those into your model to drive your cost of goods rather than just putting in
a number there that maybe you calculated on a scrap of paper.
11:59
Now of course, every business is different and
every business will have a different model that drives its revenues.
But you should think about for your business what is the fundamental logic for
where my revenues come from.
And create a spreadsheet model that uses those parameters as your input.
Not just a number that you calculate on the back of an envelope and
stick in the spreadsheet.
One of the challenges in preparing Pro Forma Financial Statements
is deciding which scenario you show.
You, of course, know that your future is uncertain.
It's very difficult to predict what your actual revenues or
costs are going to be out in year three.
And so, you have the choice when you're preparing this models of
showing a conservative scenario.
Where showing a very classic scenario, or maybe showing your expected case scenario.
And I've just going to give you my scents of correct practice in entrepreneurship.
I've been involved in 28th ventures
13:04
I've seen exactly three that have exceeded their plans significantly.
As a general rule in current practice,
entrepreneurs are optimistic, and they're optimistic in those scenarios.
The net effect of that is investors have come to expect
that your financial statements are a little bit aggressive.
There a little bit optimistic and so as a matter of practice,
I believe that most entrepreneurs show the 80th- 90th percentile outcome.
That is the scenario that is only 20% likely to play out in the future.
That tends to be what's shown in the Pro Forma Financial Statements.
Now that's not ideal, I would much prefer that entrepreneurs and
investors come to expect that maybe several scenarios that are articulated
in the Pro Forma Financial Statements.
But, it is the state of current practice,
particularly prior to the launch of the product.
Now of course as the business operates for some time the numbers have to get more and
more realistic because investors start to look for,
is the management team hitting their plan?
And so, once the business actually starts to operate and generate some revenues.
Typically, the Pro Forma Financial Statements, start to come much closer to
what management truly believes is the likely outcome for the next few periods.
15:53
And then lastly, although you probably want to provide some summary financials
in your business plan or your pitch deck that is shared with investors.
You probably benefit from just providing the pro forma financials as a separate
document.
It's usually a PDF file generated from a spreadsheet
just provide that as a separate document.
That's often the way investors expect to see it.
Lastly, let me give you some practical advice.
You do need to know some accounting, and
at a minimum, you can take an online course.
As I said, Wharton offers a great one online,
just take the accounting course because you need to understand the language of
business if you're going to be an entrepreneur.
And this is isn't enough accounting to really understand the language of
business.
You start by building the income statement and I would recommend that you the CEO,
you the entrepreneur build your own financial model, particularly for
the income statement.
I think it's important for you to understand it and
understand it at a quite detailed level.
So you should build it yourself.
Having said that, getting the balance sheet and the cash flow statement to work
properly to link those three documents is a little tricky.
If you aren't good at it, if you haven't done it before then
I would engage a partner or consultant to help you build out the full financials.
17:18
There are some very good templates available online.
One of the templates, in fact the one I used for
that example, comes from the non-profit called Score.
And you can go to the score.org website to download those spreadsheets.
There are some paid services that will automatically generate financials
from a set of assumptions.
One of them that entrepreneurs I know had used this called LivePlan.
This isn't an endorsement of LivePlan.
I'm just pointing out as one of the examples of those companies those can
generate financials automatically from some very user friendly assumptions.
In my experience, investors expect to see a true spreadsheet model.
And so, I think you might use Slide Plan to help generate those spreadsheets.
But you probably do need an actual Excel document or spreadsheet document
that contains your financials and you might need to get some help to do that.
But I do think you the entrepreneur,
you the CEO do need to create your own income statement as a way to get started.