Lesson 16: The Financial Plan, Part 3

How to Create a Business Plan Section 6: Building a Financial Model
9 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€64.99
List Price:  €92.84
You save:  €27.85
£55.80
List Price:  £79.72
You save:  £23.91
CA$95.74
List Price:  CA$136.78
You save:  CA$41.04
A$105.97
List Price:  A$151.39
You save:  A$45.42
S$94.71
List Price:  S$135.31
You save:  S$40.59
HK$547.38
List Price:  HK$782
You save:  HK$234.62
CHF 63.50
List Price:  CHF 90.72
You save:  CHF 27.21
NOK kr760.18
List Price:  NOK kr1,086.02
You save:  NOK kr325.83
DKK kr484.74
List Price:  DKK kr692.51
You save:  DKK kr207.77
NZ$116.49
List Price:  NZ$166.43
You save:  NZ$49.93
د.إ257.06
List Price:  د.إ367.25
You save:  د.إ110.18
৳7,679.15
List Price:  ৳10,970.69
You save:  ৳3,291.53
₹5,844.24
List Price:  ₹8,349.28
You save:  ₹2,505.03
RM331.61
List Price:  RM473.75
You save:  RM142.14
₦86,437.65
List Price:  ₦123,487.65
You save:  ₦37,050
₨19,466.20
List Price:  ₨27,810.05
You save:  ₨8,343.85
฿2,579.91
List Price:  ฿3,685.75
You save:  ฿1,105.83
₺2,258.19
List Price:  ₺3,226.13
You save:  ₺967.93
B$355.28
List Price:  B$507.56
You save:  B$152.28
R1,291.06
List Price:  R1,844.45
You save:  R553.39
Лв127.20
List Price:  Лв181.73
You save:  Лв54.52
₩95,163.27
List Price:  ₩135,953.36
You save:  ₩40,790.08
₪260.34
List Price:  ₪371.93
You save:  ₪111.59
₱4,006.12
List Price:  ₱5,723.27
You save:  ₱1,717.15
¥10,811.89
List Price:  ¥15,446.23
You save:  ¥4,634.33
MX$1,180.56
List Price:  MX$1,686.59
You save:  MX$506.03
QR255.22
List Price:  QR364.61
You save:  QR109.39
P950.05
List Price:  P1,357.27
You save:  P407.22
KSh9,308.67
List Price:  KSh13,298.67
You save:  KSh3,990
E£3,339.92
List Price:  E£4,771.52
You save:  E£1,431.60
ብር4,017.22
List Price:  ብር5,739.13
You save:  ብር1,721.91
Kz58,559.69
List Price:  Kz83,660.29
You save:  Kz25,100.60
CLP$65,083
List Price:  CLP$92,979.70
You save:  CLP$27,896.70
CN¥496.09
List Price:  CN¥708.73
You save:  CN¥212.64
RD$4,059.13
List Price:  RD$5,799
You save:  RD$1,739.87
DA9,404.13
List Price:  DA13,435.05
You save:  DA4,030.92
FJ$157.14
List Price:  FJ$224.49
You save:  FJ$67.35
Q543.86
List Price:  Q776.98
You save:  Q233.11
GY$14,638.84
List Price:  GY$20,913.53
You save:  GY$6,274.68
ISK kr9,768.50
List Price:  ISK kr13,955.60
You save:  ISK kr4,187.10
DH701.39
List Price:  DH1,002.03
You save:  DH300.64
L1,239.86
List Price:  L1,771.31
You save:  L531.44
ден4,006.46
List Price:  ден5,723.76
You save:  ден1,717.29
MOP$563.24
List Price:  MOP$804.66
You save:  MOP$241.42
N$1,288.69
List Price:  N$1,841.06
You save:  N$552.37
C$2,575.52
List Price:  C$3,679.48
You save:  C$1,103.95
रु9,351.66
List Price:  रु13,360.08
You save:  रु4,008.42
S/260.79
List Price:  S/372.58
You save:  S/111.78
K270.67
List Price:  K386.69
You save:  K116.01
SAR262.50
List Price:  SAR375.01
You save:  SAR112.51
ZK1,901.47
List Price:  ZK2,716.50
You save:  ZK815.03
L323.43
List Price:  L462.07
You save:  L138.63
Kč1,625.98
List Price:  Kč2,322.93
You save:  Kč696.95
Ft25,280.20
List Price:  Ft36,116.11
You save:  Ft10,835.91
SEK kr759.20
List Price:  SEK kr1,084.61
You save:  SEK kr325.41
ARS$61,608.98
List Price:  ARS$88,016.60
You save:  ARS$26,407.62
Bs483.53
List Price:  Bs690.78
You save:  Bs207.25
COP$273,394.26
List Price:  COP$390,579.97
You save:  COP$117,185.71
₡35,797.53
List Price:  ₡51,141.53
You save:  ₡15,343.99
L1,728.55
List Price:  L2,469.47
You save:  L740.91
₲523,227.64
List Price:  ₲747,500.10
You save:  ₲224,272.45
$U2,673.53
List Price:  $U3,819.50
You save:  $U1,145.96
zł280.44
List Price:  zł400.65
You save:  zł120.20
Already have an account? Log In

Transcript

Right Finally, let's look at the cash flow statement. So we have a number of times reinforce the importance of the difference between profitability and cash flow. And the way that cash flows in and out of the business is illustrated in this section. It's extremely important and and I can't iterate how important because we've spoken about it a number of times to understand how much cash the business might have on a month to month basis. So why is this important because this is the cash that's needed to operate the business. At the risk of seeming verbose, many profitable business businesses have cease to exist because of poor cash flow.

And the cash flow statement should be projected for at least a year in advance, and this needs to be broken down by month. This is very valuable because it allows both potential investors and you to understand what your cash position is like And how it changes during the year of operation. So let's start looking at the components of a cash flow statement. Firstly, we've got the cash received from our customers. And this is typically the amount of money that the business will physically collect from customers during the period. You need to note that this is not the sales figure or not the revenue figure.

And unless all of your sales were for cash, this won't be the same. The amount would typically be made up of cash sales from the current period, and outstanding accounts receivables collected from previous periods. So to calculate this amount, you'll need to estimate what percentage of your sales to customers will be in cash. And you'll also need to make an assumption of how long it will take you to collect the money from your customers that have bought things from you on credit terms, starting businesses or fledgling businesses or small businesses and businesses with a weekend Cash Flow needs to be very careful here as selling a large amount of credit. And taking a long time to collect this money will be disastrous for your business, it really will put you out of business. So it's an industry such as the retail industry on notorious for squeezing their supplies for long payment terms, often beyond 60 days after the sale is made.

And in these instances, it's up to you to fund the business and carry these expenses. And this is incredibly difficult for a new or a small business. We then need to look at other cash inflow and this would include things like interest received, or any kind of other cash physically coming into the business. So now that we understand the amount of cash entering the business, it's time to look at the amount of cash that leaves the business within that same period. This is things like cash paid to suppliers, and this section in your cash flow statement should contain any expenses that will be paid in cash, either for that specific month, all expenses that you've settled from previous previous month, so where you've incurred the actual expense last month, but you've bought something on credit and you're paying for this month, you need to include that amount of cash that flows out of the business.

So what's important is that you don't count any planned depreciation costs in the section. Because the depreciation expenses are really just an accounting book entry and not actual cash that leaves your business. The cashflow implication occurs when the asset is first purchased, purchased and paid for. Next is cash paid to employees and this would be any cash paid in the form of salaries, wages and bonuses. Then cash paid for other operating expenses. And in the section you would cover any cash leaving the business that's not part of cash paid to suppliers.

So this might be things like kind of petty cash use on a day to day basis for buying teas and coffees or office supplies, etc etc. Next is interest paid and this relates specifically to cash amounts. paid in the form of interest. And these should be listed here. This could be things like interest paid on overdrafts, or mortgages and long term and short term loans. Then finally, income taxes paid.

And this is the section where you specify any cash that flows out of the business that's used to pay income taxes in any form. So now that we have a summary of the total cash leaving the business, we can calculate our cash balance at the end of the month. This is as simple as taking the month's opening balance, adding to that the cash that flows in and then subtracting the cash that flows out. And this is going to give us a closing position at the end of the month, or effectively the amount of cash that we have on hand. This amount is then carried forward to the next month and it becomes the opening balance for the next month. And so it goes on a month to month basis.

So analyzing the cash flow statement, and this is going to allow you as the business owner to effectively understand where Your business might face negative cash flow, and negative cash flows where you've got more going up and you've got coming in. And when the business is likely to need funding, it's much better to know this a few months in advance rather than trying to sort your cash flow out when it stops. Let's take a look at the cash flow statement now. And while we've covered a lot of detail, it's a little simpler when when you see it up on the on the screen here, and it shouldn't be difficult to understand at all. Again, we're looking at the cash flow statement and this is for the year ending the 31st of March 2016. We will looking at cash flows that are coming into the business now in the first line, we've got our operating income.

So this is the the money that we have coming into the business. We've added back depreciation expense because remember, this is not real money flowing out the business. The money for your assets left the business when you bought them. One year, two year three years ago. So we taking the depreciation expense item from the profit loss statement and adding it back here. If we had lost any money on the sale of equipment or gained any money on the sale of land, for instance, we might include them, either add them or subtract them here, then we need to look at the increase in accounts payable.

So this means that we effectively outcasts, our suppliers more than we did in the previous period. So this has a cashflow implication, either in the sense that there's a negative or positive impact. So for example, at the beginning of the year, if we are supplies 10,000 pounds, and at the end of the year, we only owe them 8000 pounds. We've effectively had 2000 pounds flowing out the business. So this is the difference between those two. The same is true for the decreasing Accounts Payable.

So for instance, if at the beginning of the year we had 20,000 pounds out to us by customers, and at the end of the year, we only have 10,000 pounds owing to us that means we receive 10,000 pounds coming into the business. And this is what we need to list out in the section. adding these OLAP gives us in this case, subtracting these figures gives us the net cash flow from operating activities of 79,000 pounds or $79,000. Next, we need to look at the cash flowing in from investing activities. And this is typically things like money that we make from the sale of equipment, the sale of land, and money we pay out for the purchase of equipment. And in this case, you can see we've had a net cash flow out.

So that means we've we've paid $9,700 or pounds out. Next we need to look at cash flows from financing activities. So, if we pay the dividends and dividends are what was the cash flowing art? And have we made any interest payments in this case we have so another 458 pounds or dollars have flowed out the business. Yeah. Our net change in cash is simply then the difference between this figure, we subtracted this figure, subtract this figure.

And this means we have had a positive change in 69,000 pounds or dollars, which means our cash flow has grown or our cash balances grown. And this is reflected by the opening cash balance at the beginning of the year, which was only 7000 pounds of dollars. Add this to the 69,000 net effect that came in and we have a closing cash balance of 76,000 pounds or dollars when we look at this cash flow statement in the next period, Our opening cash balance will be the 76,000 pounds dollars. And we would need to apply this whole logic again to understand what our cash flow would look like for that period. So in summary, a number of examples have been provided in this section to illustrate the concept of the of the profit and loss statement, the balance sheet and the cash flow statement. Don't worry again, there are detailed templates as part of this training course that are going to help you put this all together.

And it's important to note that the combination of the profit and loss statement or income statement, the balance sheet, and the cash flow statement, really provide an effective tool to help the entrepreneur manage their business. And while these are merely informed forecasts, have no idea of what the immediate future may bring is much better than having no idea at all.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.