Productivity and Business Processes
$140.0B15.9% revenue growth 59.9% operating margin
Independent finance case study · October 2026
What turns growth into operating profit?
A segment-level analysis of Microsoft, connecting reported results to a transparent FY2027 planning model. Explore how growth, delivery costs, and operating expenses change the outcome.
Historical period: FY2024–FY2026. Study cutoff: June 30, 2026. Estimates are independent assumptions, not Microsoft guidance.
The finding
Growth and profitability tell different stories.
Intelligent Cloud contributed 62.9% of Microsoft’s FY2026 revenue increase. Its cost-of-revenue ratio also rose 4.2 percentage points. Productivity and Business Processes had the highest operating margin, at 59.9%.
The planning implication: forecast each segment’s growth and costs separately. A single company-wide growth rate misses changes in business mix.
Source: Microsoft FY2026 Annual Report, Note 18 ↗Reported results
Three segments. Different economics.
Each bar shows FY2026 revenue from a zero baseline. Values are USD billions; margins are operating income divided by revenue.
View historical revenue and operating income
| Metric | FY2024 actual | FY2025 actual | FY2026 actual |
|---|---|---|---|
| Productivity and Business Processes: revenue | $106.8B | $120.8B | $140.0B |
| Productivity and Business Processes: operating income | $59.7B | $69.8B | $83.9B |
| Intelligent Cloud: revenue | $87.5B | $106.3B | $137.8B |
| Intelligent Cloud: operating income | $37.8B | $44.6B | $57.0B |
| More Personal Computing: revenue | $50.8B | $54.6B | $54.1B |
| More Personal Computing: operating income | $12.0B | $14.2B | $14.4B |
The model
Make the assumptions visible.
Start with a named scenario. Then adjust Cloud growth or its cost ratio. Other segment assumptions stay fixed. “Cloud” refers to the Intelligent Cloud segment, not Azure alone.
FY2027 illustrative estimate. USD billions. No company guidance is used.
BaseFY2027 estimate
- $387.3B
- Revenue
- $185.5B
- Operating income
- 47.9%
- Operating margin
Adjust either input to see how Cloud economics affect consolidated profit.
| Segment | Revenue growth | Cost / revenue | Opex growth | Revenue | Operating income |
|---|---|---|---|---|---|
| Productivity and Business Processes | 15.0% | 17.9% | 8.0% | $161.0B | $98.6B |
| Intelligent Cloud | 25.0% | 43.0% | 10.0% | $172.2B | $72.9B |
| More Personal Computing | 0.0% | 43.4% | 3.0% | $54.1B | $13.9B |
Explore the 25-point sensitivity grid
Consolidated FY2027 operating income in USD billions. Columns adjust Cloud revenue growth; rows adjust Cloud cost of revenue as a share of revenue. All adjustments are in percentage points, relative to the named base case. Sliders do not change this grid.
| Cost ratio / growth | -10 pp | -5 pp | 0 pp | +5 pp | +10 pp |
|---|---|---|---|---|---|
| -2 pp | $180.8B | $184.9B | $188.9B | $193.0B | $197.0B |
| -1 pp | $179.2B | $183.2B | $187.2B | $191.2B | $195.2B |
| 0 pp | $177.6B | $181.5B | $185.5B | $189.4B | $193.3B |
| +1 pp | $176.0B | $179.9B | $183.7B | $187.6B | $191.5B |
| +2 pp | $174.4B | $178.2B | $182.0B | $185.8B | $189.6B |
Method and judgment
A forecast you can trace.
Keep the accounting basis consistent.
Use one annual report for all three historical periods. Preserve reported inputs separately, then reconcile segment revenue, cost of revenue, operating expenses, and operating income to consolidated controls.
Separate growth from cost behavior.
Revenue grows from the prior year. Cost of revenue follows the selected cost ratio. Operating expenses grow independently. Subtract both costs to calculate operating income.
Operating income = revenue − cost of revenue − operating expensesMake the uncertainty inspectable.
Base, Downside, and Upside use explicit assumptions. The Excel sensitivity table evaluates the same model across 25 Cloud growth and cost combinations. Scenario changes leave actuals unchanged.
Ask what would change the plan.
Monitor Cloud revenue growth alongside delivery costs. A one-point cost-ratio increase reduces operating income by 1% of forecast Cloud revenue, holding other drivers fixed. Update the plan when either assumption changes.
Why these cases?
The assumptions create a plausible range for a planning exercise, rather than claim a precise prediction. Revenue growth varies across cases, cost-ratio changes test margin pressure, and expenses remain relatively sticky in the downside.
- Productivity revenue cases span 10% to 20%. Base uses 15% growth. Cost ratio is flat in Base; operating expenses grow 8%.
- Cloud revenue cases span 15% to 35%. Base uses 25% growth and a 1 percentage point increase in cost of revenue/revenue. Operating expenses grow 10%.
- Personal Computing revenue cases span -5% to 5%. Base holds revenue and cost ratio flat; operating expenses grow 3%.
Scope and limitations
Independent annual planning exercise using FY2024–FY2026 actuals on the presentation basis in the FY2026 report. FY2027 assumptions are illustrative, not Microsoft guidance. Information after June 30, 2026, including subsequent quarterly results, is excluded. No cash-flow, valuation, tax, FX, or product-level revenue forecast is modeled. Intelligent Cloud is not equivalent to Azure.
This is an independent portfolio project, not work performed for Microsoft. The downloaded workbook is the editable model; website controls run locally and do not alter the workbook.
Inspect the work
Take the model with you.
01Excel operating model
Actuals, scenario inputs, formulas, and a native sensitivity table.
Download .xlsx ↓02One-page decision briefThe question, findings, base estimate, and assumptions in one printable page.
Open brief ↗03Historical source dataReported inputs with fiscal years, units, and the source reference.
Download .csv ↓