Harquebus Paintball, Inc.

Start your own business plan »

Paintball Products 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
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