Executive Search and Rescue Firm

Start your own business plan »

Exec 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
High-tech Firms 0% $0 $4,500 $6,454 $7,154 $7,985 $8,125 $8,678 $9,125 $9,654 $10,854 $11,547 $12,654
Non-high-tech Firms 0% $0 $0 $2,250 $2,154 $2,500 $2,458 $2,154 $2,254 $2,414 $2,345 $2,256 $2,145
Total Sales $0 $4,500 $8,704 $9,308 $10,485 $10,583 $10,832 $11,379 $12,068 $13,199 $13,803 $14,799
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
High-tech Firms $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Non-high-tech Firms $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
Dan 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Secretary/Receptionist 0% $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Part-time Employee 0% $0 $0 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Account Executive 0% $0 $0 $0 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Total People 1 2 3 4 4 4 4 4 4 4 4 4
Total Payroll $2,500 $4,000 $4,800 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
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 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $0 $4,500 $8,704 $9,308 $10,485 $10,583 $10,832 $11,379 $12,068 $13,199 $13,803 $14,799
Direct Cost of Sales $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 Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $0 $4,500 $8,704 $9,308 $10,485 $10,583 $10,832 $11,379 $12,068 $13,199 $13,803 $14,799
Gross Margin % 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $2,500 $4,000 $4,800 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $69 $69 $69 $69 $69 $69 $69 $69 $69 $69 $69 $69
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $175 $175 $175 $175 $175 $175 $175 $175 $175 $175 $175 $175
Insurance $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $375 $600 $720 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,944 $6,669 $7,589 $11,269 $11,269 $11,269 $11,269 $11,269 $11,269 $11,269 $11,269 $11,269
Profit Before Interest and Taxes ($4,944) ($2,169) $1,115 ($1,961) ($784) ($686) ($437) $110 $799 $1,930 $2,534 $3,530
EBITDA ($4,875) ($2,100) $1,184 ($1,892) ($715) ($617) ($368) $179 $868 $1,999 $2,603 $3,599
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,944) ($2,169) $1,115 ($1,961) ($784) ($686) ($437) $110 $799 $1,930 $2,534 $3,530
Net Profit/Sales 0.00% -48.20% 12.81% -21.07% -7.48% -6.48% -4.03% 0.97% 6.62% 14.62% 18.36% 23.85%
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 $0 $675 $1,306 $1,396 $1,573 $1,587 $1,625 $1,707 $1,810 $1,980 $2,070 $2,220
Cash from Receivables $0 $0 $128 $3,944 $7,416 $7,945 $8,915 $9,003 $9,223 $9,692 $10,290 $11,236
Subtotal Cash from Operations $0 $675 $1,433 $5,340 $8,988 $9,533 $10,540 $10,709 $11,033 $11,672 $12,360 $13,456
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 $6,000 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $675 $1,433 $5,340 $14,988 $9,533 $10,540 $10,709 $11,033 $11,672 $12,360 $13,456
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,500 $4,000 $4,800 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Bill Payments $79 $2,383 $2,604 $2,736 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Subtotal Spent on Operations $2,579 $6,383 $7,404 $10,736 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200
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 $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 $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,579 $6,383 $7,404 $10,736 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200
Net Cash Flow ($2,579) ($5,708) ($5,971) ($5,396) $3,788 ($1,667) ($660) ($491) ($167) $472 $1,160 $2,256
Cash Balance $18,171 $12,463 $6,492 $1,097 $4,885 $3,218 $2,557 $2,067 $1,900 $2,371 $3,532 $5,788
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 $20,750 $18,171 $12,463 $6,492 $1,097 $4,885 $3,218 $2,557 $2,067 $1,900 $2,371 $3,532 $5,788
Accounts Receivable $0 $0 $3,825 $11,096 $15,064 $16,560 $17,611 $17,903 $18,572 $19,608 $21,135 $22,578 $23,921
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $20,750 $18,171 $16,288 $17,588 $16,160 $21,445 $20,828 $20,460 $20,639 $21,507 $23,506 $26,109 $29,708
Long-term Assets
Long-term Assets $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Accumulated Depreciation $0 $69 $138 $207 $276 $345 $414 $483 $552 $621 $690 $759 $828
Total Long-term Assets $2,500 $2,431 $2,362 $2,293 $2,224 $2,155 $2,086 $2,017 $1,948 $1,879 $1,810 $1,741 $1,672
Total Assets $23,250 $20,602 $18,650 $19,881 $18,384 $23,600 $22,914 $22,477 $22,587 $23,386 $25,316 $27,850 $31,380
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 $2,296 $2,513 $2,629 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093
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 $2,296 $2,513 $2,629 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,296 $2,513 $2,629 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093 $3,093
Paid-in Capital $25,000 $25,000 $25,000 $25,000 $25,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000
Retained Earnings ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750) ($1,750)
Earnings $0 ($4,944) ($7,113) ($5,998) ($7,959) ($8,743) ($9,429) ($9,866) ($9,756) ($8,957) ($7,027) ($4,493) ($963)
Total Capital $23,250 $18,306 $16,137 $17,252 $15,291 $20,507 $19,821 $19,384 $19,494 $20,293 $22,223 $24,757 $28,287
Total Liabilities and Capital $23,250 $20,602 $18,650 $19,881 $18,384 $23,600 $22,914 $22,477 $22,587 $23,386 $25,316 $27,850 $31,380
Net Worth $23,250 $18,306 $16,137 $17,252 $15,291 $20,507 $19,821 $19,384 $19,494 $20,293 $22,223 $24,757 $28,287