ITI Financial Modeling

Instructions

Build financial models for B2B media consulting engagements that quantify strategic recommendations, project returns, test assumptions, and provide clients with defensible investment justification.

Revenue Projection Framework

Project revenue by stream with explicit assumptions:

Advertising revenue model:

• Impressions = traffic × pages/session × ads/page × sell-through rate
• Revenue = impressions × eCPM / 1,000
• Key drivers: traffic growth, sell-through optimization, CPM trends, programmatic vs. direct mix

Subscription revenue model:

• Revenue = subscribers × ARPU × (1 – churn rate)
• New subscribers = traffic × conversion funnel rates
• Key drivers: conversion rate, pricing, churn rate, upsell to premium tiers

Events revenue model:

• Attendee revenue = registrations × average ticket price × attendance rate
• Sponsor revenue = sponsors × average sponsorship value
• Key drivers: registration growth, sponsor acquisition, ticket pricing, virtual vs. in-person mix

Lead generation / data revenue:

• Revenue = leads delivered × cost per lead
• Key drivers: audience quality, advertiser demand, lead qualification criteria

For each stream, document assumptions with sources (historical data, industry benchmarks, or management estimates) and flag assumption confidence levels (high/medium/low).

ROI and NPV Analysis

Calculate return on investment for strategic initiatives:

Metric	Formula	Use
Simple ROI	(Net benefit – Investment) / Investment	Quick screening
Payback period	Investment / Annual net benefit	Cash flow timing
NPV	Σ [Cash flow / (1 + r)^t] – Initial investment	Multi-year comparison
IRR	Rate where NPV = 0	Hurdle rate comparison

Discount rate guidance for B2B media:

• Use 10-15% for established companies with stable cash flows
• Use 15-20% for growth-stage or transformation scenarios
• Use 20-25% for high-risk new revenue stream launches

Include both quantitative returns (revenue, cost savings) and qualitative benefits (strategic positioning, risk reduction, capability building) in the business case.

Three-Scenario Modeling

Build three scenarios for every major projection:

Scenario	Assumption Basis	Purpose
Conservative	75th percentile downside — assume slower adoption, higher costs, longer timelines	Floor for investment justification
Base	Most likely outcome — blended historical data and management expectations	Primary planning scenario
Optimistic	25th percentile upside — assume favorable market conditions and strong execution	Ceiling for resource planning

Scenario construction rules:

• Conservative is not worst case — it’s a realistic downside that would still justify the investment
• Base case should be defensible with existing data, not aspirational
• Optimistic should be achievable with strong execution, not a fantasy
• All three scenarios must use the same model structure; only assumptions change

Sensitivity Analysis

Test the model against key variable changes:

Standard sensitivity variables for B2B media:

1. Traffic growth rate (±20% from base)
2. Conversion rate (±30% from base)
3. Churn rate (±25% from base)
4. Average revenue per user/customer (±15% from base)
5. Implementation timeline (±3 months from base)
6. Cost escalation (±10% from base)

Build a tornado chart showing which variables have the greatest impact on NPV. Focus client attention on managing the top 2-3 sensitivity drivers.

Break-even analysis: Identify the minimum performance threshold on key variables where the initiative still returns positive NPV. If break-even requires top-quartile performance, flag the initiative as high risk.

Business Case Structure

Present financial analysis in client-ready format:

1. Investment summary — total investment, phased spending, funding source
2. Return projection — 3-year revenue/savings projection with three scenarios
3. Key assumptions — documented with confidence levels and sources
4. Sensitivity analysis — tornado chart and break-even thresholds
5. Risk-adjusted recommendation — which scenario to plan for and why
6. Decision framework — what needs to be true for this investment to succeed

Cost Categories

Ensure completeness in cost estimation:

Category	Components
Technology	Licensing, implementation, integration, migration, ongoing maintenance
People	New hires, training, contractor/freelance, reallocation of existing staff
Content	Production, rights/licensing, freelance contributors
Marketing	Audience acquisition, launch promotion, ongoing demand generation
External support	Consulting, agency, specialist vendors
Opportunity cost	Revenue deferred from existing priorities, team distraction

Always include opportunity cost — it is the most commonly omitted category and the most important for prioritization decisions.

Examples

• Subscription launch business case: model 3-year projection showing $2.1M cumulative revenue (base case) against $450K investment. NPV of $1.2M at 12% discount rate. Sensitivity shows churn rate is the dominant variable — a 2% increase in monthly churn reduces NPV by 40%.
• Technology migration ROI: model shows $180K annual savings from platform consolidation against $350K migration cost. Payback period of 23 months. Conservative scenario (implementation delays + cost overruns) still achieves payback within 30 months.
• Advisory engagement justification: demonstrate that a $120K annual advisory investment needs to drive only $400K in incremental revenue (3.3× return) to match the client’s hurdle rate — then show three scenarios projecting $600K-$1.2M in identified opportunities.