Sit n' Caddy

Start your own business plan »

Garden Furniture Maker 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
Unit Sales
Sit N' Caddy 0% 100 500 500 700 1,700 2,000 200 100 1,000 1,200 1,200 800
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 100 500 500 700 1,700 2,000 200 100 1,000 1,200 1,200 800
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sit N' Caddy $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00
Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Sit N' Caddy $2,000 $10,000 $10,000 $14,000 $34,000 $40,000 $4,000 $2,000 $20,000 $24,000 $24,000 $16,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $2,000 $10,000 $10,000 $14,000 $34,000 $40,000 $4,000 $2,000 $20,000 $24,000 $24,000 $16,000
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sit N' Caddy 0.00% $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Sit N' Caddy $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,000
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
Keith Jones 0% $250 $1,250 $1,250 $1,750 $4,250 $5,000 $500 $250 $2,500 $3,000 $3,000 $2,000
Rob Kane 0% $250 $1,250 $1,250 $1,750 $4,250 $5,000 $500 $250 $2,500 $3,000 $3,000 $2,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $2,000 $10,000 $10,000 $14,000 $34,000 $40,000 $4,000 $2,000 $20,000 $24,000 $24,000 $16,000
Direct Cost of Sales $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,000
Gross Margin $1,500 $7,500 $7,500 $10,500 $25,500 $30,000 $3,000 $1,500 $15,000 $18,000 $18,000 $12,000
Gross Margin % 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00% 75.00%
Expenses
Payroll $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,000
Sales and Marketing and Other Expenses $0 $500 $0 $0 $500 $500 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Equipment Payments $0 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Shop Rent $0 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Payroll Taxes 15% $75 $375 $375 $525 $1,275 $1,500 $150 $75 $750 $900 $900 $600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $875 $5,175 $4,675 $5,825 $12,075 $13,800 $2,950 $2,375 $7,550 $8,700 $8,700 $6,400
Profit Before Interest and Taxes $625 $2,325 $2,825 $4,675 $13,425 $16,200 $50 ($875) $7,450 $9,300 $9,300 $5,600
EBITDA $625 $2,325 $2,825 $4,675 $13,425 $16,200 $50 ($875) $7,450 $9,300 $9,300 $5,600
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $188 $581 $706 $1,169 $3,356 $4,050 $13 ($219) $1,863 $2,325 $2,325 $1,400
Net Profit $438 $1,744 $2,119 $3,506 $10,069 $12,150 $38 ($656) $5,588 $6,975 $6,975 $4,200
Net Profit/Sales 21.88% 17.44% 21.19% 25.04% 29.61% 30.38% 0.94% -32.81% 27.94% 29.06% 29.06% 26.25%
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 $2,000 $10,000 $10,000 $14,000 $34,000 $40,000 $4,000 $2,000 $20,000 $24,000 $24,000 $16,000
Subtotal Cash from Operations $2,000 $10,000 $10,000 $14,000 $34,000 $40,000 $4,000 $2,000 $20,000 $24,000 $24,000 $16,000
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 $2,000 $10,000 $10,000 $14,000 $34,000 $40,000 $4,000 $2,000 $20,000 $24,000 $24,000 $16,000
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 $500 $2,500 $2,500 $3,500 $8,500 $10,000 $1,000 $500 $5,000 $6,000 $6,000 $4,000
Bill Payments $52 $1,744 $6,952 $5,472 $8,522 $20,884 $18,915 $1,952 $1,781 $5,636 $12,088 $10,844
Subtotal Spent on Operations $552 $4,244 $9,452 $8,972 $17,022 $30,884 $19,915 $2,452 $6,781 $11,636 $18,088 $14,844
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 $552 $4,244 $9,452 $8,972 $17,022 $30,884 $19,915 $2,452 $6,781 $11,636 $18,088 $14,844
Net Cash Flow $1,448 $5,756 $548 $5,028 $16,978 $9,116 ($15,915) ($452) $13,219 $12,364 $5,912 $1,156
Cash Balance $1,948 $7,704 $8,252 $13,280 $30,259 $39,375 $23,460 $23,007 $36,226 $48,590 $54,501 $55,657
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 $500 $1,948 $7,704 $8,252 $13,280 $30,259 $39,375 $23,460 $23,007 $36,226 $48,590 $54,501 $55,657
Inventory $1,000 $1,500 $2,750 $2,750 $3,850 $9,350 $11,000 $10,000 $9,500 $5,500 $6,600 $6,600 $4,400
Other Current Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Total Current Assets $11,500 $13,448 $20,454 $21,002 $27,130 $49,609 $60,375 $43,460 $42,507 $51,726 $65,190 $71,101 $70,057
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 $11,500 $13,448 $20,454 $21,002 $27,130 $49,609 $60,375 $43,460 $42,507 $51,726 $65,190 $71,101 $70,057
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 $1,510 $6,773 $5,202 $7,824 $20,234 $18,850 $1,897 $1,601 $5,232 $11,721 $10,658 $5,413
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 $1,510 $6,773 $5,202 $7,824 $20,234 $18,850 $1,897 $1,601 $5,232 $11,721 $10,658 $5,413
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,510 $6,773 $5,202 $7,824 $20,234 $18,850 $1,897 $1,601 $5,232 $11,721 $10,658 $5,413
Paid-in Capital $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Retained Earnings ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500)
Earnings $0 $438 $2,181 $4,300 $7,806 $17,875 $30,025 $30,063 $29,406 $34,994 $41,969 $48,944 $53,144
Total Capital $11,500 $11,938 $13,681 $15,800 $19,306 $29,375 $41,525 $41,563 $40,906 $46,494 $53,469 $60,444 $64,644
Total Liabilities and Capital $11,500 $13,448 $20,454 $21,002 $27,130 $49,609 $60,375 $43,460 $42,507 $51,726 $65,190 $71,101 $70,057
Net Worth $11,500 $11,938 $13,681 $15,800 $19,306 $29,375 $41,525 $41,562 $40,906 $46,494 $53,469 $60,444 $64,644