Seminars

Start your own business plan »

Consulting Seminars 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
Unit Sales
Corporate Events 0% 0 1 0 2 0 0 0 0 2 2 0 0
Corporate units 0% 0 15 2 30 5 5 5 5 50 60 5 5
Standard Events 0% 0 0 1 0 2 2 2 3 3 3 2 1
Participants 0% 0 0 15 0 30 35 35 75 75 75 50 25
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 0 16 18 32 37 42 42 83 130 140 57 31
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Corporate Events $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00
Corporate units $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00
Standard Events $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Participants $495.00 $495.00 $495.00 $495.00 $495.00 $495.00 $495.00 $495.00 $495.00 $495.00 $495.00 $495.00
Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Corporate Events $0 $5,000 $0 $10,000 $0 $0 $0 $0 $10,000 $10,000 $0 $0
Corporate units $0 $1,350 $180 $2,700 $450 $450 $450 $450 $4,500 $5,400 $450 $450
Standard Events $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Participants $0 $0 $7,425 $0 $14,850 $17,325 $17,325 $37,125 $37,125 $37,125 $24,750 $12,375
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $6,350 $7,605 $12,700 $15,300 $17,775 $17,775 $37,575 $51,625 $52,525 $25,200 $12,825
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Corporate Events 0.00% $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00
Corporate units 0.00% $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00 $75.00
Standard Events 0.00% $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00
Participants 0.00% $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Corporate Events $0 $500 $0 $1,000 $0 $0 $0 $0 $1,000 $1,000 $0 $0
Corporate units $0 $1,125 $150 $2,250 $375 $375 $375 $375 $3,750 $4,500 $375 $375
Standard Events $0 $0 $2,000 $0 $4,000 $4,000 $4,000 $6,000 $6,000 $6,000 $4,000 $2,000
Participants $0 $0 $1,500 $0 $3,000 $3,500 $3,500 $7,500 $7,500 $7,500 $5,000 $2,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $1,625 $3,650 $3,250 $7,375 $7,875 $7,875 $13,875 $18,250 $19,000 $9,375 $4,875
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
Owner/founder 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Sales/marketing 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Admin Assistance 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
Contractors 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500
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% 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 $0 $6,350 $7,605 $12,700 $15,300 $17,775 $17,775 $37,575 $51,625 $52,525 $25,200 $12,825
Direct Cost of Sales $0 $1,625 $3,650 $3,250 $7,375 $7,875 $7,875 $13,875 $18,250 $19,000 $9,375 $4,875
Other Production Expenses $3,000 $500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $3,000 $2,125 $3,650 $3,250 $7,375 $7,875 $7,875 $13,875 $18,250 $19,000 $9,375 $4,875
Gross Margin ($3,000) $4,225 $3,955 $9,450 $7,925 $9,900 $9,900 $23,700 $33,375 $33,525 $15,825 $7,950
Gross Margin % 0.00% 66.54% 52.01% 74.41% 51.80% 55.70% 55.70% 63.07% 64.65% 63.83% 62.80% 61.99%
Expenses
Payroll $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500
Sales and Marketing and Other Expenses $6,000 $8,000 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Taxes 15% $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275 $1,275
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $16,975 $18,475 $13,975 $13,975 $13,975 $13,975 $13,975 $13,975 $13,975 $13,975 $13,975 $13,975
Profit Before Interest and Taxes ($19,975) ($14,250) ($10,020) ($4,525) ($6,050) ($4,075) ($4,075) $9,725 $19,400 $19,550 $1,850 ($6,025)
EBITDA ($19,975) ($14,250) ($10,020) ($4,525) ($6,050) ($4,075) ($4,075) $9,725 $19,400 $19,550 $1,850 ($6,025)
Interest Expense $247 $244 $303 $362 $359 $355 $352 $348 $345 $341 $213 $209
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($20,222) ($14,494) ($10,323) ($4,887) ($6,409) ($4,430) ($4,427) $9,377 $19,055 $19,209 $1,637 ($6,234)
Net Profit/Sales 0.00% -228.24% -135.74% -38.48% -41.89% -24.92% -24.90% 24.95% 36.91% 36.57% 6.50% -48.61%
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 $6,350 $7,605 $12,700 $15,300 $17,775 $17,775 $37,575 $51,625 $52,525 $25,200 $12,825
Subtotal Cash from Operations $0 $6,350 $7,605 $12,700 $15,300 $17,775 $17,775 $37,575 $51,625 $52,525 $25,200 $12,825
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 $7,500 $7,500 $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 $0 $6,350 $15,105 $20,200 $15,300 $17,775 $17,775 $37,575 $51,625 $52,525 $25,200 $12,825
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,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500 $8,500
Bill Payments $391 $11,742 $12,246 $9,416 $9,224 $13,225 $13,705 $13,902 $19,844 $24,095 $24,491 $14,913
Subtotal Spent on Operations $8,891 $20,242 $20,746 $17,916 $17,724 $21,725 $22,205 $22,402 $28,344 $32,595 $32,991 $23,413
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 $387 $391 $394 $397 $400 $404 $407 $411 $414 $417 $15,421 $424
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,000
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 $9,278 $20,633 $21,140 $18,314 $18,125 $22,129 $22,612 $22,812 $28,758 $33,012 $48,412 $33,837
Net Cash Flow ($9,278) ($14,283) ($6,035) $1,886 ($2,825) ($4,354) ($4,837) $14,763 $22,867 $19,513 ($23,212) ($21,012)
Cash Balance $37,922 $23,639 $17,604 $19,490 $16,665 $12,311 $7,474 $22,237 $45,103 $64,616 $41,404 $20,392
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 $47,200 $37,922 $23,639 $17,604 $19,490 $16,665 $12,311 $7,474 $22,237 $45,103 $64,616 $41,404 $20,392
Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total Current Assets $49,200 $39,922 $25,639 $19,604 $21,490 $18,665 $14,311 $9,474 $24,237 $47,103 $66,616 $43,404 $22,392
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 $49,200 $39,922 $25,639 $19,604 $21,490 $18,665 $14,311 $9,474 $24,237 $47,103 $66,616 $43,404 $22,392
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 $11,331 $11,932 $9,113 $8,784 $12,768 $13,248 $13,245 $19,042 $23,268 $23,989 $14,561 $10,207
Current Borrowing $30,000 $29,613 $29,222 $36,328 $43,431 $43,030 $42,627 $42,219 $41,809 $41,395 $40,977 $25,556 $25,132
Other Current Liabilities $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $0
Subtotal Current Liabilities $40,000 $50,944 $51,154 $55,442 $62,215 $65,799 $65,875 $65,464 $70,851 $74,662 $74,967 $50,117 $35,339
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $40,000 $50,944 $51,154 $55,442 $62,215 $65,799 $65,875 $65,464 $70,851 $74,662 $74,967 $50,117 $35,339
Paid-in Capital $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Retained Earnings ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800) ($15,800)
Earnings $0 ($20,222) ($34,715) ($45,038) ($49,925) ($56,334) ($60,764) ($65,191) ($55,814) ($36,759) ($17,550) ($15,913) ($22,148)
Total Capital $9,200 ($11,022) ($25,515) ($35,838) ($40,725) ($47,134) ($51,564) ($55,991) ($46,614) ($27,559) ($8,350) ($6,713) ($12,948)
Total Liabilities and Capital $49,200 $39,922 $25,639 $19,604 $21,490 $18,665 $14,311 $9,474 $24,237 $47,103 $66,616 $43,404 $22,392
Net Worth $9,200 ($11,022) ($25,515) ($35,838) ($40,725) ($47,134) ($51,564) ($55,991) ($46,614) ($27,559) ($8,350) ($6,713) ($12,948)