Paintball Products Retail Business Plan

Start your plan
Start my business plan

Start your own paintball products retail business plan

Harquebus Paintball, Inc.

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
Guns 1% $35,733 $36,090 $36,451 $36,816 $37,184 $37,556 $37,931 $38,311 $38,694 $39,081 $39,471 $39,866
Hoppers 1% $6,253 $6,316 $6,379 $6,442 $6,507 $6,572 $6,638 $6,704 $6,771 $6,839 $6,907 $6,976
Paintballs 1% $53,600 $54,136 $54,677 $55,224 $55,776 $56,334 $56,897 $57,466 $58,041 $58,622 $59,208 $59,800
Gun Upgrades 1% $17,867 $18,046 $18,226 $18,408 $18,592 $18,778 $18,966 $19,156 $19,347 $19,541 $19,736 $19,934
Apparel 1% $35,733 $36,090 $36,451 $36,816 $37,184 $37,556 $37,931 $38,311 $38,694 $39,081 $39,471 $39,866
Repairs 1% $1,787 $1,805 $1,823 $1,841 $1,860 $1,878 $1,897 $1,916 $1,935 $1,954 $1,974 $1,994
Magazines 1% $447 $451 $456 $461 $465 $470 $474 $479 $484 $489 $494 $499
Total Sales $151,420 $152,934 $154,464 $156,008 $157,568 $159,144 $160,735 $162,343 $163,966 $165,606 $167,262 $168,935
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
Guns 1% $26,800 $27,068 $27,338 $27,612 $27,888 $28,167 $28,448 $28,733 $29,020 $29,310 $29,604 $29,900
Hoppers 1% $4,690 $4,737 $4,784 $4,832 $4,880 $4,929 $4,979 $5,028 $5,079 $5,129 $5,181 $5,232
Paintballs 1% $40,200 $40,602 $41,008 $41,418 $41,832 $42,251 $42,673 $43,100 $43,531 $43,966 $44,406 $44,850
Gun Upgrades 1% $13,400 $13,534 $13,669 $13,806 $13,944 $14,084 $14,224 $14,367 $14,510 $14,655 $14,802 $14,950
Apparel 1% $26,800 $27,068 $27,339 $27,612 $27,888 $28,167 $28,449 $28,733 $29,021 $29,311 $29,604 $29,900
Repairs 1% $772 $798 $772 $798 $798 $772 $798 $772 $798 $798 $721 $798
Magazines 1% $335 $338 $342 $345 $349 $352 $356 $359 $363 $366 $370 $374
Subtotal Direct Cost of Sales $112,997 $114,145 $115,252 $116,423 $117,580 $118,721 $119,927 $121,092 $122,321 $123,537 $124,687 $126,004
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
Store Manager 0% $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Asst. Store Manager 0% $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Inventory Manager 0% $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Service Manager 0% $867 $867 $867 $867 $867 $867 $867 $867 $867 $867 $867 $867
Front Svc. Clerk 0% $803 $830 $803 $830 $830 $803 $830 $803 $830 $830 $750 $830
Front Svc. Clerk 0% $803 $830 $803 $830 $830 $803 $830 $803 $830 $830 $750 $830
Front Svc. Clerk 0% $803 $830 $803 $830 $830 $803 $830 $803 $830 $830 $750 $830
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $8,376 $8,457 $8,376 $8,457 $8,457 $8,376 $8,457 $8,376 $8,457 $8,457 $8,217 $8,457

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 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 Long-term Interest Rate 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00%
Tax Rate 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

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 $151,420 $152,934 $154,464 $156,008 $157,568 $159,144 $160,735 $162,343 $163,966 $165,606 $167,262 $168,935
Direct Cost of Sales $112,997 $114,145 $115,252 $116,423 $117,580 $118,721 $119,927 $121,092 $122,321 $123,537 $124,687 $126,004
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $112,997 $114,145 $115,252 $116,423 $117,580 $118,721 $119,927 $121,092 $122,321 $123,537 $124,687 $126,004
Gross Margin $38,423 $38,789 $39,211 $39,585 $39,989 $40,423 $40,809 $41,251 $41,645 $42,069 $42,575 $42,931
Gross Margin % 25.38% 25.36% 25.39% 25.37% 25.38% 25.40% 25.39% 25.41% 25.40% 25.40% 25.45% 25.41%
Expenses
Payroll $8,376 $8,457 $8,376 $8,457 $8,457 $8,376 $8,457 $8,376 $8,457 $8,457 $8,217 $8,457
Sales and Marketing and Other Expenses $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Depreciation $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Rent $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717 $2,717
Utilities $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Insurance $94 $94 $94 $94 $94 $94 $94 $94 $94 $94 $94 $94
Payroll Taxes 20% $562 $581 $568 $581 $581 $562 $581 $562 $581 $581 $525 $581
Website 15% $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $18,799 $18,899 $18,805 $18,899 $18,899 $18,799 $18,899 $18,799 $18,899 $18,899 $18,603 $18,899
Profit Before Interest and Taxes $19,624 $19,890 $20,406 $20,686 $21,090 $21,623 $21,909 $22,451 $22,746 $23,170 $23,972 $24,032
EBITDA $19,674 $19,940 $20,456 $20,736 $21,140 $21,673 $21,959 $22,501 $22,796 $23,220 $24,022 $24,082
Interest Expense $700 $689 $678 $666 $655 $644 $633 $621 $610 $599 $588 $576
Taxes Incurred $5,677 $5,760 $5,918 $6,006 $6,130 $6,294 $6,383 $6,549 $6,641 $6,771 $7,015 $7,037
Net Profit $13,247 $13,441 $13,810 $14,014 $14,304 $14,686 $14,894 $15,281 $15,495 $15,800 $16,369 $16,419
Net Profit/Sales 8.75% 8.79% 8.94% 8.98% 9.08% 9.23% 9.27% 9.41% 9.45% 9.54% 9.79% 9.72%

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 $151,420 $152,934 $154,464 $156,008 $157,568 $159,144 $160,735 $162,343 $163,966 $165,606 $167,262 $168,935
Subtotal Cash from Operations $151,420 $152,934 $154,464 $156,008 $157,568 $159,144 $160,735 $162,343 $163,966 $165,606 $167,262 $168,935
Additional Cash Received
Sales Tax, VAT, HST/GST Received 7.00% $10,599 $10,705 $10,812 $10,921 $11,030 $11,140 $11,251 $11,364 $11,478 $11,592 $11,708 $11,825
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 $162,019 $163,640 $165,276 $166,929 $168,598 $170,284 $171,987 $173,707 $175,444 $177,198 $178,970 $180,760
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,376 $8,457 $8,376 $8,457 $8,457 $8,376 $8,457 $8,376 $8,457 $8,457 $8,217 $8,457
Bill Payments $5,801 $172,651 $132,289 $133,490 $134,817 $136,071 $137,334 $138,702 $139,964 $141,360 $142,677 $143,943
Subtotal Spent on Operations $14,177 $181,108 $140,665 $141,947 $143,274 $144,447 $145,791 $147,078 $148,421 $149,817 $150,894 $152,400
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $10,599 $10,705 $10,812 $10,921 $11,030 $11,140 $11,251 $11,364 $11,478 $11,592 $11,708 $11,825
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 $0 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250
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 $24,777 $194,063 $153,728 $155,118 $156,554 $157,837 $159,292 $160,692 $162,149 $163,660 $164,853 $166,476
Net Cash Flow $137,243 ($30,423) $11,548 $11,811 $12,044 $12,447 $12,694 $13,014 $13,295 $13,539 $14,117 $14,284
Cash Balance $164,807 $134,383 $145,932 $157,743 $169,787 $182,234 $194,928 $207,942 $221,237 $234,776 $248,894 $263,178
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 $27,564 $164,807 $134,383 $145,932 $157,743 $169,787 $182,234 $194,928 $207,942 $221,237 $234,776 $248,894 $263,178
Inventory $80,000 $124,296 $125,559 $126,778 $128,066 $129,337 $130,593 $131,920 $133,201 $134,553 $135,890 $137,155 $138,604
Other Current Assets $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100
Total Current Assets $119,664 $301,203 $272,043 $284,809 $297,908 $311,224 $324,927 $338,948 $353,244 $367,891 $382,766 $398,149 $413,882
Long-term Assets
Long-term Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Accumulated Depreciation $0 $50 $100 $150 $200 $250 $300 $350 $400 $450 $500 $550 $600
Total Long-term Assets $5,000 $4,950 $4,900 $4,850 $4,800 $4,750 $4,700 $4,650 $4,600 $4,550 $4,500 $4,450 $4,400
Total Assets $124,664 $306,153 $276,943 $289,659 $302,708 $315,974 $329,627 $343,598 $357,844 $372,441 $387,266 $402,599 $418,282
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 $168,242 $127,841 $128,998 $130,283 $131,495 $132,712 $134,039 $135,254 $136,606 $137,881 $139,095 $140,609
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 $168,242 $127,841 $128,998 $130,283 $131,495 $132,712 $134,039 $135,254 $136,606 $137,881 $139,095 $140,609
Long-term Liabilities $140,000 $140,000 $137,750 $135,500 $133,250 $131,000 $128,750 $126,500 $124,250 $122,000 $119,750 $117,500 $115,250
Total Liabilities $140,000 $308,242 $265,591 $264,498 $263,533 $262,495 $261,462 $260,539 $259,504 $258,606 $257,631 $256,595 $255,859
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Retained Earnings ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336) ($95,336)
Earnings $0 $13,247 $26,688 $40,498 $54,511 $68,816 $83,501 $98,395 $113,676 $129,171 $144,971 $161,340 $177,759
Total Capital ($15,336) ($2,089) $11,352 $25,162 $39,175 $53,480 $68,165 $83,059 $98,340 $113,835 $129,635 $146,004 $162,423
Total Liabilities and Capital $124,664 $306,153 $276,943 $289,659 $302,708 $315,974 $329,627 $343,598 $357,844 $372,441 $387,266 $402,599 $418,282
Net Worth ($15,336) ($2,089) $11,352 $25,162 $39,175 $53,480 $68,165 $83,059 $98,340 $113,835 $129,635 $146,004 $162,423

Download link edge graphic Download this plan

Start your own paintball products retail business plan

Start your own business plan

LivePlan logo Start planning

Your business plan can look as polished and professional as this sample plan. It's fast and easy, with LivePlan.

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.