Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Sporting Goods Retail icon Sports Equipment Cafe Business Plan

Start your plan

Boulder Stop

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
Carabiners & Climbing Hardware 0% $2,680 $2,714 $2,765 $2,783 $2,694 $2,270 $3,000 $3,200 $514 $2,783 $2,818 $2,873
Ropes & Harness 0% $1,480 $1,500 $1,530 $1,540 $1,488 $1,241 $1,556 $1,139 $325 $1,240 $1,261 $1,593
Climbing Garments & Shoes 0% $400 $500 $500 $600 $600 $500 $700 $800 $100 $200 $300 $300
Books and Magazines 0% $180 $188 $189 $191 $181 $136 $102 $26 $23 $191 $195 $201
Cookies 0% $158 $161 $165 $167 $159 $119 $89 $22 $20 $167 $170 $176
Espresso Regulars 0% $5,775 $5,891 $6,067 $6,128 $5,821 $4,366 $3,275 $819 $737 $6,128 $6,250 $6,438
Espresso Shakes 0% $743 $757 $780 $788 $748 $561 $421 $105 $95 $788 $804 $828
Gear Rentals 0% $200 $204 $210 $212 $202 $151 $113 $28 $26 $200 $204 $210
Total Sales $11,616 $11,915 $12,206 $12,409 $11,893 $9,344 $9,256 $6,139 $1,840 $11,697 $12,002 $12,619
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
Carabiners & Climbing Hardware $1,072 $1,086 $1,106 $1,113 $1,078 $908 $1,200 $1,280 $206 $1,113 $1,127 $1,149
Ropes & Harness $592 $600 $612 $616 $595 $496 $622 $456 $130 $496 $504 $637
Climbing Garments & Shoes $100 $125 $125 $150 $150 $125 $175 $200 $25 $50 $75 $75
Books and Magazines $120 $118 $115 $113 $107 $80 $60 $15 $14 $116 $118 $122
Cookies $42 $41 $40 $40 $38 $28 $21 $5 $5 $42 $43 $44
Espresso Regulars $1,980 $1,940 $1,902 $1,864 $1,770 $1,328 $996 $249 $224 $1,863 $1,900 $1,957
Espresso Shakes $363 $256 $349 $342 $325 $243 $183 $46 $41 $340 $347 $358
Gear Rentals $92 $94 $96 $97 $93 $69 $52 $13 $12 $92 $94 $96
Subtotal Direct Cost of Sales $4,361 $4,260 $4,345 $4,335 $4,156 $3,277 $3,309 $2,264 $657 $4,112 $4,209 $4,438
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 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
Part-time Employee #1 0% $500 $500 $500 $500 $500 $550 $0 $0 $0 $550 $550 $550
Part-time Employee #2 0% $500 $500 $500 $500 $500 $550 $0 $0 $0 $550 $550 $550
Total People 3 3 3 3 3 3 1 1 1 3 3 3
Total Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,100 $3,000 $3,000 $3,000 $4,100 $4,100 $4,100

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 $11,616 $11,915 $12,206 $12,409 $11,893 $9,344 $9,256 $6,139 $1,840 $11,697 $12,002 $12,619
Direct Cost of Sales $4,361 $4,260 $4,345 $4,335 $4,156 $3,277 $3,309 $2,264 $657 $4,112 $4,209 $4,438
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $4,361 $4,260 $4,345 $4,335 $4,156 $3,277 $3,309 $2,264 $657 $4,112 $4,209 $4,438
Gross Margin $7,255 $7,655 $7,861 $8,074 $7,737 $6,067 $5,947 $3,875 $1,183 $7,585 $7,793 $8,181
Gross Margin % 62.46% 64.25% 64.40% 65.06% 65.06% 64.93% 64.25% 63.13% 64.32% 64.84% 64.93% 64.83%
Expenses
Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,100 $3,000 $3,000 $3,000 $4,100 $4,100 $4,100
Marketing/Promotion $700 $500 $550 $650 $250 $250 $0 $0 $0 $540 $250 $350
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Utilities $120 $121 $121 $122 $122 $122 $160 $160 $160 $115 $123 $123
Insurance $70 $70 $70 $70 $70 $70 $50 $50 $50 $70 $70 $70
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 $6,590 $6,391 $6,441 $6,542 $6,142 $6,242 $4,910 $4,910 $4,910 $6,525 $6,243 $6,343
Profit Before Interest and Taxes $665 $1,264 $1,420 $1,532 $1,595 ($175) $1,037 ($1,035) ($3,727) $1,060 $1,550 $1,838
EBITDA $665 $1,264 $1,420 $1,532 $1,595 ($175) $1,037 ($1,035) ($3,727) $1,060 $1,550 $1,838
Interest Expense ($1) ($3) ($4) ($6) ($7) ($8) ($10) ($11) ($12) ($14) ($15) ($17)
Taxes Incurred $200 $380 $427 $461 $481 ($50) $314 ($307) ($1,114) $322 $470 $556
Net Profit $466 $887 $997 $1,076 $1,121 ($117) $732 ($717) ($2,600) $751 $1,096 $1,298
Net Profit/Sales 4.02% 7.44% 8.17% 8.67% 9.43% -1.25% 7.91% -11.67% -141.30% 6.42% 9.13% 10.29%

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 $11,616 $11,915 $12,206 $12,409 $11,893 $9,344 $9,256 $6,139 $1,840 $11,697 $12,002 $12,619
Subtotal Cash from Operations $11,616 $11,915 $12,206 $12,409 $11,893 $9,344 $9,256 $6,139 $1,840 $11,697 $12,002 $12,619
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 $2,000 $0 $0 $0
Subtotal Cash Received $11,616 $11,915 $12,206 $12,409 $11,893 $9,344 $9,256 $6,139 $3,840 $11,697 $12,002 $12,619
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 $4,000 $4,000 $4,000 $4,000 $4,000 $4,100 $3,000 $3,000 $3,000 $4,100 $4,100 $4,100
Bill Payments $165 $5,012 $6,929 $7,304 $7,297 $6,502 $4,434 $5,464 $2,641 $1,075 $9,448 $6,931
Subtotal Spent on Operations $4,165 $9,012 $10,929 $11,304 $11,297 $10,602 $7,434 $8,464 $5,641 $5,175 $13,548 $11,031
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 $220 $220 $220 $220 $220 $220 $220 $220 $220 $220 $220 $220
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 $4,385 $9,232 $11,149 $11,524 $11,517 $10,822 $7,654 $8,684 $5,861 $5,395 $13,768 $11,251
Net Cash Flow $7,231 $2,683 $1,057 $885 $376 ($1,478) $1,602 ($2,545) ($2,021) $6,302 ($1,766) $1,368
Cash Balance $10,231 $12,914 $13,970 $14,856 $15,232 $13,754 $15,356 $12,812 $10,791 $17,093 $15,326 $16,695

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 $3,000 $10,231 $12,914 $13,970 $14,856 $15,232 $13,754 $15,356 $12,812 $10,791 $17,093 $15,326 $16,695
Inventory $7,000 $4,797 $4,686 $4,780 $4,769 $4,571 $3,605 $3,640 $2,490 $1,833 $4,523 $4,629 $4,882
Other Current Assets $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total Current Assets $11,000 $16,028 $18,599 $19,750 $20,625 $20,803 $18,359 $19,997 $16,302 $13,624 $22,616 $20,956 $22,577
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $11,000 $16,028 $18,599 $19,750 $20,625 $20,803 $18,359 $19,997 $16,302 $13,624 $22,616 $20,956 $22,577
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,782 $6,686 $7,060 $7,078 $6,355 $4,248 $5,374 $2,615 $757 $9,218 $6,682 $7,225
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,782 $6,686 $7,060 $7,078 $6,355 $4,248 $5,374 $2,615 $757 $9,218 $6,682 $7,225
Long-term Liabilities $0 ($220) ($440) ($660) ($880) ($1,100) ($1,320) ($1,540) ($1,760) ($1,980) ($2,200) ($2,420) ($2,640)
Total Liabilities $0 $4,562 $6,246 $6,400 $6,198 $5,255 $2,928 $3,834 $855 ($1,223) $7,018 $4,262 $4,585
Paid-in Capital $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $27,000 $29,000 $29,000 $29,000 $29,000
Retained Earnings ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000) ($16,000)
Earnings $0 $466 $1,353 $2,350 $3,426 $4,548 $4,431 $5,163 $4,447 $1,847 $2,598 $3,694 $4,992
Total Capital $11,000 $11,466 $12,353 $13,350 $14,426 $15,548 $15,431 $16,163 $15,447 $14,847 $15,598 $16,694 $17,992
Total Liabilities and Capital $11,000 $16,028 $18,599 $19,750 $20,625 $20,803 $18,359 $19,997 $16,302 $13,624 $22,616 $20,956 $22,577
Net Worth $11,000 $11,466 $12,353 $13,350 $14,426 $15,548 $15,431 $16,163 $15,447 $14,847 $15,598 $16,694 $17,992
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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Long-term Interest Rate 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0