Executive
Finance
Dashboard

Strategic Finance Portfolio Project

FY Sample Data  |  FP&A Portfolio Project  |  Melina Gaudio

Executive SummaryP&L Detail Scenario PlanningMarket Benchmark Management Actions

Executive Finance Dashboard

Strategic Finance · Melina Gaudio

YTD October 2024

Executive Summary

YTD October 2024 · 10 months consolidated · Company X

Total Revenue
EBITDA Margin
Free Cash Flow
Subscriber Growth
12-Month Revenue Trend
Actual vs Budget — monthly ($M)

Key Insights

EBITDA Bridge vs Budget
Key variance drivers ($M)
Revenue by Segment
Full year mix · % of total
Cash Flow Waterfall
EBITDA → FCF ($M)
AI Assistant — Executive Summary
I can help you interpret the Executive Summary — KPIs, revenue trend, EBITDA bridge, and key insights. What would you like to explore?
Why is EBITDA below budget? What's driving revenue outperformance? How is FCF tracking vs forecast?

P&L Detail

YTD October 2024 · Click rows to expand

Monthly
YTD
Full Year
Line ItemActualBudgetVar $Var %Prior Year
AI Assistant — P&L Detail
I can help you read the P&L table — actuals vs budget, key variance drivers, and line-item analysis. What would you like to know?
What's the biggest cost overrun? How is gross margin trending? Explain the Field Services variance

Scenario Planning

Full-year projections under three macro environments · Company X · FY 2024

Downside
Macro Stress
Revenue$198M
EBITDA Margin17.2%
EBITDA ($)$34.1M
Free Cash Flow$12M
Subscriber Growth+1.1%
Monthly Churn2.9%
vs Base Case−$20M Rev
Base Case
Steady State
Revenue$218M
EBITDA Margin21.4%
EBITDA ($)$46.7M
Free Cash Flow$22M
Subscriber Growth+3.5%
Monthly Churn1.8%
vs Budget−$2M FCF
Upside
Growth Acceleration
Revenue$241M
EBITDA Margin25.8%
EBITDA ($)$62.2M
Free Cash Flow$34M
Subscriber Growth+6.2%
Monthly Churn1.2%
vs Base Case+$23M Rev
Revenue by Scenario ($M)
Downside / Base / Upside vs Budget and Prior Year
EBITDA Margin by Scenario (%)
Full year projection vs Budget and Prior Year
P&L LineDownsideBase CaseUpsideBudgetPrior Year
Revenue$198M$218M$241M$220M$200M
Cost of Revenue($86M)($95M)($104M)($94M)($86M)
Gross Profit$112M$123M$137M$126M$114M
Gross Margin %56.6%56.4%56.8%57.3%57.0%
Operating Expenses($78M)($76M)($75M)($76M)($68M)
EBITDA$34.1M$46.7M$62.2M$50M$46M
EBITDA Margin %17.2%21.4%25.8%22.7%23.0%
Capex($10M)($13M)($14M)($14M)($12M)
Free Cash Flow$12M$22M$34M$24M$21M
AI Assistant — Scenario Planning
I can help you interpret the three scenarios (Downside / Base / Upside) and their financial implications. What would you like to explore?
What's the revenue gap between downside and upside? How does Base Case compare to Budget? What drives the EBITDA margin difference?

Market Benchmark

Company X vs peer group · Most recent fiscal year · Company X highlighted in blue

EBITDA Margin — Ranked (%)
Company X vs peers · horizontal bar
Revenue Growth vs Peers (%)
Year-over-year growth
Monthly Churn Rate (%)
Lower is better · Company X in blue
Capex / Sales (%)
Capital intensity · lower indicates efficiency
CompanyEBITDA MarginRevenue GrowthChurn RateCapex/SalesFCF YieldPosition
Company X (You)21.4%+8.0%1.8%9.2%8.1%In Range
Peer Alpha27.9%+4.2%1.5%7.8%11.4%Leader
Peer Beta24.1%+11.3%2.1%10.4%7.9%Above Avg
Peer Gamma19.8%+6.1%2.4%11.2%6.2%Below Avg
Peer Delta16.2%+2.8%3.1%13.6%4.8%Laggard
Peer Average21.8%+6.1%2.2%10.8%7.6%
AI Assistant — Market Benchmark
I can help you compare Company X against its peer group across EBITDA margin, revenue growth, churn rate, and capital intensity. What would you like to analyse?
Where does Company X rank vs peers? Is our churn rate competitive? What's our biggest competitive gap?

Management Actions

Executive recommendations ranked by strategic impact and urgency · FY 2024

🎯
Priority 1 · Immediate · 0–60 days
Restructure Field Services Cost Base
Field Services is the single largest EBITDA variance driver — $4.7M over budget YTD. Route optimisation, first-call resolution targets, and selective outsourcing of low-complexity installations deliver 15–20% cost reduction within 90 days with no revenue impact.
📉 EBITDA impact: +$0.8–1.0M / year
Priority 2 · 60 Days
Accelerate Enterprise Tier Migration
Enterprise carries 34% higher ARPU than SMB and grows at +18% YoY. Current funnel converts only 12% of eligible accounts. A dedicated onboarding team and restructured sales incentives can raise conversion to 20%, adding $6–9M incremental ARR over 12 months.
📈 Revenue impact: +$6–9M ARR
🔄
Priority 3 · 90 Days
Deploy ML-Driven Churn Prediction
Churn of 1.8%/month still exceeds benchmark peers (1.4%). An ML early-warning system flags at-risk accounts 45 days ahead of churn using usage signals. Proactive outreach projected to retain 30–40% of flagged accounts, protecting $4–6M ARR annually.
🛡 Revenue protection: $4–6M ARR
💡
Priority 4 · Strategic
Shift Content Rights to Revenue Share
Sports rights renew at +15% YoY with sub-1% contribution margin. Renegotiating to revenue-share structures — bundled with advertising inventory — reduces net cost exposure by $2–3M annually while maintaining subscriber retention value of premium content.
💰 Cost savings: $2–3M / year
AI Assistant — Management Actions
I can help you assess the strategic priorities — their financial impact, implementation timelines, and trade-offs. What would you like to explore?
Which action has the highest ROI? Why is Field Services the top priority? How does the churn ML model work?