Our biggest savings of the year
Wheelie Deals
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 |