SmokeJumpers
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 | |||||||||||||
Clothing | 0% | $3,000 | $5,000 | $6,000 | $8,000 | $11,000 | $14,000 | $14,000 | $15,000 | $17,000 | $19,000 | $11,000 | $9,000 |
Shoes | 0% | $800 | $1,500 | $2,050 | $3,000 | $4,000 | $4,000 | $4,000 | $5,000 | $6,000 | $6,000 | $3,000 | $3,000 |
Products | 0% | $300 | $700 | $1,300 | $1,500 | $2,000 | $2,000 | $2,000 | $3,000 | $3,000 | $4,000 | $1,000 | $1,500 |
Total Sales | $4,100 | $7,200 | $9,350 | $12,500 | $17,000 | $20,000 | $20,000 | $23,000 | $26,000 | $29,000 | $15,000 | $13,500 | |
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 | |
Clothing | $800 | $1,000 | $1,300 | $1,600 | $2,300 | $3,000 | $3,000 | $3,200 | $3,900 | $4,200 | $4,000 | $2,000 | |
Shoes | $250 | $400 | $700 | $900 | $1,400 | $1,400 | $1,400 | $1,600 | $1,900 | $1,900 | $800 | $800 | |
Products | $80 | $130 | $400 | $600 | $800 | $800 | $800 | $1,000 | $1,000 | $1,200 | $200 | $350 | |
Subtotal Direct Cost of Sales | $1,130 | $1,530 | $2,400 | $3,100 | $4,500 | $5,200 | $5,200 | $5,800 | $6,800 | $7,300 | $5,000 | $3,150 |
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 | ||
Manager | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Half-time Cashiers/Clerks (3) | 0% | $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 People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 |
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 | $4,100 | $7,200 | $9,350 | $12,500 | $17,000 | $20,000 | $20,000 | $23,000 | $26,000 | $29,000 | $15,000 | $13,500 | |
Direct Cost of Sales | $1,130 | $1,530 | $2,400 | $3,100 | $4,500 | $5,200 | $5,200 | $5,800 | $6,800 | $7,300 | $5,000 | $3,150 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $1,130 | $1,530 | $2,400 | $3,100 | $4,500 | $5,200 | $5,200 | $5,800 | $6,800 | $7,300 | $5,000 | $3,150 | |
Gross Margin | $2,970 | $5,670 | $6,950 | $9,400 | $12,500 | $14,800 | $14,800 | $17,200 | $19,200 | $21,700 | $10,000 | $10,350 | |
Gross Margin % | 72.44% | 78.75% | 74.33% | 75.20% | 73.53% | 74.00% | 74.00% | 74.78% | 73.85% | 74.83% | 66.67% | 76.67% | |
Expenses | |||||||||||||
Payroll | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
Sales and Marketing and Other Expenses | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Depreciation | $595 | $595 | $595 | $595 | $595 | $595 | $595 | $595 | $595 | $595 | $595 | $595 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Payroll Taxes | 15% | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | $11,270 | |
Profit Before Interest and Taxes | ($8,300) | ($5,600) | ($4,320) | ($1,870) | $1,230 | $3,530 | $3,530 | $5,930 | $7,930 | $10,430 | ($1,270) | ($920) | |
EBITDA | ($7,705) | ($5,005) | ($3,725) | ($1,275) | $1,825 | $4,125 | $4,125 | $6,525 | $8,525 | $11,025 | ($675) | ($325) | |
Interest Expense | $410 | $403 | $397 | $390 | $383 | $377 | $370 | $363 | $357 | $350 | $343 | $337 | |
Taxes Incurred | ($2,613) | ($1,801) | ($1,415) | ($678) | $254 | $946 | $948 | $1,670 | $2,272 | $3,024 | ($484) | ($377) | |
Net Profit | ($6,097) | ($4,202) | ($3,302) | ($1,582) | $593 | $2,207 | $2,212 | $3,897 | $5,301 | $7,056 | ($1,129) | ($880) | |
Net Profit/Sales | -148.71% | -58.37% | -35.31% | -12.66% | 3.49% | 11.04% | 11.06% | 16.94% | 20.39% | 24.33% | -7.53% | -6.52% |
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 | $4,100 | $7,200 | $9,350 | $12,500 | $17,000 | $20,000 | $20,000 | $23,000 | $26,000 | $29,000 | $15,000 | $13,500 | |
Subtotal Cash from Operations | $4,100 | $7,200 | $9,350 | $12,500 | $17,000 | $20,000 | $20,000 | $23,000 | $26,000 | $29,000 | $15,000 | $13,500 | |
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 | $4,100 | $7,200 | $9,350 | $12,500 | $17,000 | $20,000 | $20,000 | $23,000 | $26,000 | $29,000 | $15,000 | $13,500 | |
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 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
Bill Payments | $25,132 | $3,999 | $4,790 | $5,181 | $5,918 | $6,835 | $7,498 | $7,692 | $13,557 | $16,727 | $17,103 | $8,463 | |
Subtotal Spent on Operations | $29,632 | $8,499 | $9,290 | $9,681 | $10,418 | $11,335 | $11,998 | $12,192 | $18,057 | $21,227 | $21,603 | $12,963 | |
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 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
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 | $30,432 | $9,299 | $10,090 | $10,481 | $11,218 | $12,135 | $12,798 | $12,992 | $18,857 | $22,027 | $22,403 | $13,763 | |
Net Cash Flow | ($26,332) | ($2,099) | ($740) | $2,019 | $5,782 | $7,865 | $7,202 | $10,008 | $7,143 | $6,973 | ($7,403) | ($263) | |
Cash Balance | $13,668 | $11,569 | $10,829 | $12,848 | $18,630 | $26,495 | $33,697 | $43,706 | $50,849 | $57,822 | $50,420 | $50,157 |
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 | $40,000 | $13,668 | $11,569 | $10,829 | $12,848 | $18,630 | $26,495 | $33,697 | $43,706 | $50,849 | $57,822 | $50,420 | $50,157 |
Inventory | $30,000 | $28,870 | $27,340 | $24,940 | $21,840 | $17,340 | $12,140 | $6,940 | $6,380 | $7,480 | $8,030 | $5,500 | $3,465 |
Other Current Assets | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Total Current Assets | $70,900 | $43,438 | $39,809 | $36,669 | $35,588 | $36,870 | $39,535 | $41,537 | $50,986 | $59,229 | $66,752 | $56,820 | $54,522 |
Long-term Assets | |||||||||||||
Long-term Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Accumulated Depreciation | $0 | $595 | $1,190 | $1,785 | $2,380 | $2,975 | $3,570 | $4,165 | $4,760 | $5,355 | $5,950 | $6,545 | $7,140 |
Total Long-term Assets | $5,000 | $4,405 | $3,810 | $3,215 | $2,620 | $2,025 | $1,430 | $835 | $240 | ($355) | ($950) | ($1,545) | ($2,140) |
Total Assets | $75,900 | $47,843 | $43,619 | $39,884 | $38,208 | $38,895 | $40,965 | $42,372 | $51,226 | $58,874 | $65,802 | $55,275 | $52,382 |
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 | $25,000 | $3,840 | $4,618 | $4,985 | $5,691 | $6,585 | $7,248 | $7,243 | $13,000 | $16,147 | $16,819 | $8,221 | $7,008 |
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 | $25,000 | $3,840 | $4,618 | $4,985 | $5,691 | $6,585 | $7,248 | $7,243 | $13,000 | $16,147 | $16,819 | $8,221 | $7,008 |
Long-term Liabilities | $50,000 | $49,200 | $48,400 | $47,600 | $46,800 | $46,000 | $45,200 | $44,400 | $43,600 | $42,800 | $42,000 | $41,200 | $40,400 |
Total Liabilities | $75,000 | $53,040 | $53,018 | $52,585 | $52,491 | $52,585 | $52,448 | $51,643 | $56,600 | $58,947 | $58,819 | $49,421 | $47,408 |
Paid-in Capital | $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 |
Retained Earnings | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) | ($9,100) |
Earnings | $0 | ($6,097) | ($10,299) | ($13,601) | ($15,183) | ($14,590) | ($12,383) | ($10,171) | ($6,274) | ($973) | $6,083 | $4,954 | $4,074 |
Total Capital | $900 | ($5,197) | ($9,399) | ($12,701) | ($14,283) | ($13,690) | ($11,483) | ($9,271) | ($5,374) | ($73) | $6,983 | $5,854 | $4,974 |
Total Liabilities and Capital | $75,900 | $47,843 | $43,619 | $39,884 | $38,208 | $38,895 | $40,965 | $42,372 | $51,226 | $58,874 | $65,802 | $55,275 | $52,382 |
Net Worth | $900 | ($5,197) | ($9,399) | ($12,701) | ($14,283) | ($13,690) | ($11,483) | ($9,271) | ($5,374) | ($73) | $6,983 | $5,854 | $4,974 |