Nine Lives Outdoor Gear Consignment Shop

Start your own business plan »

Used Sports Equipment Store 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
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