professional documents
home
Profile
docsters
request
Blogs
Upload
about me
contact me
user photo
submit clear
Excel Spreadsheet

Small Business Plan Workbook center doc

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
rate this doc
email this doc
embed this doc
add to folder
digg reddit stumble delicious
flag this doc
428
88
not rated
0
1/4/2008
English
search termpage on Googletimes searched
Preview

Small Business Mobilization Plan

SBA 6/19/2008 | 29 | 0 | 0 | legal
Preview

small farm business planning

ocak 1/28/2008 | 205 | 16 | 0 | business
Preview

BUDGETING FOR THE SMALL BUSINESS

SBA 6/19/2008 | 29 | 1 | 0 | legal
Preview

Uganda Small Business Guide

user002 2/5/2008 | 206 | 3 | 0 | business
Preview

Small Business Guide

user002 2/5/2008 | 211 | 12 | 0 | business
Preview

Small Business Starts Template

user002 2/5/2008 | 254 | 15 | 0 | business
Preview

Small Business Subcontracting Plan

banter 1/8/2008 | 538 | 47 | 0 | business
Preview

small business evaluation

robandlarac 4/25/2008 | 163 | 20 | 0 | financial
Preview

small business budget

robandlarac 4/25/2008 | 188 | 30 | 0 | financial
Preview

Small Business Act

stiletto 7/3/2008 | 50 | 1 | 0 | business
Preview

Checklist for Starting a Small Business

anonymous 8/31/2007 | 662 | 41 | 0 | business
Preview

U.S. SBA Publication - Management and Planning Series - Business Plan For Small Manufacturers

Mythri 2/13/2008 | 121 | 7 | 0 | business
Preview

U.S. SBA Publication - Management and Planning Series - Business Plan For the Small Retailer

Mythri 2/13/2008 | 154 | 8 | 0 | business
Preview

Marketing for a Small Business

user003 2/8/2008 | 816 | 126 | 0 | business
Preview

Project Portfolio Data Collection Template

destined 1/4/2008 | 769 | 116 | 0 | business
Preview

Lessons Learned Template

destined 1/4/2008 | 2457 | 316 | 1 | business
Preview

Startup Expenses Template

destined 1/4/2008 | 903 | 154 | 0 | business
Preview

Accruals Template

destined 1/4/2008 | 251 | 28 | 0 | business
Preview

Oil and Gas Industry Spreadsheet

destined 1/4/2008 | 392 | 54 | 0 | business
Preview

Business Risk Template

destined 1/4/2008 | 853 | 233 | 1 | business
Preview

System Test Cases Template

destined 1/3/2008 | 1331 | 335 | 1 | business
Preview

Cashflow Forecast Template

destined 1/3/2008 | 574 | 39 | 0 | business
Preview

OPERATIONAL RISK LOSSES TEMPLATE

destined 1/3/2008 | 253 | 31 | 0 | business
Preview

Vendor Response Template

destined 1/3/2008 | 305 | 36 | 0 | business
business12
business planning workbook photography11
proforma statements workbook21
 
review this doc