Safe Keeping

Start your own business plan »

Video Documentation Service 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
Video Recording Services 0% $2,200 $2,600 $3,000 $3,400 $3,800 $4,200 $4,600 $5,000 $5,400 $5,800 $6,200 $6,600
Consultation Services 0% $3,000 $3,000 $3,500 $4,000 $4,500 $5,000 $5,500 $6,000 $6,500 $7,000 $7,500 $8,000
Total Sales $5,200 $5,600 $6,500 $7,400 $8,300 $9,200 $10,100 $11,000 $11,900 $12,800 $13,700 $14,600
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
Video Recording Services $100 $130 $160 $190 $220 $250 $280 $310 $340 $370 $400 $430
Consultation Services $100 $100 $120 $140 $160 $180 $200 $220 $240 $260 $280 $300
Subtotal Direct Cost of Sales $200 $230 $280 $330 $380 $430 $480 $530 $580 $630 $680 $730
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
John Walter 0% $2,500 $2,500 $3,000 $3,000 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Joe Norten, full time employee 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
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll $4,500 $4,500 $5,000 $5,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,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 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Long-term Interest Rate 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50% 7.50%
Tax Rate 30.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.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 $5,200 $5,600 $6,500 $7,400 $8,300 $9,200 $10,100 $11,000 $11,900 $12,800 $13,700 $14,600
Direct Cost of Sales $200 $230 $280 $330 $380 $430 $480 $530 $580 $630 $680 $730
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $200 $230 $280 $330 $380 $430 $480 $530 $580 $630 $680 $730
Gross Margin $5,000 $5,370 $6,220 $7,070 $7,920 $8,770 $9,620 $10,470 $11,320 $12,170 $13,020 $13,870
Gross Margin % 96.15% 95.89% 95.69% 95.54% 95.42% 95.33% 95.25% 95.18% 95.13% 95.08% 95.04% 95.00%
Expenses
Payroll $4,500 $4,500 $5,000 $5,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $675 $675 $750 $750 $750 $900 $900 $900 $900 $900 $900 $900
Other $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Total Operating Expenses $6,375 $6,375 $6,950 $6,950 $6,950 $8,100 $8,100 $8,100 $8,100 $8,100 $8,100 $8,100
Profit Before Interest and Taxes ($1,375) ($1,005) ($730) $120 $970 $670 $1,520 $2,370 $3,220 $4,070 $4,920 $5,770
EBITDA ($1,375) ($1,005) ($730) $120 $970 $670 $1,520 $2,370 $3,220 $4,070 $4,920 $5,770
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($413) ($281) ($204) $34 $272 $188 $426 $664 $902 $1,140 $1,378 $1,616
Net Profit ($963) ($724) ($526) $86 $698 $482 $1,094 $1,706 $2,318 $2,930 $3,542 $4,154
Net Profit/Sales -18.51% -12.92% -8.09% 1.17% 8.41% 5.24% 10.84% 15.51% 19.48% 22.89% 25.86% 28.45%
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 $5,200 $5,600 $6,500 $7,400 $8,300 $9,200 $10,100 $11,000 $11,900 $12,800 $13,700 $14,600
Subtotal Cash from Operations $5,200 $5,600 $6,500 $7,400 $8,300 $9,200 $10,100 $11,000 $11,900 $12,800 $13,700 $14,600
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 $0
Subtotal Cash Received $5,200 $5,600 $6,500 $7,400 $8,300 $9,200 $10,100 $11,000 $11,900 $12,800 $13,700 $14,600
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,500 $4,500 $5,000 $5,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Bill Payments $55 $1,668 $1,830 $2,035 $2,323 $2,605 $2,727 $3,015 $3,303 $3,591 $3,879 $4,167
Subtotal Spent on Operations $4,555 $6,168 $6,830 $7,035 $7,323 $8,605 $8,727 $9,015 $9,303 $9,591 $9,879 $10,167
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 $4,555 $6,168 $6,830 $7,035 $7,323 $8,605 $8,727 $9,015 $9,303 $9,591 $9,879 $10,167
Net Cash Flow $645 ($568) ($330) $365 $977 $595 $1,373 $1,985 $2,597 $3,209 $3,821 $4,433
Cash Balance $21,645 $21,077 $20,746 $21,111 $22,088 $22,683 $24,055 $26,040 $28,637 $31,846 $35,667 $40,099
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 $21,000 $21,645 $21,077 $20,746 $21,111 $22,088 $22,683 $24,055 $26,040 $28,637 $31,846 $35,667 $40,099
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $21,000 $21,645 $21,077 $20,746 $21,111 $22,088 $22,683 $24,055 $26,040 $28,637 $31,846 $35,667 $40,099
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 $21,000 $21,645 $21,077 $20,746 $21,111 $22,088 $22,683 $24,055 $26,040 $28,637 $31,846 $35,667 $40,099
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,607 $1,763 $1,958 $2,236 $2,515 $2,627 $2,905 $3,184 $3,462 $3,741 $4,019 $4,297
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,607 $1,763 $1,958 $2,236 $2,515 $2,627 $2,905 $3,184 $3,462 $3,741 $4,019 $4,297
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,607 $1,763 $1,958 $2,236 $2,515 $2,627 $2,905 $3,184 $3,462 $3,741 $4,019 $4,297
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 ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000) ($4,000)
Earnings $0 ($963) ($1,686) ($2,212) ($2,125) ($1,427) ($944) $150 $1,856 $4,175 $7,105 $10,648 $14,802
Total Capital $21,000 $20,038 $19,314 $18,788 $18,875 $19,573 $20,056 $21,150 $22,856 $25,175 $28,105 $31,648 $35,802
Total Liabilities and Capital $21,000 $21,645 $21,077 $20,746 $21,111 $22,088 $22,683 $24,055 $26,040 $28,637 $31,846 $35,667 $40,099
Net Worth $21,000 $20,038 $19,314 $18,788 $18,875 $19,573 $20,055 $21,150 $22,856 $25,175 $28,105 $31,648 $35,802