Wheelie Deals

Start your own business plan »

Wholesale Bicycle Distributor 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
Independent bicycle shops 0% $0 $3,455 $8,544 $12,457 $15,478 $17,454 $18,854 $25,855 $22,787 $21,987 $20,254 $20,114
Chain bicycle shops 0% $0 $2,246 $5,554 $8,097 $10,061 $11,345 $12,255 $16,806 $14,812 $14,292 $13,165 $13,074
Total Sales $0 $5,701 $14,098 $20,554 $25,539 $28,799 $31,109 $42,661 $37,599 $36,279 $33,419 $33,188
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
Independent bicycle shops $0 $1,728 $4,272 $6,229 $7,739 $8,727 $9,427 $12,928 $11,394 $10,994 $10,127 $10,057
Chain bicycle shops $0 $1,123 $2,777 $4,049 $5,030 $5,673 $6,128 $8,403 $7,406 $7,146 $6,583 $6,537
Subtotal Direct Cost of Sales $0 $2,850 $7,049 $10,277 $12,769 $14,400 $15,555 $21,330 $18,799 $18,139 $16,710 $16,594
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
Dan 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Full time administrative 0% $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Full time sales 0% $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Full time sales 0% $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Full time order fullfillment 0% $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Total People 1 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $3,000 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400
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 $5,701 $14,098 $20,554 $25,539 $28,799 $31,109 $42,661 $37,599 $36,279 $33,419 $33,188
Direct Cost of Sales $0 $2,850 $7,049 $10,277 $12,769 $14,400 $15,555 $21,330 $18,799 $18,139 $16,710 $16,594
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $2,850 $7,049 $10,277 $12,769 $14,400 $15,555 $21,330 $18,799 $18,139 $16,710 $16,594
Gross Margin $0 $2,850 $7,049 $10,277 $12,769 $14,400 $15,555 $21,330 $18,799 $18,139 $16,710 $16,594
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 $3,000 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400
Sales and Marketing and Other Expenses $100 $700 $100 $100 $100 $100 $100 $100 $100 $700 $100 $100
Depreciation $413 $413 $413 $413 $413 $413 $413 $413 $413 $413 $413 $413
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Rent $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Payroll Taxes 15% $450 $1,410 $1,410 $1,410 $1,410 $1,410 $1,410 $1,410 $1,410 $1,410 $1,410 $1,410
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $8,563 $16,523 $15,923 $15,923 $15,923 $15,923 $15,923 $15,923 $15,923 $16,523 $15,923 $15,923
Profit Before Interest and Taxes ($8,563) ($13,673) ($8,874) ($5,646) ($3,154) ($1,523) ($368) $5,407 $2,876 $1,616 $787 $671
EBITDA ($8,150) ($13,260) ($8,461) ($5,233) ($2,741) ($1,110) $45 $5,820 $3,289 $2,029 $1,200 $1,084
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($8,563) ($13,673) ($8,874) ($5,646) ($3,154) ($1,523) ($368) $5,407 $2,876 $1,616 $787 $671
Net Profit/Sales 0.00% -239.84% -62.95% -27.47% -12.35% -5.29% -1.18% 12.68% 7.65% 4.46% 2.35% 2.02%
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 $5,701 $14,098 $20,554 $25,539 $28,799 $31,109 $42,661 $37,599 $36,279 $33,419 $33,188
Subtotal Cash from Operations $0 $5,701 $14,098 $20,554 $25,539 $28,799 $31,109 $42,661 $37,599 $36,279 $33,419 $33,188
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 $5,701 $14,098 $20,554 $25,539 $28,799 $31,109 $42,661 $37,599 $36,279 $33,419 $33,188
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 $3,000 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400 $9,400
Bill Payments $172 $5,202 $6,945 $13,969 $19,994 $21,644 $22,324 $23,297 $33,405 $22,192 $24,027 $21,291
Subtotal Spent on Operations $3,172 $14,602 $16,345 $23,369 $29,394 $31,044 $31,724 $32,697 $42,805 $31,592 $33,427 $30,691
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 $3,172 $14,602 $16,345 $23,369 $29,394 $31,044 $31,724 $32,697 $42,805 $31,592 $33,427 $30,691
Net Cash Flow ($3,172) ($8,901) ($2,247) ($2,815) ($3,855) ($2,245) ($615) $9,964 ($5,206) $4,687 ($8) $2,497
Cash Balance $25,778 $16,877 $14,630 $11,815 $7,959 $5,715 $5,100 $15,064 $9,858 $14,545 $14,536 $17,033
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 $28,950 $25,778 $16,877 $14,630 $11,815 $7,959 $5,715 $5,100 $15,064 $9,858 $14,545 $14,536 $17,033
Inventory $10,000 $10,000 $7,150 $7,754 $11,305 $14,046 $15,840 $17,110 $23,463 $20,679 $19,953 $18,381 $18,253
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $38,950 $35,778 $24,027 $22,383 $23,120 $22,006 $21,554 $22,210 $38,527 $30,537 $34,498 $32,917 $35,287
Long-term Assets
Long-term Assets $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750 $24,750
Accumulated Depreciation $0 $413 $826 $1,239 $1,652 $2,065 $2,478 $2,891 $3,304 $3,717 $4,130 $4,543 $4,956
Total Long-term Assets $24,750 $24,337 $23,924 $23,511 $23,098 $22,685 $22,272 $21,859 $21,446 $21,033 $20,620 $20,207 $19,794
Total Assets $63,700 $60,115 $47,951 $45,894 $46,218 $44,691 $43,826 $44,069 $59,973 $51,570 $55,118 $53,124 $55,081
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 $4,978 $6,486 $13,304 $19,273 $20,900 $21,559 $22,171 $32,667 $21,388 $23,319 $20,539 $21,824
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 $4,978 $6,486 $13,304 $19,273 $20,900 $21,559 $22,171 $32,667 $21,388 $23,319 $20,539 $21,824
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $4,978 $6,486 $13,304 $19,273 $20,900 $21,559 $22,171 $32,667 $21,388 $23,319 $20,539 $21,824
Paid-in Capital $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000
Retained Earnings ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300) ($1,300)
Earnings $0 ($8,563) ($22,236) ($31,110) ($36,756) ($39,909) ($41,433) ($41,801) ($36,394) ($33,518) ($31,901) ($31,115) ($30,444)
Total Capital $63,700 $55,137 $41,464 $32,590 $26,944 $23,791 $22,267 $21,899 $27,306 $30,182 $31,799 $32,585 $33,256
Total Liabilities and Capital $63,700 $60,115 $47,951 $45,894 $46,218 $44,691 $43,826 $44,069 $59,973 $51,570 $55,118 $53,124 $55,081
Net Worth $63,700 $55,137 $41,464 $32,590 $26,944 $23,791 $22,267 $21,899 $27,306 $30,182 $31,799 $32,585 $33,256