Corporate Retreat Professionals

Start your own business plan »

Event Planning 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
Large companies 0% $0 $0 $1,874 $1,997 $4,587 $4,998 $5,354 $6,874 $7,445 $7,963 $8,547 $9,125
Small companies 0% $0 $0 $1,255 $1,458 $2,547 $2,754 $2,914 $3,874 $4,554 $4,998 $5,347 $5,901
Total Sales $0 $0 $3,129 $3,455 $7,134 $7,752 $8,268 $10,748 $11,999 $12,961 $13,894 $15,026
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
Large companies $0 $0 $321 $384 $1,125 $1,321 $1,478 $1,848 $2,114 $2,325 $2,400 $2,564
Small companies $0 $0 $121 $214 $457 $554 $658 $854 $1,010 $1,121 $1,145 $1,300
Subtotal Direct Cost of Sales $0 $0 $442 $598 $1,582 $1,875 $2,136 $2,702 $3,124 $3,446 $3,545 $3,864
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
Jeff 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
secretary/ receptionist 0% $0 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
account manager 0% $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 2 2 3 3 3 3 3 3 3 3 3
Total Payroll $2,000 $3,700 $3,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700
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 $0 $3,129 $3,455 $7,134 $7,752 $8,268 $10,748 $11,999 $12,961 $13,894 $15,026
Direct Cost of Sales $0 $0 $442 $598 $1,582 $1,875 $2,136 $2,702 $3,124 $3,446 $3,545 $3,864
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $442 $598 $1,582 $1,875 $2,136 $2,702 $3,124 $3,446 $3,545 $3,864
Gross Margin $0 $0 $2,687 $2,857 $5,552 $5,877 $6,132 $8,046 $8,875 $9,515 $10,349 $11,162
Gross Margin % 0.00% 0.00% 85.87% 82.69% 77.82% 75.81% 74.17% 74.86% 73.96% 73.41% 74.49% 74.28%
Expenses
Payroll $2,000 $3,700 $3,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700
Sales and Marketing and Other Expenses $0 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Depreciation $139 $139 $139 $139 $139 $139 $139 $139 $139 $139 $139 $139
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Payroll Taxes 15% $300 $555 $555 $1,005 $1,005 $1,005 $1,005 $1,005 $1,005 $1,005 $1,005 $1,005
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,939 $5,994 $5,994 $8,444 $8,444 $8,444 $8,444 $8,444 $8,444 $8,444 $8,444 $8,444
Profit Before Interest and Taxes ($3,939) ($5,994) ($3,307) ($5,587) ($2,892) ($2,567) ($2,312) ($398) $431 $1,071 $1,905 $2,718
EBITDA ($3,800) ($5,855) ($3,168) ($5,448) ($2,753) ($2,428) ($2,173) ($259) $570 $1,210 $2,044 $2,857
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 ($3,939) ($5,994) ($3,307) ($5,587) ($2,892) ($2,567) ($2,312) ($398) $431 $1,071 $1,905 $2,718
Net Profit/Sales 0.00% 0.00% -105.69% -161.71% -40.54% -33.11% -27.96% -3.70% 3.59% 8.26% 13.71% 18.09%
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 $0 $782 $864 $1,784 $1,938 $2,067 $2,687 $3,000 $3,240 $3,474 $3,757
Cash from Receivables $0 $0 $0 $78 $2,355 $2,683 $5,366 $5,827 $6,263 $8,092 $9,023 $9,744
Subtotal Cash from Operations $0 $0 $782 $942 $4,138 $4,621 $7,433 $8,514 $9,263 $11,333 $12,497 $13,501
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 $4,000 $0 $8,000 $0 $0
Subtotal Cash Received $0 $0 $782 $942 $4,138 $4,621 $7,433 $12,514 $9,263 $19,333 $12,497 $13,501
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,000 $3,700 $3,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700
Bill Payments $60 $1,812 $2,188 $3,170 $3,650 $4,962 $4,810 $5,058 $5,938 $6,200 $6,400 $6,278
Subtotal Spent on Operations $2,060 $5,512 $5,888 $8,870 $9,350 $10,662 $10,510 $10,758 $11,638 $11,900 $12,100 $11,978
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,060 $5,512 $5,888 $8,870 $9,350 $10,662 $10,510 $10,758 $11,638 $11,900 $12,100 $11,978
Net Cash Flow ($2,060) ($5,512) ($5,106) ($7,928) ($5,212) ($6,040) ($3,077) $1,756 ($2,376) $7,432 $396 $1,523
Cash Balance $39,540 $34,028 $28,922 $20,994 $15,782 $9,742 $6,665 $8,420 $6,045 $13,477 $13,874 $15,397
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 $41,600 $39,540 $34,028 $28,922 $20,994 $15,782 $9,742 $6,665 $8,420 $6,045 $13,477 $13,874 $15,397
Accounts Receivable $0 $0 $0 $2,347 $4,860 $7,855 $10,986 $11,821 $14,055 $16,792 $18,420 $19,817 $21,343
Inventory $0 $0 $0 $558 $960 $1,740 $2,063 $2,350 $2,972 $3,436 $3,791 $3,900 $4,250
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $41,600 $39,540 $34,028 $31,827 $26,814 $25,378 $22,790 $20,835 $25,448 $26,273 $35,688 $37,590 $40,990
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 $139 $278 $417 $556 $695 $834 $973 $1,112 $1,251 $1,390 $1,529 $1,668
Total Long-term Assets $5,000 $4,861 $4,722 $4,583 $4,444 $4,305 $4,166 $4,027 $3,888 $3,749 $3,610 $3,471 $3,332
Total Assets $46,600 $44,401 $38,750 $36,410 $31,258 $29,683 $26,956 $24,862 $29,336 $30,022 $39,298 $41,061 $44,322
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 $1,740 $2,083 $3,050 $3,485 $4,802 $4,642 $4,860 $5,732 $5,987 $6,192 $6,050 $6,593
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 $1,740 $2,083 $3,050 $3,485 $4,802 $4,642 $4,860 $5,732 $5,987 $6,192 $6,050 $6,593
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,740 $2,083 $3,050 $3,485 $4,802 $4,642 $4,860 $5,732 $5,987 $6,192 $6,050 $6,593
Paid-in Capital $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $54,000 $54,000 $62,000 $62,000 $62,000
Retained Earnings ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400) ($3,400)
Earnings $0 ($3,939) ($9,933) ($13,240) ($18,827) ($21,719) ($24,286) ($26,598) ($26,996) ($26,565) ($25,494) ($23,589) ($20,871)
Total Capital $46,600 $42,661 $36,667 $33,360 $27,773 $24,881 $22,314 $20,002 $23,604 $24,035 $33,106 $35,011 $37,729
Total Liabilities and Capital $46,600 $44,401 $38,750 $36,410 $31,258 $29,683 $26,956 $24,862 $29,336 $30,022 $39,298 $41,061 $44,322
Net Worth $46,600 $42,661 $36,667 $33,360 $27,773 $24,881 $22,314 $20,002 $23,604 $24,035 $33,106 $35,011 $37,729