The Complete Financial Section of the Business Plan with Examples

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;

  • A.    Introduction to the Financial Plan
  • B.    Forecasted Financial Statements
  • C.    Notes to the Forecasted Financial Statements

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

Categories: General