All About People

Start your own business plan »

Employment Agency 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
Placement Fees 0% $3,660 $4,769 $5,965 $7,226 $9,471 $12,554 $12,237 $10,216 $3,692 $7,458 $7,059 $9,941
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $3,660 $4,769 $5,965 $7,226 $9,471 $12,554 $12,237 $10,216 $3,692 $7,458 $7,059 $9,941
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
Placement Fees $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
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Placed Employees Personnel
Placed Workers at 2/3 of Sales $2,013 $2,623 $3,281 $3,974 $5,209 $6,905 $6,730 $5,619 $2,031 $4,102 $3,882 $5,467
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $2,013 $2,623 $3,281 $3,974 $5,209 $6,905 $6,730 $5,619 $2,031 $4,102 $3,882 $5,467
General and Administrative Personnel
Office Employees $0 $213 $350 $350 $350 $466 $700 $1,500 $1,750 $1,750 $1,750 $1,750
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $213 $350 $350 $350 $466 $700 $1,500 $1,750 $1,750 $1,750 $1,750
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $2,013 $2,836 $3,631 $4,324 $5,559 $7,371 $7,430 $7,119 $3,781 $5,852 $5,632 $7,217
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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
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 $3,660 $4,769 $5,965 $7,226 $9,471 $12,554 $12,237 $10,216 $3,692 $7,458 $7,059 $9,941
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Placed Employees Payroll $2,013 $2,623 $3,281 $3,974 $5,209 $6,905 $6,730 $5,619 $2,031 $4,102 $3,882 $5,467
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,013 $2,623 $3,281 $3,974 $5,209 $6,905 $6,730 $5,619 $2,031 $4,102 $3,882 $5,467
Gross Margin $1,647 $2,146 $2,684 $3,252 $4,262 $5,649 $5,507 $4,597 $1,661 $3,356 $3,177 $4,474
Gross Margin % 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 45.00% 44.99% 45.00% 45.01% 45.00%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising/Promotion $12 $0 $0 $23 $10 $111 $27 $72 $30 $599 $102 $179
Bank Service Charges $0 $57 $3 $73 $539 $106 $38 $3 $8 $48 $129 $15
Contributions $0 $0 $0 $100 $5 $0 $0 $100 $0 $0 $0 $50
Dues & Subscriptions $43 $30 $54 $0 $0 $21 $275 $94 $0 $250 $60 $60
Total Sales and Marketing Expenses $55 $87 $57 $196 $554 $239 $340 $268 $38 $897 $291 $304
Sales and Marketing % 1.50% 1.82% 0.95% 2.71% 5.85% 1.90% 2.78% 2.63% 1.02% 12.03% 4.12% 3.06%
General and Administrative Expenses
General and Administrative Payroll $0 $213 $350 $350 $350 $466 $700 $1,500 $1,750 $1,750 $1,750 $1,750
Marketing/Promotion $213 $236 $331 $691 $756 $656 $592 $441 $154 $1,149 $784 $514
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Telephone & Pager $226 $88 $416 $125 $374 $220 $439 $638 $697 $240 $616 $90
Recruitment $115 $77 $189 $220 $71 $147 $106 $251 $45 $192 $65 $95
Referral Fees $0 $20 $0 $50 $0 $100 $0 $0 $0 $0 $0 $0
Rent $195 $195 $195 $195 $195 $195 $983 $788 $788 $788 $788 $798
Office Supplies $92 $188 $96 $197 $49 $62 $116 $442 $24 $670 $177 $0
Postage $9 $49 $55 $107 $133 $94 $36 $99 $8 $175 $89 $209
Printing $0 $2 $669 $26 $290 $350 $175 $224 $832 $179 $520 $94
Professional Fees $240 $170 $664 $988 $367 $270 $0 $528 $844 $342 $2,013 $516
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Maintenance and Repairs $0 $0 $103 $100 $0 $25 $0 $39 $0 $0 $44 $0
Total General and Administrative Expenses $1,090 $1,239 $3,068 $3,049 $2,585 $2,585 $3,146 $4,949 $5,142 $5,485 $6,845 $4,065
General and Administrative % 29.77% 25.97% 51.43% 42.19% 27.30% 20.59% 25.71% 48.45% 139.28% 73.55% 96.97% 40.90%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Misc. $40 $0 $44 $244 $90 $240 $159 $0 $40 $20 $173 $0
Total Other Expenses $40 $0 $44 $244 $90 $240 $159 $0 $40 $20 $173 $0
Other % 1.09% 0.00% 0.74% 3.38% 0.95% 1.91% 1.30% 0.00% 1.08% 0.27% 2.45% 0.00%
Total Operating Expenses $1,185 $1,325 $3,168 $3,488 $3,229 $3,064 $3,645 $5,218 $5,220 $6,403 $7,309 $4,369
Profit Before Interest and Taxes $462 $821 ($484) ($236) $1,033 $2,585 $1,862 ($621) ($3,559) ($3,047) ($4,132) $104
EBITDA $462 $821 ($484) ($236) $1,033 $2,585 $1,862 ($621) ($3,559) ($3,047) ($4,132) $104
Interest Expense $283 $281 $260 $258 $256 $254 $251 $245 $243 $241 $238 $236
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit $180 $540 ($744) ($494) $777 $2,332 $1,610 ($866) ($3,802) ($3,287) ($4,370) ($132)
Net Profit/Sales 4.90% 11.32% -12.48% -6.84% 8.21% 18.57% 13.16% -8.47% -102.97% -44.08% -61.91% -1.33%
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 $915 $1,192 $1,491 $1,807 $2,368 $3,139 $3,059 $2,554 $923 $1,865 $1,765 $2,485
Cash from Receivables $0 $92 $2,773 $3,607 $4,505 $5,476 $7,180 $9,408 $9,127 $7,499 $2,863 $5,584
Subtotal Cash from Operations $915 $1,284 $4,264 $5,413 $6,873 $8,614 $10,240 $11,962 $10,050 $9,363 $4,628 $8,069
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 $10,000
Subtotal Cash Received $915 $1,284 $4,264 $5,413 $6,873 $8,614 $10,240 $11,962 $10,050 $9,363 $4,628 $18,069
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 $2,013 $2,836 $3,631 $4,324 $5,559 $7,371 $7,430 $7,119 $3,781 $5,852 $5,632 $7,217
Bill Payments $193 $1,465 $1,449 $3,089 $3,388 $3,125 $2,863 $3,222 $3,954 $3,752 $4,923 $5,699
Subtotal Spent on Operations $2,206 $4,301 $5,080 $7,413 $8,947 $10,496 $10,293 $10,341 $7,735 $9,604 $10,555 $12,916
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 $2,220 $0 $0 $0 $0 $500 $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 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375 $375
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 $2,581 $4,676 $7,675 $7,788 $9,322 $10,871 $10,668 $11,216 $8,110 $9,979 $10,930 $13,291
Net Cash Flow ($1,666) ($3,392) ($3,411) ($2,375) ($2,449) ($2,257) ($428) $745 $1,940 ($616) ($6,303) $4,777
Cash Balance $44,334 $40,942 $37,530 $35,156 $32,707 $30,450 $30,022 $30,767 $32,707 $32,091 $25,789 $30,566
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 $46,000 $44,334 $40,942 $37,530 $35,156 $32,707 $30,450 $30,022 $30,767 $32,707 $32,091 $25,789 $30,566
Accounts Receivable $0 $2,745 $6,230 $7,931 $9,744 $12,342 $16,282 $18,279 $16,534 $10,176 $8,270 $10,701 $12,573
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $46,000 $47,079 $47,172 $45,462 $44,900 $45,049 $46,732 $48,301 $47,301 $42,883 $40,361 $36,490 $43,139
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 $46,000 $47,079 $47,172 $45,462 $44,900 $45,049 $46,732 $48,301 $47,301 $42,883 $40,361 $36,490 $43,139
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 $144 $1,419 $1,347 $2,976 $3,283 $3,030 $2,756 $3,090 $3,831 $3,589 $4,730 $5,604 $2,761
Current Borrowing $2,720 $2,720 $2,720 $500 $500 $500 $500 $500 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $2,864 $4,139 $4,067 $3,476 $3,783 $3,530 $3,256 $3,590 $3,831 $3,589 $4,730 $5,604 $2,761
Long-term Liabilities $45,000 $44,625 $44,250 $43,875 $43,500 $43,125 $42,750 $42,375 $42,000 $41,625 $41,250 $40,875 $40,500
Total Liabilities $47,864 $48,764 $48,317 $47,351 $47,283 $46,655 $46,006 $45,965 $45,831 $45,214 $45,980 $46,479 $43,261
Paid-in Capital $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $7,600 $17,600
Retained Earnings ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464) ($9,464)
Earnings $0 $180 $719 ($25) ($519) $258 $2,590 $4,200 $3,334 ($467) ($3,755) ($8,125) ($8,257)
Total Capital ($1,864) ($1,684) ($1,145) ($1,889) ($2,383) ($1,606) $726 $2,336 $1,470 ($2,331) ($5,619) ($9,989) ($121)
Total Liabilities and Capital $46,000 $47,079 $47,172 $45,462 $44,900 $45,049 $46,732 $48,301 $47,301 $42,883 $40,361 $36,490 $43,139
Net Worth ($1,864) ($1,684) ($1,145) ($1,889) ($2,383) ($1,606) $726 $2,336 $1,470 ($2,331) ($5,619) ($9,989) ($121)