Type: Interactive Excel financial analysis dashboard Period covered: Q2 FY2024 – Q1 FY2027 (12 quarters) Data source: Primary — SEC filings and company investor relations releases (no third-party or pre-aggregated datasets used)
Assess whether Zoom's post-pandemic slowdown in revenue growth has been offset by improved operating discipline, and whether the company's own forward guidance has been a reliable signal of performance. The analysis is framed as a stakeholder would ask it: is this still a growth story, or has the business shifted toward a profitability story?
Every figure in this workbook is traceable to a primary source. No data was estimated, interpolated, or pulled from a secondary aggregator.
| Data | Source | Retrieval method |
|---|---|---|
| Quarterly income statement (Q2 FY2024–Q1 FY2027, excl. Q4s) | Form 10-Q, "Condensed Consolidated Statements of Operations" | SEC EDGAR, CIK 0001585521 |
| Q4 / fiscal year-end figures | Quarterly earnings press release (8-K exhibit) | Zoom Investor Relations / GlobeNewswire |
| Forward guidance ranges (7 of 12 quarters) | "Financial Outlook" section of the prior quarter's earnings release | Zoom Investor Relations / GlobeNewswire |
Methodological note: Each 10-Q reports the current quarter alongside the same quarter one year prior, which was used to cross-verify overlapping data points and confirm consistency across filings.
Fiscal calendar note: Zoom's fiscal year ends January 31. "Q1 FY2025" therefore corresponds to the calendar quarter Feb–Apr 2024, not Jan–Mar. All labeling in this workbook follows Zoom's fiscal convention, not the calendar year.
| Tab | Purpose | Type |
|---|---|---|
Dashboard |
Primary interactive view | KPI cards, charts, pivot summaries |
Raw Data |
Source-of-truth financials, one row per quarter | Excel Table |
Calculations |
Derived metrics layer | Formula-driven, sourced from Raw Data |
Guidance |
Guidance vs. actual tracking | Static reference table |
Annual Rollup |
Revenue / Operating Income / Net Income by FY | PivotTable + PivotChart |
Annual Expense Breakdown |
R&D / S&M / G&A by FY | PivotTable + PivotChart |
| Field | Formula logic | Notes |
|---|---|---|
| QoQ Growth % | (Current Qtr Revenue − Prior Qtr Revenue) / Prior Qtr Revenue | Undefined for the first row (no prior quarter) |
| YoY Growth % | (Current Qtr Revenue − Same Qtr Prior Year) / Same Qtr Prior Year | Undefined for the first 4 quarters (no prior-year data in range) |
| Gross Margin % | Gross Profit / Revenue | |
| Operating Margin % | Operating Income / Revenue | Excludes non-operating items (investment gains/losses, other income) |
| Rule of 40 | YoY Growth % + Operating Margin % | Industry benchmark threshold: 40% |
| Expense ratios (R&D / S&M / G&A % of Rev) | Category expense / Revenue | |
| Guidance Beat % | (Actual Revenue − Guidance High) / Guidance High | Positive = beat the high end of guidance |
All blank/undefined cases are handled explicitly with IFERROR and blank-checks rather than allowing Excel to silently return 0 or an error — an early bug in this build (a KPI card showing "0.0%" instead of "N/A" for quarters lacking prior-year data) was caught and corrected during QA.
- Revenue growth has plateaued at a modest, stable rate — YoY growth held in the mid-single digits across the full 12-quarter window, with no quarter showing double-digit growth.
- Operating margin nearly doubled, from 15.6% (Q2 FY2024) to 25.1% (Q1 FY2027), while gross margin stayed essentially flat (~76–78%) — the margin expansion is an opex story, not a cost-of-revenue story.
- The primary driver is disciplined S&M spend, which fell from 33% to 27% of revenue over the period, while R&D and G&A ratios stayed comparatively stable.
- Zoom beat the high end of its own guidance in all 7 tracked quarters, averaging roughly a 1% beat — a consistent pattern worth noting, though this dataset cannot distinguish between conservative guidance-setting and genuine outperformance.
- Rule of 40 improved from 19% to 30%, a meaningful trend, but the company remains below the 40% SaaS benchmark throughout the observed period.
Conclusion: The data supports a "maturing, profitability-focused business" narrative over a "growth business" narrative for this period.
- Partial fiscal years: FY2024 and FY2027 contain fewer than 4 quarters within this dataset's window; annual rollup totals for these years are explicitly flagged and should not be compared directly to complete fiscal years.
- Guidance coverage gap: Guidance data is unavailable for the first 5 quarters in the dataset (predates the earliest press release reviewed); these show as "N/A" by design, not by error.
- Margin calculation method varies by view: the Calculations tab computes margin as an average of quarterly ratios; the Annual Rollup pivot table's Calculated Field computes margin as total Operating Income ÷ total Revenue for the year (a blended figure). These are both valid but will not match exactly — this is a known and intentional methodological difference, not a data error.
- Non-operating items excluded: Investment gains/losses and other income are excluded from Operating Margin by design, since they are not representative of core business performance; this occasionally causes Net Income to move independently of Operating Income.
- A single dropdown-driven control cell feeds all 5 KPI cards via
INDEX/MATCH, withIFERRORfallbacks for quarters lacking comparison data. - Two PivotTables share a single connected slicer (via Report Connections), filtering both tables and their charts simultaneously — enabled by rebuilding both from the same source range so they share a pivot cache.
- KPI values are displayed via linked Shapes rather than plain cells, allowing independent font styling per element while remaining fully formula-driven.
Primary-source financial data extraction · dynamic lookup formulas · pivot tables with calculated fields · shared slicer connections · defensive formula design (error/blank handling) · dashboard information hierarchy and layout design
This is a self-directed portfolio project. All source figures are publicly available via SEC EDGAR and Zoom's investor relations site; no material non-public information was used.