Charts and Visualization

A spreadsheet full of numbers tells a story, but only to people who read spreadsheets for a living. A chart distills that story into a visual that investors, board members, or colleagues understand in seconds. This article covers the charts and visualizations that belong in a professional valuation model: revenue and margin trends, free cash flow waterfall, sensitivity heatmaps, and valuation waterfall. Each chart answers a specific question and supports the narrative of your valuation.

Quick definition: Valuation visualization refers to charts and graphs that display the outputs, assumptions, and drivers of a valuation model, making the analysis accessible to decision-makers who may not read the underlying spreadsheet.

Key takeaways

• Revenue and margin projections chart shows the company's top-line growth and profitability trajectory, answering "Does the company grow as expected and reach acceptable margins?"
• Free cash flow chart visualizes the cash generation path and terminal value assumption, answering "How much cash can we extract?"
• Sensitivity heatmap displays intrinsic value across ranges of two key assumptions, answering "How sensitive is the valuation to changes in my key bets?"
• Valuation waterfall breaks down intrinsic value into components (DCF value, implied multiples, safety margin), answering "Where does value come from?"
• Bridge from historical to projected shows the pivot from actual results to forecasts, answering "Is the growth assumption a reasonable extrapolation?"

Revenue and Margin Trends

This is the most fundamental chart. It shows historical revenue, projected revenue, historical margins, and projected margins on one visualization.

Structure:

• X-axis: Years (e.g., 2020, 2021, 2022, 2023, 2024P, 2025P, 2026P—where "P" = projected).
• Y-axis (left): Revenue in millions of dollars. Plot as a line or column.
• Y-axis (right): Margin as a percentage. Plot as a line.

Example chart:

• Revenue line: 2020 = $100M, 2021 = $110M, 2022 = $121M (historical). Then projects: 2023 = $140M, 2024 = $161M, 2025 = $185M (projections).
• Margin line: 2020 = 10% (historical), 2022 = 10% (historical), 2023 = 12% (projected, showing operating leverage), 2024 = 13%, 2025 = 14%.

What it answers: Is revenue growth reasonable? Are margins improving plausibly? Viewers see at a glance whether the company's future matches its past and whether the assumptions are aggressive or conservative.

Common variant: Show historical in one color (solid black) and projected in another (dashed gray or light blue), so viewers clearly see where history ends and forecasting begins.

Free Cash Flow Waterfall

This chart breaks down intrinsic value into components: the PV of 5-year FCF, the PV of terminal value, and the total intrinsic value per share.

Structure:

• Start with Year 1 FCF (e.g., $10M).
• Stack Year 2 FCF, Year 3 FCF, etc., in a waterfall format, showing cumulative value.
• Add a large block for terminal value (e.g., $500M PV).
• Sum all to show total intrinsic equity value, then divide by shares outstanding to get per-share value.

Example:

• Year 1 FCF contribution: $8M (PV)
• Year 2: $8.5M
• Year 3: $9M
• Year 4: $10M
• Year 5: $11M
• Terminal value: $400M
• Total enterprise value: $446.5M
• Less debt: $100M
• Equity value: $346.5M
• Shares outstanding: 50M
• Intrinsic value per share: $6.93

This visualization makes it obvious that terminal value dominates (90%+ of value). If terminal value accounts for 70%+ of intrinsic value—which is common—stakeholders see that the valuation is driven by long-term assumptions, not near-term projections. This prompts healthy skepticism about terminal growth and discount rate assumptions.

Sensitivity Heatmap (Two-Variable Table)

This is a color-coded table showing intrinsic value across a grid of two assumptions. It's the most insightful chart for understanding what drives value.

Example: WACC vs. Terminal Growth

WACC \ Terminal Growth	2.0%	2.5%	3.0%	3.5%	4.0%
7.0%	$142	$171	$215	$280	$390
7.5%	$115	$135	$164	$207	$275
8.0%	$95	$108	$128	$154	$193
8.5%	$79	$89	$103	$121	$147
9.0%	$67	$74	$84	$97	$115
9.5%	$58	$64	$72	$81	$93

Color the cells: green for high valuations, red for low, neutral gray for the midpoint. This makes it visual: if WACC rises from 8% to 9%, valuation drops from $128 to $84 (assuming 3% terminal growth)—a 34% decline. Conversely, terminal growth is a major lever: at 8% WACC, changing terminal growth from 2% to 4% swings valuation from $95 to $193.

What it answers: How sensitive is the valuation to my key assumptions? If the valuation ranges from $40 to $300 across plausible scenarios, it's highly uncertain. If it ranges from $90 to $110, it's robust. The chart reveals which assumptions matter most and where to focus your due diligence.

Tip: Highlight the cell corresponding to your "base case" assumptions (e.g., 8% WACC, 3% terminal growth) so reviewers see where you stand within the range.

Valuation Bridge

This waterfall chart breaks down intrinsic value by component, showing the path from free cash flow to intrinsic value per share.

Structure:

• Start with Year 1 FCF (actual figure, in millions).
• Add Year 2, 3, 4, 5 FCF (bars stacked upward).
• Add terminal value (a large bar).
• Show total enterprise value.
• Subtract net debt (a downward bar).
• Show equity value.
• Divide by shares to show per-share intrinsic value.

Example:

FCF 2024: +$50M
FCF 2025: +$60M
FCF 2026: +$70M
FCF 2027: +$80M
FCF 2028: +$90M
Terminal Value: +$800M
= Enterprise Value: $1,150M
Less: Net Debt: -$200M
= Equity Value: $950M
÷ Shares Outstanding: 100M
= Intrinsic Value per Share: $9.50

This visual makes it clear how the valuation is built. It also highlights the magnitude of each component: if terminal value is a huge bar and near-term FCF is tiny, that drives skepticism about the model (is it too focused on distant cash flows?).

Historical-to-Projected Bridge

Show the transition from historical actuals to projections with a focus on growth and margin assumptions.

Example:

• 2022 Revenue (actual): $100M
• 2023 Revenue (actual): $110M (10% growth)
• 2024 Revenue (projected): $127M (15% growth assumed)
• 2025 Revenue (projected): $146M (15% growth assumed)
• 2026 Revenue (projected): $168M (15% growth assumed)

The chart clearly shows: historical growth was 10%, but projections assume 15%. Is that reasonable? The chart forces the question and makes the assumption explicit.

Optionally, add a line showing management guidance or analyst consensus. If your 15% growth assumption exceeds guidance, you're being aggressive—and the chart makes that clear.

Mix and Segment Breakdown

For companies with multiple business segments or product lines, visualize how each contributes to revenue and profit.

Example:

• Core Business: 60% of revenue, 70% of operating income (high margin).
• New Products: 30% of revenue, 20% of operating income (lower margin, but growing faster).
• Licensing: 10% of revenue, 10% of operating income (stable).

A stacked bar chart or pie chart shows the mix and, over time, how it evolves in your projections. This helps stakeholders understand where growth and profitability come from and whether you're relying too heavily on one segment.

Operating Leverage Visualization

Show the company's operating leverage by charting revenue growth vs. operating income growth.

Example:

• Year 1: Revenue $100M, Operating Income $10M (10% margin).
• Year 2: Revenue $115M (+15%), Operating Income $13.8M (+38%).
• Year 3: Revenue $132M (+15%), Operating Income $18.5M (+34%).

Plot both lines; they should diverge if operating leverage is present (operating income grows faster than revenue). This visualization makes it clear that the company's profitability is accelerating, which justifies margin expansion assumptions.

Cash Flow Composition

Break down free cash flow into components: operating cash flow, capital expenditures, and working capital changes.

Structure:

• Operating cash flow: large positive bar.
• CapEx: downward bar.
• Change in working capital: positive or negative bar.
• = Free cash flow: net bar.

This shows whether free cash flow is driven by strong operating performance (good) or by declining CapEx (potentially unsustainable) or by working capital release (one-time benefit). It reveals the quality of cash flow.

Flowchart

Real-world examples

Example 1: SaaS company pitch. You're raising Series B funding. Your deck includes a revenue chart showing historical growth (50% YoY) and projected growth (40% declining to 20% by Year 5). Alongside, a sensitivity heatmap shows how valuation changes with churn rate and magic number assumptions. Investors see at a glance that the company is decelerating (realistic), and they understand which operational metrics matter most for value creation.

Example 2: Turnaround analysis. You're analyzing a distressed retailer. Your revenue chart shows sales declining 20% annually, but your margin chart shows improving operating margins (due to store closures and overhead reduction). The valuation bridge shows that intrinsic value comes from terminal value (stabilized lower scale), not near-term cash generation. The visual makes it clear: this is a bet on successful restructuring, not on continued current operations.

Example 3: Industrial company divestment. A conglomerate is dividing its operating segments. Your chart breaks down revenue and profit by segment. The presentation shows that Segment A (20% of revenue) contributes 40% of operating income (high margin), while Segment B (50% of revenue) contributes 30% (lower margin, but stable). Visualizing this mix helps the board decide which divisions to divest and which to keep.

Common mistakes

Creating too many charts. A thick presentation with 30 charts overwhelms rather than clarifies. Focus on 5–7 key charts that each answer a specific question.

Using default Excel formatting. Default charts are gray and difficult to read. Customize: use brand colors, enlarge fonts, remove unnecessary gridlines, add clear titles and axis labels.

Showing precision that doesn't exist. If your revenue projection is "roughly $150M," don't chart it as "$147.3M". Round to the nearest $10M so the precision matches your confidence.

Mislabeling axes. "Year 1," "Year 2," "Year 3" is clear. "2023," "2024," "2025" is also clear. But mixing "Year 1," "2024," "Year 3" is confusing, especially if your model base year isn't 2023.

Embedding charts in the model sheet. Separate your analysis sheets from your presentation sheets. Keep a dedicated "Charts" or "Output" sheet so the model isn't cluttered.

Not including a historical baseline. A chart of projections alone is hard to interpret. Always show historical actuals alongside projections so viewers can gauge whether the assumptions are a reasonable extrapolation.

FAQ

Q: Should I include all 10 years of projections in charts, or just the explicit forecast period? A: Show the forecast period (5 years) and perhaps one summary bar for the terminal value, not 10 individual years. If you project 10 years, chart Year 1, 2, 3, 4, 5, and "Terminal," skipping the intermediate years.

Q: What's the right number of sensitivity scenarios to show? A: A 2-variable sensitivity table with 5–6 rows and columns is typical. That's 25–36 cells, manageable and visual. If you want more detail, add a second table for different variable pairs (e.g., revenue growth vs. margin, rather than WACC vs. terminal growth).

Q: Can I use 3D charts or fancy formatting? A: Avoid 3D charts; they're harder to read. Use color strategically (heatmap in red/green), not decoratively. Professional design is clean and minimalist, not flashy.

Q: Should I show multiple valuation methods (DCF, multiples, asset-based) as separate charts? A: Yes, if you're using multiple methods. Show each method's valuation and then a reconciliation chart showing the average or selected method. This demonstrates triangulation.

Q: How do I present a valuation range rather than a point estimate? A: Show a range bar chart: a horizontal bar from low valuation to high valuation, with a marker for your base case. This visually communicates uncertainty.

Q: Should I create interactive charts with toggles so users can change assumptions? A: For internal use, interactive charts (via Excel Slicers or Google Data Studio) are powerful. For external presentations, static charts are clearer—they can't be misused or misunderstood.

Related concepts

• Chapter 14, Section 4: Error-Checking — Verify your model before charting.
• Chapter 10: Comparable Company Analysis — Multiples to cross-check against DCF.
• Chapter 12: Terminal Value — The component often shown separately in waterfall charts.
• Chapter 5: Presenting Valuations — Communication best practices for your charts.

Summary

Visualization transforms a spreadsheet of numbers into a story. Revenue and margin charts show the company's growth and profitability trajectory. FCF waterfalls break down intrinsic value into components. Sensitivity heatmaps reveal which assumptions drive value most. Historical-to-projected bridges make assumptions explicit. Segment breakdowns clarify where value comes from. Together, these charts make your valuation transparent, auditable, and persuasive. Spend time on visualization; it's where analysis becomes communication.

Next

Proceed to Excel Formula Best Practices.