Sample Financial Model

Sample Financial Model - Draft 1 Confidential On The Cover...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Draft 1 Confidential On The Cover DRAFT Financial Model Table Of Contents 9/8/2010 21:46 Statement Statement Total Description Of Statement / Schedule Length Frequency Pages Table Of Contents 1 page Sumry 1 page Operating Statement Annual Summary 1 page 5 yr. Sumry 1 page Annual Metrics Summary 1 page 5 yr. Sumry 1 page Monthly Metrics Summary 1 page Yr 1&2 2 pages Monthly Operating Statement 1 page Yr 1&2 2 pages Annual Operating Statement 1 page Yr 1-5 1 page Monthly Revenue Detail 1 page Yr 1&2 4 pages Annual Revenue Detail 1 page Yr 1-5 2 pages Monthly Other Revenue Detail 1 page Yr 1&2 2 pages Annual Other Revenue Detail 1 page Yr 1-5 1 page Monthly Rebate Detail 1 page Yr 1&2 2 pages Annual Rebate Detail 1 page Yr 1-5 1 page Monthly Departmental Expense 2 pages Yr 1&2 4 pages Annual Departmental Expense 2 pages Yr 1-5 2 pages Monthly Salary Expense / HeadCount 2 pages Yr 1&2 6 pages Annual Salary Expense / HeadCount 2 pages Yr 1-5 3 pages Monthly Balance Sheet 1 page Yr 1&2 2 pages Annual Balance Sheet 1 page Yr 1-5 1 page Monthly Cash Flow Statement 1 page Yr 1&2 2 pages Annual Cash Flow Statement 1 page Yr 1-5 1 page Annual Funding Statement 1 page Yr 1-5 1 page Monthly Capex Schedule 2 pages Yr 1&2 4 pages Annual Capex Schedule 2 pages Yr 1-5 2 pages Depreciation & Amortization Schedule 1 page Yr 1-5 1 page Monthly Working Capital 1 page Yr 1&2 2 pages Annual Working Capital 1 page Yr 1-5 1 page Assumptions 1 page Yr 1-5 2 pages Draft Confidential XYZ Company DRAFT Summary Of Assumptions Calendar Year 9/8/10 9:46 PM 2001 2002 2003 2004 Revenues Primetime Television Primetime episodes 22 - - - Development Fee/episode 25,000 - - - Viewers - first episode (000's) 19,000 - - - Growth Rate per episode 0%- - - Syndication Syndication episodes 94 195 195 195 Syndication markets (beginning) New Syndication markets Syndication markets (end) Percentage coverage (beginning) 54% 66% 90% 90% Monthly Growth 4% 2% 0% 0% Percentage coverage (end) 66% 90% 90% 90% Development Fee/Episode 2,500 2,625 2,756 2,894 Annual Bump in Fee- 5% 5% 5% Monthly Rev./1% coverage 10,000 10,000 23,000 37,000 Internet Traffic % of Television Viewers 25% Number from advertising Number from other mktg programs Monthly Traffic (beg. - 000's) 4,750 Increase (Annual) 15% 15% 15% 15% Monthly Traffic (end) Monthly Page Views/Visitor 5 5 5 5 Advertising CPM (Interstitials) $40 $40 $40 $40 Paid advertising (% of page views) 30% 30% 30% 30% Other Advertising Percentage Rep Firm 100% 50% 50% 50% Rep Firm Fee 15% 15% 15% 15% Commerce/Affiliate Fees Average Magazine Sub. $15.50 $15.50 $15.50 $15.50 Beginning Units 5,000 Monthly Growth (Units) 45,000 160,000 Monthly Growth (%) 20% 5% Cost of Sales % - new 30% 30% 25% 25% Cost of Sales % - renew (2nd yr) 80% 70% 60% Cost of Sales % - renew (3rd yr) 90% 80% Customer Renewals (%) 0% 60% 60% 60% Average Book Purchase $15 $15 $15 $15 Beginning Units 750 Monthly Growth (Units) 1,500 1,750 2,000 2,250 Cost of Sales % 92% 92% 92% 92% Average CD/Video Purchase...
View Full Document

Page1 / 36

Sample Financial Model - Draft 1 Confidential On The Cover...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online