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 |