Evergreen TV Productions

Start your own business plan »

Video Television Production 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
Photo Memories 0% 15 20 40 50 60 60 70 80 95 90 100 120
News Story Reels 0% 0 0 0 0 0 0 4 10 16 25 40 65
Tampa Bay Video 0% 0 0 0 2 3 5 12 2 2 18 2 2
Other Projects 0% 1 0 1 0 1 0 1 0 1 0 1 0
Total Unit Sales 16 20 41 52 64 65 87 92 114 133 143 187
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
Photo Memories $200.00 $200.00 $200.00 $200.00 $250.00 $250.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00
News Story Reels $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00
Tampa Bay Video $0.00 $0.00 $0.00 $0.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Other Projects $1,000.00 $0.00 $1,000.00 $0.00 $1,000.00 $0.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
Sales
Photo Memories $3,000 $4,000 $8,000 $10,000 $15,000 $15,000 $14,000 $16,000 $19,000 $18,000 $20,000 $24,000
News Story Reels $0 $0 $0 $0 $0 $0 $800 $2,000 $3,200 $5,000 $8,000 $13,000
Tampa Bay Video $0 $0 $0 $0 $150 $250 $600 $100 $100 $900 $100 $100
Other Projects $1,000 $0 $1,000 $0 $1,000 $0 $1,000 $0 $1,000 $0 $1,000 $0
Total Sales $4,000 $4,000 $9,000 $10,000 $16,150 $15,250 $16,400 $18,100 $23,300 $23,900 $29,100 $37,100
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
Photo Memories 0.00% $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00
News Story Reels 0.00% $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00
Tampa Bay Video 0.00% $0.00 $0.00 $0.00 $0.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00
Other Projects 0.00% $75.00 $0.00 $50.00 $0.00 $500.00 $0.00 $500.00 $0.00 $500.00 $0.00 $500.00 $0.00
Direct Cost of Sales
Photo Memories $45 $60 $120 $150 $180 $180 $210 $240 $285 $270 $300 $360
News Story Reels $0 $0 $0 $0 $0 $0 $60 $150 $240 $375 $600 $975
Tampa Bay Video $0 $0 $0 $0 $15 $25 $60 $10 $10 $90 $10 $10
Other Projects $75 $0 $50 $0 $500 $0 $500 $0 $500 $0 $500 $0
Subtotal Direct Cost of Sales $120 $60 $170 $150 $695 $205 $830 $400 $1,035 $735 $1,410 $1,345
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
Production Personnel
Photo Editor $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Photo Editor $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Photo Editor $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500
Photo Editor (2) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500
Additional Employees (3 stores) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Additional Employees (5 stores) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $1,500 $3,000 $3,000 $3,000 $3,000 $4,500 $4,500 $4,500 $6,000
Sales and Marketing Personnel
Marketing Manager (President) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
News Sales Representative $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,666 $1,666 $1,666
News Sales Representative Commission $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $1,000 $1,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,166 $2,666 $3,166
General and Administrative Personnel
Store Manager $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Store Manager Commission $0 $300 $300 $400 $400 $400 $400 $400 $400 $400 $400 $400
Store Manager (2) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,600 $1,600
Store Manager Commission (2) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $400 $400
Store Mgr/Commission (3 & 5 stores) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $1,900 $1,900 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $4,000 $4,000
Other Personnel
President $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $3,500 $3,500 $3,500 $4,000 $4,000 $4,000
Operations Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Home Division Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
B2B Division Manager $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 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $3,500 $3,500 $3,500 $4,000 $4,000 $4,000
Total People 1 2 2 3 4 4 4 4 5 6 6 8
Total Payroll $2,500 $4,400 $4,400 $6,000 $7,500 $7,500 $8,500 $8,500 $10,000 $12,666 $15,166 $17,166
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 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00%
Long-term Interest Rate 0.80% 0.80% 0.80% 0.80% 0.80% 0.80% 0.80% 0.80% 0.80% 0.80% 0.80% 0.80%
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 $4,000 $4,000 $9,000 $10,000 $16,150 $15,250 $16,400 $18,100 $23,300 $23,900 $29,100 $37,100
Direct Cost of Sales $120 $60 $170 $150 $695 $205 $830 $400 $1,035 $735 $1,410 $1,345
Production Payroll $0 $0 $0 $1,500 $3,000 $3,000 $3,000 $3,000 $4,500 $4,500 $4,500 $6,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $120 $60 $170 $1,650 $3,695 $3,205 $3,830 $3,400 $5,535 $5,235 $5,910 $7,345
Gross Margin $3,880 $3,940 $8,830 $8,350 $12,455 $12,045 $12,570 $14,700 $17,765 $18,665 $23,190 $29,755
Gross Margin % 97.00% 98.50% 98.11% 83.50% 77.12% 78.98% 76.65% 81.22% 76.24% 78.10% 79.69% 80.20%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,166 $2,666 $3,166
Advertising/Promotion $2,000 $1,500 $1,500 $2,000 $2,000 $2,000 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Travel $0 $0 $0 $0 $0 $750 $750 $750 $750 $1,500 $1,000 $1,000
Miscellaneous $500 $500 $500 $500 $500 $500 $1,000 $1,000 $1,000 $1,000 $1,000 $1,500
Total Sales and Marketing Expenses $2,500 $2,000 $2,000 $2,500 $2,500 $3,250 $3,250 $3,250 $3,250 $6,166 $6,166 $7,166
Sales and Marketing % 62.50% 50.00% 22.22% 25.00% 15.48% 21.31% 19.82% 17.96% 13.95% 25.80% 21.19% 19.32%
General and Administrative Expenses
General and Administrative Payroll $0 $1,900 $1,900 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $4,000 $4,000
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $160
Insurance $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $160
Rent $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $1,500
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $930 $2,830 $2,830 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $2,930 $4,930 $5,820
General and Administrative % 23.25% 70.75% 31.44% 29.30% 18.14% 19.21% 17.87% 16.19% 12.58% 12.26% 16.94% 15.69%
Other Expenses:
Other Payroll $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $3,500 $3,500 $3,500 $4,000 $4,000 $4,000
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $3,500 $3,500 $3,500 $4,000 $4,000 $4,000
Other % 62.50% 62.50% 27.78% 25.00% 15.48% 16.39% 21.34% 19.34% 15.02% 16.74% 13.75% 10.78%
Total Operating Expenses $5,930 $7,330 $7,330 $7,930 $7,930 $8,680 $9,680 $9,680 $9,680 $13,096 $15,096 $16,986
Profit Before Interest and Taxes ($2,050) ($3,390) $1,500 $420 $4,525 $3,365 $2,890 $5,020 $8,085 $5,569 $8,094 $12,769
EBITDA ($2,050) ($3,390) $1,500 $420 $4,525 $3,365 $2,890 $5,020 $8,085 $5,569 $8,094 $12,769
Interest Expense $54 $44 $42 $40 $38 $36 $34 $32 $30 $28 $26 $24
Taxes Incurred ($631) ($858) $365 $95 $1,122 $832 $714 $1,247 $2,014 $1,385 $2,017 $3,186
Net Profit ($1,473) ($2,575) $1,094 $285 $3,366 $2,497 $2,142 $3,741 $6,042 $4,156 $6,051 $9,559
Net Profit/Sales -36.82% -64.38% 12.15% 2.85% 20.84% 16.37% 13.06% 20.67% 25.93% 17.39% 20.80% 25.77%
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 $4,000 $4,000 $9,000 $10,000 $16,150 $15,250 $16,400 $18,100 $23,300 $23,900 $29,100 $37,100
Subtotal Cash from Operations $4,000 $4,000 $9,000 $10,000 $16,150 $15,250 $16,400 $18,100 $23,300 $23,900 $29,100 $37,100
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 $5,000 $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 $9,000 $4,000 $9,000 $10,000 $16,150 $15,250 $16,400 $18,100 $23,300 $23,900 $29,100 $37,100
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,400 $4,400 $6,000 $7,500 $7,500 $8,500 $8,500 $10,000 $12,666 $15,166 $17,166
Bill Payments $528 $3,795 $2,156 $3,344 $3,632 $5,571 $5,082 $6,050 $5,539 $7,866 $7,366 $8,106
Subtotal Spent on Operations $3,028 $8,195 $6,556 $9,344 $11,132 $13,071 $13,582 $14,550 $15,539 $20,532 $22,532 $25,272
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 $980 $185 $185 $185 $185 $185 $185 $185 $185 $185 $185
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 $3,028 $9,175 $6,741 $9,529 $11,317 $13,256 $13,767 $14,735 $15,724 $20,717 $22,717 $25,457
Net Cash Flow $5,972 ($5,175) $2,259 $471 $4,833 $1,994 $2,633 $3,365 $7,576 $3,183 $6,383 $11,643
Cash Balance $20,072 $14,897 $17,156 $17,627 $22,460 $24,453 $27,086 $30,451 $38,027 $41,210 $47,593 $59,236
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 $14,100 $20,072 $14,897 $17,156 $17,627 $22,460 $24,453 $27,086 $30,451 $38,027 $41,210 $47,593 $59,236
Inventory $0 $880 $820 $650 $500 $805 $600 $913 $513 $1,139 $1,404 $1,551 $1,480
Other Current Assets $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Current Assets $14,600 $21,452 $16,217 $18,306 $18,627 $23,765 $25,553 $28,499 $31,464 $39,665 $43,113 $49,644 $61,216
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 $14,600 $21,452 $16,217 $18,306 $18,627 $23,765 $25,553 $28,499 $31,464 $39,665 $43,113 $49,644 $61,216
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 $400 $3,724 $2,045 $3,225 $3,446 $5,403 $4,880 $5,868 $5,277 $7,621 $7,098 $7,762 $9,960
Current Borrowing $0 $5,000 $4,020 $3,835 $3,650 $3,465 $3,280 $3,095 $2,910 $2,725 $2,540 $2,355 $2,170
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $400 $8,724 $6,065 $7,060 $7,096 $8,868 $8,160 $8,963 $8,187 $10,346 $9,638 $10,117 $12,130
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $400 $8,724 $6,065 $7,060 $7,096 $8,868 $8,160 $8,963 $8,187 $10,346 $9,638 $10,117 $12,130
Paid-in Capital $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Retained Earnings ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800) ($800)
Earnings $0 ($1,473) ($4,048) ($2,954) ($2,669) $697 $3,194 $5,336 $9,078 $15,119 $19,275 $25,327 $34,886
Total Capital $14,200 $12,727 $10,152 $11,246 $11,531 $14,897 $17,394 $19,536 $23,278 $29,319 $33,475 $39,527 $49,086
Total Liabilities and Capital $14,600 $21,452 $16,217 $18,306 $18,627 $23,765 $25,553 $28,499 $31,464 $39,665 $43,113 $49,644 $61,216
Net Worth $14,200 $12,727 $10,152 $11,246 $11,531 $14,897 $17,394 $19,536 $23,278 $29,319 $33,475 $39,527 $49,086