Keith's Sporting Goods
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 |