Our biggest savings of the year
FireStarters
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% | $0 | $8,000 | $10,000 | $21,000 | $24,000 | $26,000 | $17,000 | $25,000 | $30,000 | $30,000 | $10,000 | $8,000 |
Shoes | 0% | $0 | $3,000 | $3,350 | $5,000 | $8,000 | $11,000 | $14,000 | $16,000 | $24,000 | $25,000 | $10,000 | $12,000 |
Products | 0% | $0 | $1,500 | $1,800 | $2,000 | $4,000 | $6,000 | $5,000 | $7,000 | $13,000 | $4,000 | $5,000 | $6,000 |
Total Sales | $0 | $12,500 | $15,150 | $28,000 | $36,000 | $43,000 | $36,000 | $48,000 | $67,000 | $59,000 | $25,000 | $26,000 | |
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 | $0 | $3,000 | $4,000 | $5,000 | $6,000 | $7,000 | $5,000 | $7,000 | $10,000 | $10,000 | $4,000 | $2,000 | |
Shoes | $0 | $1,000 | $1,200 | $1,000 | $1,500 | $2,000 | $3,000 | $4,000 | $5,200 | $2,000 | $2,000 | $2,200 | |
Products | $0 | $400 | $500 | $600 | $1,000 | $1,500 | $1,250 | $1,800 | $2,000 | $890 | $1,200 | $1,500 | |
Subtotal Direct Cost of Sales | $0 | $4,400 | $5,700 | $6,600 | $8,500 | $10,500 | $9,250 | $12,800 | $17,200 | $12,890 | $7,200 | $5,700 |
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% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Buyer/Marketing | 0% | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Order Processor/Website Manager | 0% | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 |
Processing Staff (2) | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 |
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 | $0 | $12,500 | $15,150 | $28,000 | $36,000 | $43,000 | $36,000 | $48,000 | $67,000 | $59,000 | $25,000 | $26,000 | |
Direct Cost of Sales | $0 | $4,400 | $5,700 | $6,600 | $8,500 | $10,500 | $9,250 | $12,800 | $17,200 | $12,890 | $7,200 | $5,700 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $4,400 | $5,700 | $6,600 | $8,500 | $10,500 | $9,250 | $12,800 | $17,200 | $12,890 | $7,200 | $5,700 | |
Gross Margin | $0 | $8,100 | $9,450 | $21,400 | $27,500 | $32,500 | $26,750 | $35,200 | $49,800 | $46,110 | $17,800 | $20,300 | |
Gross Margin % | 0.00% | 64.80% | 62.38% | 76.43% | 76.39% | 75.58% | 74.31% | 73.33% | 74.33% | 78.15% | 71.20% | 78.08% | |
Expenses | |||||||||||||
Payroll | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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% | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 | $2,220 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | $20,615 | |
Profit Before Interest and Taxes | ($20,615) | ($12,515) | ($11,165) | $785 | $6,885 | $11,885 | $6,135 | $14,585 | $29,185 | $25,495 | ($2,815) | ($315) | |
EBITDA | ($20,020) | ($11,920) | ($10,570) | $1,380 | $7,480 | $12,480 | $6,730 | $15,180 | $29,780 | $26,090 | ($2,220) | $280 | |
Interest Expense | $1,235 | $1,220 | $1,205 | $1,190 | $1,175 | $1,160 | $1,145 | $1,130 | $1,115 | $1,100 | $1,085 | $1,070 | |
Taxes Incurred | ($6,555) | ($4,121) | ($3,711) | ($122) | $1,713 | $3,218 | $1,497 | $4,037 | $8,421 | $7,319 | ($1,170) | ($416) | |
Net Profit | ($15,295) | ($9,615) | ($8,659) | ($284) | $3,997 | $7,508 | $3,493 | $9,419 | $19,649 | $17,077 | ($2,730) | ($970) | |
Net Profit/Sales | 0.00% | -76.92% | -57.16% | -1.01% | 11.10% | 17.46% | 9.70% | 19.62% | 29.33% | 28.94% | -10.92% | -3.73% |
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 | $0 | $12,500 | $15,150 | $28,000 | $36,000 | $43,000 | $36,000 | $48,000 | $67,000 | $59,000 | $25,000 | $26,000 | |
Subtotal Cash from Operations | $0 | $12,500 | $15,150 | $28,000 | $36,000 | $43,000 | $36,000 | $48,000 | $67,000 | $59,000 | $25,000 | $26,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 | $0 | $12,500 | $15,150 | $28,000 | $36,000 | $43,000 | $36,000 | $48,000 | $67,000 | $59,000 | $25,000 | $26,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 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | $14,800 | |
Bill Payments | ($100) | ($19) | $2,333 | $2,833 | $6,349 | $8,158 | $9,540 | $7,946 | $10,994 | $28,398 | $21,266 | $6,259 | |
Subtotal Spent on Operations | $14,700 | $14,781 | $17,133 | $17,633 | $21,149 | $22,958 | $24,340 | $22,746 | $25,794 | $43,198 | $36,066 | $21,059 | |
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 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
Purchase Other Current Assets | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
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 | $16,500 | $18,381 | $20,733 | $21,233 | $24,749 | $26,558 | $27,940 | $26,346 | $29,394 | $46,798 | $39,666 | $24,659 | |
Net Cash Flow | ($16,500) | ($5,881) | ($5,583) | $6,767 | $11,251 | $16,442 | $8,060 | $21,654 | $37,606 | $12,202 | ($14,666) | $1,341 | |
Cash Balance | $48,100 | $42,219 | $36,637 | $43,404 | $54,654 | $71,097 | $79,157 | $100,811 | $138,416 | $150,618 | $135,953 | $137,293 |
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 | $64,600 | $48,100 | $42,219 | $36,637 | $43,404 | $54,654 | $71,097 | $79,157 | $100,811 | $138,416 | $150,618 | $135,953 | $137,293 |
Inventory | $80,000 | $80,000 | $75,600 | $69,900 | $63,300 | $54,800 | $44,300 | $35,050 | $22,250 | $18,920 | $14,179 | $7,979 | $6,270 |
Other Current Assets | $0 | $0 | $1,800 | $3,600 | $5,400 | $7,200 | $9,000 | $10,800 | $12,600 | $14,400 | $16,200 | $18,000 | $19,800 |
Total Current Assets | $144,600 | $128,100 | $119,619 | $110,137 | $112,104 | $116,654 | $124,397 | $125,007 | $135,661 | $171,736 | $180,997 | $161,932 | $163,363 |
Long-term Assets | |||||||||||||
Long-term Assets | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,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 | $50,000 | $49,405 | $48,810 | $48,215 | $47,620 | $47,025 | $46,430 | $45,835 | $45,240 | $44,645 | $44,050 | $43,455 | $42,860 |
Total Assets | $194,600 | $177,505 | $168,429 | $158,352 | $159,724 | $163,679 | $170,827 | $170,842 | $180,901 | $216,381 | $225,047 | $205,387 | $206,223 |
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 | $0 | $2,339 | $2,720 | $6,176 | $7,934 | $9,374 | $7,697 | $10,137 | $27,768 | $21,158 | $6,027 | $9,633 |
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 | $0 | $2,339 | $2,720 | $6,176 | $7,934 | $9,374 | $7,697 | $10,137 | $27,768 | $21,158 | $6,027 | $9,633 |
Long-term Liabilities | $150,000 | $148,200 | $146,400 | $144,600 | $142,800 | $141,000 | $139,200 | $137,400 | $135,600 | $133,800 | $132,000 | $130,200 | $128,400 |
Total Liabilities | $150,000 | $148,200 | $148,739 | $147,320 | $148,976 | $148,934 | $148,574 | $145,097 | $145,737 | $161,568 | $153,158 | $136,227 | $138,033 |
Paid-in Capital | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 |
Retained Earnings | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) | ($155,400) |
Earnings | $0 | ($15,295) | ($24,910) | ($33,569) | ($33,852) | ($29,855) | ($22,348) | ($18,855) | ($9,436) | $10,213 | $27,290 | $24,560 | $23,590 |
Total Capital | $44,600 | $29,305 | $19,691 | $11,032 | $10,748 | $14,745 | $22,253 | $25,746 | $35,164 | $54,813 | $71,890 | $69,160 | $68,190 |
Total Liabilities and Capital | $194,600 | $177,505 | $168,429 | $158,352 | $159,724 | $163,679 | $170,827 | $170,842 | $180,901 | $216,381 | $225,047 | $205,387 | $206,223 |
Net Worth | $44,600 | $29,305 | $19,691 | $11,032 | $10,748 | $14,745 | $22,253 | $25,746 | $35,164 | $54,813 | $71,890 | $69,160 | $68,190 |