Docstoc

Small Business Plan Workbook

Document Sample
Small Business Plan Workbook Powered By Docstoc
					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


				
DOCUMENT INFO
Shared By:
Stats:
views:1173
posted:1/4/2008
language:English
pages:28
destined destined
About