Sportsuchtig
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 | |||||||||||||
| Sporting Goods Sales | 0% | $83,709 | $131,575 | $108,300 | $223,300 | $385,600 | $322,100 | $238,450 | $239,400 | $169,100 | $139,175 | $144,400 | $103,075 |
| Shipping Income | 0% | $4,406 | $6,925 | $5,700 | $11,700 | $20,320 | $16,900 | $12,550 | $12,600 | $8,900 | $7,325 | $7,600 | $5,425 |
| Total Sales | $88,115 | $138,500 | $114,000 | $235,000 | $405,920 | $339,000 | $251,000 | $252,000 | $178,000 | $146,500 | $152,000 | $108,500 | |
| 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 | |
| Cost of Goods Sold | $66,086 | $103,875 | $85,500 | $176,250 | $304,500 | $254,250 | $188,250 | $189,000 | $133,500 | $109,875 | $114,000 | $81,375 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $66,086 | $103,875 | $85,500 | $176,250 | $304,500 | $254,250 | $188,250 | $189,000 | $133,500 | $109,875 | $114,000 | $81,375 | |
| 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 | ||
| Warehouse/Shipping & Receiving Manager | 0% | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,916 | $1,924 |
| Warehouse/Shipping & Receiving Clerk | 0% | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,567 | $1,563 |
| Warehouse/Shipping & Receiving Clerk | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Warehouse/Shipping & Receiving Clerk | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accounting | 0% | $1,916 | $1,916 | $958 | $958 | $958 | $958 | $958 | $958 | $958 | $958 | $958 | $958 |
| Retail Phone / Accounting Assistant | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Internet Phone Sales | 0% | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,413 |
| Internet Phone Sales | 0% | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,417 | $1,413 |
| Internet Phone Sales | 0% | $1,417 | $1,417 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 | $709 |
| Internet Phone Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Internet Phone Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Internet Phone Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retail Sales PT | 0% | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $212 |
| Retail Sales PT | 0% | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $212 |
| Retail Sales PT | 0% | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $212 | $208 |
| Retail Sales PT | 0% | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $212 | $208 | $208 | $208 |
| Retail Sales PT | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retail Sales PT | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retail Sales PT | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retail Sales PT | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Store Manager | 0% | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Store Manager | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Team Sales Manager | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Team Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Team Sales | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| President & CEO | 0% | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Total People | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | |
| Total Payroll | $15,482 | $15,482 | $16,316 | $16,316 | $16,316 | $16,316 | $16,316 | $16,316 | $16,320 | $16,316 | $16,320 | $16,320 | |
| 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 | $88,115 | $138,500 | $114,000 | $235,000 | $405,920 | $339,000 | $251,000 | $252,000 | $178,000 | $146,500 | $152,000 | $108,500 | |
| Direct Cost of Sales | $66,086 | $103,875 | $85,500 | $176,250 | $304,500 | $254,250 | $188,250 | $189,000 | $133,500 | $109,875 | $114,000 | $81,375 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $66,086 | $103,875 | $85,500 | $176,250 | $304,500 | $254,250 | $188,250 | $189,000 | $133,500 | $109,875 | $114,000 | $81,375 | |
| Gross Margin | $22,029 | $34,625 | $28,500 | $58,750 | $101,420 | $84,750 | $62,750 | $63,000 | $44,500 | $36,625 | $38,000 | $27,125 | |
| Gross Margin % | 25.00% | 25.00% | 25.00% | 25.00% | 24.99% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
| Expenses | |||||||||||||
| Payroll | $15,482 | $15,482 | $16,316 | $16,316 | $16,316 | $16,316 | $16,316 | $16,316 | $16,320 | $16,316 | $16,320 | $16,320 | |
| Marketing/Promotion | $1,500 | $2,000 | $500 | $2,500 | $2,500 | $2,500 | $1,500 | $1,500 | $5,000 | $2,500 | $1,500 | $1,500 | |
| Depreciation | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Utilities | $720 | $740 | $820 | $840 | $930 | $840 | $750 | $720 | $800 | $1,600 | $1,600 | $1,600 | |
| Insurance | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | $2,100 | |
| Bad Checks | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
| Bank Card Debit & Service Fees | $1,789 | $2,812 | $2,314 | $4,770 | $8,242 | $6,882 | $5,095 | $5,116 | $3,613 | $2,974 | $3,086 | $2,203 | |
| Repairs and Maintenance | $330 | $330 | $330 | $330 | $330 | $330 | $330 | $330 | $330 | $330 | $330 | $330 | |
| Taxes and Licenses | $2,000 | $0 | $0 | $0 | $0 | $2,000 | $0 | $0 | $2,000 | $0 | $0 | $2,000 | |
| Freight In | $2,900 | $2,200 | $1,580 | $510 | $1,700 | $1,200 | $700 | $575 | $400 | $400 | $500 | $400 | |
| Interest Expense | $3,208 | $3,188 | $3,168 | $3,148 | $3,127 | $3,107 | $3,086 | $3,066 | $3,045 | $3,024 | $3,003 | $2,982 | |
| Janitorial Supplies | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | $33 | |
| Legal/Professional Fees | $500 | $170 | $170 | $170 | $1,000 | $170 | $170 | $170 | $170 | $1,000 | $170 | $170 | |
| Travel & Entertainment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $0 | $0 | $0 | $0 | |
| Membership Dues & Sub | $200 | $0 | $200 | $0 | $0 | $0 | $0 | $0 | $500 | $0 | $0 | $0 | |
| Office Supplies | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Personal Property Tax | $0 | $0 | $0 | $0 | $0 | $0 | $250 | $0 | $0 | $0 | $0 | $0 | |
| Security | $500 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
| Internet Services | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| WEB Page Services | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $500 | $500 | $500 | $500 | |
| Postage | 15% | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 |
| Telephone | $800 | $1,500 | $1,200 | $2,000 | $2,500 | $3,000 | $2,500 | $1,800 | $1,700 | $1,200 | $1,000 | $800 | |
| Total Operating Expenses | $36,362 | $34,905 | $33,081 | $37,067 | $43,128 | $42,828 | $37,180 | $38,076 | $40,611 | $36,077 | $34,242 | $35,038 | |
| Profit Before Interest and Taxes | ($14,133) | ($80) | ($4,381) | $21,883 | $58,492 | $42,122 | $25,770 | $25,124 | $4,089 | $748 | $3,958 | ($7,713) | |
| EBITDA | ($13,883) | $170 | ($4,131) | $22,133 | $58,742 | $42,372 | $26,020 | $25,374 | $4,339 | $998 | $4,208 | ($7,463) | |
| Interest Expense | $6,133 | $6,096 | $6,059 | $6,022 | $5,985 | $5,947 | $5,910 | $5,872 | $5,834 | $5,796 | $5,758 | $5,719 | |
| Taxes Incurred | ($6,080) | ($1,853) | ($3,132) | $4,758 | $15,752 | $10,852 | $5,958 | $5,776 | ($523) | ($1,514) | ($540) | ($4,030) | |
| Other Income | |||||||||||||
| Interest Income | $160 | $160 | $160 | $160 | $160 | $160 | $160 | $160 | $160 | $160 | $160 | $160 | |
| Miscellaneous Income | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | |
| Purchase Discounts Taken | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Other Income | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Other Expense | |||||||||||||
| Other Expense Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Expense Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Other Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Other Income | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Net Profit | ($14,186) | ($4,323) | ($7,308) | $11,103 | $36,755 | $25,322 | $13,902 | $13,477 | ($1,221) | ($3,533) | ($1,260) | ($9,402) | |
| Net Profit/Sales | -16.10% | -3.12% | -6.41% | 4.72% | 9.05% | 7.47% | 5.54% | 5.35% | -0.69% | -2.41% | -0.83% | -8.67% | |
| 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 | $86,353 | $135,730 | $111,720 | $230,300 | $397,802 | $332,220 | $245,980 | $246,960 | $174,440 | $143,570 | $148,960 | $106,330 | |
| Subtotal Cash from Operations | $86,411 | $137,526 | $114,474 | $232,661 | $402,616 | $340,294 | $252,701 | $251,981 | $179,431 | $147,109 | $151,894 | $109,341 | |
| 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 | $86,611 | $137,726 | $114,674 | $232,861 | $402,816 | $340,494 | $252,901 | $252,181 | $179,631 | $147,309 | $152,094 | $109,541 | |
| 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 | $15,482 | $15,482 | $16,316 | $16,316 | $16,316 | $16,316 | $16,316 | $16,316 | $16,320 | $16,316 | $16,320 | $16,320 | |
| Bill Payments | $689 | $20,774 | $23,284 | $27,727 | $287,919 | $845,041 | $236,042 | $32,504 | $33,031 | $29,166 | $30,429 | $216,132 | |
| Subtotal Spent on Operations | $16,171 | $36,256 | $39,600 | $44,043 | $304,235 | $861,357 | $252,358 | $48,820 | $49,351 | $45,482 | $46,749 | $232,452 | |
| 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 | $4,389 | $4,409 | $4,429 | $4,449 | $4,470 | $4,490 | $4,511 | $4,531 | $4,552 | $4,573 | $4,594 | $4,615 | |
| 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 | $20,560 | $40,665 | $44,029 | $48,492 | $308,705 | $865,847 | $256,869 | $53,351 | $53,903 | $50,055 | $51,343 | $237,067 | |
| Net Cash Flow | $66,051 | $97,061 | $70,645 | $184,369 | $94,110 | ($525,353) | ($3,968) | $198,829 | $125,728 | $97,254 | $100,751 | ($127,526) | |
| Cash Balance | $116,051 | $213,112 | $283,757 | $468,126 | $562,236 | $36,883 | $32,915 | $231,744 | $357,472 | $454,726 | $555,477 | $427,951 | |
| 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 | $50,000 | $116,051 | $213,112 | $283,757 | $468,126 | $562,236 | $36,883 | $32,915 | $231,744 | $357,472 | $454,726 | $555,477 | $427,951 |
| Accounts Receivable | $0 | $1,704 | $2,678 | $2,204 | $4,543 | $7,848 | $6,554 | $4,853 | $4,872 | $3,441 | $2,832 | $2,939 | $2,098 |
| Inventory | $900,000 | $833,914 | $730,039 | $644,539 | $705,000 | $1,218,000 | $1,163,750 | $975,500 | $786,500 | $653,000 | $543,125 | $629,125 | $547,750 |
| Other Current Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Total Current Assets | $975,000 | $976,669 | $970,829 | $955,500 | $1,202,669 | $1,813,084 | $1,232,187 | $1,038,268 | $1,048,116 | $1,038,914 | $1,025,684 | $1,212,541 | $1,002,799 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 |
| Accumulated Depreciation | $0 | $250 | $500 | $750 | $1,000 | $1,250 | $1,500 | $1,750 | $2,000 | $2,250 | $2,500 | $2,750 | $3,000 |
| Total Long-term Assets | $25,000 | $24,750 | $24,500 | $24,250 | $24,000 | $23,750 | $23,500 | $23,250 | $23,000 | $22,750 | $22,500 | $22,250 | $22,000 |
| Total Assets | $1,000,000 | $1,001,419 | $995,329 | $979,750 | $1,226,669 | $1,836,834 | $1,255,687 | $1,061,518 | $1,071,116 | $1,061,664 | $1,048,184 | $1,234,791 | $1,024,799 |
| 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 | $19,993 | $22,636 | $18,794 | $259,059 | $836,939 | $234,960 | $31,399 | $32,052 | $28,373 | $22,999 | $215,460 | $19,486 |
| 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 | $19,993 | $22,636 | $18,794 | $259,059 | $836,939 | $234,960 | $31,399 | $32,052 | $28,373 | $22,999 | $215,460 | $19,486 |
| Long-term Liabilities | $740,300 | $735,911 | $731,502 | $727,073 | $722,624 | $718,154 | $713,664 | $709,153 | $704,622 | $700,070 | $695,497 | $690,903 | $686,288 |
| Total Liabilities | $740,300 | $755,904 | $754,138 | $745,867 | $981,683 | $1,555,093 | $948,624 | $740,552 | $736,674 | $728,443 | $718,496 | $906,363 | $705,774 |
| Paid-in Capital | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 | $300,000 |
| Retained Earnings | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) | ($40,300) |
| Earnings | $0 | ($14,186) | ($18,509) | ($25,817) | ($14,714) | $22,041 | $47,363 | $61,266 | $74,742 | $73,521 | $69,987 | $68,728 | $59,325 |
| Total Capital | $259,700 | $245,514 | $241,191 | $233,883 | $244,986 | $281,741 | $307,063 | $320,966 | $334,442 | $333,221 | $329,687 | $328,428 | $319,025 |
| Total Liabilities and Capital | $1,000,000 | $1,001,419 | $995,329 | $979,750 | $1,226,669 | $1,836,834 | $1,255,687 | $1,061,518 | $1,071,116 | $1,061,664 | $1,048,184 | $1,234,791 | $1,024,799 |
| Net Worth | $259,700 | $245,514 | $241,191 | $233,883 | $244,986 | $281,741 | $307,063 | $320,966 | $334,442 | $333,221 | $329,687 | $328,428 | $319,025 |
By 
