Lesson 15: The Financial Plan, Part 2

How to Create a Business Plan Section 6: Building a Financial Model
10 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.98
List Price:  €92.84
You save:  €27.85
£55.64
List Price:  £79.48
You save:  £23.84
CA$95.72
List Price:  CA$136.74
You save:  CA$41.02
A$105.61
List Price:  A$150.88
You save:  A$45.27
S$94.51
List Price:  S$135.02
You save:  S$40.51
HK$546.96
List Price:  HK$781.40
You save:  HK$234.44
CHF 63.39
List Price:  CHF 90.57
You save:  CHF 27.17
NOK kr759.29
List Price:  NOK kr1,084.75
You save:  NOK kr325.45
DKK kr484.72
List Price:  DKK kr692.49
You save:  DKK kr207.76
NZ$116.27
List Price:  NZ$166.11
You save:  NZ$49.83
د.إ257.06
List Price:  د.إ367.25
You save:  د.إ110.18
৳7,668.91
List Price:  ৳10,956.06
You save:  ৳3,287.14
₹5,843.17
List Price:  ₹8,347.75
You save:  ₹2,504.57
RM331.68
List Price:  RM473.85
You save:  RM142.17
₦86,437.65
List Price:  ₦123,487.65
You save:  ₦37,050
₨19,439.77
List Price:  ₨27,772.29
You save:  ₨8,332.52
฿2,571.29
List Price:  ฿3,673.43
You save:  ฿1,102.14
₺2,259.44
List Price:  ₺3,227.91
You save:  ₺968.47
B$355.04
List Price:  B$507.22
You save:  B$152.18
R1,290.39
List Price:  R1,843.50
You save:  R553.10
Лв127.12
List Price:  Лв181.60
You save:  Лв54.48
₩94,866.43
List Price:  ₩135,529.28
You save:  ₩40,662.85
₪261.89
List Price:  ₪374.14
You save:  ₪112.25
₱3,999.98
List Price:  ₱5,714.50
You save:  ₱1,714.52
¥10,762.93
List Price:  ¥15,376.28
You save:  ¥4,613.34
MX$1,185.03
List Price:  MX$1,692.97
You save:  MX$507.94
QR254.87
List Price:  QR364.12
You save:  QR109.24
P951.97
List Price:  P1,360.02
You save:  P408.04
KSh9,396.15
List Price:  KSh13,423.65
You save:  KSh4,027.50
E£3,355.96
List Price:  E£4,794.44
You save:  E£1,438.47
ብር4,011.08
List Price:  ብር5,730.37
You save:  ብር1,719.28
Kz58,466.37
List Price:  Kz83,526.97
You save:  Kz25,060.59
CLP$65,872.48
List Price:  CLP$94,107.58
You save:  CLP$28,235.10
CN¥495.49
List Price:  CN¥707.87
You save:  CN¥212.38
RD$4,060.47
List Price:  RD$5,800.92
You save:  RD$1,740.45
DA9,414.39
List Price:  DA13,449.71
You save:  DA4,035.31
FJ$157.07
List Price:  FJ$224.39
You save:  FJ$67.32
Q543.15
List Price:  Q775.96
You save:  Q232.81
GY$14,618.48
List Price:  GY$20,884.44
You save:  GY$6,265.96
ISK kr9,767.80
List Price:  ISK kr13,954.60
You save:  ISK kr4,186.80
DH704.80
List Price:  DH1,006.90
You save:  DH302.10
L1,237.78
List Price:  L1,768.33
You save:  L530.55
ден4,001.09
List Price:  ден5,716.08
You save:  ден1,714.99
MOP$562.43
List Price:  MOP$803.50
You save:  MOP$241.07
N$1,293.49
List Price:  N$1,847.92
You save:  N$554.43
C$2,572.34
List Price:  C$3,674.94
You save:  C$1,102.59
रु9,329.91
List Price:  रु13,329.02
You save:  रु3,999.10
S/260.85
List Price:  S/372.66
You save:  S/111.80
K270.11
List Price:  K385.89
You save:  K115.77
SAR262.50
List Price:  SAR375.01
You save:  SAR112.51
ZK1,884.87
List Price:  ZK2,692.78
You save:  ZK807.91
L323.24
List Price:  L461.79
You save:  L138.55
Kč1,626.08
List Price:  Kč2,323.07
You save:  Kč696.99
Ft25,316.43
List Price:  Ft36,167.88
You save:  Ft10,851.45
SEK kr757.73
List Price:  SEK kr1,082.52
You save:  SEK kr324.79
ARS$61,503.14
List Price:  ARS$87,865.40
You save:  ARS$26,362.25
Bs483.90
List Price:  Bs691.31
You save:  Bs207.41
COP$271,944.94
List Price:  COP$388,509.43
You save:  COP$116,564.48
₡35,713.67
List Price:  ₡51,021.71
You save:  ₡15,308.04
L1,726.17
List Price:  L2,466.06
You save:  L739.89
₲523,116.65
List Price:  ₲747,341.53
You save:  ₲224,224.88
$U2,673.86
List Price:  $U3,819.97
You save:  $U1,146.10
zł281
List Price:  zł401.45
You save:  zł120.44
Already have an account? Log In

Transcript

Let's move on and take a look at the balance sheet. The balance sheet is a little trickier to complete, because when compared to the p&l, the profit and loss statement is if there's some kind of balancing involved and it's also good, it's really a good check point to ensure that everything has been accounted for. Because if you miss something, the two sides of the balance sheet are not going to balance. So the balance sheet in essence details all of the company's assets, which are the things that it owns all the company's liabilities, which are all the things that owes to others. And the equity which is essentially what's left after all the assets have been sold, outstanding money's collected and all debts paid off. Obviously, this is kind of worst case scenario.

And it's important to break the balance sheet down. Apologies it's it's not important to break the Don't you down on a monthly basis, but it should be projected forward for at least four years. Let's take a look at the components of the balance sheet. Firstly, there are current assets. These are any type of assets that are either cash or things that are easily converted to cash. So for the purposes of business planning, current assets will generally be any money that's held as cash on hand.

So like petty cash, money you have in the bank or accounts receivable, which is the money your customers, your debtors or you, it's important to consider whether or not you'll be providing credit to customers and carrying this credit for a newly established company, because this can be challenging, but again, we spoken about this isn't in an earlier example. This is particularly the case when dealing with larger organizations, especially retailers who expect up to 60 days of credit when purchasing your products and services. Ideally, you'll want to minimize the amount of credit sales in favor of cash sales, but of course, this is another possible. Just remember the key difference between profitability and cash flow. And again, this is where we contrast the differences between the income statement or profit loss statement and the balance sheet. Next is fixed assets.

And so, these are also assets. But the difference is here that they are less easy to convert into cash. And these are things like property and land, motor vehicles, manufacturing equipment and computers. Each as a top has got a limited lifetime. And this means that the asset value should reduce over time. This is indicated by depreciation and the accumulated depreciation should be subtracted from the asset purchase price to indicate the current value of the assets as presented on the balance sheet.

So, when starting up a business, it's advisable to keep the fixed assets component to a minimum because this ultimately means that you're going to have a big cash outflow to pay for assets and the more assets you have the bigger expense you're going to have on your your profit and loss statement in the terms of in terms of depreciation expenses. So, do avoid unnecessary offered office equipment and gadgets. Total Assets. This is simply the total of your current assets as we've spoken about and the fixed assets together. And these are this is presented in a single line on the balance sheet. This non competes one side of the balance sheet, and in the next section, we'll deal with how we get to the other side of the balance sheet.

In effect, the previous section describes the assets that you plan to have for use in the business. And the next section will describe how those assets are going to be used in the business. So looking at the other side of the balance sheet, this starts off with current liabilities. These are typically liabilities, things that you owe others, that the organization will be obliged to pay off in the short term and things like bank overdrafts accounts payable More money you owe suppliers. dividends payable, which has many shareholders and payroll liabilities. So things like your upcoming month in payroll or money that you're putting aside to pay for paid leave.

Some of these current liabilities might be applicable, but it's important to consider them for planning purposes. Next, let's look at long term liabilities. And these are liabilities that the organization will be obliged to pay off either over the longer term, or the more distant time in the future. And these are things like mortgages or bonds on property, long term bank loans and longer term product warranties. So for instance, if you're selling a house, if you bought a house and there's a 10 year warranty on it, he gonna need to put some money aside to cover any kind of claims against, you know, poor building quality and those sorts of things. Next is the total liabilities line and this is simply the sum of the current and long term liabilities.

Next on the balance sheet comms retained earnings, and you'll remember that when we talked about net profit in the previous section, we spoke about either distributing the profit to shareholders in the form of dividends, or the secondary option was retaining this as an amount to fund the business. So any net profit that you're planning on retaining from a current year should be carried forward from the profit and loss statement and added to any retained earnings from previous years and stated in this land on the balance sheet. Next comes common stock or owner's equity. And when starting a business, the shareholders will no doubt contributed an amount of money to the business to get it up and running. And this is the same as a loan but it indicates the owners investment in the business. And this amount should be listed here.

That might not only be the founder of the business, but it might be also shareholders that contribute money and this is where you can list this. Find the equity or total shareholders equity, and this is what is left when you subtract the total liabilities from the total assets at above zero means the organization will be solvent, which is good. And anything below zero is bad because this means the organization will be technically insolvent and unable to pay all of its bills. So calculating the equity is done simply by adding the retained earnings to the equity. Finally, then total liabilities and equity is just as it says this is the total liabilities added to the equity. So, once these two sides have been completed, the total assets should equal the total liabilities and equity.

Always, if this is not the case, then there's a miscalculation somewhere along the line. And the best place to start reconciling This is by ensuring that the retained earnings figure that you've carried forward from the profit loss statement is indeed correct. So you need to make sure, ultimately, that your revenue and your expenses are correct. And what's left at the end of the p&l statement, the bit that's carried forward. This is probably the bit that's incorrect. So I think this is going to become a little bit more clear when we look at the example.

So here we go. Again, we've got a balance sheet for the year ending 31, March 2016. And at the high level, we've got our assets listed. So we've talked about current assets are cash on hand. And our accounts receivable This is the money that customers is. This gives us total current assets of 374,000.

Next, we add on our computers. So in this example, we've paid 49,000 pounds of dollars for our computers. And over the last few years, as we've depreciated these assets, they're reduced in value by 16,000. The same holds true for office furniture and we've got a figure of 249,000 and accumulated depreciation of 49,000 pounds or dollars and Typically looks like a figure of around 20%, which means we will over a period of five years, depreciate this value to zero and this will ultimately increase. So our total fixed assets, which is the computers, minus the accumulated depreciation, plus the office furniture, minus this accumulated depreciation gives us the figure of 232,000. We then add this to the total current assets, and this gives us total assets of 607,000.

And this forms the one side of the balance sheet. Now, let's look at the other side. On the other side, we start off with the liabilities. And first we consider our current liabilities. We list out accounts payable, which is the money we owe to our suppliers with aside any other liabilities and this might be money we owe to the bank for an interest payment, or it could be money we owe to the local municipality for utilities. adding these two together give us a current liability figure of $16,000 or pounds.

Next we consider our long term liabilities. So in this instance, this might be a mortgage or a longer term loan that's payable over five or 10 years. This is 20,000. In this example, we add this to the 16,000. And this gives us a total liabilities of 36,000 pounds and $56,000. Finally, we look at the equity section.

And here we have retained earnings. And this retained earnings will be the number that's carried over from the the profit and loss statement or income statement in the previous section. And then we have a number which details the owner's equity. And this will either be the initial investment that the owners are made in the company, or that might be any profit that's retained from previous years, or it might be a combination of the two. adding these two together gives us a total equity figure out 570,000 pounds of dollars to this, then we add our total liabilities. And this gives us 607,000 pounds of dollars.

Now, this number over here, the total liabilities and equity must always equal to this total assets figure here. If it doesn't, as you said, there's a problem somewhere along line. It's typically in these numbers where these are carried forward from the profit and loss statement. And that's the first place to start looking. This is usually less of an issue when you're planning because the numbers are all of your creation. It becomes more complex when you run your business on a day to day basis, and you having to account for the actual occurrences in your business.

And this is where some way like an accountant or someone like an accountant, or accountant can help you solve these sorts of issues that this is just from a planning perspective and it's typically fairly easy to plan out

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.