Nine Lives Outdoor Gear Consignment Shop
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 | |||||||||||||
Outdoor participants-limited $$$ | 0% | $0 | $4,125 | $4,987 | $7,845 | $8,325 | $9,458 | $13,545 | $14,995 | $15,855 | $17,458 | $18,545 | $20,014 |
Gearheads | 0% | $0 | $1,325 | $1,514 | $2,125 | $2,514 | $3,250 | $4,654 | $5,002 | $6,511 | $7,545 | $7,254 | $8,354 |
Bargain hunters | 0% | $0 | $1,300 | $1,499 | $2,147 | $2,503 | $3,215 | $4,512 | $5,000 | $6,474 | $7,454 | $7,141 | $8,325 |
Total Sales | $0 | $6,750 | $8,000 | $12,117 | $13,342 | $15,923 | $22,711 | $24,997 | $28,840 | $32,457 | $32,940 | $36,693 | |
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 | |
Outdoor participants-limited $$$ | $0 | $2,063 | $2,494 | $3,923 | $4,163 | $4,729 | $6,773 | $7,498 | $7,928 | $8,729 | $9,273 | $10,007 | |
Gearheads | $0 | $663 | $757 | $1,063 | $1,257 | $1,625 | $2,327 | $2,501 | $3,256 | $3,773 | $3,627 | $4,177 | |
Bargain hunters | $0 | $650 | $750 | $1,074 | $1,252 | $1,608 | $2,256 | $2,500 | $3,237 | $3,727 | $3,571 | $4,163 | |
Subtotal Direct Cost of Sales | $0 | $3,375 | $4,000 | $6,059 | $6,671 | $7,962 | $11,356 | $12,499 | $14,420 | $16,229 | $16,470 | $18,347 |
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 | ||
Jim | 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 |
Sales associate | 0% | $0 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Sales associate | 0% | $0 | $0 | $0 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Sales associate | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 | $1,440 |
Total People | 1 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | |
Total Payroll | $2,000 | $3,440 | $3,440 | $4,880 | $4,880 | $4,880 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 |
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 | $0 | $6,750 | $8,000 | $12,117 | $13,342 | $15,923 | $22,711 | $24,997 | $28,840 | $32,457 | $32,940 | $36,693 | |
Direct Cost of Sales | $0 | $3,375 | $4,000 | $6,059 | $6,671 | $7,962 | $11,356 | $12,499 | $14,420 | $16,229 | $16,470 | $18,347 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $3,375 | $4,000 | $6,059 | $6,671 | $7,962 | $11,356 | $12,499 | $14,420 | $16,229 | $16,470 | $18,347 | |
Gross Margin | $0 | $3,375 | $4,000 | $6,059 | $6,671 | $7,962 | $11,356 | $12,499 | $14,420 | $16,229 | $16,470 | $18,347 | |
Gross Margin % | 0.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 | $2,000 | $3,440 | $3,440 | $4,880 | $4,880 | $4,880 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | |
Sales and Marketing and Other Expenses | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Depreciation | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Rent | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Rent | $67 | $67 | $67 | $67 | $67 | $67 | $67 | $67 | $67 | $67 | $67 | $67 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Payroll Taxes | 15% | $300 | $516 | $516 | $732 | $732 | $732 | $948 | $948 | $948 | $948 | $948 | $948 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $4,292 | $5,948 | $5,948 | $7,604 | $7,604 | $7,604 | $9,260 | $9,260 | $9,260 | $9,260 | $9,260 | $9,260 | |
Profit Before Interest and Taxes | ($4,292) | ($2,573) | ($1,948) | ($1,546) | ($933) | $358 | $2,096 | $3,239 | $5,160 | $6,969 | $7,210 | $9,087 | |
EBITDA | ($4,192) | ($2,473) | ($1,848) | ($1,446) | ($833) | $458 | $2,196 | $3,339 | $5,260 | $7,069 | $7,310 | $9,187 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($1,288) | ($643) | ($487) | ($386) | ($233) | $89 | $524 | $810 | $1,290 | $1,742 | $1,803 | $2,272 | |
Net Profit | ($3,004) | ($1,930) | ($1,461) | ($1,159) | ($700) | $268 | $1,572 | $2,429 | $3,870 | $5,226 | $5,408 | $6,815 | |
Net Profit/Sales | 0.00% | -28.59% | -18.26% | -9.57% | -5.24% | 1.68% | 6.92% | 9.72% | 13.42% | 16.10% | 16.42% | 18.57% |
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 | $6,750 | $8,000 | $12,117 | $13,342 | $15,923 | $22,711 | $24,997 | $28,840 | $32,457 | $32,940 | $36,693 | |
Subtotal Cash from Operations | $0 | $6,750 | $8,000 | $12,117 | $13,342 | $15,923 | $22,711 | $24,997 | $28,840 | $32,457 | $32,940 | $36,693 | |
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 | $6,750 | $8,000 | $12,117 | $13,342 | $15,923 | $22,711 | $24,997 | $28,840 | $32,457 | $32,940 | $36,693 | |
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 | $2,000 | $3,440 | $3,440 | $4,880 | $4,880 | $4,880 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | $6,320 | |
Bill Payments | $30 | $1,169 | $8,777 | $6,740 | $10,533 | $9,814 | $12,306 | $18,418 | $17,514 | $20,735 | $22,753 | $21,516 | |
Subtotal Spent on Operations | $2,030 | $4,609 | $12,217 | $11,620 | $15,413 | $14,694 | $18,626 | $24,738 | $23,834 | $27,055 | $29,073 | $27,836 | |
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 | $2,030 | $4,609 | $12,217 | $11,620 | $15,413 | $14,694 | $18,626 | $24,738 | $23,834 | $27,055 | $29,073 | $27,836 | |
Net Cash Flow | ($2,030) | $2,141 | ($4,217) | $497 | ($2,071) | $1,229 | $4,085 | $259 | $5,006 | $5,402 | $3,867 | $8,857 | |
Cash Balance | $12,120 | $14,261 | $10,043 | $10,540 | $8,469 | $9,698 | $13,782 | $14,041 | $19,047 | $24,450 | $28,317 | $37,174 |
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 | $14,150 | $12,120 | $14,261 | $10,043 | $10,540 | $8,469 | $9,698 | $13,782 | $14,041 | $19,047 | $24,450 | $28,317 | $37,174 |
Inventory | $0 | $0 | $3,713 | $4,400 | $6,664 | $7,338 | $8,758 | $12,491 | $13,748 | $15,862 | $17,851 | $18,117 | $20,181 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $14,150 | $12,120 | $17,973 | $14,443 | $17,204 | $15,807 | $18,455 | $26,273 | $27,790 | $34,909 | $42,301 | $46,434 | $57,355 |
Long-term Assets | |||||||||||||
Long-term Assets | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 | $3,700 |
Accumulated Depreciation | $0 | $100 | $200 | $300 | $400 | $500 | $600 | $700 | $800 | $900 | $1,000 | $1,100 | $1,200 |
Total Long-term Assets | $3,700 | $3,600 | $3,500 | $3,400 | $3,300 | $3,200 | $3,100 | $3,000 | $2,900 | $2,800 | $2,700 | $2,600 | $2,500 |
Total Assets | $17,850 | $15,720 | $21,473 | $17,843 | $20,504 | $19,007 | $21,555 | $29,273 | $30,690 | $37,709 | $45,001 | $49,034 | $59,855 |
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 | $874 | $8,557 | $6,388 | $10,208 | $9,411 | $11,691 | $17,838 | $16,825 | $19,975 | $22,040 | $20,666 | $24,672 |
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 | $874 | $8,557 | $6,388 | $10,208 | $9,411 | $11,691 | $17,838 | $16,825 | $19,975 | $22,040 | $20,666 | $24,672 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $874 | $8,557 | $6,388 | $10,208 | $9,411 | $11,691 | $17,838 | $16,825 | $19,975 | $22,040 | $20,666 | $24,672 |
Paid-in Capital | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Retained Earnings | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) | ($2,150) |
Earnings | $0 | ($3,004) | ($4,934) | ($6,395) | ($7,554) | ($8,254) | ($7,986) | ($6,414) | ($3,985) | ($115) | $5,111 | $10,518 | $17,333 |
Total Capital | $17,850 | $14,846 | $12,916 | $11,455 | $10,296 | $9,596 | $9,864 | $11,436 | $13,865 | $17,735 | $22,961 | $28,368 | $35,183 |
Total Liabilities and Capital | $17,850 | $15,720 | $21,473 | $17,843 | $20,504 | $19,007 | $21,555 | $29,273 | $30,690 | $37,709 | $45,001 | $49,034 | $59,855 |
Net Worth | $17,850 | $14,846 | $12,916 | $11,455 | $10,296 | $9,596 | $9,864 | $11,436 | $13,865 | $17,735 | $22,961 | $28,368 | $35,183 |