About
Small Business Plan Workbook
· To open this template, click Next on the custom toolbar. · To move from one cell to another, press Tab. · To print any page within this worksheet, click Print on the custom toolbar. This template contains placeholder text. Blue text indicates the cell is unlocked; you can type data in these cells. Black text indicates the cell is locked; you cannot type data in locked cells.
Page 1
About
Page 2
Assumptions
Financial Assumptions
Starting Year 2003 2003 0.00% 0.00% 0.00% 0.00% 2004 0.00% 0.00% 0.00% 0.00% 2005 0.00% 0.00% 0.00% 0.00% 2006 0.00% 0.00% 0.00% 0.00% 2007 0.00% 0.00% 0.00% 0.00%
Short-term interest rate Long-term interest rate Tax rate Personnel burden
Page 3
Assumptions
Page 4
567e4cea-acac-4d6e-85c0-462ea045051a.xls as of 8/13/2008
Year 1 Sales Forecast
Q1-03 Q2-03 0 0 0 0 0 0 $0 0 0 0 0 0 0 $0 0 0 0 0 0 0 $0 0 0 0 0 0 0 $0 Q3-03 0 0 0 0 0 0 $0 0 0 0 0 0 0 $0 Q4-03 0 0 0 0 0 0 $0 0 0 0 0 0 0 $0 2003 0 0 0 0 0 0 $0 0 0 0 0 0 0 $0
Sales
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Other
Total Cost of sales
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Other
Total
Page 5
567e4cea-acac-4d6e-85c0-462ea045051a.xls as of 8/13/2008
Year 1 Pro Forma Income Statement
Q1-03 Q2-03 0 0 0 $0 0 0.00% 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 0 0 0 $0 0 0.00% 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% Q3-03 0 0 0 $0 0 0.00% 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% Q4-03 0 0 0 $0 0 0.00% 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 2003 0 0 0 $0 0 0.00% 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00%
Sales Cost of sales
Currency Other
Total Gross margin
Currency Percent
Operating expenses
Advertising/Promotion Wages and salaries Leased equipment Utilities Insurance Rent Depreciation Payroll taxes etc. Contract/consultants Miscellaneous Other
Total Percent of sales Pre-tax profit
Short-term interest Long-term interest Taxes incurred
Net profit Net profit/sales
Page 6
567e4cea-acac-4d6e-85c0-462ea045051a.xls as of 8/13/2008
Year 1 Sales by Product Line
0%
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Other
Page 7
5-Year Forecast
5-Year Total Market Forecast
TARGETED MARKET SEGMENT ONLY
2003 Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Total market 0 0 0 0 0 $0 2004 0 0 0 0 0 $0 2005 0 0 0 0 0 $0 2006 0 0 0 0 0 $0 2007 0 0 0 0 0 $0
Market Share Objectives
PER MARKET SEGMENT
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 2003 0.00% 0.00% 0.00% 0.00% 0.00% 2004 0.00% 0.00% 0.00% 0.00% 0.00% 2005 0.00% 0.00% 0.00% 0.00% 0.00% 2006 0.00% 0.00% 0.00% 0.00% 0.00% 2007 0.00% 0.00% 0.00% 0.00% 0.00%
Page 8
5-Year Forecast
5-Year Sales Forecast
TOTAL SALES
2003 Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Other 0 0 0 0 0 0 $0 2004 0 0 0 0 0 0 $0 2005 0 0 0 0 0 0 $0 2006 0 0 0 0 0 0 $0 2007 0 0 0 0 0 0 $0 CAGR 0% 0% 0% 0% 0% 0% 0%
Total
TOTAL COST OF SALES
2003 Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Other 0 0 0 0 0 0 $0 2004 0 0 0 0 0 0 $0 2005 0 0 0 0 0 0 $0 2006 0 0 0 0 0 0 $0 2007 0 0 0 0 0 0 $0 CAGR 0% 0% 0% 0% 0% 0% 0%
Total
Page 9
5-Year Forecast
5-Year Sales Forecast
1
1
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5
1 1 1 1 0 0 0
0
0 2003 2004 2005 2006 2007
Page 10
5-Year Forecast
Page 11
5-Year Forecast
5-Year Total Market Forecast
1 1
1
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5
0 0 0 2003 2004 2005 2006 2007
Market Share Objectives
100.00% 90.00% 80.00% 70.00% 60.00% 50.00% 40.00% 30.00% 20.00% 10.00% 0.00% 2003 2004 2005
Product line 1 Product line 2 Product line 3 Product line 4 Product line 5
2006
5-Year Sales Forecast
Page 12
5-Year Forecast
2007
Page 13
Start-Up Needs
Start-Up Costs and Capitalization
List Subtotals Totals
START-UP EXPENSES
General and administrative
Legal and accounting Rental deposits Utility deposits Prepaid insurance Pre-opening salaries Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0
0
Sales and marketing
Advertising Promotion Signage Logo design Printing Other Other
0
Other expenses
Other Other Other
0 $0
$0
Total start-up expenses
Page 14
Start-Up Needs
Start-Up Costs and Capitalization
List Subtotals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0 0 Totals
START-UP ASSETS
Opening cash (min. balance) Inventory
Category 1 Category 2 Category 3 Other Other
0
Capital equipment
Furniture Equipment Fixtures Machinery Other Other
0
Buildings/real estate
Purchase Construction Remodeling expenses Other Other
0
Leasehold improvements
Item No1 Item No2 Item No3 Other Other
0
Other assets
Other Other Other
0 $0
$0
Total start-up assets Start-up requirements
$0
$0
$0
Page 15
Start-Up Needs
Start-Up Costs and Capitalization
List Subtotals Totals
START-UP CAPITALIZATION
Owners’ investment
Owner 1 Owner 2 Owner 3 Other Other Other 0 0 0 0 0 0 0 0 0 0 0 0 0 $0 $0
0
Bank loans
Bank 1 Bank 2 Other Other
0
Other loans
Other Other Other
0 $0 $0
$0
Total capitalization Capitalization deficit
$0
Page 16
Income Statement
5-Year Pro Forma Income Statement
SALES AND GROSS MARGIN
2003 2004 0 0 0 $0 0 0 0 $0 2005 0 0 0 $0 2006 0 0 0 $0 2007 0 0 0 $0 CAGR 0% 0% 0% 0%
Sales
Sales revenue
Cost of sales
Cost of sales Other sales costs
Total cost of sales Gross margin
Margin Percent
0 0.00%
0 0.00%
0 0.00%
0 0.00%
0 0.00%
0%
OPERATING EXPENSES
2003 2004 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 2005 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 2006 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 2007 0 0 0 0 0 0 0 0 0 0 0 $0 0.00% 0 0 0 0 $0 0.00% 0% 0% 0% 0% 0% CAGR 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% ]
Expenses
Advertising/promotion Wages and salaries Leased equipment Utilities Insurance Rent Depreciation Payroll taxes etc. Contract/consultants Miscellaneous Other
Total Percent of sales Profit
Operating profit Short-term interest Long-term interest Taxes incurred
Net profit Net profit/sales
Page 17
Income Statement
2003 Profits Analysis
Cost of sales Operating expenses Interest
0% 0% 0%
Profitability Details
2003 Cost of sales Operating expenses Interest Tax Profits Sales 0 0 0 0 0 0 2004 0 0 0 0 0 0 2005 0 0 0 0 0 0 2006 0 0 0 0 0 0 2007 0 0 0 0 0 0
Page 18
Income Statement
Company Business Plan Highlights
Sales revenue
1 1
1
Margin
Net profit
1 1 1 0 0 0
0 0
2003
2004
2005
2006
2007
Page 19
Income Statement
Page 20
Balance Sheet
5-Year Pro Forma Balance Sheet
2003 2004 2005 2006 2007 CAGR
ASSETS
Short-term assets
Cash Accounts receivable Inventory Other short-term assets 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0 0 0 0 $0 0% 0% 0% 0% 0%
Total Long-term assets
Capital assets Accumulated depreciation
Total Total assets
0 0 $0 $0
0 0 $0 $0
0 0 $0 $0
0 0 $0 $0
0 0 $0 $0
0% 0% 0% 0%
DEBT AND EQUITY
Short-term liabilities
Accounts payable Short-term notes Other short-term liabilities 0 0 0 $0 0 $0 0 0 0 $0 $0 $0 $0 0 0 0 $0 0 $0 0 0 0 $0 $0 $0 $0 0 0 0 $0 0 $0 0 0 0 $0 $0 $0 $0 0 0 0 $0 0 $0 0 0 0 $0 $0 $0 $0 0 0 0 $0 0 $0 0 0 0 $0 $0 $0 $0 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Total Long-term liabilities Total liabilities Equity
Paid-in capital Retained earnings Earnings
Total Total debt and equity
Check line
Net worth
Page 21
Balance Sheet
Page 22
Balance Sheet
Company Projected Net Worth
$1 $1 $1 $1 $1 $1
$0
$0 $0 $0 $0 2003 2004 2005 2006 2007
Page 23
Balance Sheet
Page 24
Break-Even Analysis
Break-Even Analysis
ASSUMPTIONS
Average sale Variable cost per sale Fixed expenses per month $0 0 0
MONTHLY BREAK-EVEN VOLUME
Units Sales 0 $0
Page 25
Break-Even Analysis
Company Break-Even Analysis
Monthly Profits
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1
Page 26
Break-Even Analysis
1
Monthly Sales
1
Page 27
Business Ratios
Business Ratios
2003 Gross margin Net margin Return on equity Return on investment Return on assets Current ratio Quick ratio Debt to equity Net worth 0% 0.00% 0% 0% 0% 0.00 0.00 0% $0 2004 0% 0.00% 0% 0% 0% 0.00 0.00 0% $0 2005 0% 0.00% 0% 0% 0% 0.00 0.00 0% $0 2006 0% 0.00% 0% 0% 0% 0.00 0.00 0% $0 2007 0% 0.00% 0% 0% 0% 0.00 0.00 0% $0
Page 28