Evergreen TV Productions video television production business plan appendix. Evergreen TV Productions produces digital video scrapbooks from photographs, travelogues for cities and special interest clients, and video resumes for college communications degree students.

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
Evergreen TV Productions video television production business plan appendix. Evergreen TV Productions produces digital video scrapbooks from photographs, travelogues for cities and special interest clients, and video resumes for college communications degree students.