Sportsuchtig

Start your own business plan »

Sporting Goods Retail Store 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
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