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.
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 |
: | ||||
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 |
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 |
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 |
* 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).
| |||||||
. | |||||||
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 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 |
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 |
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 |
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.
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 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 |
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 |
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 | |
* Numbers are rounded. |
| |||||||
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 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 |
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 |
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 |
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.
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 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 |
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 |
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 | |
. | |||||||
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 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 |
: | |||||||
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 |
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 |
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.
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 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 |
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 |
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 | |
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.
Selling Price per unit (note 1) | $73.89 | $68.01 | $67.61 |
Weighted Average Variable Cost per unit | $16.50 | $14.79 | $12.10 |
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 |
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.
| | | |
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 |
Cost of Goods Sold (note 2) | $104,153 | $130,191 | $149,720 |
: | |||
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 |
Net Income Before Taxes | $ 8,579 | $ 98,992 | $166,801 |
Less: Estimated Tax Rate (30%) | $ 2,574 | $ 29,698 | $ 50,040 |
* 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.
Current Assets Current Liabilities | = | $67,894 $36,359 | $67578 $39051 | $98410 $43649 |
Current Assets -Current Liabilities Current Liabilities | = | $31,535 $36,359 | $28,526 $39,051 | $54,761 $43,649 |
Total Debt Total Assets | = | $36,359 $185,753 | $39,051 $237,477 | $43,649 $293,553 |
: | ||||
Total Debt Total Equity | = | $ 36,359 $149,394 | $ 39,051 $198,426 | $ 43,649 $249,904 |
: | ||||
Net Income after tax Sales | = | $ 69,294 $582,401 | $ 74,032 $673,775 | $81,478 $78,441 |
: | ||||
Net Income after tax Total Equity | = | $ 69,294 $149,394 | $ 74,032 $198,426 | $ 81,478 $249,904 |
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;
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.
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
Sign up for the newsletter!
copy of the Ultimate Marketing Guide entitled | |
you'll also receive a Free Subscription to ; the most popular Business Tips newsletter --- filled with profitable Tips, Strategies and Solutions to solve YOUR business challenges! very seriously. We dislike Spam as much as you do! |
© Copyright 2009 - Business Plan Hut - All Rights Reserved
About - Contact Us - Privacy Policy - Disclaimer - Sitemap - Login - Admin
Trevor Betenson
10 min. read
Updated May 2, 2024
Business financial statements consist of three main components: the income statement , statement of cash flows , and balance sheet. The balance sheet is often the most misunderstood of these components—but also extremely beneficial if you understand how to use it.
Check out our free downloadable Balance Sheet Template for more, and keep reading to learn the different elements of a balance sheet, and why they matter.
The balance sheet provides a snapshot of the overall financial condition of your company at a specific point in time. It lists all of the company’s assets, liabilities, and owner’s equity in one simple document.
A balance sheet always has to balance—hence the name. Assets are on one side of the equation, and liabilities plus owner’s equity are on the other side.
Assets = Liabilities + Equity
Put simply, a balance sheet shows what a company owns (assets), what it owes (liabilities), and how much owners and shareholders have invested (equity).
Including a balance sheet in your business plan is an essential part of your financial forecast , alongside the income statement and cash flow statement.
These statements give anyone looking over the numbers a solid idea of the overall state of the business financially. In the case of the balance sheet in particular, what it’s telling you is whether or not you’re in debt, and how much your assets are worth. This information is critical to managing your business and the creation of a business plan.
The balance sheet includes spending and income that isn’t in the income statement (also called a profit and loss statement). For example, the money you spend to repay a loan or buy new assets doesn’t show up in the income statement. And the money you take in as a new loan or a new investment doesn’t show up in the income statement either. The money you are waiting to receive from customers’ outstanding invoices shows up in the balance sheet, not the income statement.
Among other things, your balance sheet can be used to determine your company’s net worth. By subtracting liabilities from assets, you can determine your company’s net worth at any given point in time.
Typically, a balance sheet is divided into three main parts: Assets, liabilities, and owner’s equity.
Assets on a balance sheet or typically organized from top to bottom based on how easily the asset can be converted into cash. This is called “liquidity.” The most “liquid” assets are at the top of the list and the least liquid are at the bottom of the list.
Brought to you by
Using ai and step-by-step instructions.
Secure funding
Validate ideas
Build a strategy
In the context of a balance sheet, cash means the money you currently have on hand. In business planning, the term “cash” represents the bank or checking account balance for the business, also sometimes referred to as “cash and cash equivalents” or “CCE.”
A cash equivalent is an asset that is liquid and can be converted to cash immediately, like a money market account or a treasury bill.
Accounts receivable is money people are supposed to pay you, but that you have not actually received yet (hence the “receivables”).
Usually, this money is sales on credit, often from business-to-business (or “B2B”) sales, where your business has invoiced a customer but has not received payment yet.
Inventory includes the value of all of the finished goods and ready materials that your business has on hand but hasn’t sold yet.
Current assets are those that can be converted to cash within one year or less. Cash, accounts receivable, and inventory are all current assets, and these amounts accumulated are sometimes referenced on a balance sheet as “total current assets.”
Long-term assets are also referred to as “fixed assets” and include things that will have a long-standing value, such as land or equipment. Long-term assets typically cannot be converted to cash quickly.
Accumulated depreciation reduces the value of assets over time. For example, if a business purchases a car, the car will lose value as time goes on.
Total long-term assets is used to describe long-term assets plus depreciation on a balance sheet.
Like assets, liabilities are ordered by how quickly a business needs to pay them off. Current liabilities are typically due within one year. Long-term liabilities are due at any point after one year.
Accounts payable is the money that your business owes to other vendors, the other side of the coin to “accounts receivable.” Your accounts payable number is the regular bills that your business is expected to pay.
Pay attention to whether this number is exceedingly high, especially if your business doesn’t have enough to cover it.
This only applies to businesses that don’t pay sales tax right away, for example, a business that pays its sales tax each quarter. That might not be your business, so if it doesn’t apply, skip it.
This is debt that you have to pay back within a year—usually any short-term loan. This can also be referred to on a balance sheet as a line item called current liabilities or short-term loans. Your related interest expenses don’t go here or anywhere on the balance sheet; those should be included in the income statement.
The above numbers added together are considered the current liabilities of a business, meaning that the business is responsible for paying them within one year.
These are the financial obligations that it takes more than a year to pay back. This is often a hefty number, and it doesn’t include interest. For example, this number reflects long-term loans on things like buildings or expensive pieces of equipment. It should be decreasing over time as the business makes payments and lowers the principal amount of the loan.
Everything listed above that you have to pay out or back is added together.
This is the sum of all shareholder money invested in the business and accumulated business profits. Owner’s equity includes common stock, retained earnings, and paid-in-capital.
Money is paid into the company as investments. This is not to be confused with the par value or market value of stocks. This is actual money paid into the company as equity investments by owners.
Earnings (or losses) that have been reinvested into the company, that have not been paid out as dividends to the owners. When retained earnings are negative, the company has accumulated losses. This can also be referred to as “shareholder’s equity.”
This doesn’t apply to all legal structures for a business; if you are a pass-through tax entity , then all profits or losses will be passed on to owners, and your balance sheet should reflect that.
This is an important number—the higher it is, the more profitable your company is. This line item can also be called income or net profit. Earnings are the proverbial “bottom line”: sales less costs of sales and expenses.
Equity means business ownership, also called capital. Equity can be calculated as the difference between assets and liabilities. This can also be referred to as “shareholder’s equity” or “stockholder’s equity.”
This is the final equation I mentioned at the beginning of this post, assets = liabilities + equity.
Your balance sheet can provide a wealth of useful information to help improve financial management. For example, you can determine your company’s net worth by subtracting your balance sheet liabilities from your assets, as noted above.
Overall, the balance sheet gives you insights into the health of your business. It’s a snapshot of what you have (assets) and what you owe (liabilities). Keeping tabs on these numbers will help you understand your financial position and if you have enough cash to make further investments in your business.
Perhaps the most useful aspect of your balance sheet is its ability to alert you to upcoming cash shortages. After a highly profitable month or quarter, for example, business owners sometimes get lulled into a sense of financial complacency if they don’t consider the impact of upcoming expenses on their cash flow .
There are two easy-to-figure ratios that can be computed from the balance sheet to help determine whether your company will have sufficient cash flow to meet current financial obligations:
This measures liquidity to show whether your company has enough current (i.e., liquid) assets on hand to pay bills on-time and run operations effectively. It is expressed as the number of times current assets exceeds current liabilities.
The higher the current ratio, the better. A current ratio of 2:1 is generally considered acceptable for inventory-carrying businesses, although industry standards can vary widely. The acceptable current ratio for a retail business, for example, is different from that of a manufacturer.
Current Assets / Current Liabilities
This ratio is similar to the current ratio but excludes inventory. A quick ratio of 1.5:1 is generally desirable for non-inventory-carrying businesses, but—just as with current ratios—desirable quick ratios differ from industry to industry.
Current Assets – Inventory / Current Liabilities
Knowing your industry’s standards is an important part of evaluating your business’s balance sheet effectively.
Remember, the balance sheet alone doesn’t give you a complete view of your business finances. You’ll want to keep tabs on your profit & loss statement (income statement) and cash flow as well.
Your profit & loss statement will show you the sales you are making and your business expenses and calculates your profitability. This is crucial for understanding the core economics of your business and if you’re building a profitable business, or not.
Your cash flow forecast shows how cash is moving in and out of your business and can help you predict your future cash balances. Fast growth can reduce cash quickly, especially for businesses that carry inventory, so this is a crucial statement to pay attention to as well.
The three statements all work together to provide you with a complete picture of your business. The balance sheet also helps illustrate how cash and profits are very different things .
Large businesses will have longer and more complex balance sheets for their businesses, sometimes having separate balance sheets for different segments or departments of their business. A small business balance sheet will be more straightforward and have fewer line items.
Here is a balance sheet from Apple, for example. You’ll see that it includes a complex stockholder’s equity section and several specifically itemized types of long-term assets and liabilities.
Apple’s balance sheet .
You’ll also notice that it says “Period Ending” at the top; this indicates that these numbers are reflective of the time up until the date listed at the top of the column. This terminology is used when you are reporting actual values, not creating a financial forecast for the future.
Most companies should update their balance once a month, or whenever lenders ask for an updated balance sheet. Today’s accounting software programs will create your balance sheet for you, but it’s up to you to enter accurate information into the program to generate useful data to work from.
The balance sheet can be an extremely useful financial tool for businesses that understand how to use it properly. If you’re not as familiar with your balance sheet as you’d like to be, now might be a good time to learn more about the workings of your balance sheet and how it can help improve financial management.
Create your balance sheet easily by downloading our Balance Sheet Template , and check out our full guide to write your financial plan.
Trevor is the CFO of Palo Alto Software, where he is responsible for leading the company’s accounting and finance efforts.
Table of Contents
Related Articles
2 Min. Read
How to Use These Common Business Ratios
11 Min. Read
How to Create a Sales Forecast
4 Min. Read
How to Create an Expense Budget
5 Min. Read
9 Common Mistakes with Business Financial Projections
The LivePlan Newsletter
Your first monthly newsetter will be delivered soon..
Unsubscribe anytime. Privacy policy .
Fill-in-the-blanks and automatic financials make it easy.
No thanks, I prefer writing 40-page documents.
Discover the world’s #1 plan building software
Learn how to create a business plan
A business plan is a document that contains the operational and financial plan of a business, and details how its objectives will be achieved. It serves as a road map for the business and can be used when pitching investors or financial institutions for debt or equity financing .
A business plan should follow a standard format and contain all the important business plan elements. Typically, it should present whatever information an investor or financial institution expects to see before providing financing to a business.
A business plan should be structured in a way that it contains all the important information that investors are looking for. Here are the main sections of a business plan:
The title page captures the legal information of the business, which includes the registered business name, physical address, phone number, email address, date, and the company logo.
The executive summary is the most important section because it is the first section that investors and bankers see when they open the business plan. It provides a summary of the entire business plan. It should be written last to ensure that you don’t leave any details out. It must be short and to the point, and it should capture the reader’s attention. The executive summary should not exceed two pages.
The industry overview section provides information about the specific industry that the business operates in. Some of the information provided in this section includes major competitors, industry trends, and estimated revenues. It also shows the company’s position in the industry and how it will compete in the market against other major players.
The market analysis section details the target market for the company’s product offerings. This section confirms that the company understands the market and that it has already analyzed the existing market to determine that there is adequate demand to support its proposed business model.
Market analysis includes information about the target market’s demographics , geographical location, consumer behavior, and market needs. The company can present numbers and sources to give an overview of the target market size.
A business can choose to consolidate the market analysis and competition analysis into one section or present them as two separate sections.
The sales and marketing plan details how the company plans to sell its products to the target market. It attempts to present the business’s unique selling proposition and the channels it will use to sell its goods and services. It details the company’s advertising and promotion activities, pricing strategy, sales and distribution methods, and after-sales support.
The management plan provides an outline of the company’s legal structure, its management team, and internal and external human resource requirements. It should list the number of employees that will be needed and the remuneration to be paid to each of the employees.
Any external professionals, such as lawyers, valuers, architects, and consultants, that the company will need should also be included. If the company intends to use the business plan to source funding from investors, it should list the members of the executive team, as well as the members of the advisory board.
The operating plan provides an overview of the company’s physical requirements, such as office space, machinery, labor, supplies, and inventory . For a business that requires custom warehouses and specialized equipment, the operating plan will be more detailed, as compared to, say, a home-based consulting business. If the business plan is for a manufacturing company, it will include information on raw material requirements and the supply chain.
The financial plan is an important section that will often determine whether the business will obtain required financing from financial institutions, investors, or venture capitalists. It should demonstrate that the proposed business is viable and will return enough revenues to be able to meet its financial obligations. Some of the information contained in the financial plan includes a projected income statement , balance sheet, and cash flow.
The appendices and exhibits part is the last section of a business plan. It includes any additional information that banks and investors may be interested in or that adds credibility to the business. Some of the information that may be included in the appendices section includes office/building plans, detailed market research , products/services offering information, marketing brochures, and credit histories of the promoters.
Here is a basic template that any business can use when developing its business plan:
Section 1: Executive Summary
Section 2: Industry Overview
Section 3: Market Analysis and Competition
Section 4: Sales and Marketing Plan
Section 5: Management Plan
Section 6: Operating Plan
Section 7: Financial Plan
Section 8: Appendices and Exhibits
Thank you for reading CFI’s guide to Business Plans. To keep learning and advancing your career, the following CFI resources will be helpful:
Access and download collection of free Templates to help power your productivity and performance.
Already have an account? Log in
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.
Already have a Full-Immersion membership? Log in
Spell out your financial forecast in dollars and sense
Creating financial projections for your startup is both an art and a science. Although investors want to see cold, hard numbers, it can be difficult to predict your financial performance three years down the road, especially if you are still raising seed money. Regardless, short- and medium-term financial projections are a required part of your business plan if you want serious attention from investors.
The financial section of your business plan should include a sales forecast , expenses budget , cash flow statement , balance sheet , and a profit and loss statement . Be sure to follow the generally accepted accounting principles (GAAP) set forth by the Financial Accounting Standards Board , a private-sector organization responsible for setting financial accounting and reporting standards in the U.S. If financial reporting is new territory for you, have an accountant review your projections.
As a startup business, you do not have past results to review, which can make forecasting sales difficult. It can be done, though, if you have a good understanding of the market you are entering and industry trends as a whole. In fact, sales forecasts based on a solid understanding of industry and market trends will show potential investors that you've done your homework and your forecast is more than just guesswork.
In practical terms, your forecast should be broken down by monthly sales with entries showing which units are being sold, their price points, and how many you expect to sell. When getting into the second year of your business plan and beyond, it's acceptable to reduce the forecast to quarterly sales. In fact, that's the case for most items in your business plan.
What you're selling has to cost something, and this budget is where you need to show your expenses. These include the cost to your business of the units being sold in addition to overhead. It's a good idea to break down your expenses by fixed costs and variable costs. For example, certain expenses will be the same or close to the same every month, including rent, insurance, and others. Some costs likely will vary month by month such as advertising or seasonal sales help.
As with your sales forecast, cash flow statements for a startup require doing some homework since you do not have historical data to use as a reference. This statement, in short, breaks down how much cash is coming into your business on a monthly basis vs. how much is going out. By using your sales forecasts and your expenses budget, you can estimate your cash flow intelligently.
Keep in mind that revenue often will trail sales, depending on the type of business you are operating. For example, if you have contracts with clients, they may not be paying for items they purchase until the month following delivery. Some clients may carry balances 60 or 90 days beyond delivery. You need to account for this lag when calculating exactly when you expect to see your revenue.
Your P&L statement should take the information from your sales projections, expenses budget, and cash flow statement to project how much you expect in profits or losses through the three years included in your business plan. You should have a figure for each individual year as well as a figure for the full three-year period.
You provide a breakdown of all of your assets and liabilities in the balances sheet. Many of these assets and liabilities are items that go beyond monthly sales and expenses. For example, any property, equipment, or unsold inventory you own is an asset with a value that can be assigned to it. The same goes for outstanding invoices owed to you that have not been paid. Even though you don't have the cash in hand, you can count those invoices as assets. The amount you owe on a business loan or the amount you owe others on invoices you've not paid would count as liabilities. The balance is the difference between the value of everything you own vs. the value of everything you owe.
If you've done a good job projecting your sales and expenses and inputting the numbers into a spreadsheet, you should be able to identify a date when your business breaks even—in other words, the date when you become profitable, with more money coming in than going out. As a startup business, this is not expected to happen overnight, but potential investors want to see that you have a date in mind and that you can support that projection with the numbers you've supplied in the financial section of your business plan.
When putting together your financial projections, keep some general tips in mind:
Written by Dave Lavinsky
Financial projections are forecasted analyses of your business’ future that include income statements, balance sheets and cash flow statements. We have found them to be an crucial part of your business plan for the following reasons:
Below you’ll learn more about the key components of financial projections and how to complete and include them in your business plan.
Financial projections are an estimate of your company’s future financial performance through financial forecasting. They are typically used by businesses to secure funding, but can also be useful for internal decision-making and planning purposes. There are three main financial statements that you will need to include in your business plan financial projections:
The income statement projection is a forecast of your company’s future revenues and expenses. It should include line items for each type of income and expense, as well as a total at the end.
There are a few key items you will need to include in your projection:
FY 1 | FY 2 | FY 3 | FY 4 | FY 5 | ||
---|---|---|---|---|---|---|
Revenues | ||||||
Total Revenues | $360,000 | $793,728 | $875,006 | $964,606 | $1,063,382 | |
Expenses & Costs | ||||||
Cost of goods sold | $64,800 | $142,871 | $157,501 | $173,629 | $191,409 | |
Lease | $50,000 | $51,250 | $52,531 | $53,845 | $55,191 | |
Marketing | $10,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Salaries | $157,015 | $214,030 | $235,968 | $247,766 | $260,155 | |
Initial expenditure | $10,000 | $0 | $0 | $0 | $0 | |
Total Expenses & Costs | $291,815 | $416,151 | $454,000 | $483,240 | $514,754 | |
EBITDA | $68,185 | $377,577 | $421,005 | $481,366 | $548,628 | |
Depreciation | $27,160 | $27,160 | $27,160 | $27,160 | $27,160 | |
EBIT | $41,025 | $350,417 | $393,845 | $454,206 | $521,468 | |
Interest | $23,462 | $20,529 | $17,596 | $14,664 | $11,731 | |
PRETAX INCOME | $17,563 | $329,888 | $376,249 | $439,543 | $509,737 | |
Net Operating Loss | $0 | $0 | $0 | $0 | $0 | |
Use of Net Operating Loss | $0 | $0 | $0 | $0 | $0 | |
Taxable Income | $17,563 | $329,888 | $376,249 | $439,543 | $509,737 | |
Income Tax Expense | $6,147 | $115,461 | $131,687 | $153,840 | $178,408 | |
NET INCOME | $11,416 | $214,427 | $244,562 | $285,703 | $331,329 |
The cash flow statement and projection are a forecast of your company’s future cash inflows and outflows. It is important to include a cash flow projection in your business plan, as it will give investors and lenders an idea of your company’s ability to generate cash.
There are a few key items you will need to include in your cash flow projection:
FY 1 | FY 2 | FY 3 | FY 4 | FY 5 | ||
---|---|---|---|---|---|---|
CASH FLOW FROM OPERATIONS | ||||||
Net Income (Loss) | $11,416 | $214,427 | $244,562 | $285,703 | $331,329 | |
Change in working capital | ($19,200) | ($1,966) | ($2,167) | ($2,389) | ($2,634) | |
Depreciation | $27,160 | $27,160 | $27,160 | $27,160 | $27,160 | |
Net Cash Flow from Operations | $19,376 | $239,621 | $269,554 | $310,473 | $355,855 | |
CASH FLOW FROM INVESTMENTS | ||||||
Investment | ($180,950) | $0 | $0 | $0 | $0 | |
Net Cash Flow from Investments | ($180,950) | $0 | $0 | $0 | $0 | |
CASH FLOW FROM FINANCING | ||||||
Cash from equity | $0 | $0 | $0 | $0 | $0 | |
Cash from debt | $315,831 | ($45,119) | ($45,119) | ($45,119) | ($45,119) | |
Net Cash Flow from Financing | $315,831 | ($45,119) | ($45,119) | ($45,119) | ($45,119) | |
Net Cash Flow | $154,257 | $194,502 | $224,436 | $265,355 | $310,736 | |
Cash at Beginning of Period | $0 | $154,257 | $348,760 | $573,195 | $838,550 | |
Cash at End of Period | $154,257 | $348,760 | $573,195 | $838,550 | $1,149,286 |
The balance sheet projection is a forecast of your company’s future financial position. It should include line items for each type of asset and liability, as well as a total at the end.
A projection should include a breakdown of your company’s assets and liabilities by category. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.
It is important to track your company’s financial position over time to ensure that it is healthy. A healthy balance is necessary for a successful business.
FY 1 | FY 2 | FY 3 | FY 4 | FY 5 | ||
---|---|---|---|---|---|---|
ASSETS | ||||||
Cash | $154,257 | $348,760 | $573,195 | $838,550 | $1,149,286 | |
Accounts receivable | $0 | $0 | $0 | $0 | $0 | |
Inventory | $30,000 | $33,072 | $36,459 | $40,192 | $44,308 | |
Total Current Assets | $184,257 | $381,832 | $609,654 | $878,742 | $1,193,594 | |
Fixed assets | $180,950 | $180,950 | $180,950 | $180,950 | $180,950 | |
Depreciation | $27,160 | $54,320 | $81,480 | $108,640 | $135,800 | |
Net fixed assets | $153,790 | $126,630 | $99,470 | $72,310 | $45,150 | |
TOTAL ASSETS | $338,047 | $508,462 | $709,124 | $951,052 | $1,238,744 | |
LIABILITIES & EQUITY | ||||||
Debt | $315,831 | $270,713 | $225,594 | $180,475 | $135,356 | |
Accounts payable | $10,800 | $11,906 | $13,125 | $14,469 | $15,951 | |
Total Liability | $326,631 | $282,618 | $238,719 | $194,944 | $151,307 | |
Share Capital | $0 | $0 | $0 | $0 | $0 | |
Retained earnings | $11,416 | $225,843 | $470,405 | $756,108 | $1,087,437 | |
Total Equity | $11,416 | $225,843 | $470,405 | $756,108 | $1,087,437 | |
TOTAL LIABILITIES & EQUITY | $338,047 | $508,462 | $709,124 | $951,052 | $1,238,744 |
Creating financial projections for your business plan can be a daunting task, but it’s important to put together accurate and realistic financial projections in order to give your business the best chance for success.
When you create financial projections, it is important to be realistic about the costs your business will incur, using historical financial data can help with this. You will need to make assumptions about the cost of goods sold, operational costs, and capital expenditures.
It is important to track your company’s expenses over time to ensure that it is staying within its budget. A healthy bottom line is necessary for a successful business.
You will also need to make assumptions about capital expenditures, funding, tax, and balance sheet items. These assumptions will help you to create a realistic financial picture of your business.
When projecting your company’s capital expenditures, you will need to make a number of assumptions about the type of equipment or property your business will purchase. You will also need to estimate the cost of the purchase.
When projecting your company’s funding needs, you will need to make a number of assumptions about where the money will come from. This might include assumptions about bank loans, venture capital, or angel investors.
When projecting your company’s tax liability, you will need to make a number of assumptions about the tax rates that will apply to your business. You will also need to estimate the amount of taxes your company will owe.
When projecting your company’s balance, you will need to make a number of assumptions about the type and amount of debt your business will have. You will also need to estimate the value of your company’s assets and liabilities.
Write two financial scenarios when creating your financial projections, a best-case scenario, and a worst-case scenario. Use your list of assumptions to come up with realistic numbers for each scenario.
Presuming that you have already generated a list of assumptions, the creation of best and worst-case scenarios should be relatively simple. For each assumption, generate a high and low estimate. For example, if you are assuming that your company will have $100,000 in revenue, your high estimate might be $120,000 and your low estimate might be $80,000.
Once you have generated high and low estimates for all of your assumptions, you can create two scenarios: a best case scenario and a worst-case scenario. Simply plug the high estimates into your financial projections for the best-case scenario and the low estimates into your financial projections for the worst-case scenario.
A ratio analysis is a useful tool that can be used to evaluate a company’s financial health. Ratios can be used to compare a company’s performance to its industry average or to its own historical performance.
There are a number of different ratios that can be used in ratio analysis. Some of the more popular ones include the following:
To conduct a ratio analysis, you will need financial statements for your company and for its competitors. You will also need industry average ratios. These can be found in industry reports or on financial websites.
Once you have the necessary information, you can calculate the ratios for your company and compare them to the industry averages or to your own historical performance. If your company’s ratios are significantly different from the industry averages, it might be indicative of a problem.
When creating your financial projections, it is important to be realistic. Your projections should be based on your list of assumptions and should reflect your best estimate of what your company’s future financial performance will be. This includes projected operating income, a projected income statement, and a profit and loss statement.
Your goal should be to create a realistic set of financial projections that can be used to guide your company’s future decision-making.
One of the most important aspects of your financial projections is your sales forecast. Your sales forecast should be based on your list of assumptions and should reflect your best estimate of what your company’s future sales will be.
Your sales forecast should be realistic and achievable. Do not try to “game” the system by creating an overly optimistic or pessimistic forecast. Your goal should be to create a realistic sales forecast that can be used to guide your company’s future decision-making.
Creating a sales forecast is not an exact science, but there are a number of methods that can be used to generate realistic estimates. Some common methods include market analysis, competitor analysis, and customer surveys.
When creating financial projections, it is important to generate projections for multiple years. This will give you a better sense of how your company’s financial performance is likely to change over time.
It is also important to remember that your financial projections are just that: projections. They are based on a number of assumptions and are not guaranteed to be accurate. As such, you should review and update your projections on a regular basis to ensure that they remain relevant.
Creating financial projections is an important part of any business plan. However, it’s important to remember that these projections are just estimates. They are not guarantees of future success.
What is a business plan financial projection.
A business plan financial projection is a forecast of your company's future financial performance. It should include line items for each type of asset and liability, as well as a total at the end.
The Annual income statement is a financial document and a financial model that summarize a company's revenues and expenses over the course of a fiscal year. They provide a snapshot of a company's financial health and performance and can be used to track trends and make comparisons with other businesses.
The necessary financial statements for a business plan are an income statement, cash flow statement, and balance sheet.
You can create financial projections by making a list of assumptions, creating two scenarios (best case and worst case), conducting a ratio analysis, and being realistic.
A business financial plan is a critical and crucial document for companies and different kinds of business establishments. Whether you are a small start-up or an established corporation, it is necessary for you to create a business financial plan as it can help you achieve your desired financial condition and other strategic objectives. The financial planning process will allow you to identify the key points of your financial needs as well as the ways on how you can let the organization realize its financial goals.
Size: A4, US
We listed a number of business financial plan templates and examples that you can use as document guides and references if you want to start creating your business’s own financial plan document. The examples available in this post can make it easier and faster for you to develop the format and discussion flow of your business plans .
Size: 353 KB
Size: 300 KB
Size: 338 KB
A financial adviser marketing plan can help you select the best financial adviser that you can work with so that you can better the financial standing of your business. However, having a professional help you is not enough to maintain the efficiency and effectiveness of your financial actions. One of the documents that you can use to sustain your financial processes is a business financial plan. This document can also help you a lot if you want to grow as a business in terms of your finances. A few of the reasons why it is important for you to have a well-formulated business financial plan include the following:
Size: 477 KB
Size: 506 KB
Bridging the gap between your current financial condition and your financial aspiration can be overwhelming and intimidating. This is why you need to be well-guided in the implementation of your action plans that involve your finances and how you use them for your business operations. Here are the steps that you can follow when developing a simple and basic business financial plan:
Size: 96 KB
Have you ever asked yourself on why a business financial plan is still used nowadays in various industries even if businesses can resort to the usage of other documents and/or processes when evaluating their financial decisions? The underlying reason behind this is most likely the effectiveness of the document which can be observed in the improvement of a company’s financial condition. Listed below are some of the reasons why it is essential for you to come up with a business financial plan:
Size: 78 KB
Size: 1,023 KB
As a business document, a financial plan promotes awareness of your current corporate financial condition while ensuring that the gathered information can be used to improve the financial standing of the business. This document deals with the programs and activities that are needed for financial growth as well as the resources that the business needs to execute its action plans. A few of the tips that can help you make a highly functional business financial plan include the following:
If you do not know where to start when making a business financial plan, make sure to check out the examples that we have provided you with in this post. Browse through these examples and identify the ones that you can use as your content and formatting guides so you can develop a business financial plan with ease. You may also see network marketing business plan examples .
Text prompt
Create a study plan for final exams in high school
Develop a project timeline for a middle school science fair.
IMAGES
VIDEO
COMMENTS
Use the numbers that you put in your sales forecast, expense projections, and cash flow statement. "Sales, lest cost of sales, is gross margin," Berry says. "Gross margin, less expenses, interest ...
Revenue - Expenses = Profit / Loss. Consider it as a snapshot of your business that shows the feasibility of your business idea. An income statement can be generated considering three scenarios: worst, expected, and best. Your income or P&L statement must list the following: Cost of goods or cost of sale.
This financial plan projections template comes as a set of pro forma templates designed to help startups. The template set includes a 12-month profit and loss statement, a balance sheet, and a cash flow statement for you to detail the current and projected financial position of a business. Download Startup Financial Projections Template.
Financial Statement #1: Profit & Loss. The profit and loss (P&L), also referred to as "income statement", is a summary of all your revenues and expenses over a given time period. By subtracting expenses from revenues, it gives a clear picture of whether your business is profitable, or loss-making. With the balance sheet and the cash flow ...
In This Article. Taking Stock of Expenses. The Income Statement. The Cash Flow Projection. The Balance Sheet. Photo: Jetta Productions Inc/Getty Images. Learn how to write the financial plan section of your business plan: income statement, cash flow projections, and balance sheet (with examples).
3. Equity: Total assets minus total liabilities (Assets = liabilities + equity.) Analysis. It's good to offer readers an analysis of the three basic financial statements — how they fit ...
Financial ratios and metrics. With your financial statements and forecasts in place, you have all the numbers needed to calculate insightful financial ratios. While including these metrics in your financial plan for a business plan is entirely optional, having them easily accessible can be valuable for tracking your performance and overall ...
Generally, the financial section is one of the last sections in a business plan. It describes a business's historical financial state (if applicable) and future financial projections. Businesses include supporting documents such as budgets and financial statements, as well as funding requests in this section of the plan. The financial part of ...
business financial plan 1. financial overview 2. assumptions. page 2 3. key financial indicators and ratios . page 3 4. break-even analysis . page 4 5. financial statements 5.1 pro forma profit and loss statement . page 5 5.2 pro forma cash flow statement . page 6 5.3 pro forma balance sheet . page 7
A small business financial plan is an outline of the financial status of your business, including income statements, balance sheets, and cash flow information. A financial plan can help guide a small business toward sustainable growth. Financial plans can aid in business goal setting and metrics tracking, as well as provide proof of profitable ...
Ideally, your cash flow statement will allow you to recognize where cash is low, when you might have a surplus, and how to be on top of your game when operating in an uncertain environment. How to Prepare a Business Plan Financial Projections Statement. 1. Start by preparing a revenue forecast and a forecast profit and loss statement.
Sections to include in your business plan financials. Here are the three statements to include in the finance section of your business plan: Profit and loss statement. A profit and loss statement, also known as an income statement, identifies your business's revenue (profit) and expenses (loss). This document describes your company's ...
Financial statements aid in making decisions about investing in a company, lending money to a company, or providing other forms of financing. There are three main types of financial statements: balance sheets, income statements, and cash flow statements. These are compiled using Generally Accepted Accounting Principles (GAAP).
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 ...
When writing a business plan, it's important to put together a comprehensive financial plan detailing your expenses, revenue and cash flow. Learn more here.
Put simply, a balance sheet shows what a company owns (assets), what it owes (liabilities), and how much owners and shareholders have invested (equity). Including a balance sheet in your business plan is an essential part of your financial forecast, alongside the income statement and cash flow statement. These statements give anyone looking ...
Here is a basic template that any business can use when developing its business plan: Section 1: Executive Summary. Present the company's mission. Describe the company's product and/or service offerings. Give a summary of the target market and its demographics.
The financial section of your business plan should include a sales forecast, expenses budget, cash flow statement, balance sheet, and a profit and loss statement. Be sure to follow the generally accepted accounting principles (GAAP) set forth by the Financial Accounting Standards Board, a private-sector organization responsible for setting ...
There are three main financial statements that you will need to include in your business plan financial projections: 1. Income Statement Projection. The income statement projection is a forecast of your company's future revenues and expenses. It should include line items for each type of income and expense, as well as a total at the end.
A business financial plan is a critical and crucial document for companies and different kinds of business establishments. Whether you are a small start-up or an established corporation, it is necessary for you to create a business financial plan as it can help you achieve your desired financial condition and other strategic objectives. The financial planning process will allow you to identify ...