Our biggest savings of the year
Sit n' Caddy
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 |