Guidance for tables
Year 1
- When preparing these tables, it is necessary to be realistic in determining the first month in which your business will begin to operate. If in doubt, then work on the principle that it will probably take at least two months to get up and running. Your business year will then be the twelve months from that date.
- It is important that you understand that to make your financial predictions valid, you only enter any money that you expect to pay or receive in the relevant month column.
- If you resort to 'averaging' throughout the year, you will not be recognising payments and receipts that are due at a certain period of time and this could lead to a distorted picture of your financial position or at worst a negative cash flow.
>Sales mix - Tables 1 & 2
>
- The Sales Mix is a financial representation of your market research and your marketing plan. Do not attempt any other tables until you have completed first draft of the Sales Mix; the remainder of the financial work relies on the information in this document. It is also important that you complete all aspects of this table, at least for the first year, before continuing your financial planning.
- Determine what your first 'Item or Service' is to be; this will be the basic element of your business.
- In the 'Number Sold per Month' row determine whether it is to be by items, a complete service or simply an hourly rate. You should alter the title line to reflect what you have determined, ie, 'Hours per Month'.
- Put in your predictions taking note of seasonal variations, business growth and other influences such as school and other holidays, if they are likely to have an effect on your business.
- Put in your 'Selling Price' and note if it is for an item, a complete service, or per hour. If there are likely to be variances in the cost, then use one that would be applicable for the majority of work. Do remember that your predictions are for a full two years and you need to take account of inflationary trends.
- The 'Total Sales' row is simply the number multiplied by the selling price and on the disk the calculations are done automatically.
- The 'Cost of Sales' row is for the recording of any tangible costs that can be directly related to the number sold. For example, if you are building pergolas then the cost of the poles or timber that you purchase would appear here multiplied by the number sold. However, the bolts, nails and other small accessories would normally be purchased in bulk and these costs would appear as an expense item in the Cash Flow in the month that they were paid for. Similarly, if you were making farm gates then the steel and mesh would be purchased in bulk for price considerations and these would only be recorded in the Cash Flow in the month that the purchase was paid for. If you only provide an intellectual service, such as computer training then you would probably have no tangible cost to record.
- Complete any other 'Items or Service' in the same manner and with the same care.
- Add up and enter 'The Total Sales' and 'Cost of Sales'.
- If you are giving credit then determine the money value received in each month and record it in the relevant row/column. For example, if your total sales for the first month are $1,000 and you determine that 50% will be cash and 50% will be 30 days credit, then you should record $500 in the cash row for the current month and $500 in the 30 days row in the following month, etc. The Credit sales payments row is simply adding the credit receipt for each month.
- When you have COMPLETED the Sales Mix, have studied it to see if it accurately reflects what you found out from your market research and your marketing plan, then you can start working on your Schedule of Drawings, which is your personal cash flow.
>Schedules of drawings - Tables 3 & 4
>
- The Schedule of Drawings is your personal cash flow to determine how much money you require from the business to maintain a predetermined lifestyle. Remember, it is likely that you will have to make some sacrifices in the first year of setting up a successful business.
- Income
- Interest is any income that you receive from invested money or shares.
- Other income is any other money that you receive as a family unit, ie, child allowances, partner's earnings, casual work etc which is not directly associated with your business.
- Do not record any money that you intend to take out of the business. This is simply a statement of personal income and expenses totally divorced from the business finances.
- Expenses
The expenses are fairly self-evident, but you need to take care that you simply do not give an average figure.
Carefully work through all the expenses, no matter how small you initially think they might be:
- Food: If you have children you will find that your food bills go up during the school holidays. Ramadan, New Year, All-Saints-Day and Christmas are times needing greater spending.
- Powerand Gas: These are generally paid every two months and if you have a home based business which uses much of these commodities then you need to determine how much of the bill is for personal consumption and only record that amount here, the business proportion goes in the Cash Flow.
- Vehicles: If you only have one vehicle for personal and business use then determine how much you spend on fuel for personal use and record it here.
- Miscellaneous: With insurance, rates/taxes, car repairs and registration,determine the percentage used for personal and business purposes and only record the personal element here.
- The proposed drawings (from the business) are the monthly figures where the anticipated income is less than the anticipated expenses. (B-A) Only these figures should be transferred to the Cash Flow as a drawing from the business. In the months where your income is greater than your expenses you do not have to credit the business and you can 'live it up'!
- Do take care with this table as it is good practice for completing accurately the next table, the Cash Flow.
>Cash flow - Tables 5 & 6
>
- The Cash Flow records the anticipated money flow into and out of the business and, to be of use, you must be very careful to record transactions exactly when they are expected to happen.
- If you borrow money from a bank or any other source then the total amount borrowed appears here in the month it is received. If you have overdraft facilities then the outstanding amount that you owe the bank at the end of each month would appear here as well.
- The other business income only relates to activities associated with your specific business, and transactions that might be recorded here include using your specialised machinery to process work for outside sources, ie, you might have a metal folding machine on which you contract to do work for another company when the machine is free.
- Remember the rules for items which are shared personal and business and put the appropriate business proportion in the cash flow.
- In Loan repayments only record the capital element, the interest is shown in Bank interest & charges - don't forget FID, FDT and the account charges.
- In the income tax row you should record the amounts when they are likely to be due. If you have staff then they will be recorded monthly. If you decide to set aside money for tax in a separate account monthly, record it in the monthly columns. Do not forget that you may have a provisional tax liability.
- The purchase of plant and equipment needs to be planned and is dependent on the availability of funds and the urgency of the requirement; the bottom line of the cash flow will indicate when you can afford the purchase.
- The net cash flow is self-evident, it is the difference between the money in (A) and the money out (B). The opening balance is the money that you have in your account at the start of the month. If you are not borrowing any money then you will need an opening balance for the first month of operation, as you will have expenses to pay from the first moment of operation, and this will be your contribution to the business. The closing balance is the net cash flow added to the opening balance. The closing balance for the first month becomes the opening balance for the second month.
- If, when you have completed the Cash Flow you find that you have a negative cash flow in any month it means that your business is not viable at that point of time if you proceed as planned and you have to do a re-think. First, see if you can delay any purchases or payments, preferably without penalty and see if this alleviates a short term problem. If it simply retards the problem to a later month then more radical thinking is necessary. Have you access to other funds? A loan or arrange an overdraft? If it is an overdraft then the sum of the negative closing balance is added to the Bank loan column for that month. You then have to pay back the money in the next month, and so on until all that is borrowed is repaid, not forgetting to pay the interest for the overdraft in the relevant months.
- Sometimes, the actions at 28 do not resolve the problem and this then calls for a reappraisal of your sales mix in the first instance. Have you been too conservative? Is your pricing structure correct? Are there any other elements in the business type that you can become involved in and add to your income? After this, look at your personal drawings and maybe for a while only have caviar once a week!
- If these actions do not solve your problem, try talking to your accountant or business adviser for further advice.
>Profit & Loss - Tables 10A & 10B
>
- You will notice that all the figures come from the previous sheets. That is why you do not attempt to produce a P & L statement until you have completed the other tables.
Year 2
- Once you have determined that you do have a viable business at the end of Year One, it is time to start Year Two.
- In the Sales Mix take account of any expected inflationary trends. Be careful that you do not increase your output beyond your reasonable capacity. In many businesses, between the 20th and 24th month of successful operation, you may have to make a decision on where your business is heading once you reach your personal output capacity to stay at a fixed output, or if you wish to continue growth, you have to think about hiring labour or taking a partner. Both actions need a great deal of careful thought for labour brings the problems of wages and on-costs and other labour-related matters and, of course PAYE taxation. A partner needs consideration of entry capital and division of responsibilities. You may even have to consider changing the structure of the business.
- Remember, that your credit percentages from Year One continue through to Year Two.
- In the Schedule of Drawings you may not have any Government assistance and you can certainly improve your standard of living.
- The Cash Flow instructions remain the same, but remember that the closing balance for the last month of Year One becomes the opening balance for Year Two. Any repayments continue unless you intend to make other arrangements depending on your financial situation. Do not forget that you may have already paid provisional tax in the March. Following the end of the first financial year, so that will lessen your money output for a while.
- The only change in Year Two P & L is that the depreciation figure has to take account of any new purchases.