WorkChairs

Start your own business plan »

Office Furniture Store Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Chairs 0% $2,000 $2,400 $2,880 $3,456 $4,147 $4,977 $5,972 $7,166 $8,600 $10,320 $12,383 $14,860
Computer Accessories 0% $400 $460 $529 $608 $700 $805 $925 $1,064 $1,224 $1,407 $1,618 $1,861
Workstations 0% $1,000 $1,150 $1,323 $1,521 $1,749 $2,011 $2,313 $2,660 $3,059 $3,518 $4,046 $4,652
Other 0% $500 $600 $720 $864 $1,037 $1,244 $1,493 $1,792 $2,150 $2,580 $3,096 $3,715
Total Sales $3,900 $4,610 $5,452 $6,449 $7,633 $9,037 $10,703 $12,682 $15,032 $17,824 $21,143 $25,089
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Chairs $1,000 $1,200 $1,440 $1,728 $2,074 $2,488 $2,986 $3,583 $4,300 $5,160 $6,192 $7,430
Computer Accessories $200 $230 $265 $304 $350 $402 $463 $532 $612 $704 $809 $930
Workstations $500 $575 $661 $760 $875 $1,006 $1,157 $1,330 $1,530 $1,759 $2,023 $2,326
Other $250 $300 $360 $432 $518 $622 $746 $896 $1,075 $1,290 $1,548 $1,858
Subtotal Direct Cost of Sales $1,950 $2,305 $2,726 $3,225 $3,816 $4,518 $5,352 $6,341 $7,516 $8,912 $10,572 $12,544
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Jake Wilson 0% $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Lisa Wilson 0% $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Peter Wilson 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $1,000 $1,000 $1,000 $1,000 $1,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $3,900 $4,610 $5,452 $6,449 $7,633 $9,037 $10,703 $12,682 $15,032 $17,824 $21,143 $25,089
Direct Cost of Sales $1,950 $2,305 $2,726 $3,225 $3,816 $4,518 $5,352 $6,341 $7,516 $8,912 $10,572 $12,544
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,950 $2,305 $2,726 $3,225 $3,816 $4,518 $5,352 $6,341 $7,516 $8,912 $10,572 $12,544
Gross Margin $1,950 $2,305 $2,726 $3,225 $3,816 $4,518 $5,352 $6,341 $7,516 $8,912 $10,572 $12,544
Gross Margin % 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Expenses
Payroll $1,000 $1,000 $1,000 $1,000 $1,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Sales and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $150 $150 $150 $150 $150 $1,050 $1,050 $1,050 $1,050 $1,050 $1,050 $1,050
Web Hosting $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Operating Expenses $1,450 $1,450 $1,450 $1,450 $1,450 $8,350 $8,350 $8,350 $8,350 $8,350 $8,350 $8,350
Profit Before Interest and Taxes $500 $855 $1,276 $1,775 $2,366 ($3,832) ($2,998) ($2,009) ($834) $562 $2,222 $4,194
EBITDA $500 $855 $1,276 $1,775 $2,366 ($3,832) ($2,998) ($2,009) ($834) $562 $2,222 $4,194
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $150 $257 $383 $532 $710 ($1,149) ($900) ($603) ($250) $169 $666 $1,258
Net Profit $350 $599 $893 $1,242 $1,656 ($2,682) ($2,099) ($1,406) ($584) $394 $1,555 $2,936
Net Profit/Sales 8.97% 12.98% 16.38% 19.26% 21.70% -29.68% -19.61% -11.09% -3.88% 2.21% 7.36% 11.70%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $3,900 $4,610 $5,452 $6,449 $7,633 $9,037 $10,703 $12,682 $15,032 $17,824 $21,143 $25,089
Subtotal Cash from Operations $3,900 $4,610 $5,452 $6,449 $7,633 $9,037 $10,703 $12,682 $15,032 $17,824 $21,143 $25,089
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $3,900 $4,610 $5,452 $6,449 $7,633 $9,037 $10,703 $12,682 $15,032 $17,824 $21,143 $25,089
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $1,000 $1,000 $1,000 $1,000 $1,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Bill Payments $85 $2,565 $3,030 $3,580 $4,233 $4,968 $4,755 $5,845 $7,139 $8,676 $10,503 $12,674
Subtotal Spent on Operations $1,085 $3,565 $4,030 $4,580 $5,233 $11,968 $11,755 $12,845 $14,139 $15,676 $17,503 $19,674
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $1,085 $3,565 $4,030 $4,580 $5,233 $11,968 $11,755 $12,845 $14,139 $15,676 $17,503 $19,674
Net Cash Flow $2,815 $1,045 $1,422 $1,869 $2,400 ($2,931) ($1,052) ($163) $893 $2,148 $3,640 $5,415
Cash Balance $8,990 $10,035 $11,456 $13,326 $15,725 $12,795 $11,743 $11,580 $12,473 $14,621 $18,261 $23,676
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $6,175 $8,990 $10,035 $11,456 $13,326 $15,725 $12,795 $11,743 $11,580 $12,473 $14,621 $18,261 $23,676
Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Current Assets $8,175 $10,990 $12,035 $13,456 $15,326 $17,725 $14,795 $13,743 $13,580 $14,473 $16,621 $20,261 $25,676
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $8,175 $10,990 $12,035 $13,456 $15,326 $17,725 $14,795 $13,743 $13,580 $14,473 $16,621 $20,261 $25,676
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $2,465 $2,911 $3,440 $4,067 $4,810 $4,562 $5,609 $6,852 $8,329 $10,083 $12,168 $14,647
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $2,465 $2,911 $3,440 $4,067 $4,810 $4,562 $5,609 $6,852 $8,329 $10,083 $12,168 $14,647
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,465 $2,911 $3,440 $4,067 $4,810 $4,562 $5,609 $6,852 $8,329 $10,083 $12,168 $14,647
Paid-in Capital $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Retained Earnings ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825) ($3,825)
Earnings $0 $350 $949 $1,842 $3,084 $4,740 $2,058 ($41) ($1,447) ($2,031) ($1,637) ($82) $2,854
Total Capital $8,175 $8,525 $9,124 $10,017 $11,259 $12,915 $10,233 $8,134 $6,728 $6,144 $6,538 $8,093 $11,029
Total Liabilities and Capital $8,175 $10,990 $12,035 $13,456 $15,326 $17,725 $14,795 $13,743 $13,580 $14,473 $16,621 $20,261 $25,676
Net Worth $8,175 $8,525 $9,124 $10,017 $11,259 $12,915 $10,233 $8,134 $6,728 $6,144 $6,538 $8,093 $11,029