Ad Revenue Calculator | | | | | | Current | 2007 Base | Scenario 1 | Scenario 2 | Scenario 3 | TV HH | 110,000,000 | 110,000,000 | 110,000,000 | 110,000,000 | 110,000,000 | Average Rating | 1.00% | 1.00% | 1.20% | 0.80% | 1.20% | Average Viewers (thousand) | 1,100 | 1,100 | 1,320 | 880 | 1,320 | Average CPM | $2.00 | $1.80 | $1.80 | $3.50 | $2.50 | Average Revenue/ Ad Minute | $2,200 | $1,980 | $2,376 | $3,080 | $3,300 | Ad minutes/Week | 2,016 | 2,016 | 2,016 | 2,016 | 2,016 | Week/ Year | 52 | 52 | 52 | 52 | 52 | Ad Revenue/ Year | $230,630,400 | $207,567,360 | $249,080,832 | $322,882,560 | $345,945,600 | Incremental Programming Expense | | | | $15,000,000 | $20,000,000 |
Average Viewers = TV HH * Average Rating / 1000
Average Revenue/ Ad Minute = Average Viewers * Average CPM
Ad Revenue/ Year = Average Revenue * Ad minutes in Week * 52
TFC Estimated Financials for 2006 and 2007 | | 2006 Actual | 2007 Base | Scenario 1 | Scenario 2 | Scenario 3 | Revenue | | | | | | Ad Sales | $230,630,400 | $207,567,360 | $249,080,832 | $322,882,560 | $345,945,600 | Affiliate Fees | $80,000,000 | $81,600,000 | $81,600,000 | $81,600,000 | $81,600,000 | Total Revenue | $310,630,400 | $289,167,360 | $330,680,832 | $404,482,560 | $427,545,600 | | | | | | | Expenses | | | | | | Cost of Operation | $70,000,000 | $72,100,000 | $72,100,000 | $72,100,000 | $72,100,000 | Cost of Programming | $55,000,000 | $55,000,000 | $55,000,000 | $70,000,000 | $75,000,000 | Ad Sales Commissions | $6,918,912 | $6,227,021 | $7,472,425 | $9,686,477 | $10,378,368 | Marketing & Advertising | $45,000,000 | $60,000,000 | $60,000,000 | $60,000,000 | $60,000,000 |