Keith's Sporting Goods

Start your own business plan »

Sports Equipment Retail 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
Shoes 0% $14,400 $14,688 $14,982 $15,281 $15,587 $15,899 $16,217 $16,541 $16,872 $17,209 $17,554 $17,905
Apparel 0% $18,000 $18,360 $18,727 $19,102 $19,484 $19,873 $20,271 $20,676 $21,090 $21,512 $21,942 $22,381
Total Sales $32,400 $33,048 $33,709 $34,383 $35,071 $35,772 $36,488 $37,217 $37,962 $38,721 $39,495 $40,285
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
Shoes 60% $8,640 $8,813 $8,989 $9,169 $9,352 $9,539 $9,730 $9,925 $10,123 $10,326 $10,532 $10,743
Apparel $10,800 $11,016 $11,236 $11,461 $11,690 $11,924 $12,163 $12,406 $12,654 $12,907 $13,165 $13,428
Subtotal Direct Cost of Sales $19,440 $19,829 $20,225 $20,630 $21,042 $21,463 $21,893 $22,330 $22,777 $23,233 $23,697 $24,171
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
Owner Operator 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
Manager 0% $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Employees 0% $1,836 $1,836 $1,836 $1,836 $1,836 $1,836 $1,836 $1,836 $1,836 $1,836 $1,836 $1,836
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $32,400 $33,048 $33,709 $34,383 $35,071 $35,772 $36,488 $37,217 $37,962 $38,721 $39,495 $40,285
Direct Cost of Sales $19,440 $19,829 $20,225 $20,630 $21,042 $21,463 $21,893 $22,330 $22,777 $23,233 $23,697 $24,171
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $19,440 $19,829 $20,225 $20,630 $21,042 $21,463 $21,893 $22,330 $22,777 $23,233 $23,697 $24,171
Gross Margin $12,960 $13,219 $13,484 $13,753 $14,028 $14,309 $14,595 $14,887 $15,185 $15,488 $15,798 $16,114
Gross Margin % 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00%
Expenses
Payroll $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436
Sales and Marketing and Other Expenses $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Rent $1,980 $1,980 $1,980 $1,980 $1,980 $1,980 $1,980 $1,980 $1,980 $1,980 $1,980 $1,980
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $13,016 $13,016 $13,016 $13,016 $13,016 $13,016 $13,016 $13,016 $13,016 $13,016 $13,016 $13,016
Profit Before Interest and Taxes ($56) $203 $468 $737 $1,012 $1,293 $1,579 $1,871 $2,169 $2,472 $2,782 $3,098
EBITDA ($56) $203 $468 $737 $1,012 $1,293 $1,579 $1,871 $2,169 $2,472 $2,782 $3,098
Interest Expense $492 $483 $475 $467 $458 $450 $442 $433 $425 $417 $408 $400
Taxes Incurred ($164) ($70) ($2) $68 $138 $211 $284 $359 $436 $514 $593 $675
Net Profit ($383) ($210) ($6) $203 $415 $632 $853 $1,078 $1,308 $1,542 $1,780 $2,024
Net Profit/Sales -1.18% -0.64% -0.02% 0.59% 1.18% 1.77% 2.34% 2.90% 3.44% 3.98% 4.51% 5.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 $32,400 $33,048 $33,709 $34,383 $35,071 $35,772 $36,488 $37,217 $37,962 $38,721 $39,495 $40,285
Subtotal Cash from Operations $32,400 $33,048 $33,709 $34,383 $35,071 $35,772 $36,488 $37,217 $37,962 $38,721 $39,495 $40,285
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 $32,400 $33,048 $33,709 $34,383 $35,071 $35,772 $36,488 $37,217 $37,962 $38,721 $39,495 $40,285
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 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436 $8,436
Bill Payments $164 $4,910 $4,995 $5,719 $25,085 $26,690 $27,184 $27,688 $28,202 $28,727 $29,262 $29,809
Subtotal Spent on Operations $8,600 $13,346 $13,431 $14,155 $33,521 $35,126 $35,620 $36,124 $36,638 $37,163 $37,698 $38,245
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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
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 $9,600 $14,346 $14,431 $15,155 $34,521 $36,126 $36,620 $37,124 $37,638 $38,163 $38,698 $39,245
Net Cash Flow $22,800 $18,702 $19,278 $19,228 $550 ($353) ($132) $93 $323 $558 $797 $1,041
Cash Balance $31,289 $49,991 $69,269 $88,497 $89,047 $88,693 $88,561 $88,655 $88,978 $89,536 $90,333 $91,374
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 $8,489 $31,289 $49,991 $69,269 $88,497 $89,047 $88,693 $88,561 $88,655 $88,978 $89,536 $90,333 $91,374
Inventory $82,901 $63,461 $43,632 $23,407 $22,693 $23,147 $23,610 $24,082 $24,563 $25,055 $25,556 $26,067 $26,588
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $91,390 $94,750 $93,623 $92,676 $111,190 $112,193 $112,303 $112,643 $113,218 $114,033 $115,092 $116,400 $117,962
Long-term Assets
Long-term Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Assets $93,390 $96,750 $95,623 $94,676 $113,190 $114,193 $114,303 $114,643 $115,218 $116,033 $117,092 $118,400 $119,962
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,744 $4,827 $4,885 $24,196 $25,784 $26,261 $26,748 $27,245 $27,752 $28,269 $28,797 $29,335
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,744 $4,827 $4,885 $24,196 $25,784 $26,261 $26,748 $27,245 $27,752 $28,269 $28,797 $29,335
Long-term Liabilities $60,000 $59,000 $58,000 $57,000 $56,000 $55,000 $54,000 $53,000 $52,000 $51,000 $50,000 $49,000 $48,000
Total Liabilities $60,000 $63,744 $62,827 $61,885 $80,196 $80,784 $80,261 $79,748 $79,245 $78,752 $78,269 $77,797 $77,335
Paid-in Capital $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Retained Earnings ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610) ($6,610)
Earnings $0 ($383) ($593) ($599) ($396) $19 $652 $1,505 $2,583 $3,891 $5,432 $7,213 $9,236
Total Capital $33,390 $33,007 $32,797 $32,791 $32,994 $33,409 $34,042 $34,895 $35,973 $37,281 $38,822 $40,603 $42,626
Total Liabilities and Capital $93,390 $96,750 $95,623 $94,676 $113,190 $114,193 $114,303 $114,643 $115,218 $116,033 $117,092 $118,400 $119,962
Net Worth $33,390 $33,007 $32,797 $32,791 $32,994 $33,409 $34,042 $34,895 $35,973 $37,281 $38,822 $40,603 $42,626