login
|
join
professional documents
home
Profile
docsters
request
Blogs
Upload
all docs
legal
business
financial
technology
educational
creative
BUZZ
destined
about me
contact me
In order to send a message you need to be logged in.
Small Business Plan Workbook
Categories
business
>
Bz Planing
>
Sample Business Plans
Tags
Small Biz
,
Small bizplan
be first to review
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 1About Page 2Assumptions Financial Assumptions Starting Year 2003 2003 2004 2005 2006 2007 Short-term interest rate 0.00% 0.00% 0.00% 0.00% 0.00% Long-term interest rate 0.00% 0.00% 0.00% 0.00% 0.00% Tax rate 0.00% 0.00% 0.00% 0.00% 0.00% Personnel burden 0.00% 0.00% 0.00% 0.00% 0.00% Page 3Assumptions Page 4$ASQSmall_Business_Plan_Workbook.xls as of 1/30/2008 Year 1 Sales Forecast Q1-03 Q2-03 Q3-03 Q4-03 2003 Sales Product line 1 0 0 0 0 0 Product line 2 0 0 0 0 0 Product line 3 0 0 0 0 0 Product line 4 0 0 0 0 0 Product line 5 0 0 0 0 0 Other 0 0 0 0 0 Total $0 $0 $0 $0 $0 Cost of sales Product line 1 0 0 0 0 0 Product line 2 0 0 0 0 0 Product line 3 0 0 0 0 0 Product line 4 0 0 0 0 0 Product line 5 0 0 0 0 0 Other 0 0 0 0 0 Total $0 $0 $0 $0 $0 Page 5$ASQSmall_Business_Plan_Workbook.xls as of 1/30/2008 Year 1 Pro Forma Income Statement Q1-03 Q2-03 Q3-03 Q4-03 2003 Sales 0 0 0 0 0 Cost of sales Currency 0 0 0 0 0 Other 0 0 0 0 0 Total $0 $0 $0 $0 $0 Gross margin Currency 0 0 0 0 0 Percent 0.00% 0.00% 0.00% 0.00% 0.00% Operating expenses Advertising/Promotion 0 0 0 0 0 Wages and salaries 0 0 0 0 0 Leased equipment 0 0 0 0 0 Utilities 0 0 0 0 0 Insurance 0 0 0 0 0 Rent 0 0 0 0 0 Depreciation 0 0 0 0 0 Payroll taxes etc. 0 0 0 0 0 Contract/consultants 0 0 0 0 0 Miscellaneous 0 0 0 0 0 Other 0 0 0 0 0 Total $0 $0 $0 $0 $0 Percent of sales 0.00% 0.00% 0.00% 0.00% 0.00% Pre-tax profit 0 0 0 0 0 Short-term interest 0 0 0 0 0 Long-term interest 0 0 0 0 0 Taxes incurred 0 0 0 0 0 Net profit $0 $0 $0 $0 $0 Net profit/sales 0.00% 0.00% 0.00% 0.00% 0.00% Page 6$ASQSmall_Business_Plan_Workbook.xls as of 1/30/2008 Year 1 Sales by Product Line 1% Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Other Page 75-Year Forecast 5-Year Total Market Forecast TARGETED MARKET SEGMENT ONLY 2003 2004 2005 2006 2007 Product line 1 0 0 0 0 0 Product line 2 0 0 0 0 0 Product line 3 0 0 0 0 0 Product line 4 0 0 0 0 0 Product line 5 0 0 0 0 0 Total market $0 $0 $0 $0 $0 Market Share Objectives PER MARKET SEGMENT 2003 2004 2005 2006 2007 Product line 1 0.00% 0.00% 0.00% 0.00% 0.00% Product line 2 0.00% 0.00% 0.00% 0.00% 0.00% Product line 3 0.00% 0.00% 0.00% 0.00% 0.00% Product line 4 0.00% 0.00% 0.00% 0.00% 0.00% Product line 5 0.00% 0.00% 0.00% 0.00% 0.00% Page 85-Year Forecast 5-Year Sales Forecast TOTAL SALES 2003 2004 2005 2006 2007 CAGR Product line 1 0 0 0 0 0 0% Product line 2 0 0 0 0 0 0% Product line 3 0 0 0 0 0 0% Product line 4 0 0 0 0 0 0% Product line 5 0 0 0 0 0 0% Other 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% TOTAL COST OF SALES 2003 2004 2005 2006 2007 CAGR Product line 1 0 0 0 0 0 0% Product line 2 0 0 0 0 0 0% Product line 3 0 0 0 0 0 0% Product line 4 0 0 0 0 0 0% Product line 5 0 0 0 0 0 0% Other 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% Page 95-Year Forecast 00000111111 2003 2004 2005 2006 2007 5-Year Sales Forecast Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Page 105-Year Forecast 2007 Page 115-Year Forecast 000111 2003 2004 2005 2006 2007 5-Year Total Market Forecast Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Market Share Objectives 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 90.00% 100.00%2003 2004 2005 2006 2007 Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 0000111111 5-Year Sales Forecast Product line 1 Product line 2 Product line 3 Product line 4 Product line 5 Page 125-Year Forecast 2007 Page 13Start-Up Needs Start-Up Costs and Capitalization List Subtotals Totals START-UP EXPENSES General and administrative Legal and accounting 0 Rental deposits 0 Utility deposits 0 Prepaid insurance 0 Pre-opening salaries 0 Other 0 0 Sales and marketing Advertising 0 Promotion 0 Signage 0 Logo design 0 Printing 0 Other 0 Other 0 0 Other expenses Other 0 Other 0 Other 0 0 $0 Total start-up expenses $0 $0 Page 14Start-Up Needs Start-Up Costs and Capitalization List Subtotals Totals START-UP ASSETS Opening cash (min. balance) 0 0 Inventory Category 1 0 Category 2 0 Category 3 0 Other 0 Other 0 0 Capital equipment Furniture 0 Equipment 0 Fixtures 0 Machinery 0 Other 0 Other 0 0 Buildings/real estate Purchase 0 Construction 0 Remodeling expenses 0 Other 0 Other 0 0 Leasehold improvements Item No1 0 Item No2 0 Item No3 0 Other 0 Other 0 0 Other assets Other 0 Other 0 Other 0 0 $0 Total start-up assets $0 $0 Start-up requirements $0 $0 $0 Page 15Start-Up Needs Start-Up Costs and Capitalization List Subtotals Totals START-UP CAPITALIZATION Owners’ investment Owner 1 0 Owner 2 0 Owner 3 0 Other 0 Other 0 Other 0 0 Bank loans Bank 1 0 Bank 2 0 Other 0 Other 0 0 Other loans Other 0 Other 0 Other 0 0 $0 Total capitalization $0 $0 Capitalization deficit $0 $0 $0 Page 16Income Statement 5-Year Pro Forma Income Statement SALES AND GROSS MARGIN 2003 2004 2005 2006 2007 CAGR Sales Sales revenue 0 0 0 0 0 0% Cost of sales Cost of sales 0 0 0 0 0 0% Other sales costs 0 0 0 0 0 0% Total cost of sales $0 $0 $0 $0 $0 0% Gross margin Margin 0 0 0 0 0 0% Percent 0.00% 0.00% 0.00% 0.00% 0.00% OPERATING EXPENSES 2003 2004 2005 2006 2007 CAGR Expenses Advertising/promotion 0 0 0 0 0 0% Wages and salaries 0 0 0 0 0 0% Leased equipment 0 0 0 0 0 0% Utilities 0 0 0 0 0 0% Insurance 0 0 0 0 0 0% Rent 0 0 0 0 0 0% Depreciation 0 0 0 0 0 0% Payroll taxes etc. 0 0 0 0 0 0% Contract/consultants 0 0 0 0 0 0% Miscellaneous 0 0 0 0 0 0% Other 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% ] Percent of sales 0.00% 0.00% 0.00% 0.00% 0.00% Profit Operating profit 0 0 0 0 0 0% Short-term interest 0 0 0 0 0 0% Long-term interest 0 0 0 0 0 0% Taxes incurred 0 0 0 0 0 0% Net profit $0 $0 $0 $0 $0 0% Net profit/sales 0.00% 0.00% 0.00% 0.00% 0.00% 2003 Profits Analysis Cost of sales Operating expenses Interest Page 17Income Statement Profitability Details 2003 2004 2005 2006 2007 Cost of sales 0 0 0 0 0 Operating expenses 0 0 0 0 0 Interest 0 0 0 0 0 Tax 0 0 0 0 0 Profits 0 0 0 0 0 Sales 0 0 0 0 0 2003 Profits Analysis 1% 1% 1% Cost of sales Operating expenses Interest Page 18Income Statement 00000111111 2003 2004 2005 2006 2007 Company Business Plan HighlightsSales revenue Margin Net profit Page 19Income Statement 2007 Page 20Balance Sheet 5-Year Pro Forma Balance Sheet 2003 2004 2005 2006 2007 CAGR ASSETS Short-term assets Cash 0 0 0 0 0 0% Accounts receivable 0 0 0 0 0 0% Inventory 0 0 0 0 0 0% Other short-term assets 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% Long-term assets Capital assets 0 0 0 0 0 0% Accumulated depreciation 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% Total assets $0 $0 $0 $0 $0 0% DEBT AND EQUITY Short-term liabilities Accounts payable 0 0 0 0 0 0% Short-term notes 0 0 0 0 0 0% Other short-term liabilities 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% Long-term liabilities 0 0 0 0 0 0% Total liabilities $0 $0 $0 $0 $0 0% Equity Paid-in capital 0 0 0 0 0 0% Retained earnings 0 0 0 0 0 0% Earnings 0 0 0 0 0 0% Total $0 $0 $0 $0 $0 0% Total debt and equity $0 $0 $0 $0 $0 0% Check line $0 $0 $0 $0 $0 Net worth $0 $0 $0 $0 $0 0% Page 21Balance Sheet Page 22Balance Sheet $0 $0 $0 $0 $0 $1 $1 $1 $1 $1 $1 2003 2004 2005 2006 2007 Company Projected Net Worth Page 23Balance Sheet 2007 Page 24Break-Even Analysis Break-Even Analysis ASSUMPTIONSAverage sale $0 Variable cost per sale 0 Fixed expenses per month 0 MONTHLY BREAK-EVEN VOLUME Units 0 Sales $0 Page 25Break-Even Analysis Company Break-Even Analysis 00000111111 0 0 0 0 0 1 1 1 1 1Monthly Sales Monthly Profits Page 26Break-Even Analysis 1 1 Monthly Sales Page 27Business Ratios Business Ratios 2003 2004 2005 2006 2007 Gross margin 0% 0% 0% 0% 0% Net margin 0.00% 0.00% 0.00% 0.00% 0.00% Return on equity 0% 0% 0% 0% 0% Return on investment 0% 0% 0% 0% 0% Return on assets 0% 0% 0% 0% 0% Current ratio 0.00 0.00 0.00 0.00 0.00 Quick ratio 0.00 0.00 0.00 0.00 0.00 Debt to equity 0% 0% 0% 0% 0% Net worth $0 $0 $0 $0 $0 Page 28
Public Domain
views:
428
downloads:
88
rating:
not rated
reviews:
0
posted:
1/4/2008
language:
English
related docs
other docs by this user
search analytics
search term
page on Google
times searched
Small Business Mobilization Plan
shared by:
SBA
on:
6/19/2008
|
views:
29
|
downloads:
0
|
comments:
0
|
category:
legal
small farm business planning
shared by:
ocak
on:
1/28/2008
|
views:
205
|
downloads:
16
|
comments:
0
|
category:
business
BUDGETING FOR THE SMALL BUSINESS
shared by:
SBA
on:
6/19/2008
|
views:
29
|
downloads:
1
|
comments:
0
|
category:
legal
Uganda Small Business Guide
shared by:
user002
on:
2/5/2008
|
views:
206
|
downloads:
3
|
comments:
0
|
category:
business
Small Business Guide
shared by:
user002
on:
2/5/2008
|
views:
211
|
downloads:
12
|
comments:
0
|
category:
business
Small Business Starts Template
shared by:
user002
on:
2/5/2008
|
views:
254
|
downloads:
15
|
comments:
0
|
category:
business
Small Business Subcontracting Plan
shared by:
banter
on:
1/8/2008
|
views:
538
|
downloads:
47
|
comments:
0
|
category:
business
small business evaluation
shared by:
robandlarac
on:
4/25/2008
|
views:
163
|
downloads:
20
|
comments:
0
|
category:
financial
small business budget
shared by:
robandlarac
on:
4/25/2008
|
views:
188
|
downloads:
30
|
comments:
0
|
category:
financial
Small Business Act
shared by:
stiletto
on:
7/3/2008
|
views:
50
|
downloads:
1
|
comments:
0
|
category:
business
Checklist for Starting a Small Business
shared by:
anonymous
on:
8/31/2007
|
views:
662
|
downloads:
41
|
comments:
0
|
category:
business
U.S. SBA Publication - Management and Planning Series - Business Plan For Small Manufacturers
shared by:
Mythri
on:
2/13/2008
|
views:
121
|
downloads:
7
|
comments:
0
|
category:
business
U.S. SBA Publication - Management and Planning Series - Business Plan For the Small Retailer
shared by:
Mythri
on:
2/13/2008
|
views:
154
|
downloads:
8
|
comments:
0
|
category:
business
Marketing for a Small Business
shared by:
user003
on:
2/8/2008
|
views:
816
|
downloads:
126
|
comments:
0
|
category:
business
Project Portfolio Data Collection Template
shared by:
destined
on:
1/4/2008
|
views:
769
|
downloads:
116
|
comments:
0
|
category:
business
Lessons Learned Template
shared by:
destined
on:
1/4/2008
|
views:
2457
|
downloads:
316
|
comments:
1
|
category:
business
Startup Expenses Template
shared by:
destined
on:
1/4/2008
|
views:
903
|
downloads:
154
|
comments:
0
|
category:
business
Accruals Template
shared by:
destined
on:
1/4/2008
|
views:
251
|
downloads:
28
|
comments:
0
|
category:
business
Oil and Gas Industry Spreadsheet
shared by:
destined
on:
1/4/2008
|
views:
392
|
downloads:
54
|
comments:
0
|
category:
business
Business Risk Template
shared by:
destined
on:
1/4/2008
|
views:
853
|
downloads:
233
|
comments:
1
|
category:
business
System Test Cases Template
shared by:
destined
on:
1/3/2008
|
views:
1331
|
downloads:
335
|
comments:
1
|
category:
business
Cashflow Forecast Template
shared by:
destined
on:
1/3/2008
|
views:
574
|
downloads:
39
|
comments:
0
|
category:
business
OPERATIONAL RISK LOSSES TEMPLATE
shared by:
destined
on:
1/3/2008
|
views:
253
|
downloads:
31
|
comments:
0
|
category:
business
Vendor Response Template
shared by:
destined
on:
1/3/2008
|
views:
305
|
downloads:
36
|
comments:
0
|
category:
business
business
1
2
business planning workbook photography
1
1
proforma statements workbook
2
1