Male Gear Wear
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 | |||||||||||||
Hardcore athletes | 40% | $0 | $0 | $3,433 | $4,412 | $4,645 | $5,323 | $6,112 | $6,687 | $7,112 | $7,454 | $7,878 | $10,101 |
Newbies | 40% | $0 | $0 | $3,845 | $4,941 | $5,202 | $5,962 | $6,845 | $7,489 | $7,965 | $8,348 | $8,823 | $11,313 |
Total Sales | $0 | $0 | $7,278 | $9,353 | $9,847 | $11,285 | $12,957 | $14,176 | $15,077 | $15,802 | $16,701 | $21,414 | |
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 | |
Hardcore athletes | $0 | $0 | $1,373 | $1,765 | $1,858 | $2,129 | $2,445 | $2,675 | $2,845 | $2,982 | $3,151 | $4,040 | |
Newbies | $0 | $0 | $1,538 | $1,977 | $2,081 | $2,385 | $2,738 | $2,996 | $3,186 | $3,339 | $3,529 | $4,525 | |
Subtotal Direct Cost of Sales | $0 | $0 | $2,911 | $3,741 | $3,939 | $4,514 | $5,183 | $5,671 | $6,031 | $6,321 | $6,681 | $8,566 |
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 | ||
Stan | 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 staff | 0% | $0 | $0 | $1,500 | $2,000 | $2,500 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Support Staff | 0% | $0 | $0 | $1,500 | $2,000 | $2,200 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
Bookkeeper | 0% | $0 | $1,000 | $1,200 | $1,500 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Total People | 1 | 2 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $2,000 | $3,000 | $6,200 | $7,500 | $8,700 | $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 | $0 | $7,278 | $9,353 | $9,847 | $11,285 | $12,957 | $14,176 | $15,077 | $15,802 | $16,701 | $21,414 | |
Direct Cost of Sales | $0 | $0 | $2,911 | $3,741 | $3,939 | $4,514 | $5,183 | $5,671 | $6,031 | $6,321 | $6,681 | $8,566 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $2,911 | $3,741 | $3,939 | $4,514 | $5,183 | $5,671 | $6,031 | $6,321 | $6,681 | $8,566 | |
Gross Margin | $0 | $0 | $4,367 | $5,612 | $5,908 | $6,771 | $7,774 | $8,506 | $9,046 | $9,481 | $10,021 | $12,848 | |
Gross Margin % | 0.00% | 0.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
Expenses | |||||||||||||
Payroll | $2,000 | $3,000 | $6,200 | $7,500 | $8,700 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | |
Sales and Marketing and Other Expenses | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Depreciation | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Rent | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | |
Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Insurance | $325 | $325 | $325 | $325 | $325 | $325 | $325 | $325 | $325 | $325 | $325 | $325 | |
Payroll Taxes | 15% | $300 | $450 | $930 | $1,125 | $1,305 | $1,410 | $1,410 | $1,410 | $1,410 | $1,410 | $1,410 | $1,410 |
Other | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Total Operating Expenses | $4,675 | $5,825 | $9,505 | $11,000 | $12,380 | $13,185 | $13,185 | $13,185 | $13,185 | $13,185 | $13,185 | $13,185 | |
Profit Before Interest and Taxes | ($4,675) | ($5,825) | ($5,138) | ($5,388) | ($6,472) | ($6,414) | ($5,411) | ($4,679) | ($4,139) | ($3,704) | ($3,164) | ($337) | |
EBITDA | ($4,525) | ($5,675) | ($4,988) | ($5,238) | ($6,322) | ($6,264) | ($5,261) | ($4,529) | ($3,989) | ($3,554) | ($3,014) | ($187) | |
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 | ($4,675) | ($5,825) | ($5,138) | ($5,388) | ($6,472) | ($6,414) | ($5,411) | ($4,679) | ($4,139) | ($3,704) | ($3,164) | ($337) | |
Net Profit/Sales | 0.00% | 0.00% | -70.60% | -57.60% | -65.72% | -56.84% | -41.76% | -33.01% | -27.45% | -23.44% | -18.95% | -1.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 | $0 | $7,278 | $9,353 | $9,847 | $11,285 | $12,957 | $14,176 | $15,077 | $15,802 | $16,701 | $21,414 | |
Subtotal Cash from Operations | $0 | $0 | $7,278 | $9,353 | $9,847 | $11,285 | $12,957 | $14,176 | $15,077 | $15,802 | $16,701 | $21,414 | |
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 | $0 | $7,278 | $9,353 | $9,847 | $11,285 | $12,957 | $14,176 | $15,077 | $15,802 | $16,701 | $21,414 | |
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,000 | $6,200 | $7,500 | $8,700 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | |
Bill Payments | $84 | $2,530 | $2,895 | $9,226 | $7,994 | $7,723 | $8,807 | $9,564 | $9,849 | $10,070 | $10,290 | $10,830 | |
Subtotal Spent on Operations | $2,084 | $5,530 | $9,095 | $16,726 | $16,694 | $17,123 | $18,207 | $18,964 | $19,249 | $19,470 | $19,690 | $20,230 | |
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,084 | $5,530 | $9,095 | $16,726 | $16,694 | $17,123 | $18,207 | $18,964 | $19,249 | $19,470 | $19,690 | $20,230 | |
Net Cash Flow | ($2,084) | ($5,530) | ($1,817) | ($7,373) | ($6,847) | ($5,838) | ($5,250) | ($4,787) | ($4,172) | ($3,667) | ($2,988) | $1,184 | |
Cash Balance | $86,016 | $80,486 | $78,669 | $71,296 | $64,450 | $58,611 | $53,362 | $48,575 | $44,403 | $40,736 | $37,748 | $38,932 |
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 | $88,100 | $86,016 | $80,486 | $78,669 | $71,296 | $64,450 | $58,611 | $53,362 | $48,575 | $44,403 | $40,736 | $37,748 | $38,932 |
Inventory | $0 | $0 | $0 | $3,202 | $4,116 | $4,333 | $4,965 | $5,701 | $6,238 | $6,634 | $6,953 | $7,349 | $9,422 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $88,100 | $86,016 | $80,486 | $81,871 | $75,412 | $68,782 | $63,577 | $59,063 | $54,812 | $51,037 | $47,689 | $45,096 | $48,354 |
Long-term Assets | |||||||||||||
Long-term Assets | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 | $9,000 |
Accumulated Depreciation | $0 | $150 | $300 | $450 | $600 | $750 | $900 | $1,050 | $1,200 | $1,350 | $1,500 | $1,650 | $1,800 |
Total Long-term Assets | $9,000 | $8,850 | $8,700 | $8,550 | $8,400 | $8,250 | $8,100 | $7,950 | $7,800 | $7,650 | $7,500 | $7,350 | $7,200 |
Total Assets | $97,100 | $94,866 | $89,186 | $90,421 | $83,812 | $77,032 | $71,677 | $67,013 | $62,612 | $58,687 | $55,189 | $52,446 | $55,554 |
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 | $2,441 | $2,586 | $8,960 | $7,738 | $7,430 | $8,489 | $9,235 | $9,514 | $9,727 | $9,933 | $10,354 | $13,798 |
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 | $2,441 | $2,586 | $8,960 | $7,738 | $7,430 | $8,489 | $9,235 | $9,514 | $9,727 | $9,933 | $10,354 | $13,798 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $2,441 | $2,586 | $8,960 | $7,738 | $7,430 | $8,489 | $9,235 | $9,514 | $9,727 | $9,933 | $10,354 | $13,798 |
Paid-in Capital | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 |
Retained Earnings | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) | ($17,900) |
Earnings | $0 | ($4,675) | ($10,500) | ($15,638) | ($21,026) | ($27,498) | ($33,912) | ($39,322) | ($44,002) | ($48,140) | ($51,844) | ($55,008) | ($55,344) |
Total Capital | $97,100 | $92,425 | $86,600 | $81,462 | $76,074 | $69,602 | $63,188 | $57,778 | $53,098 | $48,960 | $45,256 | $42,092 | $41,756 |
Total Liabilities and Capital | $97,100 | $94,866 | $89,186 | $90,421 | $83,812 | $77,032 | $71,677 | $67,013 | $62,612 | $58,687 | $55,189 | $52,446 | $55,554 |
Net Worth | $97,100 | $92,425 | $86,600 | $81,462 | $76,074 | $69,602 | $63,188 | $57,778 | $53,098 | $48,960 | $45,256 | $42,092 | $41,756 |