Batten-Hatchez Security

Start your own business plan »

Security Guard 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
Security Guards $6,000 $10,800 $19,440 $34,992 $55,987 $78,382 $94,058 $96,880 $99,787 $102,780 $105,864 $109,040
Security Audits $500 $700 $980 $1,372 $1,921 $2,689 $3,765 $5,271 $7,379 $10,331 $14,463 $20,248
Commissions $0 $500 $700 $980 $1,372 $1,921 $2,689 $3,765 $5,271 $7,379 $10,331 $14,463
Total Sales $6,500 $12,000 $21,120 $37,344 $59,280 $82,992 $100,513 $105,916 $112,436 $120,490 $130,657 $143,750
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
Job Supplies $300 $540 $972 $1,750 $2,799 $3,919 $4,703 $4,844 $4,989 $5,139 $5,293 $5,452
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $300 $540 $972 $1,750 $2,799 $3,919 $4,703 $4,844 $4,989 $5,139 $5,293 $5,452
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
Chindit Batten $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Viipuri Hatchez $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Administrative/Call Center Assistants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
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 $6,500 $12,000 $21,120 $37,344 $59,280 $82,992 $100,513 $105,916 $112,436 $120,490 $130,657 $143,750
Direct Cost of Sales $300 $540 $972 $1,750 $2,799 $3,919 $4,703 $4,844 $4,989 $5,139 $5,293 $5,452
Security Guard Labor $3,575 $6,600 $11,616 $20,539 $32,604 $45,646 $55,282 $58,254 $61,840 $66,270 $71,861 $79,063
Total Cost of Sales $3,875 $7,140 $12,588 $22,289 $35,403 $49,565 $59,985 $63,098 $66,829 $71,409 $77,155 $84,515
Gross Margin $2,625 $4,860 $8,532 $15,055 $23,877 $33,427 $40,528 $42,818 $45,607 $49,082 $53,503 $59,236
Gross Margin % 40.38% 40.50% 40.40% 40.31% 40.28% 40.28% 40.32% 40.43% 40.56% 40.73% 40.95% 41.21%
Expenses
Payroll $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Marketing/Promotion $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $2,000 $2,000 $2,000
Depreciation $28 $34 $39 $45 $50 $56 $61 $67 $72 $78 $84 $89
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Surety Bond $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $1,136 $1,590 $2,342 $3,681 $5,491 $7,447 $9,492 $9,938 $10,476 $11,140 $11,979 $13,059
Employee Benefits 10% $758 $1,060 $1,562 $2,454 $3,660 $4,965 $6,328 $6,625 $6,984 $7,427 $7,986 $8,706
Training 15% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Licenses and Permits $500 $600 $700 $700 $800 $800 $900 $900 $1,000 $1,000 $1,000 $8,000
Total Operating Expenses $10,422 $11,284 $12,643 $14,879 $18,001 $21,267 $28,782 $29,530 $30,532 $30,645 $32,049 $40,855
Profit Before Interest and Taxes ($7,797) ($6,424) ($4,111) $176 $5,875 $12,160 $11,746 $13,288 $15,075 $18,436 $21,454 $18,381
EBITDA ($7,769) ($6,390) ($4,072) $220 $5,926 $12,216 $11,807 $13,355 $15,147 $18,514 $21,537 $18,470
Interest Expense $60 $58 $55 $53 $50 $48 $45 $43 $40 $38 $35 $33
Taxes Incurred ($2,357) ($1,944) ($1,250) $37 $1,748 $3,634 $3,510 $3,974 $4,510 $5,520 $6,426 $5,505
Net Profit ($5,500) ($4,537) ($2,916) $86 $4,078 $8,479 $8,191 $9,272 $10,524 $12,879 $14,993 $12,844
Net Profit/Sales -84.61% -37.81% -13.81% 0.23% 6.88% 10.22% 8.15% 8.75% 9.36% 10.69% 11.48% 8.93%
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 $1,950 $3,600 $6,336 $11,203 $17,784 $24,898 $30,154 $31,775 $33,731 $36,147 $39,197 $43,125
Cash from Receivables $0 $2,427 $6,603 $11,805 $20,841 $34,330 $50,349 $64,635 $72,376 $76,575 $81,712 $88,139
Subtotal Cash from Operations $1,950 $6,027 $12,939 $23,008 $38,625 $59,228 $80,502 $96,410 $106,107 $112,723 $120,909 $131,264
Additional Cash Received
Sales Tax, VAT, HST/GST Received 7.00% $455 $840 $1,478 $2,614 $4,150 $5,809 $7,036 $7,414 $7,871 $8,434 $9,146 $10,063
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 $2,405 $6,867 $14,418 $25,622 $42,775 $65,037 $87,538 $103,824 $113,978 $121,157 $130,055 $141,326
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,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Bill Payments $266 $8,123 $12,753 $20,438 $33,811 $51,796 $70,917 $84,405 $88,753 $94,029 $99,801 $108,088
Subtotal Spent on Operations $4,266 $12,123 $16,753 $24,438 $37,811 $55,796 $78,917 $92,405 $96,753 $102,029 $107,801 $116,088
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $455 $840 $1,478 $2,614 $4,150 $5,809 $7,036 $7,414 $7,871 $8,434 $9,146 $10,063
Principal Repayment of Current Borrowing $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $5,121 $13,363 $18,631 $27,452 $42,361 $62,005 $86,353 $100,219 $105,023 $110,864 $117,347 $126,551
Net Cash Flow ($2,716) ($6,496) ($4,214) ($1,830) $414 $3,032 $1,185 $3,606 $8,954 $10,293 $12,708 $14,775
Cash Balance $37,284 $30,788 $26,575 $24,745 $25,159 $28,191 $29,376 $32,982 $41,936 $52,229 $64,937 $79,712
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 $40,000 $37,284 $30,788 $26,575 $24,745 $25,159 $28,191 $29,376 $32,982 $41,936 $52,229 $64,937 $79,712
Accounts Receivable $0 $4,550 $10,523 $18,704 $33,040 $53,695 $77,459 $97,470 $106,975 $113,305 $121,072 $130,820 $143,307
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $40,000 $41,834 $41,312 $45,279 $57,785 $78,854 $105,650 $126,845 $139,957 $155,240 $173,301 $195,757 $223,019
Long-term Assets
Long-term Assets $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $2,200 $2,400 $2,600 $2,800 $3,000 $3,200 $3,400
Accumulated Depreciation $0 $28 $62 $101 $145 $196 $251 $313 $380 $452 $530 $614 $703
Total Long-term Assets $1,000 $1,172 $1,338 $1,499 $1,655 $1,804 $1,949 $2,087 $2,220 $2,348 $2,470 $2,586 $2,697
Total Assets $41,000 $43,006 $42,650 $46,778 $59,439 $80,658 $107,599 $128,933 $142,177 $157,588 $175,771 $198,343 $225,716
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 $7,706 $12,086 $19,331 $32,106 $49,447 $68,109 $81,452 $85,625 $90,712 $96,215 $103,995 $118,723
Current Borrowing $5,000 $4,800 $4,600 $4,400 $4,200 $4,000 $3,800 $3,600 $3,400 $3,200 $3,000 $2,800 $2,600
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $5,000 $12,506 $16,686 $23,731 $36,306 $53,447 $71,909 $85,052 $89,025 $93,912 $99,215 $106,795 $121,323
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $5,000 $12,506 $16,686 $23,731 $36,306 $53,447 $71,909 $85,052 $89,025 $93,912 $99,215 $106,795 $121,323
Paid-in Capital $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700 $72,700
Retained Earnings ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700) ($36,700)
Earnings $0 ($5,500) ($10,036) ($12,953) ($12,866) ($8,789) ($310) $7,881 $17,153 $27,677 $40,556 $55,549 $68,393
Total Capital $36,000 $30,500 $25,964 $23,047 $23,134 $27,211 $35,690 $43,881 $53,153 $63,677 $76,556 $91,549 $104,393
Total Liabilities and Capital $41,000 $43,006 $42,650 $46,778 $59,439 $80,658 $107,599 $128,933 $142,177 $157,588 $175,771 $198,343 $225,716
Net Worth $36,000 $30,500 $25,964 $23,047 $23,134 $27,211 $35,690 $43,881 $53,153 $63,677 $76,556 $91,549 $104,393