FINANCIAL SECTION OF YOUR BUSINESS PLAN
The Financial Section, in many cases, is the most scrutinized section of your business plan. In short, it provides details on how potentially profitable the business will be, how much debt and equity capital is required for the business venture, when debts are scheduled to be repaid to investors, your financial statement forecasts, and the assumptions made when creating your financial projections.
The Financial Section of your business plan relies on Forecasted Financial Statements. Forecasted financial statements help an entrepreneur determine the feasibility of his/her business venture and help to estimate the amount of money an entrepreneur will need in order to successfully launch and operate the proposed endeavor. In addition, these statement help investors in determining the plan's feasibility and its potential profitability. It is for these reasons that many refer the financial section as the "heart of a business plan". All other sections of the plan (operations section, management section, marketing section, etc) show an investor whether or not an entrepreneurs' financial projections can materialize as envisioned.
The financial section of the business plan can be developed by you or an accountant. At any rate, the structure of the financial section generally includes the following items;
Below further explains each of the above components; beginning with the "Introduction to the Financial Plan".
PART A. - INTRODUCTION TO THE FINANCIAL PLAN
The Financial section of your business plan will begin with an introduction to the Financial Plan. The actual structure and details provided in the introduction is left up to the entrepreneur. Moreover, some entrepreneurs (business plan writers) feel its imperative to give the reader a quick summary of each forecasted statement, while others only tell the reader how the financial plan section has been organized. The following example of an Introduction to the Financial Plan supports the latter.
Example of J&B Incorporated's Introduction to the Financial Plan
INTRODUCTION TO THE FINANCIAL PLAN
The Financial Plan outlines J&B's forecasted financial statements and the assumptions made when developing them. The Company's capital requirements, how the capital is to be used and our repayment plan is also illustrated here.
The following financial statements and analysis have been forecasted over a three year period.
Income Statements |
Balance Sheets |
Cash Flow Statements |
Break-Even Analysis |
Sensitivity Analysis |
Ratio Analysis |
The above financial statements assume that the Product Development Phase will begin January 1, 1998 and end on April 30, 1998. In May, J&B will begin its operations. The fiscal year end has been set for April 30 so that a full year of operation can be shown each year for the three year forecasted period.
Following the forecasted statements and analysis are "Notes to the Financial Statements". These Notes explain how we arrived at the account balances.
Notice, the above example tells the reader what he/she is expected to see under the Financial Plan. It does not go into details on how the Company plans to repay its debt nor how it will obtain its start-up capital. Rather the Introduction suggests that readers refer to the "Notes to the Financial Statements" for further information. If your Notes to the Financial Statements do not fully explain the "higher points" of your forecasted income statement, balance sheet, your loan repayment schedule, capital requirements, or how the capital will be used, we suggest you develop a in-depth Introduction. On the other end of the continuum, if your notes to the financial statements fully explain these items, you may elect to develop and Introduction similar to J&B Incorporated.
PART B FORECASTED FINANCIAL STATEMENTS
The next part of the Financial Plan is the Forecasted Financial Statements. You will include the following forecasted statements and analysis in your Financial Plan.
Three Year Forecasted Income Statements |
Three Year Forecasted Balance Sheets |
Three Year Forecasted Cash Flow statements |
Three Year Break-even Analysis |
Three Year Sensitivity Analysis |
Three Year Ratio Analysis |
Below briefly explains the above statements and analysis and depicts how each should appear in Part B of your Financial Plan.
1. - THE FORECASTED INCOME STATEMENT
The first statement appearing in the financial plan is your Forecasted Income Statement. An Income Statement is a financial tool used to determine whether a company earned a profit or incurred a loss within a given time frame. An income statement is developed by listing all revenues (sales) within a specific time frame, listing all expenses within the same time frame and subtracting the expenses from the revenues to arrive at Earnings Before Taxes (EBT) for that time frame. Income taxes are then calculated and subtracted from earnings before taxes to arrive at a company's Net Income after taxes or what many people refer to as - THE BOTTOM LINE.
If you plan to open a new business or plan on expanding an existing one, you will not have actual revenues or expenses. In this case, you will be required to anticipate (forecast) revenues and expenses over a one year period, for a minimum of three years. In other words, you will have to construct what is known as an annual forecasted income statement for three years. The forecasted Income statement will show investors such as banks, governments, and private entities if and when your business plans to make a profit.
The forecasted income statements for three years should appear on One Page. Moreover, the one page will consist of three columns - one column for your first year forecasted income statement, one column for the second year forecasted income statement, and one column for your third year forecasted income statement. Below provides an example of how your forecasted incomes should appear.
J&B INCORPORATED FORECASTED INCOME STATEMENT FOR YEARS ENDING | |||
Ending April 1999 * |
Ending April 2000 |
Ending April 2001 |
|
Total Revenue from Sales (note 1) | $582,401 | $673,775 | $784,411 |
Cost of Goods Sold (note 2) | $130,191 | $146,378 | $152,846 |
GROSS MARGIN ** | $452,210 | $527,397 | $631,566 |
OPERATING EXPENSES: | |||
Advertising Expense (note 3) | $130,000 | $150,000 | $170,000 |
Wages & Employee Benefits (note 4) | $122,366 | $136,153 | $167,421 |
Casual Labor (note 5) | $ 2,400 | $ 3,000 | $ 3,600 |
Office Supplies (note 6) | $ 1,500 | $ 1,715 | $ 1,908 |
Rent Expense (note 7) | $ 12,000 | $ 12,600 | $ 13,230 |
Telephone/Fax Expense (note 8) | $ 3,600 | $ 3,840 | $ 4,080 |
Professional Services (note 9) | $ 7,000 | $ 3,500 | $ 4,000 |
Insurance Expenses (note 10) | $ 1,500 | $ 1,650 | $ 1,815 |
Toll-free Charges above Variable Cost (note 11) | $ 15,685 | $ 20,706 | $ 25,408 |
Bad Debt Expense (note 12) | $ 5,824 | $ 6,738 | $ 7,844 |
Interest on Operating Loan (note 13) | $ 2,000 | $ nil | $ nil |
Internet Storage & Accounts Expense (note 14) | $ 2,550 | $ 2,700 | $ 2,865 |
Miscellaneous Expenses (note 15) | $ 2,400 | $ 2,600 | $ 2,800 |
Depreciation Expense - Equipment (note 16) | $ 3,142 | $ 4,392 | $ 6,392 |
Depreciation Expense- Furniture (note 17) | $ 606 | $ 906 | $ 1,306 |
Amortization of Initial Development Costs (note 18) | $ 15,924 | $ 15,924 | $ 15,924 |
Amortization of Future Development Costs (note 19) | $ 24,720 | $ 55,215 | $ 86,575 |
TOTAL OPERATING EXPENSES ** | $353,218 | $421,638 | $515,168 |
Net Income Before Taxes | $ 98,992 | $105,759 | $116,397 |
Less: Taxes (note 20) | $ 29,698 | $ 31,728 | $ 34,919 |
NET INCOME AFTER TAXES | $ 69,294 | $ 74,032 | $ 81,478 |
* Ending April 1999 refers to J&B's forecasted revenues and expenses from April 1998 to April 1999. It does not however, include the expected expenses incurred during the product's five month development phase. For further information regarding the Company's Initial Development Costs, please refer to NOTE 18. | |||
** Numbers are rounded |
Notice after each account item that a note and a number is stated. These numbers refer to the Notes to the Financial Statements and allows readers (investors) the opportunity to see how J&B arrived at each account balance or value. This will become more apparent later on as we discuss Part C of the Financial Plan entitled "Notes to the Forecasted Financial Statements".
Also, notice J&B's three year Forecasted Income Statement is one page in length. The revenue and expense "items" are listed on the left hand side, while each year's forecasted revenues and expenses ("values") are shown in a column to the right. Your forecasted income statement for a three year period should appear in a similar fashion. Moreover, it is more professional and investors can compare your expected revenue and expense projections from year to year.
This concludes our discussion on how your forecasted income statements should appear in your Financial Plan. Remember it is imperative to understand the theory behind the income statement before attempting to forecast your own. To learn more about this statement, please refer to the section entitled "The Income Statement". When you understand the theory behind each financial statement and analysis, you will be equipped with the tools necessary tools needed in Forecasting Your Own Forecasted Financial Statements.
2. THE FORECASTED BALANCE SHEETS
The next statement to appear in the financial plan is your Forecasted Balance Sheets. Three, annual (year end) Forecasted Balance Sheets should follow your three year projected income statements. These forecasted balance sheets show investors the items your business anticipates to own at the beginning and end of each forecasted year. In addition, these statements will show investors how much your business anticipates to owe at the beginning and end of each forecasted period. By developing a forecasted annual balance sheet for three years into the future, you and investors will be able to determine if your proposed business provides an opportunity (IE profitable).
In addition to the three year forecasted balance sheets, investors will want to see an opening balance sheet. An opening balance sheet generally shows the businesses' assets, liabilities, and owner's investments into the business.
The three year forecasted balance sheets should be placed on one page. Moreover, the one page will consist of four columns - one column for your opening balance sheet, one column for the first year forecasted balance sheet, one column for the second year forecasted balance sheet, and one column for your third year forecasted balance sheet. Below provides an example of J&B Incorporated's forecasted Balance Sheet.
J&B Incorporated Forecasted Balance Sheets Ending April 30 | ||||
April | April | April | April | |
1998 * | 1999 ** | 2000 | 2001 | |
CURRENT ASSETS: | ||||
Ending Cash (note 21) | $ 63,314 | $ 57,608 | $ 61,968 | $ 94,091 |
Office Supplies (note 6) | $ 0 | $ 500 | $ 735 | $ 476 |
Finished Diskette Inventory (note 2) | $ 0 | $ 6,683 | $ 2,803 | $ 1,790 |
Finished CD Inventory (note 2) | $ 0 | $ 3,103 | $ 2,072 | $ 2,053 |
Total Current Assets | $ 63,314 | $ 67,894 | $67,578 | $ 98,410 |
FIXED ASSETS: | ||||
Net Computer Equipment (note 16) | $ 7,602 | $ 9,426 | $ 10,034 | $ 11,642 |
Net Office Furniture (note 17) | $ 1,412 | $ 2,425 | $ 3,018 | $ 3,712 |
Net Intangible - Initial R&D (note 18) | $ 47,772 | $ 31,848 | $ 15,924 | $ 0 |
Net Intangible - Future R&D (note 19) | $ 0 | $ 74,161 | $140,923 | $179,789 |
Total Fixed Assets | $ 56,786 | $117,860 | $169,900 | $195,143 |
TOTAL ASSETS | $120,100 | $185,753 | $237,477 | $293,553 |
LIABILITIES: | ||||
Accounts Payable (note 22) | $ 0 | $ 4,975 | $ 5,274 | $ 6,394 |
Wages & Employee Benefits (note 23) | $ 0 | $ 1,686 | $ 2,049 | $ 2,336 |
Operating Loan Payable (note 13) | $20,000 | $ 0 | $ 0 | $ 0 |
Taxes Payable (note 20) | $ 0 | $ 29,698 | $ 31,728 | $ 34,919 |
TOTAL LIABILITIES | $20,000 | $ 36,359 | $ 39,051 | $ 43,649 |
SHAREHOLDER'S EQUITY: | ||||
100 Class A Common Shares(note 24) | $ 100 | $ 100 | $ 100 | $ 100 |
50 Class B Common Shares (note 24) | $100,000 | $100,000 | $100,000 | $100,000 |
Retained Earnings (note 25) | $ 0 | $ 49,294 | $ 98,326 | $149,804 |
TOTAL SHAREHOLDER'S EQUITY | $100,100 | $149,394 | $198,426 | $249,904 |
TOTAL LIABILITIES & EQUITY | $120,100 | $185,753 | $237,477 | $293,553 |
* April 30, 1998 represents the forecasted account balances at the end of the product's development phase. | ||||
** April 30, 1999 represents the forecasted account balances at the end of the company's first year of operation. |
Notice J&B's three year Forecasted Balance is one page in length. The Asset, Liability, and Equity "items" are listed on the left hand side, while each year's forecasted account balances (values) are shown in a column to the right. Your forecasted balance sheet for a year three period should appear in a similar fashion. It is more tidy and investors can compare your expected financial position from year to year.
Also, notice after each account item that a note and a number is stated. These numbers refer to the Notes to the Financial Statements and allows readers (investors) the opportunity to see how J&B arrived at each account balance or value. This will become more apparent later on as we discuss Part C of the Financial Plan entitled "Notes to the Forecasted Financial Statements".
This concludes our discussion on how your projected balance sheet should appear in your Financial Plan. Remember it is imperative to understand the theory behind the Balance Sheet before attempting to forecast your own. To learn more about this statement, please refer to the section entitled "The Balance Sheet". When you understand the theory behind each financial statement and analysis, you will be equipped with the tools necessary tools needed in Forecasting Your Own Forecasted Financial Statements.
3. FORECASTED CASH FLOW STATEMENTS
The next statement to appear in the financial plan is your Forecasted Cash-flow Statements. The Cash Flow Statement is a tool used to forecast the movement of cash into and out-off the business. The movement of cash into a company may result from sales to customers, cash from investors, cash from bank loans, cash from the owners, cash from interest earned, cash from commission sales, or from any other source that provides cash to the business. The movement of cash out-off the company might include items such as advertising, wages and salaries, inventory purchases, payment on taxes, payment on business loans, utilities, owner withdrawals, rent, dividends, and so on.
Without the necessary cash, a business will not survive. Therefore, a forecasted cash flow statement is constructed to determine if an entrepreneur's business will have enough cash to carry out the day to day (month to month) operations.
A cash flow statement can be organized on a daily, weekly, monthly or quarterly bases. Most bankers and other investors, however, prefer see a monthly cash flow statement for a three year period. In other words, you will be required to develop three forecasted cashflow statements, each consisting of a twelve month period.
This may seem overwhelming at first, but with the aid of a spreadsheet program such as Lotus 123 or Excel, the task becomes rather simple. If you do not have a spreadsheet program, you are advised to purchase one and learn how it operates - It is an invaluable business tool that will save you lots of time and money. Below provides an example of J&B's forecasted cashflow statement for a three year period. (please note: normally each annual cashflow statement is constructed in a spreadsheet program and consist of a twelve month forecasted period. Due to the margins of this program, we are unable to place twelve columns on one page. As a result, we have used two pages for each year to illustrate J&B's annual forecasted cash flow statement).
J&B INCORPORATED CASH FLOW STATEMENT MAY 1, 1998 - NOVEMBER 30, 1998 |
|||||||
ASSUMPTIONS: | MAY | JUNE | JULY | AUG. | SEPT. | OCT. | NOV. |
Percentage of Sales (per month) | 3% | 3% | 8% | 8% | 9% | 9% | 10% |
Total Unit Sales/ Month) | 236 | 236 | 631 | 631 | 709 | 709 | 788 |
Diskette Sales (note 26) | 142 | 142 | 378 | 378 | 426 | 426 | 473 |
CD Sales (note 26) | 83 | 83 | 221 | 221 | 248 | 248 | 276 |
Internet Sales (note 26) | 12 | 12 | 32 | 32 | 35 | 35 | 39 |
Weighed Average Selling Price (1) | $73.89 | $73.89 | $73.89 | $73.89 | $73.89 | $73.89 | $73.89 |
CASH INFLOWS: | |||||||
Cash From Product Sales (100%) | $17,472 | $17,472 | $46,592 | $46,592 | $52,416 | $52,416 | $58,240 |
Less: Bad Debt Expense (1%) | $ 175 | $ 175 | $ 466 | $ 466 | $ 524 | $ 524 | $ 582 |
NET CASH INFLOWS | $17,297 | $17,297 | $46,126 | $46,126 | $51,892 | $51,892 | $57,658 |
CASH OUTFLOWS: | |||||||
Purchase of Diskettes (note 27 a) | $8,670 | $ 0 | $ 0 | $ 8,670 | $ 0 | $ 8,670 | $ 0 |
Purchase of CD (note 27 b) | $2,500 | $ 0 | $ 0 | $ 0 | $ 2,500 | $ 0 | $ 0 |
Credit Card Charges (note 27 c) | $ 877 | $ 877 | $ 2,339 | $ 2,339 | $ 2,632 | $ 2,632 | $ 2,924 |
Packaging Charges (note 27 d) | $ 130 | $ 130 | $ 347 | $ 347 | $ 391 | $ 391 | $ 434 |
Actual Shipping Charges (note 27 e) | $ 636 | $ 636 | $ 1,696 | $ 1,696 | $ 1,908 | $ 1,908 | $ 2,120 |
Toll Free Charges (note 27 f) | $ 0 | $ 471 | $ 471 | $ 1,255 | $ 1,255 | $ 1,412 | $ 1,412 |
Commission on Sales (note 27 g) | $ 0 | $ 236 | $ 236 | $ 631 | $ 631 | $ 709 | $ 709 |
Product Miscellaneous (note 27 h) | $ 118 | $ 118 | $ 315 | $ 315 | $ 355 | $ 355 | $ 394 |
Advertising | $5,000 | $5,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
Wages & Employee Benefits | $6,217 | $6,900 | $10,464 | $10,857 | $10,857 | $10,857 | $10,857 |
Research & Development | $7,630 | $8,240 | $ 8,240 | $ 8,240 | $ 8,240 | $ 8,240 | $ 8,240 |
Casual Labor | $ 0 | $ 0 | $ 0 | $ 800 | $ 0 | $ 0 | $ 0 |
Office Supplies | $ 0 | $ 500 | $ 0 | $ 0 | $ 500 | $ 0 | $ 0 |
Rent | $1,000 | $1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 1,000 |
Telephone/Fax | $ 0 | $ 300 | $ 300 | $ 300 | $ 300 | $ 300 | $ 300 |
Professional Services | $ 0 | $2,250 | $ 2,250 | $ 250 | $ 250 | $ 250 | $ 250 |
Business Insurance | $1,500 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Toll-free Charges above Variable | $ 0 | $ 471 | $ 471 | $ 1,255 | $ 1,255 | $ 1,412 | $ 1,412 |
Miscellaneous Charges | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 |
Office Furniture | $1,618 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Office Equipment | $4,966 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Payment on Operating Loan | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Interest on Loan | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Internet Storage and Accounts | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 | $ 150 |
Dividends Paid (note 28) | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $20,000 |
TOTAL CASH OUTFLOWS | $41,213 | $27,480 | $40,480 | $50,305 | $44,422 | $50,485 | $62,402 |
Net Cash Flow (Deficiency) | $-23,915 | $-10,183 | $5,646 | $-4,179 | $7,470 | $1,407 | $-4,744 |
Beginning Cash Balance (note 21) | $63,314 | $39,398 | $29,216 | $34,862 | $30,683 | $38,153 | $39,560 |
ENDING CASH BALANCE | $39,398 | $29,216 | $34,862 | $30,683 | $38,153 | $39,560 | $34,816 |
The remaining five (5) months of J&B's first year Forecasted Cashflow Statement is presented below. Recall this is not the correct format - the first year cashflow statement should be developed in a spreadsheet program and should appear on one page.
J&B INCORPORATED CASH FLOW STATEMENT DECEMBER 1, 1998 - APRIL 30, 1999 | ||||||
ASSUMPTIONS: | DEC. | JAN | FEB. | MARCH | APRIL | TOTALS |
Percentage of Total Sales (per month) | 10% | 10% | 10% | 10% | 10% | 100% |
Total Unit Sales/ Month) | 788 | 788 | 788 | 788 | 788 | 7,882 |
Diskette Sales (note 26) | 473 | 473 | 473 | 473 | 473 | 4729 |
CD Sales (note 26) | 276 | 276 | 276 | 276 | 276 | 2,759 |
Internet Sales (note 26) | 39 | 39 | 39 | 39 | 39 | 394 |
Weighed Average Selling Price (note 1) | $73.89 | $73.89 | $73.89 | $73.89 | $73.89 | |
CASH INFLOWS: | ||||||
Cash From Product Sales (100%) | $58,240 | $58,240 | $58,240 | $58,240 | $58,240 | $582,401 |
Less: Bad Debt Expense (1%) | $ 582 | $ 582 | $ 582 | $ 582 | $ 582 | $ 5,824 |
NET CASH INFLOWS | $57,658 | $57,658 | $57,658 | $57,658 | $57,658 | $576,577 |
CASH OUTFLOWS: | ||||||
Purchase of Diskettes (note 27 a) | $ 0 | $13,005 | $ 0 | $ 8,670 | $ 0 | $47,658 |
Purchase of CD (note 27 b) | $ 0 | $ 2,500 | $ 0 | $ 0 | $ 2,500 | $ 10,000 |
Credit Card Charges (note 27 c) | $2,924 | $ 2,924 | $ 2,924 | $ 2,924 | $ 2,924 | $ 29,242 |
Packaging Charges (note 27 d) | $ 434 | $ 434 | $ 434 | $ 434 | $ 434 | $ 4,343 |
Actual Shipping Charges (note 27 e) | $2,120 | $ 2,120 | $ 2,120 | $ 2,120 | $ 2,120 | $ 21,199 |
Toll Free Charges (note 27 f) | $1,569 | $ 1,569 | $ 1,569 | $ 1,569 | $ 1,569 | $ 14,117 |
Commission on Sales (note 27 g) | $ 788 | $ 788 | $ 788 | $ 788 | $ 788 | $ 7,094 |
Product Miscellaneous (note 27 h) | $ 394 | $ 394 | $ 394 | $ 394 | $ 394 | $ 3,941 |
Advertising | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $130,000 |
Wages & Employee Benefits | $10,857 | $10,857 | $10,857 | $10,857 | $10,857 | $121,291 |
Research & Development | $8,240 | $8,240 | $ 8,240 | $ 8,240 | $ 8,240 | $ 98,271 |
Casual Labour | $ 800 | $ 0 | $ 0 | $ 0 | $ 800 | $ 2,400 |
Office Supplies | $ 500 | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,500 |
Rent | $1,000 | $1,000 | $ 1,000 | $ 1,000 | $ 1,000 | $ 12,000 |
Telephone/Fax | $ 300 | $ 300 | $ 300 | $ 300 | $ 300 | $ 3,300 |
Professional Services | $ 250 | $ 250 | $ 250 | $ 250 | $ 250 | $ 6,750 |
Business Insurance | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,500 |
Toll-free Charges above Variable | $1,569 | $1,569 | $ 1,569 | $ 1,569 | $ 1,569 | $ 14,117 |
Miscellaneous Charges | $ 200 | $ 200 | $ 200 | $ 200 | $ 200 | $ 2,400 |
Office Furniture | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,618 |
Office Equipment | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 4,966 |
Payment on Operating Loan | $20,000 | $ 0 | $ 0 | $ 0 | $ 0 | $ 20,000 |
Interest on Loan | $ 2,000 | $ 0 | $ 0 | $ 0 | $ 0 | $ 2,000 |
Internet Storage and Accounts | $ 900 | $ 150 | $ 150 | $ 150 | $ 150 | $ 2,550 |
Dividends Paid (note 28) | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 20,000 |
TOTAL CASH OUTFLOWS | $66,844 | $58,299 | $42,794 | $51,464 | $46,094 | $582,283 |
Net Cash Flow (Deficiency) | $(9,187) | $ (642) | $14,863 | $ 6,193 | $11,563 | |
Plus Beginning Cash Balance (note 21) | $34,816 | $25,629 | $24,988 | $39,851 | $46,044 | |
ENDING CASH BALANCE | $25,629 | $24,988 | $39,851 | $46,044 | $57,608 | |
* Numbers are rounded. |
J&B INCORPORATED CASH FLOW STATEMENT MAY 1, 1999 - NOVEMBER 30, 1999 |
|||||||
ASSUMPTIONS: | MAY | JUNE | JULY | AUG. | SEPT. | OCT. | NOV. |
Percentage of Sales (per month) | 8% | 7% | 7% | 8% | 8% | 10% | 9% |
Total Unit Sales/ Month) | 793 | 693 | 693 | 793 | 793 | 991 | 892 |
Diskette Sales (note 26) | 317 | 277 | 277 | 317 | 317 | 396 | 357 |
CD Sales (note 26) | 396 | 347 | 347 | 396 | 396 | 495 | 446 |
Internet Sales (note 26) | 79 | 69 | 69 | 79 | 79 | 99 | 89 |
Weighed Average Selling Price (1) | $68.01 | $68.01 | $68.01 | $68.01 | $68.01 | $68.01 | $68.01 |
Product Cost Inflation Rate | 5% | 5% | 5% | 5% | 5% | 5% | 5% |
CASH INFLOWS: | |||||||
Cash From Product Sales (100%) | $53,902 | $47,164 | $47,164 | $53,902 | $53,902 | $67,378 | $60,640 |
Less: Bad Debt Expense (1%) | $ 539 | $ 472 | $ 472 | $ 539 | $ 539 | $ 674 | $ 606 |
NET CASH INFLOWS | $53,363 | $46,693 | $46,693 | $53,363 | $53,363 | $66,704 | $60,033 |
CASH OUTFLOWS: | |||||||
Purchase of Diskettes (note 27 a) | $ 0 | $ 9,100 | $ 0 | $ 0 | $ 9,100 | $ 0 | $ 0 |
Purchase of CD (note 27 b) | $ 0 | $ 0 | $ 2,630 | $ 0 | $ 0 | $ 3,945 | $ 0 |
Credit Card Charges (note 27 c) | $ 2,726 | $ 2,386 | $ 2,386 | $ 2,726 | $ 2,726 | $ 3,408 | $ 3,067 |
Packaging Charges (note 27 d) | $ 435 | $ 381 | $ 381 | $ 435 | $ 435 | $ 544 | $ 490 |
Actual Shipping Charges (note 27 e) | $ 1,752 | $ 1,533 | $ 1,533 | $ 1,752 | $ 1,752 | $ 2,190 | $ 1,971 |
Toll Free Charges (note 27 f) | $ 1,569 | $ 1,656 | $ 1,449 | $ 1,449 | $ 1,656 | $ 1,656 | $ 2,071 |
Commission on Sales (note 27 g) | $ 788 | $ 832 | $ 728 | $ 728 | $ 832 | $ 832 | $ 1,040 |
Product Miscellaneous (note 27 h) | $ 420 | $ 368 | $ 368 | $ 420 | $ 420 | $ 525 | $ 473 |
Advertising | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 |
Wages & Employee Benefits | $11,298 | $11,346 | $11,346 | $11,346 | $11,346 | $11,346 | $11,346 |
Research & Development | $ 9,850 | $10,165 | $10,165 | $10,165 | $10,165 | $10,165 | $10,165 |
Casual Labour | $ 750 | $ 0 | $ 0 | $ 750 | $ 0 | $ 0 | $ 0 |
Office Supplies | $ 500 | $ 0 | $ 0 | $ 488 | $ 0 | $ 488 | $ 0 |
Rent | $ 1,050 | $ 1,050 | $ 1,050 | $ 1,050 | $ 1,050 | $ 1,050 | $ 1,050 |
Telephone/Fax | $ 300 | $ 320 | $ 320 | $ 320 | $ 320 | $ 320 | $ 320 |
Professional Services | $ 250 | $ 292 | $ 292 | $ 292 | $ 292 | $ 292 | $ 292 |
Business Insurance | $ 1,650 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Toll-free Charges above Variable | $ 1,569 | $ 1,656 | $ 1,449 | $ 1,449 | $ 1,656 | $ 1,656 | $ 2,071 |
Miscellaneous Charges | $ 217 | $ 217 | $ 217 | $ 217 | $ 217 | $ 217 | $ 217 |
Taxes Payable | $29,698 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Office Furniture | $ 1,500 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Office Equipment | $ 5,000 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Internet Storage & Accounts | $ 160 | $ 160 | $ 160 | $ 160 | $ 160 | $ 160 | $ 160 |
Dividends Paid (note 28) | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $25,000 |
TOTAL CASH OUTFLOWS | $83,981 | $53,961 | $46,973 | $46,247 | $54,628 | $51,294 | $72,231 |
Net Cash Flow (Deficiency) | $-30,618 | $ -7,269 | $ - 281 | $ 7,115 | $ -1,265 | $15,410 | $-12,198 |
Plus Beginning Cash Balance | $57,608 | $26,989 | $19,721 | $19,440 | $26,555 | $25,290 | $40,700 |
ENDING CASH BALANCE | $26,989 | $19,721 | $19,440 | $26,555 | $25,290 | $40,700 | $28,502 |
The remaining five (5) months of J&B's second year Forecasted Cashflow Statement is presented below. Recall this is not the correct format - the second year cashflow statement should be developed in a spreadsheet program and should appear on one page.
J&B INCORPORATED CASH FLOW STATEMENT DECEMBER 1, 1999 - APRIL 30, 2000 | ||||||
ASSUMPTIONS: | DEC. | JAN | FEB. | MARCH | APRIL | TOTALS |
Percentage of Total Sales (per month) | 8% | 7% | 10% | 9% | 9% | 100% |
Total Unit Sales/ Month) | 793 | 693 | 991 | 892 | 892 | 9,907 |
Diskette Sales (note 26) | 317 | 277 | 396 | 357 | 357 | 3,963 |
CD Sales (note 26) | 396 | 347 | 495 | 446 | 446 | 4,954 |
Internet Sales (note 26) | 79 | 69 | 99 | 89 | 89 | 991 |
Weighed Average Selling Price (note 1) | 68.01 | 68.01 | 68.01 | $68.01 | $68.01 | |
Product Cost Inflation Rate | 5% | 5% | 5% | 5% | 5% | |
CASH INFLOWS: | ||||||
Cash From Product Sales (100%) | $53,902 | $47,164 | $67,378 | $60,640 | $60,640 | $673,775 |
Less: Bad Debt Expense (1%) | $ 539 | $ 472 | $ 674 | $ 606 | $ 606 | $ 6,738 |
NET CASH INFLOWS | $53,363 | $46,693 | $66,704 | $60,033 | $60,033 | $667,037 |
CASH OUTFLOWS: | ||||||
Purchase of Diskettes (note 27 a) | $ 9,100 | $ 0 | $ 0 | $ 4,550 | $ 0 | $ 31,850 |
Purchase of CD (note 27 b) | $ 0 | $ 2,630 | $ 0 | $ 0 | $ 2,630 | $ 11,835 |
Credit Card Charges (note 27 c) | $ 2,726 | $ 2,386 | $ 3,408 | $ 3,067 | $ 3,067 | $ 34,080 |
Packaging Charges (note 27 d) | $ 435 | $ 381 | $ 544 | $ 490 | $ 490 | $ 5,439 |
Actual Shipping Charges (note 27 e) | $ 1,752 | $ 1,533 | $ 2,190 | $ 1,971 | $ 1,971 | $ 21,904 |
Toll Free Charges (note 27 f) | $ 1,864 | $ 1,656 | $ 1,449 | $ 2,071 | $ 1,864 | $ 20,411 |
Commission on Sales (note 27 g) | $ 936 | $ 832 | $ 728 | $ 1,040 | $ 936 | $ 10,254 |
Product Miscellaneous (note 27 h) | $ 420 | $ 368 | $ 525 | $ 473 | $ 473 | $ 5,251 |
Advertising | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $150,000 |
Wages & Employee Benefits | $11,346 | $11,346 | $11,346 | $11,346 | $11,346 | $136,104 |
Research & Development | $10,165 | $10,165 | $10,165 | $10,165 | $10,165 | $121,662 |
Casual Labour | $ 750 | $ 0 | $ 0 | $ 0 | $ 750 | $ 3,000 |
Office Supplies | $ 0 | $ 488 | $ 0 | $ 0 | $ 488 | $ 2,450 |
Rent | $ 1,050 | $ 1,050 | $ 1,050 | $ 1,050 | $ 1,050 | $ 12,600 |
Telephone/Fax | $ 320 | $ 320 | $ 320 | $ 320 | $ 320 | $ 3,820 |
Professional Services | $ 292 | $ 292 | $ 292 | $ 292 | $ 292 | $ 3,458 |
Business Insurance | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,650 |
Toll-free Charges above variable | $ 1,864 | $ 1,656 | $ 1,449 | $ 2,071 | $ 1,864 | $ 20,411 |
Miscellaneous | $ 217 | $ 217 | $ 217 | $ 217 | $ 217 | $ 2,600 |
Taxes Payable | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 29,698 |
Office Furniture | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,500 |
Computer Equipment | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 5,000 |
Internet Storage & Accounts | $ 940 | $ 160 | $ 160 | $ 160 | $ 160 | $ 2,700 |
Dividends Paid | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 25,000 |
TOTAL CASH OUTFLOWS | $56,676 | $47,979 | $46,343 | $51,781 | $50,581 | $662,677 |
Net Cash Flow (Deficiency) | $-3,313 | $-1,286 | $20,360 | $ 8,252 | $ 9,453 | |
Plus: Beginning Cash Balance | $28,502 | $25,189 | $23,903 | $44,263 | $52,515 | |
ENDING CASH BALANCE | $25,189 | $23,903 | $44,263 | $52,515 | $61,968 |
J&B INCORPORATED CASH FLOW STATEMENT MAY 1, 2000 - NOVEMBER 30, 2000 | |||||||
ASSUMPTIONS: | MAY | JUNE | JULY | AUG. | SEPT. | OCT. | NOV. |
Percentage of Total Sales (per month) | 8% | 7% | 7% | 8% | 8% | 10% | 9% |
Total Unit Sales/ Month) | 928 | 812 | 812 | 928 | 928 | 1,160 | 1,044 |
Diskette Sales (note 26) | 186 | 162 | 162 | 186 | 186 | 232 | 209 |
CD Sales (note 26) | 603 | 528 | 528 | 603 | 603 | 754 | 679 |
Internet Sales (note 26) | 139 | 122 | 122 | 139 | 139 | 174 | 157 |
Weighed Average Selling Price ( 1) | $67.61 | $67.61 | $67.61 | $67.61 | $67.61 | $67.61 | $67.61 |
Product Cost Inflation Rate | 10% | 10% | 10% | 10% | 10% | 10% | 10% |
CASH INFLOWS: | |||||||
Cash From Product Sales (100%) | $62,753 | $54,909 | $54,909 | $62,753 | $62,753 | $78,441 | $70,597 |
Less: Bad Debt Expense (1%) | $ 628 | $ 549 | $ 549 | $ 628 | $ 628 | $ 784 | $ 706 |
NET CASH INFLOWS | $62,125 | $54,360 | $54,360 | $62,125 | $62,125 | $77,657 | $69,891 |
CASH OUTFLOWS: | |||||||
Purchase of Diskettes (note 27 a) | $ 0 | $ 9,540 | $ 0 | $ 0 | $ 0 | $ 0 | $ 9,540 |
Purchase of CD (note 27 b) | $ 0 | $ 5,500 | $ 0 | $ 0 | $ 5,500 | $ 0 | $ 0 |
Credit Card Charges (note 27 c) | $ 3,193 | $ 2,794 | $ 2,794 | $ 3,193 | $ 3,193 | $ 3,991 | $ 3,592 |
Packaging Charges (note 27 d) | $ 505 | $ 442 | $ 442 | $ 505 | $ 505 | $ 631 | $ 568 |
Actual Shipping Charges (note 27 e) | $ 1,554 | $ 1,360 | $ 1,360 | $ 1,554 | $ 1,554 | $ 1,943 | $ 1,748 |
Toll Free Charges (note 27 f) | $ 1,863 | $ 2,033 | $ 1,779 | $ 1,779 | $ 2,033 | $ 2,033 | $ 2,541 |
Commission on Sales (note 27 g) | $ 936 | $ 1,021 | $ 893 | $ 893 | $ 1,021 | $ 1,021 | $ 1,276 |
Product Miscellaneous (note 27 h) | $ 510 | $ 447 | $ 447 | $ 510 | $ 510 | $ 638 | $ 574 |
Advertising | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 |
Wages & Employee Benefits | $13,694 | $13,952 | $13,952 | $13,952 | $13,952 | $13,952 | $13,952 |
Research & Development | $10,425 | $10,453 | $10,453 | $10,453 | $10,453 | $10,453 | $10,453 |
Casual Labour | $ 900 | $ 0 | $ 0 | $ 900 | $ 0 | $ 0 | $ 0 |
Office Supplies | $ 0 | $ 0 | $ 412 | $ 0 | $ 0 | $ 412 | $ 0 |
Rent | $ 1,102 | $ 1,102 | $ 1,102 | $ 1,102 | $ 1,102 | $ 1,102 | $ 1,102 |
Telephone/Fax | $ 320 | $ 340 | $ 340 | $ 340 | $ 340 | $ 340 | $ 340 |
Professional Services | $ 292 | $ 333 | $ 333 | $ 333 | $ 333 | $ 333 | $ 333 |
Business Insurance | $ 1,815 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Toll-free Charges above Variable | $ 1,864 | $ 2,033 | $ 1,779 | $ 1,779 | $ 2,033 | $ 2,033 | $ 2,541 |
Miscellaneous Charges | $ 233 | $ 233 | $ 233 | $ 233 | $ 233 | $ 233 | $ 233 |
Taxes Payable | $31,728 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Office Furniture | $ 0 | $ 2,000 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Office Equipment | $ 0 | $ 8,000 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 |
Internet Storage & Accounts | $ 170 | $ 170 | $ 170 | $ 170 | $ 170 | $ 170 | $ 170 |
Dividends Paid (note 28) | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $30,000 |
TOTAL CASH OUTFLOWS | $85,271 | $75,919 | $50,656 | $51,864 | $57,100 | $53,453 | $93,132 |
Net Cash Flow (Deficiency) | $-23,145 | $-21,560 | $3,704 | $10,261 | $ 5,026 | $24,204 | $-23,241 |
Plus Beginning Cash Balance | $61,968 | $38,823 | $17,263 | $20,967 | $31,228 | $36,254 | $60,457 |
ENDING CASH BALANCE | $38,823 | $17,263 | $20,967 | $31,228 | $36,254 | $60,457 | $37,217 |
The remaining five (5) months of J&B's third year Forecasted Cashflow Statement is presented below. Recall this is not the correct procedure - the third year cashflow statement should be developed in a spreadsheet program and should appear on one page.
J&B INCORPORATED CASH FLOW STATEMENT DECEMBER 1, 2000 - APRIL 30, 2001 | ||||||
ASSUMPTIONS: | DEC. | JAN | FEB. | MARCH | APRIL | TOTALS |
Percentage of Total Sales (per month) | 8% | 7% | 10% | 9% | 9% | 100% |
Total Unit Sales/ Month) | 928 | 812 | 1,160 | 1044 | 1044 | 11,602 |
Diskette Sales (note 26) | 186 | 162 | 232 | 209 | 209 | 2320 |
CD Sales (note 26) | 603 | 528 | 754 | 679 | 679 | 7541 |
Internet Sales (note 26) | 139 | 122 | 174 | 157 | 157 | 1740 |
Weighed Average Selling Price (note 1) | $67.61 | $67.61 | $67.61 | $67.61 | $67.61 | |
Product Cost Inflation Rate | 10% | 10% | 10% | 10% | 10% | |
CASH INFLOWS: | ||||||
Cash From Product Sales (100%) | $62,753 | $54,909 | $78,441 | $70,597 | $70,597 | $784,411 |
Bad Debt Expense (1%) | $ 628 | $ 549 | $ 784 | $ 706 | $ 706 | $ 7,844 |
NET CASH INFLOWS | $62,125 | $54,360 | $77657 | $69,891 | $69,891 | $776,567 |
CASH OUTFLOWS: | ||||||
Purchase of Diskettes (note 27 a) | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,908 | $ 20,988 |
Purchase of CD (note 27 b) | $ 5,500 | $ 0 | $ 0 | $ 4,125 | $ 0 | $ 20,625 |
Credit Card Charges (note 27 c) | $ 3,193 | $ 2,794 | $ 3,991 | $ 3,592 | $ 3,592 | $ 39,911 |
Packaging Charges (note 27 d) | $ 505 | $ 442 | $ 631 | $ 568 | $ 568 | $ 6,311 |
Actual Shipping Charges (note 27 e) | $ 1,554 | $ 1,360 | $ 1,943 | $ 1,748 | $ 1,748 | $ 19,428 |
Toll Free Charges (note 27 f) | $ 2,287 | $ 2,033 | $ 1,779 | $ 2,541 | $ 2,287 | $ 24,985 |
Commission on Sales (note 27 g) | $ 1,149 | $ 1,021 | $ 893 | $ 1,276 | $ 1,149 | $ 12,550 |
Product Miscellaneous (note 27 h) | $ 510 | $ 447 | $ 638 | $ 574 | $ 574 | $ 6,381 |
Advertising | $14,167 | $14,167 | $14,167 | $14,167 | $14,167 | $170,000 |
Wages & Employee Benefits | $13,952 | $13,952 | $13,952 | $13,952 | $13,952 | $167,163 |
Research & Development | $10,453 | $10,453 | $10,453 | $10,453 | $10,453 | $125,411 |
Casual Labour | $ 900 | $ 0 | $ 0 | $ 0 | $ 900 | $ 3,600 |
Office Supplies | $ 0 | $ 412 | $ 0 | $ 0 | $ 412 | $ 1,650 |
Rent | $ 1,102 | $ 1,102 | $ 1,102 | $ 1,102 | $ 1,102 | $ 13,230 |
Telephone/Fax | $ 340 | $ 340 | $ 340 | $ 340 | $ 340 | $ 4,060 |
Professional Services | $ 333 | $ 333 | $ 333 | $ 333 | $ 333 | $ 3,958 |
Business Insurance | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 1,815 |
Toll-free Charges above Variable | $ 2,287 | $ 2,033 | $ 1,779 | $ 2,541 | $ 2,287 | $ 24,985 |
Miscellaneous Charges | $ 233 | $ 233 | $ 233 | $ 233 | $ 233 | $ 2,800 |
Taxes Payable | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 31,728 |
Office Furniture | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 2,000 |
Office Equipment | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 8,000 |
Internet Storage & Accounts | $ 995 | $ 170 | $ 170 | $ 170 | $ 170 | $ 2,865 |
Dividends Paid (note 28) | $ 0 | $ 0 | $ 0 | $ 0 | $ 0 | $ 30,000 |
TOTAL CASH OUTFLOWS | $59,461 | $51,292 | $52,405 | $57,717 | $56,176 | $744,444 |
Net Cash Flow (Deficiency) | $2,665 | $3,068 | $25,252 | $12,174 | $13,715 | |
Plus: Beginning Cash Balance | $37,217 | $39,882 | $42,949 | $68,202 | $80,376 | |
ENDING CASH BALANCE | $39,882 | $42,949 | $68,202 | $80,376 | $94,091 |
As you can see, the above forecasted cash flow statements project J&B's cash inflows (from customers, from a bank loan and investors) and all expected cash outflow (from purchases of inventory, for advertising, for rent etc,) each month for thirty-six months. The inflows and outflows are subtracted and the difference is known as the Net Cash Flow (Deficiency). The cash at the beginning of the month is then added to the Net Cash Flow (Deficiency) to produce the Ending Cash Balance for the month.
Notice at the beginning of each cash flow statement, an ASSUMPTION section has been used. This assists the reader (investor) in understanding how the entrepreneur arrived at various values throughout the Cash Flow Statement (optional).
Also notice, after some of the account items, a note and a number is stated. These numbers refer to the Notes to the Financial Statements and allows readers (investors) the opportunity to see how J&B arrived at each account balance or value. This will become more apparent later on as we discuss Part C of the Financial Plan entitled "Notes to the Forecasted Financial Statements".
We can not stress enough that you should have three cash flow statements; one for each forecasted year. In addition, each cash flow statement will consist of a twelve month forecasted period; for a total of thirty-six months.
This concludes our discussion on how your forecasted cash flow statement should appear in your Financial Plan. Remember, it is imperative to understand the theory behind the cash flow statement before attempting to forecast your own. To learn more about this statement, please refer to the section entitled "The Cash-Flow Statement". When you understand the theory behind each financial statement and analysis, you will be equipped with the tools necessary tools needed in Forecasting Your Own Forecasted Financial Statements.
4. FORECASTED BREAK-EVEN ANALYSIS
The next analysis to appear in your financial plan is the Forecasted Break-even Analysis. A Break Even Analysis, in its simplest form, is a tool used to determine the level of sales a business must earn in order to achieve neither a profit nor a loss. In other words, the point at which a business' Net Income is ZERO (revenues - expenses = 0).
The break-even analysis focuses mainly on the items included in a company's income statement (revenues and expenses). Moreover, the Break-even Analysis relies on your forecasted Fixed Costs, your forecasted Variable Costs and your forecasted Selling Price(s). Forecasted Fixed Costs are costs and expenses that do not fluctuate with sales increases or decreases. Forecasted Variable Costs are costs and expenses that do fluctuate with sales increases or decreases. A Forecasted Selling Price (s) is the price or prices you plan to sell your product at.
Your Forecasted Break-even analysis can consist of one page or two pages; depending upon how much detail you decide to offer. For example, J&B Incorporated's forecasted break-even analysis, presented below, consists of two parts. PART A. provides the reader with all information required in making the break-even calculation, and PART B shows the actual break-even calculation.
J&B INCORPORATED FORECASTED BREAK-EVEN ANALYSIS FOR YEARS... | |||
REQUIRED INFORMATION: | |||
CONTRIBUTION MARGIN: | YEAR 1 | YEAR 2 | YEAR 3 |
Selling Price per unit (note 1) | $73.89 | $68.01 | $67.61 |
Weighted Average Variable Cost per unit | $16.50 | $14.79 | $12.10 |
CONTRIBUTION MARGIN PER UNIT | $57.39 | $53.22 | $55.51 |
FIXED COSTS PER YEAR: | |||
Advertising Expense (note 3) | $130,000 | $150,000 | $170,000 |
Wages & Employee Benefits (note 4) | $122,366 | $136,153 | $167,421 |
Casual Labor (note 5) | $ 2,400 | $ 3,000 | $ 3,600 |
Office Supplies (note 6) | $ 1,500 | $ 1,715 | $ 1,908 |
Rent Expense (note 7) | $ 12,000 | $ 12,600 | $ 13,230 |
Telephone/Fax Expense (note 8) | $ 3,600 | $ 3,840 | $ 4,080 |
Professional Services (note 9) | $ 7,000 | $ 3,500 | $ 4,000 |
Insurance Expenses (note 10) | $ 1,500 | $ 1,650 | $ 1,815 |
Toll-free Charges above Variable Cost (note 11) | $ 15,685 | $ 20,706 | $ 25,408 |
Bad Debt Expense (note 12) | $ 5,824 | $ 6,738 | $ 7,844 |
Interest on Operating Loan (note 13) | $ 2,000 | $ nil | $ nil |
Internet Storage & Accounts Expense (note 14) | $ 2,550 | $ 2,700 | $ 2,865 |
Miscellaneous Expenses (note 15) | $ 2,400 | $ 2,600 | $ 2,800 |
Depreciation Expense - Equipment (note 16) | $ 3,142 | $ 4,392 | $ 6,392 |
Depreciation Expense- Furniture (note 17) | $ 606 | $ 906 | $ 1,306 |
Amortization of Initial Development Costs (note 18) | $ 15,924 | $ 15,924 | $ 15,924 |
Amortization of Future Development Costs (note 19) | $ 24,720 | $ 55,215 | $ 86,575 |
TOTAL OPERATING/FIXED COSTS | $353,218 | $421,638 | $515,168 |
Note: all J&B's Operating Expenses are considered to Fixed Costs! |
J&B INCORPORATED BREAK-EVEN CALCULATION (IN UNITS): FOR YEARS 1, 2, 3 | ||||
Year 1 | Year 2 | Year 3 | ||
Fixed Costs divided by Contribution Margin | = | 6,155 units | 7,923 units | 9,281 units |
Forecasted Sales in units per year | = | 7,882 units | 9,907 units | 11,602 units |
Forecasted Sales above Break-even | = | 1,727 units | 1,984 units | 2,321 units |
J&B is forecasting sales of 1,727 units above its break-even point in year one, 1,984 units above break-even in year two and 2,321 units above break-even in year three. |
In the above example, notice that J&B calculates its break-even point and provides an indication of how many units it plans to sell above its break-even point. To do this, J&B simply subtracts each years' forecasted break-even point from the number units it plans to sell in each forecasted year.
Also notice, J&B provides readers with all figures needed to calculate the break-even point. You may elect to use this format or you may decide to only provide the break-even calculations. Whichever format you decide, be sure your break-even point is calculated over a three year period - one column for each forecasted year. You may also decide to provide the reader with an explanation on why your forecasted break-even point is increasing or decreasing. For example, J&B's break-even point is increasing due to the company's planned decrease in its selling price, its estimated increase in variable costs, and its planned increase in fixed costs. As a result, the company is earning a lower contribution margin on each sale made during year two and three. Thus less "money" is contributing to their higher fixed costs.
This concludes our discussion on how your projected break-even analysis should appear in your Financial Plan. Remember, it is imperative to understand the theory behind the break-even analysis before attempting to forecast your own. To learn more about this financial analysis, please refer to the section entitled "The Break-even Analysis". When you understand the theory behind each financial statement and analysis, you will be equipped with the tools necessary tools needed in Forecasting Your Own Forecasted Financial Statements.
5. SENSITIVITY ANALYSIS
A sensitivity analysis shows the effects on Net Income when forecasted sales are increased or decreased by various percentages. Since your forecasted sales will NEVER be one hundred percent accurate, the sensitivity analysis shows investors how your net income will change if your original sales forecast increases by 30%, 20% and 15% or if your original sales forecast decreases and a 15% or 20 %, for example. The percentages chosen for your sensitivity analysis is up to you, however, avoid percentages of 14% or lower.
Many entrepreneurs develop only one sensitivity analysis ( for their first year operation). Others develop three sensitivity analysis; one for each forecasted year of operation. Whichever format you plan to use is not important, what is important, however, is that you include this analysis in your business plan. It shows the investor that you understand; 1) the forecasting process and 2)that your original sales forecasts generally do NOT materialize as envisioned.
Like Break-even Analysis, the Sensitivity Analysis uses your forecasted income statement as its starting point. The analysis relies on distinguishing between Forecasted Fixed Costs and Forecasted Variable Costs. Recall, Forecasted Fixed Costs are costs and expenses that do not fluctuate with sales increases or decreases. Forecasted Variable Costs are costs and expenses that do fluctuate with sales increases or decreases.
Below provides an example of J&B's sensitivity analysis for its first forecasted year of operations. Notice, J&B has chosen a sales percentage increase of 15% of its original sales forecast and a sales percentage decrease of 20% of its original sales forecast.
J&B INCORPORATED SENSITIVITY ANALYSIS FOR PERIOD MAY 1, 1998 TO APRIL 31, 1999 | |||
Pessimistic 20% Decrease in sales |
Original Sales Level |
Optimistic 15%Increase in sales |
|
SALES IN UNITS & DOLLARS: | |||
Sales in Units (note 1) | 6,306 units | 7,882 units | 9,064 units |
Weighted Average Selling Price (note 1) | $73.89 | $73.89 | $73.89 |
TOTAL DOLLAR SALES * | $465,950 | $582,401 | $669,739 |
VARIABLE COSTS: | |||
Cost of Goods Sold (note 2) | $104,153 | $130,191 | $149,720 |
TOTAL VARIABLE COSTS * | $104,153 | $130,191 | $149,720 |
FIXED COSTS: | |||
Advertising Expense | $130,000 | $130,000 | $130,000 |
Wages & Employee Benefits | $122,366 | $122,366 | $122,366 |
Casual Labor | $ 2,400 | $ 2,400 | $ 2,400 |
Office Supplies | $ 1,500 | $ 1,500 | $ 1,500 |
Rent Expense | $ 12,000 | $ 12,000 | $ 12,000 |
Telephone/Fax Expense | $ 3,600 | $ 3,600 | $ 3,600 |
Professional Services | $ 7,000 | $ 7,000 | $ 7,000 |
Insurance Expenses | $ 1,500 | $ 1,500 | $ 1,500 |
Toll-free above Variable | $ 15,685 | $ 15,685 | $ 15,685 |
Bad Debt Expense (note 12) | $ 5,824 | $ 5,824 | $ 5,824 |
Interest on Operating Loan | $ 2,000 | $ 2,000 | $ 2,000 |
Internet Storage & Accounts | $ 2,550 | $ 2,550 | $ 2,550 |
Miscellaneous Expenses | $ 2,400 | $ 2,400 | $ 2,400 |
Depreciation Exp. - Equipment | $ 3,142 | $ 3,142 | $ 3,142 |
Depreciation Exp.- Furniture | $ 606 | $ 606 | $ 606 |
Amortization of Initial R&D Costs | $ 15,924 | $ 15,924 | $ 15,924 |
Amortization of Future R&D Costs | $ 24,720 | $ 24,720 | $ 24,720 |
TOTAL FIXED COSTS * | $353,218 | $353,218 | $353,218 |
TOTAL COSTS | $457,371 | $483,409 | $502,938 |
Net Income Before Taxes | $ 8,579 | $ 98,992 | $166,801 |
Less: Estimated Tax Rate (30%) | $ 2,574 | $ 29,698 | $ 50,040 |
Net Income (Loss) After Taxes | $ 6,005 | $ 69,294 | $116,761 |
* All Operating Expenses are considered Fixed Costs. ** The only Variable Cost is J&B's Cost of Goods Sold. *** Figures are rounded. |
Notice, J&B's forecasted Operating Expenses are considered to be Fixed Costs (they do not fluctuate with sales increases or decreases. Also, the company's Variable Costs, in this example, include only the Cost of Goods Sold (COGS will always fluctuate with sales increases or decreases and therefore will always be considered variable). The only other item, in the above example, that fluctuates with sales is Sales itself! In other words, if you increase the original forecasted sales by a certain percentage, then sales will have to increase by that amount (in units sold and in dollars). Alternatively if you decrease the original sales forecast by any amount, then SALES in units sold and in dollar will certainly change by that amount or percentage.
This concludes our discussion on how your projected sensitivity analysis should appear in your Financial Plan. Remember, it is imperative to understand the theory behind the sensitivity analysis before attempting to forecast your own. To learn more about this financial analysis, please refer to the section entitled "The Sensitivity Analysis". When you understand the theory behind each financial statement and analysis, you will be equipped with the tools necessary tools needed in Forecasting Your Own Forecasted Financial Statements.
6. RATIO ANALYSIS
The next analysis appearing in the financial plan should be your Forecasted Ratio Analysis. In a nutshell, Ratio Analysis is a general technique for analyzing the performance of an existing or potential business.
Ratios involve dividing numbers from the Balance Sheet and Income Statement to create percentages and decimals. When aspiring entrepreneurs and existing business owners apply for a loan, for example, bankers usually look at their forecasted ratios and compare them to ratios of other businesses operating within the same industry.
Your projected ratios should be calculated over a three year forecasted period. Many business plan writers calculate the ratios and provide a narrative discussion, depicting how each has changed over the three year forecasted period. Others calculate the ratios and provide a footnote stating "a complete analysis regarding the forecasted ratios is available upon request. Yet other business plan writers feel the need to calculate various ratios and compare them to ratios of other businesses within the industry. The later approach can be time consuming and may not be "cost effective". Below provides an example of J&B's forecasted Ratio Calculations.
J&B INCORPORATED FORECASTED RATIO CALCULATIONS FOR YEARS ENDING APRIL ... | ||||
YEAR 1 | YEAR 2 | YEAR 3 | ||
CURRENT RATIO: | ||||
Current Assets Current Liabilities |
= | $67,894 $36,359 |
$67578 $39051 |
$98410 $43649 |
= | 1.87 | 1.73 | 2.25 | |
QUICK RATIO: | ||||
Current Assets -Current Liabilities Current Liabilities |
= | $31,535 $36,359 |
$28,526 $39,051 |
$54,761 $43,649 |
= | 0.87 | 0.73 | 1.25 | |
DEBT RATIO: | ||||
Total Debt Total Assets |
= | $36,359 $185,753 |
$39,051 $237,477 |
$43,649 $293,553 |
= | 0.20 | 0.16 | 0.15 | |
DEBT-TO-EQUITY RATIO: | ||||
Total Debt Total Equity |
= | $ 36,359 $149,394 |
$ 39,051 $198,426 |
$ 43,649 $249,904 |
= | 0.24 | 0.20 | 0.17 | |
NET PROFIT MARGIN: | ||||
Net Income after tax Sales |
= | $ 69,294 $582,401 |
$ 74,032 $673,775 |
$81,478 $78,441 |
= | 0.12 | 0.11 | 0.10 | |
RETURN ON EQUITY: | ||||
Net Income after tax Total Equity |
= | $ 69,294 $149,394 |
$ 74,032 $198,426 |
$ 81,478 $249,904 |
= | 0.46 | 0.37 | 0.33 | |
NOTE: Complete analysis on above ratios is available upon request . |
Notice the information provided in the above example. The name of each ratio, the formula required in calculating each ratio, the dollar amounts for each formula item, and the ratio calculation for each of the forecasted years. It is important to stress that these dollar amounts have been taking from J&B's forecasted Balance Sheet and Forecasted Income Statement. Therefore, the forecasted balance sheet and income statement must be complete before ratios can be calculated.
Also notice that J&B decided to calculate the ratios without providing any narrative discussion. Moreover, the company states that a "complete analysis is available upon request". If you want to impress the investor, it might in your best interest to provide the ratio analysis (narrative discussion) in your business plan. To do this, simply calculate each ratio for the three year forecasted period and then briefly discuss the variables attributing to change in ratio value.
This concludes our discussion on how your projected ratio analysis should appear in your Financial Plan. Remember, it is imperative to understand the theory behind the ratio analysis before attempting to forecast your own. To learn more about how to read or determine the meaning behind ratios, please refer to the section entitled "Ratio Analysis". This section will also provide you with other ratio formulas which you may decide to include in your analysis.
This concludes PART B of the financial plan entitled "Forecasted Financial Statements".The purpose of this section was not to show you how to develop forecasted financial statements, rather the purpose was to show you how the statements generally appear in the Financial Plan.
To learn the theory behind each financial statement, please refer to the section entitled "Learning and Understanding Financial Statements". To learn how to forecast your own financial statements, please refer to the section entitled "Forecasting your Own Financial Statements".
In summary, be sure your forecasted financial statements and analysis provide for a three year forecasted period and include the following;
FINANCIAL STATEMENT & ANALYSIS | FORMAT |
Forecasted Income Statements | all on one page |
Forecasted Balance Sheets | all on one page |
Forecasted Cash Flow Statements | one page for each cash flow statement |
Break-even Analysis | Calculations on one page, analysis is unlimited |
Sensitivity Analysis | One page for each sensitivity, analysis is unlimited |
Ratio Analysis | on one to three pages depending upon your format |
Please Note: as mentioned earlier, you will save yourself time and money if you develop the above financial items using a spreadsheet program.
PART C - NOTES TO THE FINANCIAL STATEMENTS
The third and final part of the financial section of the Business Plan is known as the notes to the forecasted financial statements. Notes to the Forecasted Financial Statements summarize the "activities" and "assumptions" made when creating the forecasted financial statements.. The Notes will give the readers (bankers, investors, and other readers) the necessary information needed to understand and comprehend your forecasts and projections. It also alleviates any guessing or questioning a reader may have when analyzing the financial section of the business plan. NOTE: never, ever, ever, create the notes to the forecasted financial statements until you have" fully completed" all forecasted statements and analysis.
There is no set structure nor specific guideline that dictate which topics should be included in the notes to the financial statements. Rather it is left up to the individual to decide which items warrant a "note" and which items are self explanatory. The following list provides some suggestions you may use when creating your notes section.
POSSIBLE NOTES TO THE FORECASTED FINANCIAL STATEMENTS |
Sales Forecast note to the financial statements |
Gross Margin note to the financial statements |
Management and Staff note to the financial statements |
Office or Store Supplies note to the financial statements |
Bad Debt Expense Rate note to the financial statements |
Marketing Expenses Breakdown note to the financial statements |
Income Tax Rate notes to the financial statements |
Income Tax Payable note to the financial statements |
Net Income note to the financial statements |
Accounts Receivable note to the financial statements |
Personal Assets Invested by the Owner note to financial statements |
Fixed Asset Purchases note to the financial statements |
Total Fixed Assets Available note to the financial statements |
Deprecation Rates on Fixed Assets note to the financial statements |
Inventory note to the financial statements |
Accounts Payable note to the financial statements |
Short-term Loans note to the financial statements |
Long-term Debt (mortgage) note to the financial statements |
Sales Tax note to the financial statements |
Owner (s)Capital Account note to the financial statements |
Retained Earnings note to the financial statements |
Dividend Distribution note to the financial statements |
Your notes should provide details on each of the required three year forecasted periods. Below provides a link to J&B's Notes to the Forecasted Financial Statements. BUT FIRST - recall from above, the word "note" and a "number" followed several account items on J&B's forecasted income statement, balance sheet and cash flow statement, etc. For instance, on the company's income statement, an account called revenue from sales is present. Following the revenue from sales account is a "note 1". This refers to the first note under the Notes to the Forecasted Financial Statements. When investors read J&B's income statement and see note 1 beside the account item entitled "Total Revenue From Sales", they can quickly refer to the Notes section for information on how the entrepreneur arrived at these dollars amounts. As a result, the investor better understands the financial statements and the assumptions used when creating them. . Try is yourself - print off all J&B's financial statements and refer to the Notes below. You'll find your understanding of the financial statements as well as the company's initiatives is much better. Remember, when investors understand your financial projections, it reduces their risk, and in many cases, it increases your chances of receiving financing.
Link to: J&B Incorporated's Notes to their Forecasted Financial Statements
For additional information on this topic, please refer to the section entitled "Notes to the Financial Statements".
CONCLUSION OF THE FINANCIAL PLAN
This concludes our discussion on the Financial Plan section of a business plan. Remember the Financial Plan generally consists of three parts:
The Introduction |
The Forecasted Financial Statements |
The Notes to the Forecasted Financial Statements |
Below provides examples of how your Financial Plan should appear in its entirety. (Please note, the financial statements and analysis for two of the examples below; namely The Internet Company and Scholarship Information Services provide forecasts for a two year period. Your financial statements and analysis, however, generally provide projections for at least a three year period.
EXAMPLES OF THE FINANCIAL PLAN SECTION OF A BUSINESS PLAN J&B Incorporated Scholarship Information Services The Internet Company