$SMCI
Business
Supermicro designs and integrates servers, rack-scale AI systems, storage and cooling solutions. Sales depend on component availability, customer acceptance and deployment schedules. Large systems carry substantial inventory and receivables. Working capital can therefore require financing even when reported earnings grow, and preferred stock, convertible notes and bank loans create claims ahead of common shareholders.
Three drivers
- Delivered systems, customer acceptance and product mix
- Gross margin and engineering/compliance expense
- Inventory, receivables, customer funding and capital claims
Thesis
Our view
The business can grow quickly with AI infrastructure demand, but the central test is whether system profits finance the inventory and credit needed to deliver that growth. FY2026 earnings were positive while CFO was deeply negative. New orders, higher ending cash and financing proceeds cannot substitute for recurring cash generation.
What changes it
Track sales and gross margin alongside sequential inventory, receivables and customer advances. Improve confidence if growth funds itself after capex and senior claims; reduce it if turnover worsens or current bank obligations require continuing outside capital.
Scenario ranges
Explicit downside/base/upside business assumptions; not price targets, probabilities or historical market-memory bands.
Model · 8 fiscal quarters (last eight)
| Fiscal quarter | 2025Q1 2024-09-30 | 2025Q2 2024-12-31 | 2025Q3 2025-03-31 | 2025Q4 2025-06-30 | 2026Q1 2025-09-30 | 2026Q2 2025-12-31 | 2026Q3 2026-03-31 | 2026Q4 2026-06-30 |
|---|---|---|---|---|---|---|---|---|
| Revenue ($M) | 5,937.31 | 5,678.02 | 4,599.93 | 5,756.9†4 | 5,017.81 | 12,682.52 | 10,243.03 | 11,119.8†4 |
| Gross profit ($M) | 775.65 | 670.06 | 440.27 | 544.1†8 | 467.45 | 798.66 | 1,018.77 | 1,942.6†8 |
| Operating income ($M) | 509.29 | 368.610 | 146.811 | 228.4†12 | 182.39 | 474.310 | 625.911 | 1,488.1†12 |
| Net income ($M) | 424.313 | 320.614 | 108.815 | 195.2†16 | 168.313 | 400.614 | 483.415 | 1,178.2†16 |
| EPS, diluted ($) | 0.6717 | 0.5118 | 0.1719 | — | 0.2617 | 0.6018 | 0.7219 | — |
| Diluted shares (M) | 639.120 | 636.021 | 621.822 | — | 663.220 | 694.021 | 692.222 | — |
| Cash ($M) | 2,088.723 | 1,430.024 | 2,536.125 | 5,169.926 | 4,196.927 | 4,091.128 | 1,290.329 | 7,521.526 |
| Long-term debt ($M) | — | — | — | — | — | — | — | — |
| Cash from operations ($M) | 408.930 | -239.8†31 | 626.8†32 | 863.6†33 | -917.530 | -23.9†31 | -6,615.4†32 | 747.0†33 |
| Capex ($M) | 44.334 | 27.5†35 | 32.7†36 | 22.7†37 | 32.334 | 21.2†35 | 80.3†36 | 28.2†37 |
| Free cash flow ($M) | 364.6†38 | -267.3†39 | 594.1†40 | 840.9†41 | -949.8†38 | -45.1†39 | -6,695.7†40 | 718.7†41 |
Estimates · base scenario
| Period | Revenue ($M) | EPS ($) | As of | Basis |
|---|---|---|---|---|
| 2027Q1 | 15,000.0 | — | 2026-09-19 | Desk base scenario. Revenue basis: Revenue ($M). Calculated from the operating-model inputs below; not consensus or company guidance. |
| 2027Q2 | 16,050.0 | — | 2026-09-19 | Desk base scenario. Revenue basis: Revenue ($M). Calculated from the operating-model inputs below; not consensus or company guidance. |
| 2027Q3 | 17,655.0 | — | 2026-09-19 | Desk base scenario. Revenue basis: Revenue ($M). Calculated from the operating-model inputs below; not consensus or company guidance. |
| 2027Q4 | 19,795.0 | — | 2026-09-19 | Desk base scenario. Revenue basis: Revenue ($M). Calculated from the operating-model inputs below; not consensus or company guidance. |
AI system delivery must finance inventory and senior claims
Anchor FY2027 sales and Q1 to management ranges, then explicitly allocate remaining quarters. FY2028 is a desk expansion scenario. Model gross margin, operating expense and stock compensation independently. Roll receivables, inventory and payables from June balances using editable quarter-end turnover assumptions. Separate net deferred-revenue customer funding from cash before that funding. Deduct capex, preferred cash dividends and employee withholding; debt principal and new financing are outside the measure.
Reported anchors and guidance
| Measure | Period | Value | Basis |
|---|---|---|---|
| FY2027 revenue guidance midpoint | FY2027 | 68,500.00 | derived. Calculated midpoint of the company range; not an additional company forecast. |
| Q1 FY2027 revenue guidance midpoint | 2027Q1 | 15,000.00 | derived. Calculated midpoint of the company range; not an additional company forecast. |
| FY2026 revenue | FY2026 | 39,063.07 | reported. Reported consolidated amount, converted from thousands to millions. Source · 2026-08-31 |
| FY2026 gross profit | FY2026 | 4,227.25 | reported. Reported consolidated amount, converted from thousands to millions. Source · 2026-08-31 |
| FY2026 cfo | FY2026 | -6,809.89 | reported. Reported consolidated amount, converted from thousands to millions. Source · 2026-08-31 |
| FY2026 CFO less PP&E | FY2026 | -6,971.89 | derived. After severe inventory and receivables funding needs. |
| FY2026 cash before customer funding | FY2026 | -8,690.54 | derived. Removes only net deferred-revenue cash contribution. |
| FY2026 customer funding | FY2026 | 1,880.65 | reported. Reported consolidated amount, converted from thousands to millions. Source · 2026-08-31 |
| inventory | June 2026 | 12,895.95 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| receivables | June 2026 | 6,125.41 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| cash | June 2026 | 7,521.47 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| loans current | June 2026 | 2,039.77 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| loans long | June 2026 | 2,016.37 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| convert carrying | June 2026 | 4,664.14 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| preferred face | June 2026 | 4,312.50 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
| Declared September aggregate cash dividend | 2027Q1 | 63.73 | assumption. Desk aggregate: 4.3125 million June preferred shares times declared $14.7778 per share; assumes unchanged shares through record date. Source · 2026-08-05 |
| FY2026 total financing | FY2026 | 9,478.75 | reported. Reported consolidated amount, converted from thousands to millions. Source · 2026-08-31 |
| receivables sold | June 2026 | 831.67 | reported. Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Source · 2026-08-31 |
Downside scenario
| Period | Operating cash flow proxy ($M) | CFO less capex ($M) | Cash PP&E purchases ($M) | Revenue ($M) | GAAP gross profit ($M) | Preferred cash dividend ($M) | Net deferred-revenue cash source ($M) | GAAP operating income ($M) | Cash after preferred and award taxes ($M) | Cash before net deferred-revenue funding ($M) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2027Q1 | -3,195.71 | -3,265.71 | 70.00 | 13,200.00 | 1,122.00 | 63.73 | 150.00 | 494.00 | -3,369.44 | -3,345.71 |
| 2027Q2 | -728.79 | -803.79 | 75.00 | 14,124.00 | 1,200.54 | 75.47 | 100.00 | 547.94 | -921.26 | -828.79 |
| 2027Q3 | -1,445.18 | -1,525.18 | 80.00 | 15,536.40 | 1,320.59 | 75.47 | 0.00 | 643.39 | -1,644.65 | -1,445.18 |
| 2027Q4 | -2,105.62 | -2,190.62 | 85.00 | 17,419.60 | 1,480.67 | 75.47 | -100.00 | 778.87 | -2,312.08 | -2,005.62 |
| FY2027 | -7,475.29 | -7,785.29 | 310.00 | 60,280.00 | 5,123.80 | 290.14 | 150.00 | 2,464.20 | -8,247.42 | -7,625.29 |
| FY2028 | 3,131.84 | 2,741.84 | 390.00 | 61,485.60 | 5,410.73 | 301.88 | 0.00 | 2,357.53 | 2,235.96 | 3,131.84 |
Base scenario
| Period | Operating cash flow proxy ($M) | CFO less capex ($M) | Cash PP&E purchases ($M) | Revenue ($M) | GAAP gross profit ($M) | Preferred cash dividend ($M) | Net deferred-revenue cash source ($M) | GAAP operating income ($M) | Cash after preferred and award taxes ($M) | Cash before net deferred-revenue funding ($M) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2027Q1 | 227.03 | 157.03 | 70.00 | 15,000.00 | 1,650.00 | 63.73 | 500.00 | 1,037.00 | 53.30 | -272.97 |
| 2027Q2 | 459.10 | 384.10 | 75.00 | 16,050.00 | 1,765.50 | 75.47 | 500.00 | 1,128.50 | 266.63 | -40.90 |
| 2027Q3 | -150.55 | -230.55 | 80.00 | 17,655.00 | 1,942.05 | 75.47 | 350.00 | 1,281.05 | -350.02 | -500.55 |
| 2027Q4 | -735.76 | -820.76 | 85.00 | 19,795.00 | 2,177.45 | 75.47 | 150.00 | 1,492.45 | -942.22 | -885.76 |
| FY2027 | -200.18 | -510.18 | 310.00 | 68,500.00 | 7,535.00 | 290.14 | 1,500.00 | 4,939.00 | -972.31 | -1,700.18 |
| FY2028 | 3,851.08 | 3,461.08 | 390.00 | 82,200.00 | 9,288.60 | 301.88 | 500.00 | 6,308.60 | 2,955.21 | 3,351.08 |
Upside scenario
| Period | Operating cash flow proxy ($M) | CFO less capex ($M) | Cash PP&E purchases ($M) | Revenue ($M) | GAAP gross profit ($M) | Preferred cash dividend ($M) | Net deferred-revenue cash source ($M) | GAAP operating income ($M) | Cash after preferred and award taxes ($M) | Cash before net deferred-revenue funding ($M) |
|---|---|---|---|---|---|---|---|---|---|---|
| 2027Q1 | 2,368.56 | 2,298.56 | 70.00 | 16,200.00 | 2,106.00 | 63.73 | 600.00 | 1,478.00 | 2,194.83 | 1,768.56 |
| 2027Q2 | 1,161.15 | 1,086.15 | 75.00 | 17,334.00 | 2,253.42 | 75.47 | 600.00 | 1,600.82 | 968.68 | 561.15 |
| 2027Q3 | 662.45 | 582.45 | 80.00 | 19,067.40 | 2,478.76 | 75.47 | 450.00 | 1,801.56 | 462.98 | 212.45 |
| 2027Q4 | 204.09 | 119.09 | 85.00 | 21,378.60 | 2,779.22 | 75.47 | 250.00 | 2,077.42 | -2.38 | -45.91 |
| FY2027 | 4,396.25 | 4,086.25 | 310.00 | 73,980.00 | 9,617.40 | 290.14 | 1,900.00 | 6,957.80 | 3,624.11 | 2,496.25 |
| FY2028 | 6,025.84 | 5,635.84 | 390.00 | 96,174.00 | 12,791.14 | 301.88 | 750.00 | 9,737.94 | 5,129.97 | 5,275.84 |
All inputs and formulas — reproduce this model
| Input / calculation | Period / case | Value / unit | Evidence or assumption |
|---|---|---|---|
| FY2026 revenue fy26_revenue | FY2026 / shared | 39,063.07 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 gross profit fy26_gross_profit | FY2026 / shared | 4,227.25 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 operating income fy26_operating_income | FY2026 / shared | 2,770.49 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 net income fy26_net_income | FY2026 / shared | 2,230.45 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 cfo fy26_cfo | FY2026 / shared | -6,809.89 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 capex fy26_capex | FY2026 / shared | 162.00 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 sbc fy26_sbc | FY2026 / shared | 412.12 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 da fy26_da | FY2026 / shared | 53.67 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 inventory use fy26_inventory_use | FY2026 / shared | 8,876.75 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 receivable use fy26_receivable_use | FY2026 / shared | 3,921.87 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 customer funding fy26_customer_funding | FY2026 / shared | 1,880.65 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 equity award cash fy26_equity_award_cash | FY2026 / shared | 129.88 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 preferred accrual fy26_preferred_accrual | FY2026 / shared | 13.09 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 common financing fy26_common_financing | FY2026 / shared | 1,406.95 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 preferred financing fy26_preferred_financing | FY2026 / shared | 4,231.64 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 total financing fy26_total_financing | FY2026 / shared | 9,478.75 USD_millions | reported: Reported consolidated amount, converted from thousands to millions. Primary source · 2026-08-31 |
| FY2026 CFO less PP&E fy26_fcf | FY2026 / shared | -6,971.89 USD_millions | derived: After severe inventory and receivables funding needs. Formula: subtract(fy26_cfo, fy26_capex). |
| FY2026 cash before customer funding fy26_cfo_before_funding | FY2026 / shared | -8,690.54 USD_millions | derived: Removes only net deferred-revenue cash contribution. Formula: subtract(fy26_cfo, fy26_customer_funding). |
| cash cash | June 2026 / shared | 7,521.47 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| restricted restricted | June 2026 / shared | 110.06 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| receivables receivables | June 2026 / shared | 6,125.41 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| inventory inventory | June 2026 / shared | 12,895.95 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| payables payables | June 2026 / shared | 2,247.00 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| loans current loans_current | June 2026 / shared | 2,039.77 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| loans long loans_long | June 2026 / shared | 2,016.37 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| convert carrying convert_carrying | June 2026 / shared | 4,664.14 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| preferred face preferred_face | June 2026 / shared | 4,312.50 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| receivables sold receivables_sold | June 2026 / shared | 831.67 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| q4 gross profit q4_gross_profit | June 2026 / shared | 1,942.63 USD_millions | reported: Preferred face is 4.3125M shares at $1,000; debt amounts are carrying values. Receivables sold is FY2026 flow, not a June balance. Primary source · 2026-08-31 |
| FY2027 revenue guidance low annual_guide_low | FY2027 / shared | 65,000.00 USD_millions | management guidance: Company guidance; not a desk forecast. Primary source · 2026-08-11 |
| FY2027 revenue guidance high annual_guide_high | FY2027 / shared | 72,000.00 USD_millions | management guidance: Company guidance; not a desk forecast. Primary source · 2026-08-11 |
| Midpoint divisor two | Model / shared | 200.0% ratio | assumption: Arithmetic constant. |
| FY2027 revenue guidance endpoint sum annual_guide_sum | FY2027 / shared | 137,000.00 USD_millions | derived: Arithmetic intermediate. Formula: sum(annual_guide_low, annual_guide_high). |
| FY2027 revenue guidance midpoint annual_guide | FY2027 / shared | 68,500.00 USD_millions | derived: Calculated midpoint of the company range; not an additional company forecast. Formula: divide(annual_guide_sum, two). |
| Q1 FY2027 revenue guidance low q1_guide_low | 2027Q1 / shared | 14,500.00 USD_millions | management guidance: Company guidance; not a desk forecast. Primary source · 2026-08-11 |
| Q1 FY2027 revenue guidance high q1_guide_high | 2027Q1 / shared | 15,500.00 USD_millions | management guidance: Company guidance; not a desk forecast. Primary source · 2026-08-11 |
| Q1 FY2027 revenue guidance endpoint sum q1_guide_sum | 2027Q1 / shared | 30,000.00 USD_millions | derived: Arithmetic intermediate. Formula: sum(q1_guide_low, q1_guide_high). |
| Q1 FY2027 revenue guidance midpoint q1_guide | 2027Q1 / shared | 15,000.00 USD_millions | derived: Calculated midpoint of the company range; not an additional company forecast. Formula: divide(q1_guide_sum, two). |
| Preferred annual dividend rate preferred_rate | Annual / shared | 7.0% ratio | reported: 7% of liquidation preference; future cash/share election and declaration conditions apply. Primary source · 2026-06-15 |
| Initial preferred dividend per share declared_initial_dividend | September 2026 / shared | 14.78 USD_per_share | reported: Declared August 5, payable September 1. This is per preferred share, not per depositary share. Primary source · 2026-08-05 |
| Declared September aggregate cash dividend initial_preferred_cash | 2027Q1 / shared | 63.73 USD_millions | assumption: Desk aggregate: 4.3125 million June preferred shares times declared $14.7778 per share; assumes unchanged shares through record date. Primary source · 2026-08-05 |
| Sales delivery / guidance midpoint downside_delivery | FY2027 / downside | 88.0% ratio | assumption: Desk delivery sensitivity. |
| FY2027 sales target downside_annual_target | FY2027 / downside | 60,280.00 USD_millions | derived: Base uses midpoint; no incremental order-book revenue. Formula: multiply(annual_guide, downside_delivery). |
| Q1 sales target downside_q1_target | 2027Q1 / downside | 13,200.00 USD_millions | derived: Base uses quarterly midpoint. Formula: multiply(q1_guide, downside_delivery). |
| Remaining FY2027 sales downside_remaining | FY2027 / downside | 47,080.00 USD_millions | derived: Separate Q1 anchor and remaining allocation. Formula: subtract(downside_annual_target, downside_q1_target). |
| Identity multiplier downside_2027q1_one | 2027Q1 / downside | 100.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2027q1_revenue | 2027Q1 / downside | 13,200.00 USD_millions | derived: Q1 company guidance scenario. Formula: multiply(downside_q1_target, downside_2027q1_one). |
| Gross margin downside_2027q1_gm | 2027Q1 / downside | 8.5% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2027q1_gross_profit | 2027Q1 / downside | 1,122.00 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2027q1_revenue, downside_2027q1_gm). |
| Cost of goods sold downside_2027q1_cogs | 2027Q1 / downside | 12,078.00 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2027q1_revenue, downside_2027q1_gross_profit). |
| Total stock compensation expense downside_2027q1_sbc | 2027Q1 / downside | 138.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2027q1_cogs_sbc | 2027Q1 / downside | 10.00 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2027q1_opex_sbc | 2027Q1 / downside | 128.00 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2027q1_sbc, downside_2027q1_cogs_sbc). |
| Operating costs excluding SBC downside_2027q1_cashopex | 2027Q1 / downside | 500.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2027q1_opex | 2027Q1 / downside | 628.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2027q1_cashopex, downside_2027q1_opex_sbc). |
| GAAP operating income downside_2027q1_operating_income | 2027Q1 / downside | 494.00 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2027q1_gross_profit, downside_2027q1_opex). |
| Standard quarter days downside_2027q1_ar_quarter_days | 2027Q1 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q1_ar_daily | 2027Q1 / downside | 146.67 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q1_revenue, downside_2027q1_ar_quarter_days). |
| Ending balance turnover days downside_2027q1_ar_days | 2027Q1 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2027q1_ar_balance | 2027Q1 / downside | 8,066.67 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q1_ar_daily, downside_2027q1_ar_days). |
| Cash source from ar downside_2027q1_ar_cash | 2027Q1 / downside | -1,941.25 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(receivables, downside_2027q1_ar_balance). |
| Standard quarter days downside_2027q1_inv_quarter_days | 2027Q1 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q1_inv_daily | 2027Q1 / downside | 134.20 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q1_cogs, downside_2027q1_inv_quarter_days). |
| Ending balance turnover days downside_2027q1_inv_days | 2027Q1 / downside | 11,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2027q1_inv_balance | 2027Q1 / downside | 14,762.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q1_inv_daily, downside_2027q1_inv_days). |
| Cash source from inv downside_2027q1_inv_cash | 2027Q1 / downside | -1,866.05 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(inventory, downside_2027q1_inv_balance). |
| Standard quarter days downside_2027q1_ap_quarter_days | 2027Q1 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q1_ap_daily | 2027Q1 / downside | 134.20 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q1_cogs, downside_2027q1_ap_quarter_days). |
| Ending balance turnover days downside_2027q1_ap_days | 2027Q1 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2027q1_ap_balance | 2027Q1 / downside | 2,415.60 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q1_ap_daily, downside_2027q1_ap_days). |
| Cash source from ap downside_2027q1_ap_cash | 2027Q1 / downside | 168.60 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q1_ap_balance, payables). |
| Depreciation and amortization downside_2027q1_da | 2027Q1 / downside | 16.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2027q1_profit_cash | 2027Q1 / downside | 648.00 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2027q1_operating_income, downside_2027q1_sbc, downside_2027q1_da). |
| Cash interest net of cash investment income downside_2027q1_interest | 2027Q1 / downside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2027q1_cash_tax | 2027Q1 / downside | 180.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2027q1_other_wc | 2027Q1 / downside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2027q1_cash_uses | 2027Q1 / downside | 355.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2027q1_interest, downside_2027q1_cash_tax, downside_2027q1_other_wc). |
| Cash profit after taxes and net interest downside_2027q1_cash_after_uses | 2027Q1 / downside | 293.00 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2027q1_profit_cash, downside_2027q1_cash_uses). |
| Cash before net deferred-revenue funding downside_2027q1_cfo_before_funding | 2027Q1 / downside | -3,345.71 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2027q1_cash_after_uses, downside_2027q1_ar_cash, downside_2027q1_inv_cash, downside_2027q1_ap_cash). |
| Net customer deferred-revenue cash source downside_2027q1_customer_funding | 2027Q1 / downside | 150.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2027q1_cfo | 2027Q1 / downside | -3,195.71 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2027q1_cfo_before_funding, downside_2027q1_customer_funding). |
| Cash PP&E purchases downside_2027q1_capex | 2027Q1 / downside | 70.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2027q1_fcf | 2027Q1 / downside | -3,265.71 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2027q1_cfo, downside_2027q1_capex). |
| Initial dividend multiplier downside_2027q1_dividend_factor | 2027Q1 / downside | 100.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2027q1_preferred_cash | 2027Q1 / downside | 63.73 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(initial_preferred_cash, downside_2027q1_dividend_factor). |
| Equity-award tax withholding downside_2027q1_awards | 2027Q1 / downside | 40.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2027q1_capital_claims | 2027Q1 / downside | 103.73 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2027q1_preferred_cash, downside_2027q1_awards). |
| Cash after preferred and award taxes downside_2027q1_cash_after_claims | 2027Q1 / downside | -3,369.44 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2027q1_fcf, downside_2027q1_capital_claims). |
| Remaining sales share downside_2027q2_remaining_share | 2027Q2 / downside | 30.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2027q2_revenue | 2027Q2 / downside | 14,124.00 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(downside_remaining, downside_2027q2_remaining_share). |
| Gross margin downside_2027q2_gm | 2027Q2 / downside | 8.5% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2027q2_gross_profit | 2027Q2 / downside | 1,200.54 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2027q2_revenue, downside_2027q2_gm). |
| Cost of goods sold downside_2027q2_cogs | 2027Q2 / downside | 12,923.46 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2027q2_revenue, downside_2027q2_gross_profit). |
| Total stock compensation expense downside_2027q2_sbc | 2027Q2 / downside | 143.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2027q2_cogs_sbc | 2027Q2 / downside | 10.40 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2027q2_opex_sbc | 2027Q2 / downside | 132.60 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2027q2_sbc, downside_2027q2_cogs_sbc). |
| Operating costs excluding SBC downside_2027q2_cashopex | 2027Q2 / downside | 520.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2027q2_opex | 2027Q2 / downside | 652.60 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2027q2_cashopex, downside_2027q2_opex_sbc). |
| GAAP operating income downside_2027q2_operating_income | 2027Q2 / downside | 547.94 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2027q2_gross_profit, downside_2027q2_opex). |
| Standard quarter days downside_2027q2_ar_quarter_days | 2027Q2 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q2_ar_daily | 2027Q2 / downside | 156.93 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q2_revenue, downside_2027q2_ar_quarter_days). |
| Ending balance turnover days downside_2027q2_ar_days | 2027Q2 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2027q2_ar_balance | 2027Q2 / downside | 8,631.33 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q2_ar_daily, downside_2027q2_ar_days). |
| Cash source from ar downside_2027q2_ar_cash | 2027Q2 / downside | -564.67 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q1_ar_balance, downside_2027q2_ar_balance). |
| Standard quarter days downside_2027q2_inv_quarter_days | 2027Q2 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q2_inv_daily | 2027Q2 / downside | 143.59 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q2_cogs, downside_2027q2_inv_quarter_days). |
| Ending balance turnover days downside_2027q2_inv_days | 2027Q2 / downside | 10,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2027q2_inv_balance | 2027Q2 / downside | 15,508.15 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q2_inv_daily, downside_2027q2_inv_days). |
| Cash source from inv downside_2027q2_inv_cash | 2027Q2 / downside | -746.15 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q1_inv_balance, downside_2027q2_inv_balance). |
| Standard quarter days downside_2027q2_ap_quarter_days | 2027Q2 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q2_ap_daily | 2027Q2 / downside | 143.59 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q2_cogs, downside_2027q2_ap_quarter_days). |
| Ending balance turnover days downside_2027q2_ap_days | 2027Q2 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2027q2_ap_balance | 2027Q2 / downside | 2,584.69 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q2_ap_daily, downside_2027q2_ap_days). |
| Cash source from ap downside_2027q2_ap_cash | 2027Q2 / downside | 169.09 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q2_ap_balance, downside_2027q1_ap_balance). |
| Depreciation and amortization downside_2027q2_da | 2027Q2 / downside | 17.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2027q2_profit_cash | 2027Q2 / downside | 707.94 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2027q2_operating_income, downside_2027q2_sbc, downside_2027q2_da). |
| Cash interest net of cash investment income downside_2027q2_interest | 2027Q2 / downside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2027q2_cash_tax | 2027Q2 / downside | 220.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2027q2_other_wc | 2027Q2 / downside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2027q2_cash_uses | 2027Q2 / downside | 395.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2027q2_interest, downside_2027q2_cash_tax, downside_2027q2_other_wc). |
| Cash profit after taxes and net interest downside_2027q2_cash_after_uses | 2027Q2 / downside | 312.94 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2027q2_profit_cash, downside_2027q2_cash_uses). |
| Cash before net deferred-revenue funding downside_2027q2_cfo_before_funding | 2027Q2 / downside | -828.79 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2027q2_cash_after_uses, downside_2027q2_ar_cash, downside_2027q2_inv_cash, downside_2027q2_ap_cash). |
| Net customer deferred-revenue cash source downside_2027q2_customer_funding | 2027Q2 / downside | 100.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2027q2_cfo | 2027Q2 / downside | -728.79 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2027q2_cfo_before_funding, downside_2027q2_customer_funding). |
| Cash PP&E purchases downside_2027q2_capex | 2027Q2 / downside | 75.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2027q2_fcf | 2027Q2 / downside | -803.79 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2027q2_cfo, downside_2027q2_capex). |
| Quarter-year dividend factor downside_2027q2_dividend_quarter | 2027Q2 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2027q2_preferred_cash | 2027Q2 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2027q2_dividend_quarter). |
| Equity-award tax withholding downside_2027q2_awards | 2027Q2 / downside | 42.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2027q2_capital_claims | 2027Q2 / downside | 117.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2027q2_preferred_cash, downside_2027q2_awards). |
| Cash after preferred and award taxes downside_2027q2_cash_after_claims | 2027Q2 / downside | -921.26 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2027q2_fcf, downside_2027q2_capital_claims). |
| Remaining sales share downside_2027q3_remaining_share | 2027Q3 / downside | 33.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2027q3_revenue | 2027Q3 / downside | 15,536.40 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(downside_remaining, downside_2027q3_remaining_share). |
| Gross margin downside_2027q3_gm | 2027Q3 / downside | 8.5% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2027q3_gross_profit | 2027Q3 / downside | 1,320.59 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2027q3_revenue, downside_2027q3_gm). |
| Cost of goods sold downside_2027q3_cogs | 2027Q3 / downside | 14,215.81 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2027q3_revenue, downside_2027q3_gross_profit). |
| Total stock compensation expense downside_2027q3_sbc | 2027Q3 / downside | 148.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2027q3_cogs_sbc | 2027Q3 / downside | 10.80 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2027q3_opex_sbc | 2027Q3 / downside | 137.20 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2027q3_sbc, downside_2027q3_cogs_sbc). |
| Operating costs excluding SBC downside_2027q3_cashopex | 2027Q3 / downside | 540.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2027q3_opex | 2027Q3 / downside | 677.20 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2027q3_cashopex, downside_2027q3_opex_sbc). |
| GAAP operating income downside_2027q3_operating_income | 2027Q3 / downside | 643.39 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2027q3_gross_profit, downside_2027q3_opex). |
| Standard quarter days downside_2027q3_ar_quarter_days | 2027Q3 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q3_ar_daily | 2027Q3 / downside | 172.63 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q3_revenue, downside_2027q3_ar_quarter_days). |
| Ending balance turnover days downside_2027q3_ar_days | 2027Q3 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2027q3_ar_balance | 2027Q3 / downside | 9,494.47 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q3_ar_daily, downside_2027q3_ar_days). |
| Cash source from ar downside_2027q3_ar_cash | 2027Q3 / downside | -863.13 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q2_ar_balance, downside_2027q3_ar_balance). |
| Standard quarter days downside_2027q3_inv_quarter_days | 2027Q3 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q3_inv_daily | 2027Q3 / downside | 157.95 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q3_cogs, downside_2027q3_inv_quarter_days). |
| Ending balance turnover days downside_2027q3_inv_days | 2027Q3 / downside | 10,600.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2027q3_inv_balance | 2027Q3 / downside | 16,743.06 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q3_inv_daily, downside_2027q3_inv_days). |
| Cash source from inv downside_2027q3_inv_cash | 2027Q3 / downside | -1,234.91 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q2_inv_balance, downside_2027q3_inv_balance). |
| Standard quarter days downside_2027q3_ap_quarter_days | 2027Q3 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q3_ap_daily | 2027Q3 / downside | 157.95 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q3_cogs, downside_2027q3_ap_quarter_days). |
| Ending balance turnover days downside_2027q3_ap_days | 2027Q3 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2027q3_ap_balance | 2027Q3 / downside | 2,843.16 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q3_ap_daily, downside_2027q3_ap_days). |
| Cash source from ap downside_2027q3_ap_cash | 2027Q3 / downside | 258.47 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q3_ap_balance, downside_2027q2_ap_balance). |
| Depreciation and amortization downside_2027q3_da | 2027Q3 / downside | 18.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2027q3_profit_cash | 2027Q3 / downside | 809.39 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2027q3_operating_income, downside_2027q3_sbc, downside_2027q3_da). |
| Cash interest net of cash investment income downside_2027q3_interest | 2027Q3 / downside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2027q3_cash_tax | 2027Q3 / downside | 240.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2027q3_other_wc | 2027Q3 / downside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2027q3_cash_uses | 2027Q3 / downside | 415.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2027q3_interest, downside_2027q3_cash_tax, downside_2027q3_other_wc). |
| Cash profit after taxes and net interest downside_2027q3_cash_after_uses | 2027Q3 / downside | 394.39 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2027q3_profit_cash, downside_2027q3_cash_uses). |
| Cash before net deferred-revenue funding downside_2027q3_cfo_before_funding | 2027Q3 / downside | -1,445.18 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2027q3_cash_after_uses, downside_2027q3_ar_cash, downside_2027q3_inv_cash, downside_2027q3_ap_cash). |
| Net customer deferred-revenue cash source downside_2027q3_customer_funding | 2027Q3 / downside | 0.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2027q3_cfo | 2027Q3 / downside | -1,445.18 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2027q3_cfo_before_funding, downside_2027q3_customer_funding). |
| Cash PP&E purchases downside_2027q3_capex | 2027Q3 / downside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2027q3_fcf | 2027Q3 / downside | -1,525.18 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2027q3_cfo, downside_2027q3_capex). |
| Quarter-year dividend factor downside_2027q3_dividend_quarter | 2027Q3 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2027q3_preferred_cash | 2027Q3 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2027q3_dividend_quarter). |
| Equity-award tax withholding downside_2027q3_awards | 2027Q3 / downside | 44.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2027q3_capital_claims | 2027Q3 / downside | 119.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2027q3_preferred_cash, downside_2027q3_awards). |
| Cash after preferred and award taxes downside_2027q3_cash_after_claims | 2027Q3 / downside | -1,644.65 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2027q3_fcf, downside_2027q3_capital_claims). |
| Remaining sales share downside_2027q4_remaining_share | 2027Q4 / downside | 37.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2027q4_revenue | 2027Q4 / downside | 17,419.60 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(downside_remaining, downside_2027q4_remaining_share). |
| Gross margin downside_2027q4_gm | 2027Q4 / downside | 8.5% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2027q4_gross_profit | 2027Q4 / downside | 1,480.67 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2027q4_revenue, downside_2027q4_gm). |
| Cost of goods sold downside_2027q4_cogs | 2027Q4 / downside | 15,938.93 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2027q4_revenue, downside_2027q4_gross_profit). |
| Total stock compensation expense downside_2027q4_sbc | 2027Q4 / downside | 153.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2027q4_cogs_sbc | 2027Q4 / downside | 11.20 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2027q4_opex_sbc | 2027Q4 / downside | 141.80 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2027q4_sbc, downside_2027q4_cogs_sbc). |
| Operating costs excluding SBC downside_2027q4_cashopex | 2027Q4 / downside | 560.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2027q4_opex | 2027Q4 / downside | 701.80 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2027q4_cashopex, downside_2027q4_opex_sbc). |
| GAAP operating income downside_2027q4_operating_income | 2027Q4 / downside | 778.87 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2027q4_gross_profit, downside_2027q4_opex). |
| Standard quarter days downside_2027q4_ar_quarter_days | 2027Q4 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q4_ar_daily | 2027Q4 / downside | 193.55 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q4_revenue, downside_2027q4_ar_quarter_days). |
| Ending balance turnover days downside_2027q4_ar_days | 2027Q4 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2027q4_ar_balance | 2027Q4 / downside | 10,645.31 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q4_ar_daily, downside_2027q4_ar_days). |
| Cash source from ar downside_2027q4_ar_cash | 2027Q4 / downside | -1,150.84 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q3_ar_balance, downside_2027q4_ar_balance). |
| Standard quarter days downside_2027q4_inv_quarter_days | 2027Q4 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q4_inv_daily | 2027Q4 / downside | 177.10 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q4_cogs, downside_2027q4_inv_quarter_days). |
| Ending balance turnover days downside_2027q4_inv_days | 2027Q4 / downside | 10,400.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2027q4_inv_balance | 2027Q4 / downside | 18,418.32 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q4_inv_daily, downside_2027q4_inv_days). |
| Cash source from inv downside_2027q4_inv_cash | 2027Q4 / downside | -1,675.26 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q3_inv_balance, downside_2027q4_inv_balance). |
| Standard quarter days downside_2027q4_ap_quarter_days | 2027Q4 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2027q4_ap_daily | 2027Q4 / downside | 177.10 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2027q4_cogs, downside_2027q4_ap_quarter_days). |
| Ending balance turnover days downside_2027q4_ap_days | 2027Q4 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2027q4_ap_balance | 2027Q4 / downside | 3,187.79 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2027q4_ap_daily, downside_2027q4_ap_days). |
| Cash source from ap downside_2027q4_ap_cash | 2027Q4 / downside | 344.63 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q4_ap_balance, downside_2027q3_ap_balance). |
| Depreciation and amortization downside_2027q4_da | 2027Q4 / downside | 19.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2027q4_profit_cash | 2027Q4 / downside | 950.87 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2027q4_operating_income, downside_2027q4_sbc, downside_2027q4_da). |
| Cash interest net of cash investment income downside_2027q4_interest | 2027Q4 / downside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2027q4_cash_tax | 2027Q4 / downside | 300.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2027q4_other_wc | 2027Q4 / downside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2027q4_cash_uses | 2027Q4 / downside | 475.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2027q4_interest, downside_2027q4_cash_tax, downside_2027q4_other_wc). |
| Cash profit after taxes and net interest downside_2027q4_cash_after_uses | 2027Q4 / downside | 475.87 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2027q4_profit_cash, downside_2027q4_cash_uses). |
| Cash before net deferred-revenue funding downside_2027q4_cfo_before_funding | 2027Q4 / downside | -2,005.62 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2027q4_cash_after_uses, downside_2027q4_ar_cash, downside_2027q4_inv_cash, downside_2027q4_ap_cash). |
| Net customer deferred-revenue cash source downside_2027q4_customer_funding | 2027Q4 / downside | -100.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2027q4_cfo | 2027Q4 / downside | -2,105.62 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2027q4_cfo_before_funding, downside_2027q4_customer_funding). |
| Cash PP&E purchases downside_2027q4_capex | 2027Q4 / downside | 85.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2027q4_fcf | 2027Q4 / downside | -2,190.62 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2027q4_cfo, downside_2027q4_capex). |
| Quarter-year dividend factor downside_2027q4_dividend_quarter | 2027Q4 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2027q4_preferred_cash | 2027Q4 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2027q4_dividend_quarter). |
| Equity-award tax withholding downside_2027q4_awards | 2027Q4 / downside | 46.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2027q4_capital_claims | 2027Q4 / downside | 121.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2027q4_preferred_cash, downside_2027q4_awards). |
| Cash after preferred and award taxes downside_2027q4_cash_after_claims | 2027Q4 / downside | -2,312.08 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2027q4_fcf, downside_2027q4_capital_claims). |
| FY2028 sales expansion downside_2028q1_growth | 2028Q1 / downside | 102.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share downside_2028q1_season | 2028Q1 / downside | 23.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2028q1_revenue | 2028Q1 / downside | 14,141.69 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(downside_annual_target, downside_2028q1_growth, downside_2028q1_season). |
| Gross margin downside_2028q1_gm | 2028Q1 / downside | 8.8% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2028q1_gross_profit | 2028Q1 / downside | 1,244.47 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2028q1_revenue, downside_2028q1_gm). |
| Cost of goods sold downside_2028q1_cogs | 2028Q1 / downside | 12,897.22 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2028q1_revenue, downside_2028q1_gross_profit). |
| Total stock compensation expense downside_2028q1_sbc | 2028Q1 / downside | 158.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2028q1_cogs_sbc | 2028Q1 / downside | 11.60 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2028q1_opex_sbc | 2028Q1 / downside | 146.40 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2028q1_sbc, downside_2028q1_cogs_sbc). |
| Operating costs excluding SBC downside_2028q1_cashopex | 2028Q1 / downside | 580.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2028q1_opex | 2028Q1 / downside | 726.40 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2028q1_cashopex, downside_2028q1_opex_sbc). |
| GAAP operating income downside_2028q1_operating_income | 2028Q1 / downside | 518.07 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2028q1_gross_profit, downside_2028q1_opex). |
| Standard quarter days downside_2028q1_ar_quarter_days | 2028Q1 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q1_ar_daily | 2028Q1 / downside | 157.13 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q1_revenue, downside_2028q1_ar_quarter_days). |
| Ending balance turnover days downside_2028q1_ar_days | 2028Q1 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2028q1_ar_balance | 2028Q1 / downside | 8,642.14 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q1_ar_daily, downside_2028q1_ar_days). |
| Cash source from ar downside_2028q1_ar_cash | 2028Q1 / downside | 2,003.17 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q4_ar_balance, downside_2028q1_ar_balance). |
| Standard quarter days downside_2028q1_inv_quarter_days | 2028Q1 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q1_inv_daily | 2028Q1 / downside | 143.30 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q1_cogs, downside_2028q1_inv_quarter_days). |
| Ending balance turnover days downside_2028q1_inv_days | 2028Q1 / downside | 10,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2028q1_inv_balance | 2028Q1 / downside | 14,616.85 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q1_inv_daily, downside_2028q1_inv_days). |
| Cash source from inv downside_2028q1_inv_cash | 2028Q1 / downside | 3,801.48 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2027q4_inv_balance, downside_2028q1_inv_balance). |
| Standard quarter days downside_2028q1_ap_quarter_days | 2028Q1 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q1_ap_daily | 2028Q1 / downside | 143.30 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q1_cogs, downside_2028q1_ap_quarter_days). |
| Ending balance turnover days downside_2028q1_ap_days | 2028Q1 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2028q1_ap_balance | 2028Q1 / downside | 2,579.44 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q1_ap_daily, downside_2028q1_ap_days). |
| Cash source from ap downside_2028q1_ap_cash | 2028Q1 / downside | -608.34 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q1_ap_balance, downside_2027q4_ap_balance). |
| Depreciation and amortization downside_2028q1_da | 2028Q1 / downside | 20.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2028q1_profit_cash | 2028Q1 / downside | 696.07 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2028q1_operating_income, downside_2028q1_sbc, downside_2028q1_da). |
| Cash interest net of cash investment income downside_2028q1_interest | 2028Q1 / downside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2028q1_cash_tax | 2028Q1 / downside | 280.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2028q1_other_wc | 2028Q1 / downside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2028q1_cash_uses | 2028Q1 / downside | 445.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2028q1_interest, downside_2028q1_cash_tax, downside_2028q1_other_wc). |
| Cash profit after taxes and net interest downside_2028q1_cash_after_uses | 2028Q1 / downside | 251.07 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2028q1_profit_cash, downside_2028q1_cash_uses). |
| Cash before net deferred-revenue funding downside_2028q1_cfo_before_funding | 2028Q1 / downside | 5,447.37 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2028q1_cash_after_uses, downside_2028q1_ar_cash, downside_2028q1_inv_cash, downside_2028q1_ap_cash). |
| Net customer deferred-revenue cash source downside_2028q1_customer_funding | 2028Q1 / downside | 0.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2028q1_cfo | 2028Q1 / downside | 5,447.37 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2028q1_cfo_before_funding, downside_2028q1_customer_funding). |
| Cash PP&E purchases downside_2028q1_capex | 2028Q1 / downside | 90.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2028q1_fcf | 2028Q1 / downside | 5,357.37 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2028q1_cfo, downside_2028q1_capex). |
| Quarter-year dividend factor downside_2028q1_dividend_quarter | 2028Q1 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2028q1_preferred_cash | 2028Q1 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2028q1_dividend_quarter). |
| Equity-award tax withholding downside_2028q1_awards | 2028Q1 / downside | 48.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2028q1_capital_claims | 2028Q1 / downside | 123.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2028q1_preferred_cash, downside_2028q1_awards). |
| Cash after preferred and award taxes downside_2028q1_cash_after_claims | 2028Q1 / downside | 5,233.90 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2028q1_fcf, downside_2028q1_capital_claims). |
| FY2028 sales expansion downside_2028q2_growth | 2028Q2 / downside | 102.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share downside_2028q2_season | 2028Q2 / downside | 24.5% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2028q2_revenue | 2028Q2 / downside | 15,063.97 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(downside_annual_target, downside_2028q2_growth, downside_2028q2_season). |
| Gross margin downside_2028q2_gm | 2028Q2 / downside | 8.8% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2028q2_gross_profit | 2028Q2 / downside | 1,325.63 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2028q2_revenue, downside_2028q2_gm). |
| Cost of goods sold downside_2028q2_cogs | 2028Q2 / downside | 13,738.34 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2028q2_revenue, downside_2028q2_gross_profit). |
| Total stock compensation expense downside_2028q2_sbc | 2028Q2 / downside | 163.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2028q2_cogs_sbc | 2028Q2 / downside | 12.00 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2028q2_opex_sbc | 2028Q2 / downside | 151.00 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2028q2_sbc, downside_2028q2_cogs_sbc). |
| Operating costs excluding SBC downside_2028q2_cashopex | 2028Q2 / downside | 600.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2028q2_opex | 2028Q2 / downside | 751.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2028q2_cashopex, downside_2028q2_opex_sbc). |
| GAAP operating income downside_2028q2_operating_income | 2028Q2 / downside | 574.63 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2028q2_gross_profit, downside_2028q2_opex). |
| Standard quarter days downside_2028q2_ar_quarter_days | 2028Q2 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q2_ar_daily | 2028Q2 / downside | 167.38 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q2_revenue, downside_2028q2_ar_quarter_days). |
| Ending balance turnover days downside_2028q2_ar_days | 2028Q2 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2028q2_ar_balance | 2028Q2 / downside | 9,205.76 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q2_ar_daily, downside_2028q2_ar_days). |
| Cash source from ar downside_2028q2_ar_cash | 2028Q2 / downside | -563.62 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q1_ar_balance, downside_2028q2_ar_balance). |
| Standard quarter days downside_2028q2_inv_quarter_days | 2028Q2 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q2_inv_daily | 2028Q2 / downside | 152.65 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q2_cogs, downside_2028q2_inv_quarter_days). |
| Ending balance turnover days downside_2028q2_inv_days | 2028Q2 / downside | 10,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2028q2_inv_balance | 2028Q2 / downside | 15,264.82 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q2_inv_daily, downside_2028q2_inv_days). |
| Cash source from inv downside_2028q2_inv_cash | 2028Q2 / downside | -647.98 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q1_inv_balance, downside_2028q2_inv_balance). |
| Standard quarter days downside_2028q2_ap_quarter_days | 2028Q2 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q2_ap_daily | 2028Q2 / downside | 152.65 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q2_cogs, downside_2028q2_ap_quarter_days). |
| Ending balance turnover days downside_2028q2_ap_days | 2028Q2 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2028q2_ap_balance | 2028Q2 / downside | 2,747.67 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q2_ap_daily, downside_2028q2_ap_days). |
| Cash source from ap downside_2028q2_ap_cash | 2028Q2 / downside | 168.22 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q2_ap_balance, downside_2028q1_ap_balance). |
| Depreciation and amortization downside_2028q2_da | 2028Q2 / downside | 21.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2028q2_profit_cash | 2028Q2 / downside | 758.63 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2028q2_operating_income, downside_2028q2_sbc, downside_2028q2_da). |
| Cash interest net of cash investment income downside_2028q2_interest | 2028Q2 / downside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2028q2_cash_tax | 2028Q2 / downside | 300.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2028q2_other_wc | 2028Q2 / downside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2028q2_cash_uses | 2028Q2 / downside | 465.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2028q2_interest, downside_2028q2_cash_tax, downside_2028q2_other_wc). |
| Cash profit after taxes and net interest downside_2028q2_cash_after_uses | 2028Q2 / downside | 293.63 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2028q2_profit_cash, downside_2028q2_cash_uses). |
| Cash before net deferred-revenue funding downside_2028q2_cfo_before_funding | 2028Q2 / downside | -749.74 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2028q2_cash_after_uses, downside_2028q2_ar_cash, downside_2028q2_inv_cash, downside_2028q2_ap_cash). |
| Net customer deferred-revenue cash source downside_2028q2_customer_funding | 2028Q2 / downside | 0.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2028q2_cfo | 2028Q2 / downside | -749.74 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2028q2_cfo_before_funding, downside_2028q2_customer_funding). |
| Cash PP&E purchases downside_2028q2_capex | 2028Q2 / downside | 95.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2028q2_fcf | 2028Q2 / downside | -844.74 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2028q2_cfo, downside_2028q2_capex). |
| Quarter-year dividend factor downside_2028q2_dividend_quarter | 2028Q2 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2028q2_preferred_cash | 2028Q2 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2028q2_dividend_quarter). |
| Equity-award tax withholding downside_2028q2_awards | 2028Q2 / downside | 50.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2028q2_capital_claims | 2028Q2 / downside | 125.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2028q2_preferred_cash, downside_2028q2_awards). |
| Cash after preferred and award taxes downside_2028q2_cash_after_claims | 2028Q2 / downside | -970.21 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2028q2_fcf, downside_2028q2_capital_claims). |
| FY2028 sales expansion downside_2028q3_growth | 2028Q3 / downside | 102.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share downside_2028q3_season | 2028Q3 / downside | 25.5% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2028q3_revenue | 2028Q3 / downside | 15,678.83 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(downside_annual_target, downside_2028q3_growth, downside_2028q3_season). |
| Gross margin downside_2028q3_gm | 2028Q3 / downside | 8.8% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2028q3_gross_profit | 2028Q3 / downside | 1,379.74 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2028q3_revenue, downside_2028q3_gm). |
| Cost of goods sold downside_2028q3_cogs | 2028Q3 / downside | 14,299.09 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2028q3_revenue, downside_2028q3_gross_profit). |
| Total stock compensation expense downside_2028q3_sbc | 2028Q3 / downside | 168.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2028q3_cogs_sbc | 2028Q3 / downside | 12.40 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2028q3_opex_sbc | 2028Q3 / downside | 155.60 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2028q3_sbc, downside_2028q3_cogs_sbc). |
| Operating costs excluding SBC downside_2028q3_cashopex | 2028Q3 / downside | 620.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2028q3_opex | 2028Q3 / downside | 775.60 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2028q3_cashopex, downside_2028q3_opex_sbc). |
| GAAP operating income downside_2028q3_operating_income | 2028Q3 / downside | 604.14 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2028q3_gross_profit, downside_2028q3_opex). |
| Standard quarter days downside_2028q3_ar_quarter_days | 2028Q3 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q3_ar_daily | 2028Q3 / downside | 174.21 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q3_revenue, downside_2028q3_ar_quarter_days). |
| Ending balance turnover days downside_2028q3_ar_days | 2028Q3 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2028q3_ar_balance | 2028Q3 / downside | 9,581.51 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q3_ar_daily, downside_2028q3_ar_days). |
| Cash source from ar downside_2028q3_ar_cash | 2028Q3 / downside | -375.75 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q2_ar_balance, downside_2028q3_ar_balance). |
| Standard quarter days downside_2028q3_inv_quarter_days | 2028Q3 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q3_inv_daily | 2028Q3 / downside | 158.88 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q3_cogs, downside_2028q3_inv_quarter_days). |
| Ending balance turnover days downside_2028q3_inv_days | 2028Q3 / downside | 10,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2028q3_inv_balance | 2028Q3 / downside | 15,887.88 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q3_inv_daily, downside_2028q3_inv_days). |
| Cash source from inv downside_2028q3_inv_cash | 2028Q3 / downside | -623.05 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q2_inv_balance, downside_2028q3_inv_balance). |
| Standard quarter days downside_2028q3_ap_quarter_days | 2028Q3 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q3_ap_daily | 2028Q3 / downside | 158.88 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q3_cogs, downside_2028q3_ap_quarter_days). |
| Ending balance turnover days downside_2028q3_ap_days | 2028Q3 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2028q3_ap_balance | 2028Q3 / downside | 2,859.82 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q3_ap_daily, downside_2028q3_ap_days). |
| Cash source from ap downside_2028q3_ap_cash | 2028Q3 / downside | 112.15 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q3_ap_balance, downside_2028q2_ap_balance). |
| Depreciation and amortization downside_2028q3_da | 2028Q3 / downside | 22.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2028q3_profit_cash | 2028Q3 / downside | 794.14 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2028q3_operating_income, downside_2028q3_sbc, downside_2028q3_da). |
| Cash interest net of cash investment income downside_2028q3_interest | 2028Q3 / downside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2028q3_cash_tax | 2028Q3 / downside | 320.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2028q3_other_wc | 2028Q3 / downside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2028q3_cash_uses | 2028Q3 / downside | 485.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2028q3_interest, downside_2028q3_cash_tax, downside_2028q3_other_wc). |
| Cash profit after taxes and net interest downside_2028q3_cash_after_uses | 2028Q3 / downside | 309.14 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2028q3_profit_cash, downside_2028q3_cash_uses). |
| Cash before net deferred-revenue funding downside_2028q3_cfo_before_funding | 2028Q3 / downside | -577.51 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2028q3_cash_after_uses, downside_2028q3_ar_cash, downside_2028q3_inv_cash, downside_2028q3_ap_cash). |
| Net customer deferred-revenue cash source downside_2028q3_customer_funding | 2028Q3 / downside | 0.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2028q3_cfo | 2028Q3 / downside | -577.51 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2028q3_cfo_before_funding, downside_2028q3_customer_funding). |
| Cash PP&E purchases downside_2028q3_capex | 2028Q3 / downside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2028q3_fcf | 2028Q3 / downside | -677.51 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2028q3_cfo, downside_2028q3_capex). |
| Quarter-year dividend factor downside_2028q3_dividend_quarter | 2028Q3 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2028q3_preferred_cash | 2028Q3 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2028q3_dividend_quarter). |
| Equity-award tax withholding downside_2028q3_awards | 2028Q3 / downside | 52.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2028q3_capital_claims | 2028Q3 / downside | 127.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2028q3_preferred_cash, downside_2028q3_awards). |
| Cash after preferred and award taxes downside_2028q3_cash_after_claims | 2028Q3 / downside | -804.98 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2028q3_fcf, downside_2028q3_capital_claims). |
| FY2028 sales expansion downside_2028q4_growth | 2028Q4 / downside | 102.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share downside_2028q4_season | 2028Q4 / downside | 27.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue downside_2028q4_revenue | 2028Q4 / downside | 16,601.11 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(downside_annual_target, downside_2028q4_growth, downside_2028q4_season). |
| Gross margin downside_2028q4_gm | 2028Q4 / downside | 8.8% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit downside_2028q4_gross_profit | 2028Q4 / downside | 1,460.90 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(downside_2028q4_revenue, downside_2028q4_gm). |
| Cost of goods sold downside_2028q4_cogs | 2028Q4 / downside | 15,140.21 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(downside_2028q4_revenue, downside_2028q4_gross_profit). |
| Total stock compensation expense downside_2028q4_sbc | 2028Q4 / downside | 173.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit downside_2028q4_cogs_sbc | 2028Q4 / downside | 12.80 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense downside_2028q4_opex_sbc | 2028Q4 / downside | 160.20 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(downside_2028q4_sbc, downside_2028q4_cogs_sbc). |
| Operating costs excluding SBC downside_2028q4_cashopex | 2028Q4 / downside | 640.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense downside_2028q4_opex | 2028Q4 / downside | 800.20 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(downside_2028q4_cashopex, downside_2028q4_opex_sbc). |
| GAAP operating income downside_2028q4_operating_income | 2028Q4 / downside | 660.70 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(downside_2028q4_gross_profit, downside_2028q4_opex). |
| Standard quarter days downside_2028q4_ar_quarter_days | 2028Q4 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q4_ar_daily | 2028Q4 / downside | 184.46 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q4_revenue, downside_2028q4_ar_quarter_days). |
| Ending balance turnover days downside_2028q4_ar_days | 2028Q4 / downside | 5,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables downside_2028q4_ar_balance | 2028Q4 / downside | 10,145.12 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q4_ar_daily, downside_2028q4_ar_days). |
| Cash source from ar downside_2028q4_ar_cash | 2028Q4 / downside | -563.62 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q3_ar_balance, downside_2028q4_ar_balance). |
| Standard quarter days downside_2028q4_inv_quarter_days | 2028Q4 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q4_inv_daily | 2028Q4 / downside | 168.22 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q4_cogs, downside_2028q4_inv_quarter_days). |
| Ending balance turnover days downside_2028q4_inv_days | 2028Q4 / downside | 10,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory downside_2028q4_inv_balance | 2028Q4 / downside | 16,822.46 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q4_inv_daily, downside_2028q4_inv_days). |
| Cash source from inv downside_2028q4_inv_cash | 2028Q4 / downside | -934.58 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q3_inv_balance, downside_2028q4_inv_balance). |
| Standard quarter days downside_2028q4_ap_quarter_days | 2028Q4 / downside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day downside_2028q4_ap_daily | 2028Q4 / downside | 168.22 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(downside_2028q4_cogs, downside_2028q4_ap_quarter_days). |
| Ending balance turnover days downside_2028q4_ap_days | 2028Q4 / downside | 1,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables downside_2028q4_ap_balance | 2028Q4 / downside | 3,028.04 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(downside_2028q4_ap_daily, downside_2028q4_ap_days). |
| Cash source from ap downside_2028q4_ap_cash | 2028Q4 / downside | 168.22 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(downside_2028q4_ap_balance, downside_2028q3_ap_balance). |
| Depreciation and amortization downside_2028q4_da | 2028Q4 / downside | 23.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense downside_2028q4_profit_cash | 2028Q4 / downside | 856.70 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(downside_2028q4_operating_income, downside_2028q4_sbc, downside_2028q4_da). |
| Cash interest net of cash investment income downside_2028q4_interest | 2028Q4 / downside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance downside_2028q4_cash_tax | 2028Q4 / downside | 350.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use downside_2028q4_other_wc | 2028Q4 / downside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses downside_2028q4_cash_uses | 2028Q4 / downside | 515.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(downside_2028q4_interest, downside_2028q4_cash_tax, downside_2028q4_other_wc). |
| Cash profit after taxes and net interest downside_2028q4_cash_after_uses | 2028Q4 / downside | 341.70 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(downside_2028q4_profit_cash, downside_2028q4_cash_uses). |
| Cash before net deferred-revenue funding downside_2028q4_cfo_before_funding | 2028Q4 / downside | -988.28 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(downside_2028q4_cash_after_uses, downside_2028q4_ar_cash, downside_2028q4_inv_cash, downside_2028q4_ap_cash). |
| Net customer deferred-revenue cash source downside_2028q4_customer_funding | 2028Q4 / downside | 0.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy downside_2028q4_cfo | 2028Q4 / downside | -988.28 USD_millions | derived: Customer funding enters cash only. Formula: sum(downside_2028q4_cfo_before_funding, downside_2028q4_customer_funding). |
| Cash PP&E purchases downside_2028q4_capex | 2028Q4 / downside | 105.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex downside_2028q4_fcf | 2028Q4 / downside | -1,093.28 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(downside_2028q4_cfo, downside_2028q4_capex). |
| Quarter-year dividend factor downside_2028q4_dividend_quarter | 2028Q4 / downside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend downside_2028q4_preferred_cash | 2028Q4 / downside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, downside_2028q4_dividend_quarter). |
| Equity-award tax withholding downside_2028q4_awards | 2028Q4 / downside | 54.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes downside_2028q4_capital_claims | 2028Q4 / downside | 129.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(downside_2028q4_preferred_cash, downside_2028q4_awards). |
| Cash after preferred and award taxes downside_2028q4_cash_after_claims | 2028Q4 / downside | -1,222.75 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(downside_2028q4_fcf, downside_2028q4_capital_claims). |
| Revenue ($M) downside_fy2027_revenue | FY2027 / downside | 60,280.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_revenue, downside_2027q2_revenue, downside_2027q3_revenue, downside_2027q4_revenue). |
| GAAP gross profit ($M) downside_fy2027_gross_profit | FY2027 / downside | 5,123.80 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_gross_profit, downside_2027q2_gross_profit, downside_2027q3_gross_profit, downside_2027q4_gross_profit). |
| GAAP operating income ($M) downside_fy2027_operating_income | FY2027 / downside | 2,464.20 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_operating_income, downside_2027q2_operating_income, downside_2027q3_operating_income, downside_2027q4_operating_income). |
| Cash before net deferred-revenue funding ($M) downside_fy2027_cfo_before_funding | FY2027 / downside | -7,625.29 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_cfo_before_funding, downside_2027q2_cfo_before_funding, downside_2027q3_cfo_before_funding, downside_2027q4_cfo_before_funding). |
| Net deferred-revenue cash source ($M) downside_fy2027_customer_funding | FY2027 / downside | 150.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_customer_funding, downside_2027q2_customer_funding, downside_2027q3_customer_funding, downside_2027q4_customer_funding). |
| Operating cash flow proxy ($M) downside_fy2027_cfo | FY2027 / downside | -7,475.29 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_cfo, downside_2027q2_cfo, downside_2027q3_cfo, downside_2027q4_cfo). |
| Cash PP&E purchases ($M) downside_fy2027_capex | FY2027 / downside | 310.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_capex, downside_2027q2_capex, downside_2027q3_capex, downside_2027q4_capex). |
| CFO less capex ($M) downside_fy2027_fcf | FY2027 / downside | -7,785.29 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_fcf, downside_2027q2_fcf, downside_2027q3_fcf, downside_2027q4_fcf). |
| Preferred cash dividend ($M) downside_fy2027_preferred_cash | FY2027 / downside | 290.14 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_preferred_cash, downside_2027q2_preferred_cash, downside_2027q3_preferred_cash, downside_2027q4_preferred_cash). |
| Cash after preferred and award taxes ($M) downside_fy2027_cash_after_claims | FY2027 / downside | -8,247.42 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2027q1_cash_after_claims, downside_2027q2_cash_after_claims, downside_2027q3_cash_after_claims, downside_2027q4_cash_after_claims). |
| Revenue ($M) downside_fy2028_revenue | FY2028 / downside | 61,485.60 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_revenue, downside_2028q2_revenue, downside_2028q3_revenue, downside_2028q4_revenue). |
| GAAP gross profit ($M) downside_fy2028_gross_profit | FY2028 / downside | 5,410.73 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_gross_profit, downside_2028q2_gross_profit, downside_2028q3_gross_profit, downside_2028q4_gross_profit). |
| GAAP operating income ($M) downside_fy2028_operating_income | FY2028 / downside | 2,357.53 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_operating_income, downside_2028q2_operating_income, downside_2028q3_operating_income, downside_2028q4_operating_income). |
| Cash before net deferred-revenue funding ($M) downside_fy2028_cfo_before_funding | FY2028 / downside | 3,131.84 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_cfo_before_funding, downside_2028q2_cfo_before_funding, downside_2028q3_cfo_before_funding, downside_2028q4_cfo_before_funding). |
| Net deferred-revenue cash source ($M) downside_fy2028_customer_funding | FY2028 / downside | 0.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_customer_funding, downside_2028q2_customer_funding, downside_2028q3_customer_funding, downside_2028q4_customer_funding). |
| Operating cash flow proxy ($M) downside_fy2028_cfo | FY2028 / downside | 3,131.84 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_cfo, downside_2028q2_cfo, downside_2028q3_cfo, downside_2028q4_cfo). |
| Cash PP&E purchases ($M) downside_fy2028_capex | FY2028 / downside | 390.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_capex, downside_2028q2_capex, downside_2028q3_capex, downside_2028q4_capex). |
| CFO less capex ($M) downside_fy2028_fcf | FY2028 / downside | 2,741.84 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_fcf, downside_2028q2_fcf, downside_2028q3_fcf, downside_2028q4_fcf). |
| Preferred cash dividend ($M) downside_fy2028_preferred_cash | FY2028 / downside | 301.88 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_preferred_cash, downside_2028q2_preferred_cash, downside_2028q3_preferred_cash, downside_2028q4_preferred_cash). |
| Cash after preferred and award taxes ($M) downside_fy2028_cash_after_claims | FY2028 / downside | 2,235.96 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(downside_2028q1_cash_after_claims, downside_2028q2_cash_after_claims, downside_2028q3_cash_after_claims, downside_2028q4_cash_after_claims). |
| Sales delivery / guidance midpoint base_delivery | FY2027 / base | 100.0% ratio | assumption: Desk delivery sensitivity. |
| FY2027 sales target base_annual_target | FY2027 / base | 68,500.00 USD_millions | derived: Base uses midpoint; no incremental order-book revenue. Formula: multiply(annual_guide, base_delivery). |
| Q1 sales target base_q1_target | 2027Q1 / base | 15,000.00 USD_millions | derived: Base uses quarterly midpoint. Formula: multiply(q1_guide, base_delivery). |
| Remaining FY2027 sales base_remaining | FY2027 / base | 53,500.00 USD_millions | derived: Separate Q1 anchor and remaining allocation. Formula: subtract(base_annual_target, base_q1_target). |
| Identity multiplier base_2027q1_one | 2027Q1 / base | 100.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2027q1_revenue | 2027Q1 / base | 15,000.00 USD_millions | derived: Q1 company guidance scenario. Formula: multiply(base_q1_target, base_2027q1_one). |
| Gross margin base_2027q1_gm | 2027Q1 / base | 11.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2027q1_gross_profit | 2027Q1 / base | 1,650.00 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2027q1_revenue, base_2027q1_gm). |
| Cost of goods sold base_2027q1_cogs | 2027Q1 / base | 13,350.00 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2027q1_revenue, base_2027q1_gross_profit). |
| Total stock compensation expense base_2027q1_sbc | 2027Q1 / base | 138.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2027q1_cogs_sbc | 2027Q1 / base | 10.00 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2027q1_opex_sbc | 2027Q1 / base | 128.00 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2027q1_sbc, base_2027q1_cogs_sbc). |
| Operating costs excluding SBC base_2027q1_cashopex | 2027Q1 / base | 485.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2027q1_opex | 2027Q1 / base | 613.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2027q1_cashopex, base_2027q1_opex_sbc). |
| GAAP operating income base_2027q1_operating_income | 2027Q1 / base | 1,037.00 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2027q1_gross_profit, base_2027q1_opex). |
| Standard quarter days base_2027q1_ar_quarter_days | 2027Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q1_ar_daily | 2027Q1 / base | 166.67 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q1_revenue, base_2027q1_ar_quarter_days). |
| Ending balance turnover days base_2027q1_ar_days | 2027Q1 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2027q1_ar_balance | 2027Q1 / base | 7,500.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q1_ar_daily, base_2027q1_ar_days). |
| Cash source from ar base_2027q1_ar_cash | 2027Q1 / base | -1,374.59 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(receivables, base_2027q1_ar_balance). |
| Standard quarter days base_2027q1_inv_quarter_days | 2027Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q1_inv_daily | 2027Q1 / base | 148.33 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q1_cogs, base_2027q1_inv_quarter_days). |
| Ending balance turnover days base_2027q1_inv_days | 2027Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2027q1_inv_balance | 2027Q1 / base | 13,350.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q1_inv_daily, base_2027q1_inv_days). |
| Cash source from inv base_2027q1_inv_cash | 2027Q1 / base | -454.05 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(inventory, base_2027q1_inv_balance). |
| Standard quarter days base_2027q1_ap_quarter_days | 2027Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q1_ap_daily | 2027Q1 / base | 148.33 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q1_cogs, base_2027q1_ap_quarter_days). |
| Ending balance turnover days base_2027q1_ap_days | 2027Q1 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2027q1_ap_balance | 2027Q1 / base | 2,966.67 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q1_ap_daily, base_2027q1_ap_days). |
| Cash source from ap base_2027q1_ap_cash | 2027Q1 / base | 719.66 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q1_ap_balance, payables). |
| Depreciation and amortization base_2027q1_da | 2027Q1 / base | 16.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2027q1_profit_cash | 2027Q1 / base | 1,191.00 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2027q1_operating_income, base_2027q1_sbc, base_2027q1_da). |
| Cash interest net of cash investment income base_2027q1_interest | 2027Q1 / base | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2027q1_cash_tax | 2027Q1 / base | 180.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2027q1_other_wc | 2027Q1 / base | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2027q1_cash_uses | 2027Q1 / base | 355.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2027q1_interest, base_2027q1_cash_tax, base_2027q1_other_wc). |
| Cash profit after taxes and net interest base_2027q1_cash_after_uses | 2027Q1 / base | 836.00 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2027q1_profit_cash, base_2027q1_cash_uses). |
| Cash before net deferred-revenue funding base_2027q1_cfo_before_funding | 2027Q1 / base | -272.97 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2027q1_cash_after_uses, base_2027q1_ar_cash, base_2027q1_inv_cash, base_2027q1_ap_cash). |
| Net customer deferred-revenue cash source base_2027q1_customer_funding | 2027Q1 / base | 500.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2027q1_cfo | 2027Q1 / base | 227.03 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2027q1_cfo_before_funding, base_2027q1_customer_funding). |
| Cash PP&E purchases base_2027q1_capex | 2027Q1 / base | 70.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2027q1_fcf | 2027Q1 / base | 157.03 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2027q1_cfo, base_2027q1_capex). |
| Initial dividend multiplier base_2027q1_dividend_factor | 2027Q1 / base | 100.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2027q1_preferred_cash | 2027Q1 / base | 63.73 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(initial_preferred_cash, base_2027q1_dividend_factor). |
| Equity-award tax withholding base_2027q1_awards | 2027Q1 / base | 40.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2027q1_capital_claims | 2027Q1 / base | 103.73 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2027q1_preferred_cash, base_2027q1_awards). |
| Cash after preferred and award taxes base_2027q1_cash_after_claims | 2027Q1 / base | 53.30 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2027q1_fcf, base_2027q1_capital_claims). |
| Remaining sales share base_2027q2_remaining_share | 2027Q2 / base | 30.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2027q2_revenue | 2027Q2 / base | 16,050.00 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(base_remaining, base_2027q2_remaining_share). |
| Gross margin base_2027q2_gm | 2027Q2 / base | 11.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2027q2_gross_profit | 2027Q2 / base | 1,765.50 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2027q2_revenue, base_2027q2_gm). |
| Cost of goods sold base_2027q2_cogs | 2027Q2 / base | 14,284.50 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2027q2_revenue, base_2027q2_gross_profit). |
| Total stock compensation expense base_2027q2_sbc | 2027Q2 / base | 143.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2027q2_cogs_sbc | 2027Q2 / base | 10.40 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2027q2_opex_sbc | 2027Q2 / base | 132.60 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2027q2_sbc, base_2027q2_cogs_sbc). |
| Operating costs excluding SBC base_2027q2_cashopex | 2027Q2 / base | 504.40 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2027q2_opex | 2027Q2 / base | 637.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2027q2_cashopex, base_2027q2_opex_sbc). |
| GAAP operating income base_2027q2_operating_income | 2027Q2 / base | 1,128.50 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2027q2_gross_profit, base_2027q2_opex). |
| Standard quarter days base_2027q2_ar_quarter_days | 2027Q2 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q2_ar_daily | 2027Q2 / base | 178.33 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q2_revenue, base_2027q2_ar_quarter_days). |
| Ending balance turnover days base_2027q2_ar_days | 2027Q2 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2027q2_ar_balance | 2027Q2 / base | 8,025.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q2_ar_daily, base_2027q2_ar_days). |
| Cash source from ar base_2027q2_ar_cash | 2027Q2 / base | -525.00 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q1_ar_balance, base_2027q2_ar_balance). |
| Standard quarter days base_2027q2_inv_quarter_days | 2027Q2 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q2_inv_daily | 2027Q2 / base | 158.72 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q2_cogs, base_2027q2_inv_quarter_days). |
| Ending balance turnover days base_2027q2_inv_days | 2027Q2 / base | 8,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2027q2_inv_balance | 2027Q2 / base | 13,967.07 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q2_inv_daily, base_2027q2_inv_days). |
| Cash source from inv base_2027q2_inv_cash | 2027Q2 / base | -617.07 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q1_inv_balance, base_2027q2_inv_balance). |
| Standard quarter days base_2027q2_ap_quarter_days | 2027Q2 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q2_ap_daily | 2027Q2 / base | 158.72 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q2_cogs, base_2027q2_ap_quarter_days). |
| Ending balance turnover days base_2027q2_ap_days | 2027Q2 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2027q2_ap_balance | 2027Q2 / base | 3,174.33 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q2_ap_daily, base_2027q2_ap_days). |
| Cash source from ap base_2027q2_ap_cash | 2027Q2 / base | 207.67 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q2_ap_balance, base_2027q1_ap_balance). |
| Depreciation and amortization base_2027q2_da | 2027Q2 / base | 17.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2027q2_profit_cash | 2027Q2 / base | 1,288.50 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2027q2_operating_income, base_2027q2_sbc, base_2027q2_da). |
| Cash interest net of cash investment income base_2027q2_interest | 2027Q2 / base | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2027q2_cash_tax | 2027Q2 / base | 220.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2027q2_other_wc | 2027Q2 / base | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2027q2_cash_uses | 2027Q2 / base | 395.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2027q2_interest, base_2027q2_cash_tax, base_2027q2_other_wc). |
| Cash profit after taxes and net interest base_2027q2_cash_after_uses | 2027Q2 / base | 893.50 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2027q2_profit_cash, base_2027q2_cash_uses). |
| Cash before net deferred-revenue funding base_2027q2_cfo_before_funding | 2027Q2 / base | -40.90 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2027q2_cash_after_uses, base_2027q2_ar_cash, base_2027q2_inv_cash, base_2027q2_ap_cash). |
| Net customer deferred-revenue cash source base_2027q2_customer_funding | 2027Q2 / base | 500.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2027q2_cfo | 2027Q2 / base | 459.10 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2027q2_cfo_before_funding, base_2027q2_customer_funding). |
| Cash PP&E purchases base_2027q2_capex | 2027Q2 / base | 75.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2027q2_fcf | 2027Q2 / base | 384.10 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2027q2_cfo, base_2027q2_capex). |
| Quarter-year dividend factor base_2027q2_dividend_quarter | 2027Q2 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2027q2_preferred_cash | 2027Q2 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2027q2_dividend_quarter). |
| Equity-award tax withholding base_2027q2_awards | 2027Q2 / base | 42.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2027q2_capital_claims | 2027Q2 / base | 117.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2027q2_preferred_cash, base_2027q2_awards). |
| Cash after preferred and award taxes base_2027q2_cash_after_claims | 2027Q2 / base | 266.63 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2027q2_fcf, base_2027q2_capital_claims). |
| Remaining sales share base_2027q3_remaining_share | 2027Q3 / base | 33.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2027q3_revenue | 2027Q3 / base | 17,655.00 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(base_remaining, base_2027q3_remaining_share). |
| Gross margin base_2027q3_gm | 2027Q3 / base | 11.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2027q3_gross_profit | 2027Q3 / base | 1,942.05 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2027q3_revenue, base_2027q3_gm). |
| Cost of goods sold base_2027q3_cogs | 2027Q3 / base | 15,712.95 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2027q3_revenue, base_2027q3_gross_profit). |
| Total stock compensation expense base_2027q3_sbc | 2027Q3 / base | 148.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2027q3_cogs_sbc | 2027Q3 / base | 10.80 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2027q3_opex_sbc | 2027Q3 / base | 137.20 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2027q3_sbc, base_2027q3_cogs_sbc). |
| Operating costs excluding SBC base_2027q3_cashopex | 2027Q3 / base | 523.80 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2027q3_opex | 2027Q3 / base | 661.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2027q3_cashopex, base_2027q3_opex_sbc). |
| GAAP operating income base_2027q3_operating_income | 2027Q3 / base | 1,281.05 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2027q3_gross_profit, base_2027q3_opex). |
| Standard quarter days base_2027q3_ar_quarter_days | 2027Q3 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q3_ar_daily | 2027Q3 / base | 196.17 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q3_revenue, base_2027q3_ar_quarter_days). |
| Ending balance turnover days base_2027q3_ar_days | 2027Q3 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2027q3_ar_balance | 2027Q3 / base | 8,827.50 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q3_ar_daily, base_2027q3_ar_days). |
| Cash source from ar base_2027q3_ar_cash | 2027Q3 / base | -802.50 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q2_ar_balance, base_2027q3_ar_balance). |
| Standard quarter days base_2027q3_inv_quarter_days | 2027Q3 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q3_inv_daily | 2027Q3 / base | 174.59 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q3_cogs, base_2027q3_inv_quarter_days). |
| Ending balance turnover days base_2027q3_inv_days | 2027Q3 / base | 8,600.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2027q3_inv_balance | 2027Q3 / base | 15,014.60 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q3_inv_daily, base_2027q3_inv_days). |
| Cash source from inv base_2027q3_inv_cash | 2027Q3 / base | -1,047.53 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q2_inv_balance, base_2027q3_inv_balance). |
| Standard quarter days base_2027q3_ap_quarter_days | 2027Q3 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q3_ap_daily | 2027Q3 / base | 174.59 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q3_cogs, base_2027q3_ap_quarter_days). |
| Ending balance turnover days base_2027q3_ap_days | 2027Q3 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2027q3_ap_balance | 2027Q3 / base | 3,491.77 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q3_ap_daily, base_2027q3_ap_days). |
| Cash source from ap base_2027q3_ap_cash | 2027Q3 / base | 317.43 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q3_ap_balance, base_2027q2_ap_balance). |
| Depreciation and amortization base_2027q3_da | 2027Q3 / base | 18.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2027q3_profit_cash | 2027Q3 / base | 1,447.05 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2027q3_operating_income, base_2027q3_sbc, base_2027q3_da). |
| Cash interest net of cash investment income base_2027q3_interest | 2027Q3 / base | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2027q3_cash_tax | 2027Q3 / base | 240.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2027q3_other_wc | 2027Q3 / base | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2027q3_cash_uses | 2027Q3 / base | 415.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2027q3_interest, base_2027q3_cash_tax, base_2027q3_other_wc). |
| Cash profit after taxes and net interest base_2027q3_cash_after_uses | 2027Q3 / base | 1,032.05 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2027q3_profit_cash, base_2027q3_cash_uses). |
| Cash before net deferred-revenue funding base_2027q3_cfo_before_funding | 2027Q3 / base | -500.55 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2027q3_cash_after_uses, base_2027q3_ar_cash, base_2027q3_inv_cash, base_2027q3_ap_cash). |
| Net customer deferred-revenue cash source base_2027q3_customer_funding | 2027Q3 / base | 350.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2027q3_cfo | 2027Q3 / base | -150.55 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2027q3_cfo_before_funding, base_2027q3_customer_funding). |
| Cash PP&E purchases base_2027q3_capex | 2027Q3 / base | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2027q3_fcf | 2027Q3 / base | -230.55 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2027q3_cfo, base_2027q3_capex). |
| Quarter-year dividend factor base_2027q3_dividend_quarter | 2027Q3 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2027q3_preferred_cash | 2027Q3 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2027q3_dividend_quarter). |
| Equity-award tax withholding base_2027q3_awards | 2027Q3 / base | 44.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2027q3_capital_claims | 2027Q3 / base | 119.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2027q3_preferred_cash, base_2027q3_awards). |
| Cash after preferred and award taxes base_2027q3_cash_after_claims | 2027Q3 / base | -350.02 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2027q3_fcf, base_2027q3_capital_claims). |
| Remaining sales share base_2027q4_remaining_share | 2027Q4 / base | 37.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2027q4_revenue | 2027Q4 / base | 19,795.00 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(base_remaining, base_2027q4_remaining_share). |
| Gross margin base_2027q4_gm | 2027Q4 / base | 11.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2027q4_gross_profit | 2027Q4 / base | 2,177.45 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2027q4_revenue, base_2027q4_gm). |
| Cost of goods sold base_2027q4_cogs | 2027Q4 / base | 17,617.55 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2027q4_revenue, base_2027q4_gross_profit). |
| Total stock compensation expense base_2027q4_sbc | 2027Q4 / base | 153.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2027q4_cogs_sbc | 2027Q4 / base | 11.20 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2027q4_opex_sbc | 2027Q4 / base | 141.80 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2027q4_sbc, base_2027q4_cogs_sbc). |
| Operating costs excluding SBC base_2027q4_cashopex | 2027Q4 / base | 543.20 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2027q4_opex | 2027Q4 / base | 685.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2027q4_cashopex, base_2027q4_opex_sbc). |
| GAAP operating income base_2027q4_operating_income | 2027Q4 / base | 1,492.45 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2027q4_gross_profit, base_2027q4_opex). |
| Standard quarter days base_2027q4_ar_quarter_days | 2027Q4 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q4_ar_daily | 2027Q4 / base | 219.94 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q4_revenue, base_2027q4_ar_quarter_days). |
| Ending balance turnover days base_2027q4_ar_days | 2027Q4 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2027q4_ar_balance | 2027Q4 / base | 9,897.50 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q4_ar_daily, base_2027q4_ar_days). |
| Cash source from ar base_2027q4_ar_cash | 2027Q4 / base | -1,070.00 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q3_ar_balance, base_2027q4_ar_balance). |
| Standard quarter days base_2027q4_inv_quarter_days | 2027Q4 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q4_inv_daily | 2027Q4 / base | 195.75 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q4_cogs, base_2027q4_inv_quarter_days). |
| Ending balance turnover days base_2027q4_inv_days | 2027Q4 / base | 8,400.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2027q4_inv_balance | 2027Q4 / base | 16,443.05 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q4_inv_daily, base_2027q4_inv_days). |
| Cash source from inv base_2027q4_inv_cash | 2027Q4 / base | -1,428.45 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q3_inv_balance, base_2027q4_inv_balance). |
| Standard quarter days base_2027q4_ap_quarter_days | 2027Q4 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2027q4_ap_daily | 2027Q4 / base | 195.75 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2027q4_cogs, base_2027q4_ap_quarter_days). |
| Ending balance turnover days base_2027q4_ap_days | 2027Q4 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2027q4_ap_balance | 2027Q4 / base | 3,915.01 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2027q4_ap_daily, base_2027q4_ap_days). |
| Cash source from ap base_2027q4_ap_cash | 2027Q4 / base | 423.24 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q4_ap_balance, base_2027q3_ap_balance). |
| Depreciation and amortization base_2027q4_da | 2027Q4 / base | 19.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2027q4_profit_cash | 2027Q4 / base | 1,664.45 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2027q4_operating_income, base_2027q4_sbc, base_2027q4_da). |
| Cash interest net of cash investment income base_2027q4_interest | 2027Q4 / base | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2027q4_cash_tax | 2027Q4 / base | 300.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2027q4_other_wc | 2027Q4 / base | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2027q4_cash_uses | 2027Q4 / base | 475.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2027q4_interest, base_2027q4_cash_tax, base_2027q4_other_wc). |
| Cash profit after taxes and net interest base_2027q4_cash_after_uses | 2027Q4 / base | 1,189.45 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2027q4_profit_cash, base_2027q4_cash_uses). |
| Cash before net deferred-revenue funding base_2027q4_cfo_before_funding | 2027Q4 / base | -885.76 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2027q4_cash_after_uses, base_2027q4_ar_cash, base_2027q4_inv_cash, base_2027q4_ap_cash). |
| Net customer deferred-revenue cash source base_2027q4_customer_funding | 2027Q4 / base | 150.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2027q4_cfo | 2027Q4 / base | -735.76 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2027q4_cfo_before_funding, base_2027q4_customer_funding). |
| Cash PP&E purchases base_2027q4_capex | 2027Q4 / base | 85.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2027q4_fcf | 2027Q4 / base | -820.76 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2027q4_cfo, base_2027q4_capex). |
| Quarter-year dividend factor base_2027q4_dividend_quarter | 2027Q4 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2027q4_preferred_cash | 2027Q4 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2027q4_dividend_quarter). |
| Equity-award tax withholding base_2027q4_awards | 2027Q4 / base | 46.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2027q4_capital_claims | 2027Q4 / base | 121.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2027q4_preferred_cash, base_2027q4_awards). |
| Cash after preferred and award taxes base_2027q4_cash_after_claims | 2027Q4 / base | -942.22 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2027q4_fcf, base_2027q4_capital_claims). |
| FY2028 sales expansion base_2028q1_growth | 2028Q1 / base | 120.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share base_2028q1_season | 2028Q1 / base | 23.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2028q1_revenue | 2028Q1 / base | 18,906.00 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(base_annual_target, base_2028q1_growth, base_2028q1_season). |
| Gross margin base_2028q1_gm | 2028Q1 / base | 11.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2028q1_gross_profit | 2028Q1 / base | 2,136.38 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2028q1_revenue, base_2028q1_gm). |
| Cost of goods sold base_2028q1_cogs | 2028Q1 / base | 16,769.62 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2028q1_revenue, base_2028q1_gross_profit). |
| Total stock compensation expense base_2028q1_sbc | 2028Q1 / base | 158.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2028q1_cogs_sbc | 2028Q1 / base | 11.60 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2028q1_opex_sbc | 2028Q1 / base | 146.40 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2028q1_sbc, base_2028q1_cogs_sbc). |
| Operating costs excluding SBC base_2028q1_cashopex | 2028Q1 / base | 562.60 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2028q1_opex | 2028Q1 / base | 709.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2028q1_cashopex, base_2028q1_opex_sbc). |
| GAAP operating income base_2028q1_operating_income | 2028Q1 / base | 1,427.38 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2028q1_gross_profit, base_2028q1_opex). |
| Standard quarter days base_2028q1_ar_quarter_days | 2028Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q1_ar_daily | 2028Q1 / base | 210.07 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q1_revenue, base_2028q1_ar_quarter_days). |
| Ending balance turnover days base_2028q1_ar_days | 2028Q1 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2028q1_ar_balance | 2028Q1 / base | 9,453.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q1_ar_daily, base_2028q1_ar_days). |
| Cash source from ar base_2028q1_ar_cash | 2028Q1 / base | 444.50 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q4_ar_balance, base_2028q1_ar_balance). |
| Standard quarter days base_2028q1_inv_quarter_days | 2028Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q1_inv_daily | 2028Q1 / base | 186.33 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q1_cogs, base_2028q1_inv_quarter_days). |
| Ending balance turnover days base_2028q1_inv_days | 2028Q1 / base | 8,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2028q1_inv_balance | 2028Q1 / base | 15,278.99 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q1_inv_daily, base_2028q1_inv_days). |
| Cash source from inv base_2028q1_inv_cash | 2028Q1 / base | 1,164.06 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2027q4_inv_balance, base_2028q1_inv_balance). |
| Standard quarter days base_2028q1_ap_quarter_days | 2028Q1 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q1_ap_daily | 2028Q1 / base | 186.33 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q1_cogs, base_2028q1_ap_quarter_days). |
| Ending balance turnover days base_2028q1_ap_days | 2028Q1 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2028q1_ap_balance | 2028Q1 / base | 3,726.58 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q1_ap_daily, base_2028q1_ap_days). |
| Cash source from ap base_2028q1_ap_cash | 2028Q1 / base | -188.43 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q1_ap_balance, base_2027q4_ap_balance). |
| Depreciation and amortization base_2028q1_da | 2028Q1 / base | 20.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2028q1_profit_cash | 2028Q1 / base | 1,605.38 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2028q1_operating_income, base_2028q1_sbc, base_2028q1_da). |
| Cash interest net of cash investment income base_2028q1_interest | 2028Q1 / base | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2028q1_cash_tax | 2028Q1 / base | 280.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2028q1_other_wc | 2028Q1 / base | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2028q1_cash_uses | 2028Q1 / base | 445.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2028q1_interest, base_2028q1_cash_tax, base_2028q1_other_wc). |
| Cash profit after taxes and net interest base_2028q1_cash_after_uses | 2028Q1 / base | 1,160.38 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2028q1_profit_cash, base_2028q1_cash_uses). |
| Cash before net deferred-revenue funding base_2028q1_cfo_before_funding | 2028Q1 / base | 2,580.51 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2028q1_cash_after_uses, base_2028q1_ar_cash, base_2028q1_inv_cash, base_2028q1_ap_cash). |
| Net customer deferred-revenue cash source base_2028q1_customer_funding | 2028Q1 / base | 200.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2028q1_cfo | 2028Q1 / base | 2,780.51 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2028q1_cfo_before_funding, base_2028q1_customer_funding). |
| Cash PP&E purchases base_2028q1_capex | 2028Q1 / base | 90.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2028q1_fcf | 2028Q1 / base | 2,690.51 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2028q1_cfo, base_2028q1_capex). |
| Quarter-year dividend factor base_2028q1_dividend_quarter | 2028Q1 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2028q1_preferred_cash | 2028Q1 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2028q1_dividend_quarter). |
| Equity-award tax withholding base_2028q1_awards | 2028Q1 / base | 48.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2028q1_capital_claims | 2028Q1 / base | 123.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2028q1_preferred_cash, base_2028q1_awards). |
| Cash after preferred and award taxes base_2028q1_cash_after_claims | 2028Q1 / base | 2,567.04 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2028q1_fcf, base_2028q1_capital_claims). |
| FY2028 sales expansion base_2028q2_growth | 2028Q2 / base | 120.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share base_2028q2_season | 2028Q2 / base | 24.5% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2028q2_revenue | 2028Q2 / base | 20,139.00 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(base_annual_target, base_2028q2_growth, base_2028q2_season). |
| Gross margin base_2028q2_gm | 2028Q2 / base | 11.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2028q2_gross_profit | 2028Q2 / base | 2,275.71 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2028q2_revenue, base_2028q2_gm). |
| Cost of goods sold base_2028q2_cogs | 2028Q2 / base | 17,863.29 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2028q2_revenue, base_2028q2_gross_profit). |
| Total stock compensation expense base_2028q2_sbc | 2028Q2 / base | 163.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2028q2_cogs_sbc | 2028Q2 / base | 12.00 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2028q2_opex_sbc | 2028Q2 / base | 151.00 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2028q2_sbc, base_2028q2_cogs_sbc). |
| Operating costs excluding SBC base_2028q2_cashopex | 2028Q2 / base | 582.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2028q2_opex | 2028Q2 / base | 733.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2028q2_cashopex, base_2028q2_opex_sbc). |
| GAAP operating income base_2028q2_operating_income | 2028Q2 / base | 1,542.71 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2028q2_gross_profit, base_2028q2_opex). |
| Standard quarter days base_2028q2_ar_quarter_days | 2028Q2 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q2_ar_daily | 2028Q2 / base | 223.77 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q2_revenue, base_2028q2_ar_quarter_days). |
| Ending balance turnover days base_2028q2_ar_days | 2028Q2 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2028q2_ar_balance | 2028Q2 / base | 10,069.50 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q2_ar_daily, base_2028q2_ar_days). |
| Cash source from ar base_2028q2_ar_cash | 2028Q2 / base | -616.50 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q1_ar_balance, base_2028q2_ar_balance). |
| Standard quarter days base_2028q2_inv_quarter_days | 2028Q2 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q2_inv_daily | 2028Q2 / base | 198.48 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q2_cogs, base_2028q2_inv_quarter_days). |
| Ending balance turnover days base_2028q2_inv_days | 2028Q2 / base | 8,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2028q2_inv_balance | 2028Q2 / base | 15,878.48 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q2_inv_daily, base_2028q2_inv_days). |
| Cash source from inv base_2028q2_inv_cash | 2028Q2 / base | -599.49 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q1_inv_balance, base_2028q2_inv_balance). |
| Standard quarter days base_2028q2_ap_quarter_days | 2028Q2 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q2_ap_daily | 2028Q2 / base | 198.48 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q2_cogs, base_2028q2_ap_quarter_days). |
| Ending balance turnover days base_2028q2_ap_days | 2028Q2 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2028q2_ap_balance | 2028Q2 / base | 3,969.62 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q2_ap_daily, base_2028q2_ap_days). |
| Cash source from ap base_2028q2_ap_cash | 2028Q2 / base | 243.04 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q2_ap_balance, base_2028q1_ap_balance). |
| Depreciation and amortization base_2028q2_da | 2028Q2 / base | 21.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2028q2_profit_cash | 2028Q2 / base | 1,726.71 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2028q2_operating_income, base_2028q2_sbc, base_2028q2_da). |
| Cash interest net of cash investment income base_2028q2_interest | 2028Q2 / base | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2028q2_cash_tax | 2028Q2 / base | 300.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2028q2_other_wc | 2028Q2 / base | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2028q2_cash_uses | 2028Q2 / base | 465.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2028q2_interest, base_2028q2_cash_tax, base_2028q2_other_wc). |
| Cash profit after taxes and net interest base_2028q2_cash_after_uses | 2028Q2 / base | 1,261.71 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2028q2_profit_cash, base_2028q2_cash_uses). |
| Cash before net deferred-revenue funding base_2028q2_cfo_before_funding | 2028Q2 / base | 288.75 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2028q2_cash_after_uses, base_2028q2_ar_cash, base_2028q2_inv_cash, base_2028q2_ap_cash). |
| Net customer deferred-revenue cash source base_2028q2_customer_funding | 2028Q2 / base | 200.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2028q2_cfo | 2028Q2 / base | 488.75 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2028q2_cfo_before_funding, base_2028q2_customer_funding). |
| Cash PP&E purchases base_2028q2_capex | 2028Q2 / base | 95.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2028q2_fcf | 2028Q2 / base | 393.75 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2028q2_cfo, base_2028q2_capex). |
| Quarter-year dividend factor base_2028q2_dividend_quarter | 2028Q2 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2028q2_preferred_cash | 2028Q2 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2028q2_dividend_quarter). |
| Equity-award tax withholding base_2028q2_awards | 2028Q2 / base | 50.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2028q2_capital_claims | 2028Q2 / base | 125.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2028q2_preferred_cash, base_2028q2_awards). |
| Cash after preferred and award taxes base_2028q2_cash_after_claims | 2028Q2 / base | 268.28 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2028q2_fcf, base_2028q2_capital_claims). |
| FY2028 sales expansion base_2028q3_growth | 2028Q3 / base | 120.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share base_2028q3_season | 2028Q3 / base | 25.5% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2028q3_revenue | 2028Q3 / base | 20,961.00 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(base_annual_target, base_2028q3_growth, base_2028q3_season). |
| Gross margin base_2028q3_gm | 2028Q3 / base | 11.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2028q3_gross_profit | 2028Q3 / base | 2,368.59 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2028q3_revenue, base_2028q3_gm). |
| Cost of goods sold base_2028q3_cogs | 2028Q3 / base | 18,592.41 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2028q3_revenue, base_2028q3_gross_profit). |
| Total stock compensation expense base_2028q3_sbc | 2028Q3 / base | 168.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2028q3_cogs_sbc | 2028Q3 / base | 12.40 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2028q3_opex_sbc | 2028Q3 / base | 155.60 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2028q3_sbc, base_2028q3_cogs_sbc). |
| Operating costs excluding SBC base_2028q3_cashopex | 2028Q3 / base | 601.40 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2028q3_opex | 2028Q3 / base | 757.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2028q3_cashopex, base_2028q3_opex_sbc). |
| GAAP operating income base_2028q3_operating_income | 2028Q3 / base | 1,611.59 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2028q3_gross_profit, base_2028q3_opex). |
| Standard quarter days base_2028q3_ar_quarter_days | 2028Q3 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q3_ar_daily | 2028Q3 / base | 232.90 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q3_revenue, base_2028q3_ar_quarter_days). |
| Ending balance turnover days base_2028q3_ar_days | 2028Q3 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2028q3_ar_balance | 2028Q3 / base | 10,480.50 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q3_ar_daily, base_2028q3_ar_days). |
| Cash source from ar base_2028q3_ar_cash | 2028Q3 / base | -411.00 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q2_ar_balance, base_2028q3_ar_balance). |
| Standard quarter days base_2028q3_inv_quarter_days | 2028Q3 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q3_inv_daily | 2028Q3 / base | 206.58 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q3_cogs, base_2028q3_inv_quarter_days). |
| Ending balance turnover days base_2028q3_inv_days | 2028Q3 / base | 8,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2028q3_inv_balance | 2028Q3 / base | 16,526.58 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q3_inv_daily, base_2028q3_inv_days). |
| Cash source from inv base_2028q3_inv_cash | 2028Q3 / base | -648.10 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q2_inv_balance, base_2028q3_inv_balance). |
| Standard quarter days base_2028q3_ap_quarter_days | 2028Q3 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q3_ap_daily | 2028Q3 / base | 206.58 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q3_cogs, base_2028q3_ap_quarter_days). |
| Ending balance turnover days base_2028q3_ap_days | 2028Q3 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2028q3_ap_balance | 2028Q3 / base | 4,131.65 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q3_ap_daily, base_2028q3_ap_days). |
| Cash source from ap base_2028q3_ap_cash | 2028Q3 / base | 162.03 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q3_ap_balance, base_2028q2_ap_balance). |
| Depreciation and amortization base_2028q3_da | 2028Q3 / base | 22.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2028q3_profit_cash | 2028Q3 / base | 1,801.59 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2028q3_operating_income, base_2028q3_sbc, base_2028q3_da). |
| Cash interest net of cash investment income base_2028q3_interest | 2028Q3 / base | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2028q3_cash_tax | 2028Q3 / base | 320.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2028q3_other_wc | 2028Q3 / base | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2028q3_cash_uses | 2028Q3 / base | 485.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2028q3_interest, base_2028q3_cash_tax, base_2028q3_other_wc). |
| Cash profit after taxes and net interest base_2028q3_cash_after_uses | 2028Q3 / base | 1,316.59 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2028q3_profit_cash, base_2028q3_cash_uses). |
| Cash before net deferred-revenue funding base_2028q3_cfo_before_funding | 2028Q3 / base | 419.52 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2028q3_cash_after_uses, base_2028q3_ar_cash, base_2028q3_inv_cash, base_2028q3_ap_cash). |
| Net customer deferred-revenue cash source base_2028q3_customer_funding | 2028Q3 / base | 100.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2028q3_cfo | 2028Q3 / base | 519.52 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2028q3_cfo_before_funding, base_2028q3_customer_funding). |
| Cash PP&E purchases base_2028q3_capex | 2028Q3 / base | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2028q3_fcf | 2028Q3 / base | 419.52 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2028q3_cfo, base_2028q3_capex). |
| Quarter-year dividend factor base_2028q3_dividend_quarter | 2028Q3 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2028q3_preferred_cash | 2028Q3 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2028q3_dividend_quarter). |
| Equity-award tax withholding base_2028q3_awards | 2028Q3 / base | 52.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2028q3_capital_claims | 2028Q3 / base | 127.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2028q3_preferred_cash, base_2028q3_awards). |
| Cash after preferred and award taxes base_2028q3_cash_after_claims | 2028Q3 / base | 292.05 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2028q3_fcf, base_2028q3_capital_claims). |
| FY2028 sales expansion base_2028q4_growth | 2028Q4 / base | 120.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share base_2028q4_season | 2028Q4 / base | 27.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue base_2028q4_revenue | 2028Q4 / base | 22,194.00 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(base_annual_target, base_2028q4_growth, base_2028q4_season). |
| Gross margin base_2028q4_gm | 2028Q4 / base | 11.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit base_2028q4_gross_profit | 2028Q4 / base | 2,507.92 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(base_2028q4_revenue, base_2028q4_gm). |
| Cost of goods sold base_2028q4_cogs | 2028Q4 / base | 19,686.08 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(base_2028q4_revenue, base_2028q4_gross_profit). |
| Total stock compensation expense base_2028q4_sbc | 2028Q4 / base | 173.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit base_2028q4_cogs_sbc | 2028Q4 / base | 12.80 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense base_2028q4_opex_sbc | 2028Q4 / base | 160.20 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(base_2028q4_sbc, base_2028q4_cogs_sbc). |
| Operating costs excluding SBC base_2028q4_cashopex | 2028Q4 / base | 620.80 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense base_2028q4_opex | 2028Q4 / base | 781.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(base_2028q4_cashopex, base_2028q4_opex_sbc). |
| GAAP operating income base_2028q4_operating_income | 2028Q4 / base | 1,726.92 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(base_2028q4_gross_profit, base_2028q4_opex). |
| Standard quarter days base_2028q4_ar_quarter_days | 2028Q4 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q4_ar_daily | 2028Q4 / base | 246.60 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q4_revenue, base_2028q4_ar_quarter_days). |
| Ending balance turnover days base_2028q4_ar_days | 2028Q4 / base | 4,500.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables base_2028q4_ar_balance | 2028Q4 / base | 11,097.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q4_ar_daily, base_2028q4_ar_days). |
| Cash source from ar base_2028q4_ar_cash | 2028Q4 / base | -616.50 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q3_ar_balance, base_2028q4_ar_balance). |
| Standard quarter days base_2028q4_inv_quarter_days | 2028Q4 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q4_inv_daily | 2028Q4 / base | 218.73 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q4_cogs, base_2028q4_inv_quarter_days). |
| Ending balance turnover days base_2028q4_inv_days | 2028Q4 / base | 8,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory base_2028q4_inv_balance | 2028Q4 / base | 17,498.74 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q4_inv_daily, base_2028q4_inv_days). |
| Cash source from inv base_2028q4_inv_cash | 2028Q4 / base | -972.15 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q3_inv_balance, base_2028q4_inv_balance). |
| Standard quarter days base_2028q4_ap_quarter_days | 2028Q4 / base | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day base_2028q4_ap_daily | 2028Q4 / base | 218.73 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(base_2028q4_cogs, base_2028q4_ap_quarter_days). |
| Ending balance turnover days base_2028q4_ap_days | 2028Q4 / base | 2,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables base_2028q4_ap_balance | 2028Q4 / base | 4,374.68 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(base_2028q4_ap_daily, base_2028q4_ap_days). |
| Cash source from ap base_2028q4_ap_cash | 2028Q4 / base | 243.04 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(base_2028q4_ap_balance, base_2028q3_ap_balance). |
| Depreciation and amortization base_2028q4_da | 2028Q4 / base | 23.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense base_2028q4_profit_cash | 2028Q4 / base | 1,922.92 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(base_2028q4_operating_income, base_2028q4_sbc, base_2028q4_da). |
| Cash interest net of cash investment income base_2028q4_interest | 2028Q4 / base | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance base_2028q4_cash_tax | 2028Q4 / base | 350.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use base_2028q4_other_wc | 2028Q4 / base | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses base_2028q4_cash_uses | 2028Q4 / base | 515.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(base_2028q4_interest, base_2028q4_cash_tax, base_2028q4_other_wc). |
| Cash profit after taxes and net interest base_2028q4_cash_after_uses | 2028Q4 / base | 1,407.92 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(base_2028q4_profit_cash, base_2028q4_cash_uses). |
| Cash before net deferred-revenue funding base_2028q4_cfo_before_funding | 2028Q4 / base | 62.31 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(base_2028q4_cash_after_uses, base_2028q4_ar_cash, base_2028q4_inv_cash, base_2028q4_ap_cash). |
| Net customer deferred-revenue cash source base_2028q4_customer_funding | 2028Q4 / base | 0.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy base_2028q4_cfo | 2028Q4 / base | 62.31 USD_millions | derived: Customer funding enters cash only. Formula: sum(base_2028q4_cfo_before_funding, base_2028q4_customer_funding). |
| Cash PP&E purchases base_2028q4_capex | 2028Q4 / base | 105.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex base_2028q4_fcf | 2028Q4 / base | -42.69 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(base_2028q4_cfo, base_2028q4_capex). |
| Quarter-year dividend factor base_2028q4_dividend_quarter | 2028Q4 / base | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend base_2028q4_preferred_cash | 2028Q4 / base | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, base_2028q4_dividend_quarter). |
| Equity-award tax withholding base_2028q4_awards | 2028Q4 / base | 54.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes base_2028q4_capital_claims | 2028Q4 / base | 129.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(base_2028q4_preferred_cash, base_2028q4_awards). |
| Cash after preferred and award taxes base_2028q4_cash_after_claims | 2028Q4 / base | -172.16 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(base_2028q4_fcf, base_2028q4_capital_claims). |
| Revenue ($M) base_fy2027_revenue | FY2027 / base | 68,500.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_revenue, base_2027q2_revenue, base_2027q3_revenue, base_2027q4_revenue). |
| GAAP gross profit ($M) base_fy2027_gross_profit | FY2027 / base | 7,535.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_gross_profit, base_2027q2_gross_profit, base_2027q3_gross_profit, base_2027q4_gross_profit). |
| GAAP operating income ($M) base_fy2027_operating_income | FY2027 / base | 4,939.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_operating_income, base_2027q2_operating_income, base_2027q3_operating_income, base_2027q4_operating_income). |
| Cash before net deferred-revenue funding ($M) base_fy2027_cfo_before_funding | FY2027 / base | -1,700.18 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_cfo_before_funding, base_2027q2_cfo_before_funding, base_2027q3_cfo_before_funding, base_2027q4_cfo_before_funding). |
| Net deferred-revenue cash source ($M) base_fy2027_customer_funding | FY2027 / base | 1,500.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_customer_funding, base_2027q2_customer_funding, base_2027q3_customer_funding, base_2027q4_customer_funding). |
| Operating cash flow proxy ($M) base_fy2027_cfo | FY2027 / base | -200.18 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_cfo, base_2027q2_cfo, base_2027q3_cfo, base_2027q4_cfo). |
| Cash PP&E purchases ($M) base_fy2027_capex | FY2027 / base | 310.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_capex, base_2027q2_capex, base_2027q3_capex, base_2027q4_capex). |
| CFO less capex ($M) base_fy2027_fcf | FY2027 / base | -510.18 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_fcf, base_2027q2_fcf, base_2027q3_fcf, base_2027q4_fcf). |
| Preferred cash dividend ($M) base_fy2027_preferred_cash | FY2027 / base | 290.14 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_preferred_cash, base_2027q2_preferred_cash, base_2027q3_preferred_cash, base_2027q4_preferred_cash). |
| Cash after preferred and award taxes ($M) base_fy2027_cash_after_claims | FY2027 / base | -972.31 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2027q1_cash_after_claims, base_2027q2_cash_after_claims, base_2027q3_cash_after_claims, base_2027q4_cash_after_claims). |
| Revenue ($M) base_fy2028_revenue | FY2028 / base | 82,200.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_revenue, base_2028q2_revenue, base_2028q3_revenue, base_2028q4_revenue). |
| GAAP gross profit ($M) base_fy2028_gross_profit | FY2028 / base | 9,288.60 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_gross_profit, base_2028q2_gross_profit, base_2028q3_gross_profit, base_2028q4_gross_profit). |
| GAAP operating income ($M) base_fy2028_operating_income | FY2028 / base | 6,308.60 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_operating_income, base_2028q2_operating_income, base_2028q3_operating_income, base_2028q4_operating_income). |
| Cash before net deferred-revenue funding ($M) base_fy2028_cfo_before_funding | FY2028 / base | 3,351.08 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_cfo_before_funding, base_2028q2_cfo_before_funding, base_2028q3_cfo_before_funding, base_2028q4_cfo_before_funding). |
| Net deferred-revenue cash source ($M) base_fy2028_customer_funding | FY2028 / base | 500.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_customer_funding, base_2028q2_customer_funding, base_2028q3_customer_funding, base_2028q4_customer_funding). |
| Operating cash flow proxy ($M) base_fy2028_cfo | FY2028 / base | 3,851.08 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_cfo, base_2028q2_cfo, base_2028q3_cfo, base_2028q4_cfo). |
| Cash PP&E purchases ($M) base_fy2028_capex | FY2028 / base | 390.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_capex, base_2028q2_capex, base_2028q3_capex, base_2028q4_capex). |
| CFO less capex ($M) base_fy2028_fcf | FY2028 / base | 3,461.08 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_fcf, base_2028q2_fcf, base_2028q3_fcf, base_2028q4_fcf). |
| Preferred cash dividend ($M) base_fy2028_preferred_cash | FY2028 / base | 301.88 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_preferred_cash, base_2028q2_preferred_cash, base_2028q3_preferred_cash, base_2028q4_preferred_cash). |
| Cash after preferred and award taxes ($M) base_fy2028_cash_after_claims | FY2028 / base | 2,955.21 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(base_2028q1_cash_after_claims, base_2028q2_cash_after_claims, base_2028q3_cash_after_claims, base_2028q4_cash_after_claims). |
| Sales delivery / guidance midpoint upside_delivery | FY2027 / upside | 108.0% ratio | assumption: Desk delivery sensitivity. |
| FY2027 sales target upside_annual_target | FY2027 / upside | 73,980.00 USD_millions | derived: Base uses midpoint; no incremental order-book revenue. Formula: multiply(annual_guide, upside_delivery). |
| Q1 sales target upside_q1_target | 2027Q1 / upside | 16,200.00 USD_millions | derived: Base uses quarterly midpoint. Formula: multiply(q1_guide, upside_delivery). |
| Remaining FY2027 sales upside_remaining | FY2027 / upside | 57,780.00 USD_millions | derived: Separate Q1 anchor and remaining allocation. Formula: subtract(upside_annual_target, upside_q1_target). |
| Identity multiplier upside_2027q1_one | 2027Q1 / upside | 100.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2027q1_revenue | 2027Q1 / upside | 16,200.00 USD_millions | derived: Q1 company guidance scenario. Formula: multiply(upside_q1_target, upside_2027q1_one). |
| Gross margin upside_2027q1_gm | 2027Q1 / upside | 13.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2027q1_gross_profit | 2027Q1 / upside | 2,106.00 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2027q1_revenue, upside_2027q1_gm). |
| Cost of goods sold upside_2027q1_cogs | 2027Q1 / upside | 14,094.00 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2027q1_revenue, upside_2027q1_gross_profit). |
| Total stock compensation expense upside_2027q1_sbc | 2027Q1 / upside | 138.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2027q1_cogs_sbc | 2027Q1 / upside | 10.00 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2027q1_opex_sbc | 2027Q1 / upside | 128.00 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2027q1_sbc, upside_2027q1_cogs_sbc). |
| Operating costs excluding SBC upside_2027q1_cashopex | 2027Q1 / upside | 500.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2027q1_opex | 2027Q1 / upside | 628.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2027q1_cashopex, upside_2027q1_opex_sbc). |
| GAAP operating income upside_2027q1_operating_income | 2027Q1 / upside | 1,478.00 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2027q1_gross_profit, upside_2027q1_opex). |
| Standard quarter days upside_2027q1_ar_quarter_days | 2027Q1 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q1_ar_daily | 2027Q1 / upside | 180.00 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q1_revenue, upside_2027q1_ar_quarter_days). |
| Ending balance turnover days upside_2027q1_ar_days | 2027Q1 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2027q1_ar_balance | 2027Q1 / upside | 7,200.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q1_ar_daily, upside_2027q1_ar_days). |
| Cash source from ar upside_2027q1_ar_cash | 2027Q1 / upside | -1,074.59 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(receivables, upside_2027q1_ar_balance). |
| Standard quarter days upside_2027q1_inv_quarter_days | 2027Q1 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q1_inv_daily | 2027Q1 / upside | 156.60 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q1_cogs, upside_2027q1_inv_quarter_days). |
| Ending balance turnover days upside_2027q1_inv_days | 2027Q1 / upside | 8,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2027q1_inv_balance | 2027Q1 / upside | 12,528.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q1_inv_daily, upside_2027q1_inv_days). |
| Cash source from inv upside_2027q1_inv_cash | 2027Q1 / upside | 367.95 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(inventory, upside_2027q1_inv_balance). |
| Standard quarter days upside_2027q1_ap_quarter_days | 2027Q1 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q1_ap_daily | 2027Q1 / upside | 156.60 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q1_cogs, upside_2027q1_ap_quarter_days). |
| Ending balance turnover days upside_2027q1_ap_days | 2027Q1 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2027q1_ap_balance | 2027Q1 / upside | 3,445.20 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q1_ap_daily, upside_2027q1_ap_days). |
| Cash source from ap upside_2027q1_ap_cash | 2027Q1 / upside | 1,198.20 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q1_ap_balance, payables). |
| Depreciation and amortization upside_2027q1_da | 2027Q1 / upside | 16.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2027q1_profit_cash | 2027Q1 / upside | 1,632.00 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2027q1_operating_income, upside_2027q1_sbc, upside_2027q1_da). |
| Cash interest net of cash investment income upside_2027q1_interest | 2027Q1 / upside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2027q1_cash_tax | 2027Q1 / upside | 180.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2027q1_other_wc | 2027Q1 / upside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2027q1_cash_uses | 2027Q1 / upside | 355.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2027q1_interest, upside_2027q1_cash_tax, upside_2027q1_other_wc). |
| Cash profit after taxes and net interest upside_2027q1_cash_after_uses | 2027Q1 / upside | 1,277.00 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2027q1_profit_cash, upside_2027q1_cash_uses). |
| Cash before net deferred-revenue funding upside_2027q1_cfo_before_funding | 2027Q1 / upside | 1,768.56 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2027q1_cash_after_uses, upside_2027q1_ar_cash, upside_2027q1_inv_cash, upside_2027q1_ap_cash). |
| Net customer deferred-revenue cash source upside_2027q1_customer_funding | 2027Q1 / upside | 600.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2027q1_cfo | 2027Q1 / upside | 2,368.56 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2027q1_cfo_before_funding, upside_2027q1_customer_funding). |
| Cash PP&E purchases upside_2027q1_capex | 2027Q1 / upside | 70.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2027q1_fcf | 2027Q1 / upside | 2,298.56 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2027q1_cfo, upside_2027q1_capex). |
| Initial dividend multiplier upside_2027q1_dividend_factor | 2027Q1 / upside | 100.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2027q1_preferred_cash | 2027Q1 / upside | 63.73 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(initial_preferred_cash, upside_2027q1_dividend_factor). |
| Equity-award tax withholding upside_2027q1_awards | 2027Q1 / upside | 40.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2027q1_capital_claims | 2027Q1 / upside | 103.73 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2027q1_preferred_cash, upside_2027q1_awards). |
| Cash after preferred and award taxes upside_2027q1_cash_after_claims | 2027Q1 / upside | 2,194.83 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2027q1_fcf, upside_2027q1_capital_claims). |
| Remaining sales share upside_2027q2_remaining_share | 2027Q2 / upside | 30.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2027q2_revenue | 2027Q2 / upside | 17,334.00 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(upside_remaining, upside_2027q2_remaining_share). |
| Gross margin upside_2027q2_gm | 2027Q2 / upside | 13.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2027q2_gross_profit | 2027Q2 / upside | 2,253.42 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2027q2_revenue, upside_2027q2_gm). |
| Cost of goods sold upside_2027q2_cogs | 2027Q2 / upside | 15,080.58 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2027q2_revenue, upside_2027q2_gross_profit). |
| Total stock compensation expense upside_2027q2_sbc | 2027Q2 / upside | 143.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2027q2_cogs_sbc | 2027Q2 / upside | 10.40 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2027q2_opex_sbc | 2027Q2 / upside | 132.60 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2027q2_sbc, upside_2027q2_cogs_sbc). |
| Operating costs excluding SBC upside_2027q2_cashopex | 2027Q2 / upside | 520.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2027q2_opex | 2027Q2 / upside | 652.60 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2027q2_cashopex, upside_2027q2_opex_sbc). |
| GAAP operating income upside_2027q2_operating_income | 2027Q2 / upside | 1,600.82 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2027q2_gross_profit, upside_2027q2_opex). |
| Standard quarter days upside_2027q2_ar_quarter_days | 2027Q2 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q2_ar_daily | 2027Q2 / upside | 192.60 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q2_revenue, upside_2027q2_ar_quarter_days). |
| Ending balance turnover days upside_2027q2_ar_days | 2027Q2 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2027q2_ar_balance | 2027Q2 / upside | 7,704.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q2_ar_daily, upside_2027q2_ar_days). |
| Cash source from ar upside_2027q2_ar_cash | 2027Q2 / upside | -504.00 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q1_ar_balance, upside_2027q2_ar_balance). |
| Standard quarter days upside_2027q2_inv_quarter_days | 2027Q2 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q2_inv_daily | 2027Q2 / upside | 167.56 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q2_cogs, upside_2027q2_inv_quarter_days). |
| Ending balance turnover days upside_2027q2_inv_days | 2027Q2 / upside | 7,800.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2027q2_inv_balance | 2027Q2 / upside | 13,069.84 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q2_inv_daily, upside_2027q2_inv_days). |
| Cash source from inv upside_2027q2_inv_cash | 2027Q2 / upside | -541.84 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q1_inv_balance, upside_2027q2_inv_balance). |
| Standard quarter days upside_2027q2_ap_quarter_days | 2027Q2 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q2_ap_daily | 2027Q2 / upside | 167.56 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q2_cogs, upside_2027q2_ap_quarter_days). |
| Ending balance turnover days upside_2027q2_ap_days | 2027Q2 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2027q2_ap_balance | 2027Q2 / upside | 3,686.36 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q2_ap_daily, upside_2027q2_ap_days). |
| Cash source from ap upside_2027q2_ap_cash | 2027Q2 / upside | 241.16 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q2_ap_balance, upside_2027q1_ap_balance). |
| Depreciation and amortization upside_2027q2_da | 2027Q2 / upside | 17.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2027q2_profit_cash | 2027Q2 / upside | 1,760.82 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2027q2_operating_income, upside_2027q2_sbc, upside_2027q2_da). |
| Cash interest net of cash investment income upside_2027q2_interest | 2027Q2 / upside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2027q2_cash_tax | 2027Q2 / upside | 220.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2027q2_other_wc | 2027Q2 / upside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2027q2_cash_uses | 2027Q2 / upside | 395.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2027q2_interest, upside_2027q2_cash_tax, upside_2027q2_other_wc). |
| Cash profit after taxes and net interest upside_2027q2_cash_after_uses | 2027Q2 / upside | 1,365.82 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2027q2_profit_cash, upside_2027q2_cash_uses). |
| Cash before net deferred-revenue funding upside_2027q2_cfo_before_funding | 2027Q2 / upside | 561.15 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2027q2_cash_after_uses, upside_2027q2_ar_cash, upside_2027q2_inv_cash, upside_2027q2_ap_cash). |
| Net customer deferred-revenue cash source upside_2027q2_customer_funding | 2027Q2 / upside | 600.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2027q2_cfo | 2027Q2 / upside | 1,161.15 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2027q2_cfo_before_funding, upside_2027q2_customer_funding). |
| Cash PP&E purchases upside_2027q2_capex | 2027Q2 / upside | 75.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2027q2_fcf | 2027Q2 / upside | 1,086.15 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2027q2_cfo, upside_2027q2_capex). |
| Quarter-year dividend factor upside_2027q2_dividend_quarter | 2027Q2 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2027q2_preferred_cash | 2027Q2 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2027q2_dividend_quarter). |
| Equity-award tax withholding upside_2027q2_awards | 2027Q2 / upside | 42.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2027q2_capital_claims | 2027Q2 / upside | 117.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2027q2_preferred_cash, upside_2027q2_awards). |
| Cash after preferred and award taxes upside_2027q2_cash_after_claims | 2027Q2 / upside | 968.68 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2027q2_fcf, upside_2027q2_capital_claims). |
| Remaining sales share upside_2027q3_remaining_share | 2027Q3 / upside | 33.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2027q3_revenue | 2027Q3 / upside | 19,067.40 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(upside_remaining, upside_2027q3_remaining_share). |
| Gross margin upside_2027q3_gm | 2027Q3 / upside | 13.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2027q3_gross_profit | 2027Q3 / upside | 2,478.76 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2027q3_revenue, upside_2027q3_gm). |
| Cost of goods sold upside_2027q3_cogs | 2027Q3 / upside | 16,588.64 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2027q3_revenue, upside_2027q3_gross_profit). |
| Total stock compensation expense upside_2027q3_sbc | 2027Q3 / upside | 148.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2027q3_cogs_sbc | 2027Q3 / upside | 10.80 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2027q3_opex_sbc | 2027Q3 / upside | 137.20 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2027q3_sbc, upside_2027q3_cogs_sbc). |
| Operating costs excluding SBC upside_2027q3_cashopex | 2027Q3 / upside | 540.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2027q3_opex | 2027Q3 / upside | 677.20 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2027q3_cashopex, upside_2027q3_opex_sbc). |
| GAAP operating income upside_2027q3_operating_income | 2027Q3 / upside | 1,801.56 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2027q3_gross_profit, upside_2027q3_opex). |
| Standard quarter days upside_2027q3_ar_quarter_days | 2027Q3 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q3_ar_daily | 2027Q3 / upside | 211.86 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q3_revenue, upside_2027q3_ar_quarter_days). |
| Ending balance turnover days upside_2027q3_ar_days | 2027Q3 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2027q3_ar_balance | 2027Q3 / upside | 8,474.40 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q3_ar_daily, upside_2027q3_ar_days). |
| Cash source from ar upside_2027q3_ar_cash | 2027Q3 / upside | -770.40 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q2_ar_balance, upside_2027q3_ar_balance). |
| Standard quarter days upside_2027q3_inv_quarter_days | 2027Q3 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q3_inv_daily | 2027Q3 / upside | 184.32 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q3_cogs, upside_2027q3_inv_quarter_days). |
| Ending balance turnover days upside_2027q3_inv_days | 2027Q3 / upside | 7,600.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2027q3_inv_balance | 2027Q3 / upside | 14,008.18 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q3_inv_daily, upside_2027q3_inv_days). |
| Cash source from inv upside_2027q3_inv_cash | 2027Q3 / upside | -938.35 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q2_inv_balance, upside_2027q3_inv_balance). |
| Standard quarter days upside_2027q3_ap_quarter_days | 2027Q3 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q3_ap_daily | 2027Q3 / upside | 184.32 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q3_cogs, upside_2027q3_ap_quarter_days). |
| Ending balance turnover days upside_2027q3_ap_days | 2027Q3 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2027q3_ap_balance | 2027Q3 / upside | 4,055.00 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q3_ap_daily, upside_2027q3_ap_days). |
| Cash source from ap upside_2027q3_ap_cash | 2027Q3 / upside | 368.64 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q3_ap_balance, upside_2027q2_ap_balance). |
| Depreciation and amortization upside_2027q3_da | 2027Q3 / upside | 18.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2027q3_profit_cash | 2027Q3 / upside | 1,967.56 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2027q3_operating_income, upside_2027q3_sbc, upside_2027q3_da). |
| Cash interest net of cash investment income upside_2027q3_interest | 2027Q3 / upside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2027q3_cash_tax | 2027Q3 / upside | 240.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2027q3_other_wc | 2027Q3 / upside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2027q3_cash_uses | 2027Q3 / upside | 415.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2027q3_interest, upside_2027q3_cash_tax, upside_2027q3_other_wc). |
| Cash profit after taxes and net interest upside_2027q3_cash_after_uses | 2027Q3 / upside | 1,552.56 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2027q3_profit_cash, upside_2027q3_cash_uses). |
| Cash before net deferred-revenue funding upside_2027q3_cfo_before_funding | 2027Q3 / upside | 212.45 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2027q3_cash_after_uses, upside_2027q3_ar_cash, upside_2027q3_inv_cash, upside_2027q3_ap_cash). |
| Net customer deferred-revenue cash source upside_2027q3_customer_funding | 2027Q3 / upside | 450.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2027q3_cfo | 2027Q3 / upside | 662.45 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2027q3_cfo_before_funding, upside_2027q3_customer_funding). |
| Cash PP&E purchases upside_2027q3_capex | 2027Q3 / upside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2027q3_fcf | 2027Q3 / upside | 582.45 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2027q3_cfo, upside_2027q3_capex). |
| Quarter-year dividend factor upside_2027q3_dividend_quarter | 2027Q3 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2027q3_preferred_cash | 2027Q3 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2027q3_dividend_quarter). |
| Equity-award tax withholding upside_2027q3_awards | 2027Q3 / upside | 44.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2027q3_capital_claims | 2027Q3 / upside | 119.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2027q3_preferred_cash, upside_2027q3_awards). |
| Cash after preferred and award taxes upside_2027q3_cash_after_claims | 2027Q3 / upside | 462.98 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2027q3_fcf, upside_2027q3_capital_claims). |
| Remaining sales share upside_2027q4_remaining_share | 2027Q4 / upside | 37.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2027q4_revenue | 2027Q4 / upside | 21,378.60 USD_millions | derived: Explicit back-half delivery allocation. Formula: multiply(upside_remaining, upside_2027q4_remaining_share). |
| Gross margin upside_2027q4_gm | 2027Q4 / upside | 13.0% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2027q4_gross_profit | 2027Q4 / upside | 2,779.22 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2027q4_revenue, upside_2027q4_gm). |
| Cost of goods sold upside_2027q4_cogs | 2027Q4 / upside | 18,599.38 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2027q4_revenue, upside_2027q4_gross_profit). |
| Total stock compensation expense upside_2027q4_sbc | 2027Q4 / upside | 153.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2027q4_cogs_sbc | 2027Q4 / upside | 11.20 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2027q4_opex_sbc | 2027Q4 / upside | 141.80 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2027q4_sbc, upside_2027q4_cogs_sbc). |
| Operating costs excluding SBC upside_2027q4_cashopex | 2027Q4 / upside | 560.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2027q4_opex | 2027Q4 / upside | 701.80 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2027q4_cashopex, upside_2027q4_opex_sbc). |
| GAAP operating income upside_2027q4_operating_income | 2027Q4 / upside | 2,077.42 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2027q4_gross_profit, upside_2027q4_opex). |
| Standard quarter days upside_2027q4_ar_quarter_days | 2027Q4 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q4_ar_daily | 2027Q4 / upside | 237.54 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q4_revenue, upside_2027q4_ar_quarter_days). |
| Ending balance turnover days upside_2027q4_ar_days | 2027Q4 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2027q4_ar_balance | 2027Q4 / upside | 9,501.60 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q4_ar_daily, upside_2027q4_ar_days). |
| Cash source from ar upside_2027q4_ar_cash | 2027Q4 / upside | -1,027.20 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q3_ar_balance, upside_2027q4_ar_balance). |
| Standard quarter days upside_2027q4_inv_quarter_days | 2027Q4 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q4_inv_daily | 2027Q4 / upside | 206.66 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q4_cogs, upside_2027q4_inv_quarter_days). |
| Ending balance turnover days upside_2027q4_inv_days | 2027Q4 / upside | 7,400.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2027q4_inv_balance | 2027Q4 / upside | 15,292.83 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q4_inv_daily, upside_2027q4_inv_days). |
| Cash source from inv upside_2027q4_inv_cash | 2027Q4 / upside | -1,284.64 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q3_inv_balance, upside_2027q4_inv_balance). |
| Standard quarter days upside_2027q4_ap_quarter_days | 2027Q4 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2027q4_ap_daily | 2027Q4 / upside | 206.66 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2027q4_cogs, upside_2027q4_ap_quarter_days). |
| Ending balance turnover days upside_2027q4_ap_days | 2027Q4 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2027q4_ap_balance | 2027Q4 / upside | 4,546.52 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2027q4_ap_daily, upside_2027q4_ap_days). |
| Cash source from ap upside_2027q4_ap_cash | 2027Q4 / upside | 491.52 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q4_ap_balance, upside_2027q3_ap_balance). |
| Depreciation and amortization upside_2027q4_da | 2027Q4 / upside | 19.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2027q4_profit_cash | 2027Q4 / upside | 2,249.42 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2027q4_operating_income, upside_2027q4_sbc, upside_2027q4_da). |
| Cash interest net of cash investment income upside_2027q4_interest | 2027Q4 / upside | 75.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2027q4_cash_tax | 2027Q4 / upside | 300.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2027q4_other_wc | 2027Q4 / upside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2027q4_cash_uses | 2027Q4 / upside | 475.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2027q4_interest, upside_2027q4_cash_tax, upside_2027q4_other_wc). |
| Cash profit after taxes and net interest upside_2027q4_cash_after_uses | 2027Q4 / upside | 1,774.42 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2027q4_profit_cash, upside_2027q4_cash_uses). |
| Cash before net deferred-revenue funding upside_2027q4_cfo_before_funding | 2027Q4 / upside | -45.91 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2027q4_cash_after_uses, upside_2027q4_ar_cash, upside_2027q4_inv_cash, upside_2027q4_ap_cash). |
| Net customer deferred-revenue cash source upside_2027q4_customer_funding | 2027Q4 / upside | 250.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2027q4_cfo | 2027Q4 / upside | 204.09 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2027q4_cfo_before_funding, upside_2027q4_customer_funding). |
| Cash PP&E purchases upside_2027q4_capex | 2027Q4 / upside | 85.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2027q4_fcf | 2027Q4 / upside | 119.09 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2027q4_cfo, upside_2027q4_capex). |
| Quarter-year dividend factor upside_2027q4_dividend_quarter | 2027Q4 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2027q4_preferred_cash | 2027Q4 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2027q4_dividend_quarter). |
| Equity-award tax withholding upside_2027q4_awards | 2027Q4 / upside | 46.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2027q4_capital_claims | 2027Q4 / upside | 121.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2027q4_preferred_cash, upside_2027q4_awards). |
| Cash after preferred and award taxes upside_2027q4_cash_after_claims | 2027Q4 / upside | -2.38 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2027q4_fcf, upside_2027q4_capital_claims). |
| FY2028 sales expansion upside_2028q1_growth | 2028Q1 / upside | 130.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share upside_2028q1_season | 2028Q1 / upside | 23.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2028q1_revenue | 2028Q1 / upside | 22,120.02 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(upside_annual_target, upside_2028q1_growth, upside_2028q1_season). |
| Gross margin upside_2028q1_gm | 2028Q1 / upside | 13.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2028q1_gross_profit | 2028Q1 / upside | 2,941.96 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2028q1_revenue, upside_2028q1_gm). |
| Cost of goods sold upside_2028q1_cogs | 2028Q1 / upside | 19,178.06 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2028q1_revenue, upside_2028q1_gross_profit). |
| Total stock compensation expense upside_2028q1_sbc | 2028Q1 / upside | 158.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2028q1_cogs_sbc | 2028Q1 / upside | 11.60 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2028q1_opex_sbc | 2028Q1 / upside | 146.40 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2028q1_sbc, upside_2028q1_cogs_sbc). |
| Operating costs excluding SBC upside_2028q1_cashopex | 2028Q1 / upside | 580.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2028q1_opex | 2028Q1 / upside | 726.40 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2028q1_cashopex, upside_2028q1_opex_sbc). |
| GAAP operating income upside_2028q1_operating_income | 2028Q1 / upside | 2,215.56 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2028q1_gross_profit, upside_2028q1_opex). |
| Standard quarter days upside_2028q1_ar_quarter_days | 2028Q1 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q1_ar_daily | 2028Q1 / upside | 245.78 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q1_revenue, upside_2028q1_ar_quarter_days). |
| Ending balance turnover days upside_2028q1_ar_days | 2028Q1 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2028q1_ar_balance | 2028Q1 / upside | 9,831.12 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q1_ar_daily, upside_2028q1_ar_days). |
| Cash source from ar upside_2028q1_ar_cash | 2028Q1 / upside | -329.52 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q4_ar_balance, upside_2028q1_ar_balance). |
| Standard quarter days upside_2028q1_inv_quarter_days | 2028Q1 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q1_inv_daily | 2028Q1 / upside | 213.09 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q1_cogs, upside_2028q1_inv_quarter_days). |
| Ending balance turnover days upside_2028q1_inv_days | 2028Q1 / upside | 7,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2028q1_inv_balance | 2028Q1 / upside | 15,342.45 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q1_inv_daily, upside_2028q1_inv_days). |
| Cash source from inv upside_2028q1_inv_cash | 2028Q1 / upside | -49.62 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2027q4_inv_balance, upside_2028q1_inv_balance). |
| Standard quarter days upside_2028q1_ap_quarter_days | 2028Q1 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q1_ap_daily | 2028Q1 / upside | 213.09 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q1_cogs, upside_2028q1_ap_quarter_days). |
| Ending balance turnover days upside_2028q1_ap_days | 2028Q1 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2028q1_ap_balance | 2028Q1 / upside | 4,687.97 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q1_ap_daily, upside_2028q1_ap_days). |
| Cash source from ap upside_2028q1_ap_cash | 2028Q1 / upside | 141.45 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q1_ap_balance, upside_2027q4_ap_balance). |
| Depreciation and amortization upside_2028q1_da | 2028Q1 / upside | 20.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2028q1_profit_cash | 2028Q1 / upside | 2,393.56 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2028q1_operating_income, upside_2028q1_sbc, upside_2028q1_da). |
| Cash interest net of cash investment income upside_2028q1_interest | 2028Q1 / upside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2028q1_cash_tax | 2028Q1 / upside | 280.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2028q1_other_wc | 2028Q1 / upside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2028q1_cash_uses | 2028Q1 / upside | 445.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2028q1_interest, upside_2028q1_cash_tax, upside_2028q1_other_wc). |
| Cash profit after taxes and net interest upside_2028q1_cash_after_uses | 2028Q1 / upside | 1,948.56 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2028q1_profit_cash, upside_2028q1_cash_uses). |
| Cash before net deferred-revenue funding upside_2028q1_cfo_before_funding | 2028Q1 / upside | 1,710.88 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2028q1_cash_after_uses, upside_2028q1_ar_cash, upside_2028q1_inv_cash, upside_2028q1_ap_cash). |
| Net customer deferred-revenue cash source upside_2028q1_customer_funding | 2028Q1 / upside | 250.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2028q1_cfo | 2028Q1 / upside | 1,960.88 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2028q1_cfo_before_funding, upside_2028q1_customer_funding). |
| Cash PP&E purchases upside_2028q1_capex | 2028Q1 / upside | 90.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2028q1_fcf | 2028Q1 / upside | 1,870.88 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2028q1_cfo, upside_2028q1_capex). |
| Quarter-year dividend factor upside_2028q1_dividend_quarter | 2028Q1 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2028q1_preferred_cash | 2028Q1 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2028q1_dividend_quarter). |
| Equity-award tax withholding upside_2028q1_awards | 2028Q1 / upside | 48.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2028q1_capital_claims | 2028Q1 / upside | 123.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2028q1_preferred_cash, upside_2028q1_awards). |
| Cash after preferred and award taxes upside_2028q1_cash_after_claims | 2028Q1 / upside | 1,747.41 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2028q1_fcf, upside_2028q1_capital_claims). |
| FY2028 sales expansion upside_2028q2_growth | 2028Q2 / upside | 130.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share upside_2028q2_season | 2028Q2 / upside | 24.5% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2028q2_revenue | 2028Q2 / upside | 23,562.63 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(upside_annual_target, upside_2028q2_growth, upside_2028q2_season). |
| Gross margin upside_2028q2_gm | 2028Q2 / upside | 13.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2028q2_gross_profit | 2028Q2 / upside | 3,133.83 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2028q2_revenue, upside_2028q2_gm). |
| Cost of goods sold upside_2028q2_cogs | 2028Q2 / upside | 20,428.80 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2028q2_revenue, upside_2028q2_gross_profit). |
| Total stock compensation expense upside_2028q2_sbc | 2028Q2 / upside | 163.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2028q2_cogs_sbc | 2028Q2 / upside | 12.00 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2028q2_opex_sbc | 2028Q2 / upside | 151.00 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2028q2_sbc, upside_2028q2_cogs_sbc). |
| Operating costs excluding SBC upside_2028q2_cashopex | 2028Q2 / upside | 600.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2028q2_opex | 2028Q2 / upside | 751.00 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2028q2_cashopex, upside_2028q2_opex_sbc). |
| GAAP operating income upside_2028q2_operating_income | 2028Q2 / upside | 2,382.83 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2028q2_gross_profit, upside_2028q2_opex). |
| Standard quarter days upside_2028q2_ar_quarter_days | 2028Q2 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q2_ar_daily | 2028Q2 / upside | 261.81 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q2_revenue, upside_2028q2_ar_quarter_days). |
| Ending balance turnover days upside_2028q2_ar_days | 2028Q2 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2028q2_ar_balance | 2028Q2 / upside | 10,472.28 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q2_ar_daily, upside_2028q2_ar_days). |
| Cash source from ar upside_2028q2_ar_cash | 2028Q2 / upside | -641.16 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q1_ar_balance, upside_2028q2_ar_balance). |
| Standard quarter days upside_2028q2_inv_quarter_days | 2028Q2 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q2_inv_daily | 2028Q2 / upside | 226.99 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q2_cogs, upside_2028q2_inv_quarter_days). |
| Ending balance turnover days upside_2028q2_inv_days | 2028Q2 / upside | 7,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2028q2_inv_balance | 2028Q2 / upside | 15,889.07 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q2_inv_daily, upside_2028q2_inv_days). |
| Cash source from inv upside_2028q2_inv_cash | 2028Q2 / upside | -546.62 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q1_inv_balance, upside_2028q2_inv_balance). |
| Standard quarter days upside_2028q2_ap_quarter_days | 2028Q2 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q2_ap_daily | 2028Q2 / upside | 226.99 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q2_cogs, upside_2028q2_ap_quarter_days). |
| Ending balance turnover days upside_2028q2_ap_days | 2028Q2 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2028q2_ap_balance | 2028Q2 / upside | 4,993.71 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q2_ap_daily, upside_2028q2_ap_days). |
| Cash source from ap upside_2028q2_ap_cash | 2028Q2 / upside | 305.74 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q2_ap_balance, upside_2028q1_ap_balance). |
| Depreciation and amortization upside_2028q2_da | 2028Q2 / upside | 21.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2028q2_profit_cash | 2028Q2 / upside | 2,566.83 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2028q2_operating_income, upside_2028q2_sbc, upside_2028q2_da). |
| Cash interest net of cash investment income upside_2028q2_interest | 2028Q2 / upside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2028q2_cash_tax | 2028Q2 / upside | 300.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2028q2_other_wc | 2028Q2 / upside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2028q2_cash_uses | 2028Q2 / upside | 465.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2028q2_interest, upside_2028q2_cash_tax, upside_2028q2_other_wc). |
| Cash profit after taxes and net interest upside_2028q2_cash_after_uses | 2028Q2 / upside | 2,101.83 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2028q2_profit_cash, upside_2028q2_cash_uses). |
| Cash before net deferred-revenue funding upside_2028q2_cfo_before_funding | 2028Q2 / upside | 1,219.79 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2028q2_cash_after_uses, upside_2028q2_ar_cash, upside_2028q2_inv_cash, upside_2028q2_ap_cash). |
| Net customer deferred-revenue cash source upside_2028q2_customer_funding | 2028Q2 / upside | 250.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2028q2_cfo | 2028Q2 / upside | 1,469.79 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2028q2_cfo_before_funding, upside_2028q2_customer_funding). |
| Cash PP&E purchases upside_2028q2_capex | 2028Q2 / upside | 95.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2028q2_fcf | 2028Q2 / upside | 1,374.79 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2028q2_cfo, upside_2028q2_capex). |
| Quarter-year dividend factor upside_2028q2_dividend_quarter | 2028Q2 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2028q2_preferred_cash | 2028Q2 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2028q2_dividend_quarter). |
| Equity-award tax withholding upside_2028q2_awards | 2028Q2 / upside | 50.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2028q2_capital_claims | 2028Q2 / upside | 125.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2028q2_preferred_cash, upside_2028q2_awards). |
| Cash after preferred and award taxes upside_2028q2_cash_after_claims | 2028Q2 / upside | 1,249.32 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2028q2_fcf, upside_2028q2_capital_claims). |
| FY2028 sales expansion upside_2028q3_growth | 2028Q3 / upside | 130.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share upside_2028q3_season | 2028Q3 / upside | 25.5% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2028q3_revenue | 2028Q3 / upside | 24,524.37 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(upside_annual_target, upside_2028q3_growth, upside_2028q3_season). |
| Gross margin upside_2028q3_gm | 2028Q3 / upside | 13.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2028q3_gross_profit | 2028Q3 / upside | 3,261.74 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2028q3_revenue, upside_2028q3_gm). |
| Cost of goods sold upside_2028q3_cogs | 2028Q3 / upside | 21,262.63 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2028q3_revenue, upside_2028q3_gross_profit). |
| Total stock compensation expense upside_2028q3_sbc | 2028Q3 / upside | 168.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2028q3_cogs_sbc | 2028Q3 / upside | 12.40 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2028q3_opex_sbc | 2028Q3 / upside | 155.60 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2028q3_sbc, upside_2028q3_cogs_sbc). |
| Operating costs excluding SBC upside_2028q3_cashopex | 2028Q3 / upside | 620.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2028q3_opex | 2028Q3 / upside | 775.60 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2028q3_cashopex, upside_2028q3_opex_sbc). |
| GAAP operating income upside_2028q3_operating_income | 2028Q3 / upside | 2,486.14 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2028q3_gross_profit, upside_2028q3_opex). |
| Standard quarter days upside_2028q3_ar_quarter_days | 2028Q3 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q3_ar_daily | 2028Q3 / upside | 272.49 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q3_revenue, upside_2028q3_ar_quarter_days). |
| Ending balance turnover days upside_2028q3_ar_days | 2028Q3 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2028q3_ar_balance | 2028Q3 / upside | 10,899.72 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q3_ar_daily, upside_2028q3_ar_days). |
| Cash source from ar upside_2028q3_ar_cash | 2028Q3 / upside | -427.44 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q2_ar_balance, upside_2028q3_ar_balance). |
| Standard quarter days upside_2028q3_inv_quarter_days | 2028Q3 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q3_inv_daily | 2028Q3 / upside | 236.25 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q3_cogs, upside_2028q3_inv_quarter_days). |
| Ending balance turnover days upside_2028q3_inv_days | 2028Q3 / upside | 7,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2028q3_inv_balance | 2028Q3 / upside | 16,537.60 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q3_inv_daily, upside_2028q3_inv_days). |
| Cash source from inv upside_2028q3_inv_cash | 2028Q3 / upside | -648.53 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q2_inv_balance, upside_2028q3_inv_balance). |
| Standard quarter days upside_2028q3_ap_quarter_days | 2028Q3 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q3_ap_daily | 2028Q3 / upside | 236.25 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q3_cogs, upside_2028q3_ap_quarter_days). |
| Ending balance turnover days upside_2028q3_ap_days | 2028Q3 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2028q3_ap_balance | 2028Q3 / upside | 5,197.53 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q3_ap_daily, upside_2028q3_ap_days). |
| Cash source from ap upside_2028q3_ap_cash | 2028Q3 / upside | 203.82 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q3_ap_balance, upside_2028q2_ap_balance). |
| Depreciation and amortization upside_2028q3_da | 2028Q3 / upside | 22.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2028q3_profit_cash | 2028Q3 / upside | 2,676.14 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2028q3_operating_income, upside_2028q3_sbc, upside_2028q3_da). |
| Cash interest net of cash investment income upside_2028q3_interest | 2028Q3 / upside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2028q3_cash_tax | 2028Q3 / upside | 320.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2028q3_other_wc | 2028Q3 / upside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2028q3_cash_uses | 2028Q3 / upside | 485.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2028q3_interest, upside_2028q3_cash_tax, upside_2028q3_other_wc). |
| Cash profit after taxes and net interest upside_2028q3_cash_after_uses | 2028Q3 / upside | 2,191.14 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2028q3_profit_cash, upside_2028q3_cash_uses). |
| Cash before net deferred-revenue funding upside_2028q3_cfo_before_funding | 2028Q3 / upside | 1,318.99 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2028q3_cash_after_uses, upside_2028q3_ar_cash, upside_2028q3_inv_cash, upside_2028q3_ap_cash). |
| Net customer deferred-revenue cash source upside_2028q3_customer_funding | 2028Q3 / upside | 150.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2028q3_cfo | 2028Q3 / upside | 1,468.99 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2028q3_cfo_before_funding, upside_2028q3_customer_funding). |
| Cash PP&E purchases upside_2028q3_capex | 2028Q3 / upside | 100.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2028q3_fcf | 2028Q3 / upside | 1,368.99 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2028q3_cfo, upside_2028q3_capex). |
| Quarter-year dividend factor upside_2028q3_dividend_quarter | 2028Q3 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2028q3_preferred_cash | 2028Q3 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2028q3_dividend_quarter). |
| Equity-award tax withholding upside_2028q3_awards | 2028Q3 / upside | 52.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2028q3_capital_claims | 2028Q3 / upside | 127.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2028q3_preferred_cash, upside_2028q3_awards). |
| Cash after preferred and award taxes upside_2028q3_cash_after_claims | 2028Q3 / upside | 1,241.52 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2028q3_fcf, upside_2028q3_capital_claims). |
| FY2028 sales expansion upside_2028q4_growth | 2028Q4 / upside | 130.0% ratio | assumption: Desk assumption, not company guidance. |
| Annual sales quarter share upside_2028q4_season | 2028Q4 / upside | 27.0% ratio | assumption: Desk assumption, not company guidance. |
| Revenue upside_2028q4_revenue | 2028Q4 / upside | 25,966.98 USD_millions | derived: Independent next-year expansion, not management guidance. Formula: multiply(upside_annual_target, upside_2028q4_growth, upside_2028q4_season). |
| Gross margin upside_2028q4_gm | 2028Q4 / upside | 13.3% ratio | assumption: Desk assumption, not company guidance. |
| GAAP gross profit upside_2028q4_gross_profit | 2028Q4 / upside | 3,453.61 USD_millions | derived: Includes COGS equity compensation and inventory economics. Formula: multiply(upside_2028q4_revenue, upside_2028q4_gm). |
| Cost of goods sold upside_2028q4_cogs | 2028Q4 / upside | 22,513.37 USD_millions | derived: Expense baseline for inventory and payable turnover. Formula: subtract(upside_2028q4_revenue, upside_2028q4_gross_profit). |
| Total stock compensation expense upside_2028q4_sbc | 2028Q4 / upside | 173.00 USD_millions | assumption: Q1 reference is approximately $106M after-tax adjustment plus $32M related tax effect; later periods are desk assumptions. |
| SBC already included in gross profit upside_2028q4_cogs_sbc | 2028Q4 / upside | 12.80 USD_millions | assumption: Desk assumption, not company guidance. |
| SBC in operating expense upside_2028q4_opex_sbc | 2028Q4 / upside | 160.20 USD_millions | derived: Avoid subtracting COGS SBC a second time. Formula: subtract(upside_2028q4_sbc, upside_2028q4_cogs_sbc). |
| Operating costs excluding SBC upside_2028q4_cashopex | 2028Q4 / upside | 640.00 USD_millions | assumption: Desk assumption, not company guidance. |
| GAAP operating expense upside_2028q4_opex | 2028Q4 / upside | 800.20 USD_millions | derived: Ordinary lease, compliance and development costs remain in operating expense. Formula: sum(upside_2028q4_cashopex, upside_2028q4_opex_sbc). |
| GAAP operating income upside_2028q4_operating_income | 2028Q4 / upside | 2,653.41 USD_millions | derived: No non-GAAP cash-cost exclusion. Formula: subtract(upside_2028q4_gross_profit, upside_2028q4_opex). |
| Standard quarter days upside_2028q4_ar_quarter_days | 2028Q4 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q4_ar_daily | 2028Q4 / upside | 288.52 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q4_revenue, upside_2028q4_ar_quarter_days). |
| Ending balance turnover days upside_2028q4_ar_days | 2028Q4 / upside | 4,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending receivables upside_2028q4_ar_balance | 2028Q4 / upside | 11,540.88 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q4_ar_daily, upside_2028q4_ar_days). |
| Cash source from ar upside_2028q4_ar_cash | 2028Q4 / upside | -641.16 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q3_ar_balance, upside_2028q4_ar_balance). |
| Standard quarter days upside_2028q4_inv_quarter_days | 2028Q4 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q4_inv_daily | 2028Q4 / upside | 250.15 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q4_cogs, upside_2028q4_inv_quarter_days). |
| Ending balance turnover days upside_2028q4_inv_days | 2028Q4 / upside | 7,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending inventory upside_2028q4_inv_balance | 2028Q4 / upside | 17,510.40 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q4_inv_daily, upside_2028q4_inv_days). |
| Cash source from inv upside_2028q4_inv_cash | 2028Q4 / upside | -972.80 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q3_inv_balance, upside_2028q4_inv_balance). |
| Standard quarter days upside_2028q4_ap_quarter_days | 2028Q4 / upside | 9,000.0% ratio | assumption: Desk assumption, not company guidance. |
| Quarter revenue or COGS per model day upside_2028q4_ap_daily | 2028Q4 / upside | 250.15 USD_millions | derived: Turnover approximation using a 90-day quarter. Formula: divide(upside_2028q4_cogs, upside_2028q4_ap_quarter_days). |
| Ending balance turnover days upside_2028q4_ap_days | 2028Q4 / upside | 2,200.0% ratio | assumption: Desk assumption, not company guidance. |
| Ending payables upside_2028q4_ap_balance | 2028Q4 / upside | 5,503.27 USD_millions | derived: Stock balance; not summed in annual outputs. Formula: multiply(upside_2028q4_ap_daily, upside_2028q4_ap_days). |
| Cash source from ap upside_2028q4_ap_cash | 2028Q4 / upside | 305.74 USD_millions | derived: Payable increases fund cash; receivable/inventory increases consume cash. Formula: subtract(upside_2028q4_ap_balance, upside_2028q3_ap_balance). |
| Depreciation and amortization upside_2028q4_da | 2028Q4 / upside | 23.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Operating profit plus noncash expense upside_2028q4_profit_cash | 2028Q4 / upside | 2,849.41 USD_millions | derived: SBC reverses once; dilution remains an economic cost. Formula: sum(upside_2028q4_operating_income, upside_2028q4_sbc, upside_2028q4_da). |
| Cash interest net of cash investment income upside_2028q4_interest | 2028Q4 / upside | 85.00 USD_millions | assumption: Desk bank-rate/coupon timing proxy; exact financing schedule not modeled. |
| Cash tax allowance upside_2028q4_cash_tax | 2028Q4 / upside | 350.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Prepaids, reserves and other working capital use upside_2028q4_other_wc | 2028Q4 / upside | 80.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Net interest, cash taxes and other operating uses upside_2028q4_cash_uses | 2028Q4 / upside | 515.00 USD_millions | derived: Debt principal and preferred dividends excluded here. Formula: sum(upside_2028q4_interest, upside_2028q4_cash_tax, upside_2028q4_other_wc). |
| Cash profit after taxes and net interest upside_2028q4_cash_after_uses | 2028Q4 / upside | 2,334.41 USD_millions | derived: Operating cash-cost proxy. Formula: subtract(upside_2028q4_profit_cash, upside_2028q4_cash_uses). |
| Cash before net deferred-revenue funding upside_2028q4_cfo_before_funding | 2028Q4 / upside | 1,026.19 USD_millions | derived: Sequential balance movements; not a fixed cash-conversion multiple. Formula: sum(upside_2028q4_cash_after_uses, upside_2028q4_ar_cash, upside_2028q4_inv_cash, upside_2028q4_ap_cash). |
| Net customer deferred-revenue cash source upside_2028q4_customer_funding | 2028Q4 / upside | 100.00 USD_millions | assumption: Desk net advance/deferral movement, not all customer cash receipts. |
| Operating cash flow proxy upside_2028q4_cfo | 2028Q4 / upside | 1,126.19 USD_millions | derived: Customer funding enters cash only. Formula: sum(upside_2028q4_cfo_before_funding, upside_2028q4_customer_funding). |
| Cash PP&E purchases upside_2028q4_capex | 2028Q4 / upside | 105.00 USD_millions | assumption: Desk assumption, not company guidance. |
| CFO less capex upside_2028q4_fcf | 2028Q4 / upside | 1,021.19 USD_millions | derived: Before equity investment purchases and financing claims. Formula: subtract(upside_2028q4_cfo, upside_2028q4_capex). |
| Quarter-year dividend factor upside_2028q4_dividend_quarter | 2028Q4 / upside | 25.0% ratio | assumption: Desk assumption, not company guidance. |
| Preferred cash dividend upside_2028q4_preferred_cash | 2028Q4 / upside | 75.47 USD_millions | derived: September uses declared payment; later quarters assume full cash election. Formula: multiply(preferred_face, preferred_rate, upside_2028q4_dividend_quarter). |
| Equity-award tax withholding upside_2028q4_awards | 2028Q4 / upside | 54.00 USD_millions | assumption: Desk assumption, not company guidance. |
| Preferred cash plus employee award taxes upside_2028q4_capital_claims | 2028Q4 / upside | 129.47 USD_millions | derived: Financing outflows; no additional operating expense. Formula: sum(upside_2028q4_preferred_cash, upside_2028q4_awards). |
| Cash after preferred and award taxes upside_2028q4_cash_after_claims | 2028Q4 / upside | 891.72 USD_millions | derived: Before debt repayments and any new financing, including current bank obligations. Formula: subtract(upside_2028q4_fcf, upside_2028q4_capital_claims). |
| Revenue ($M) upside_fy2027_revenue | FY2027 / upside | 73,980.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_revenue, upside_2027q2_revenue, upside_2027q3_revenue, upside_2027q4_revenue). |
| GAAP gross profit ($M) upside_fy2027_gross_profit | FY2027 / upside | 9,617.40 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_gross_profit, upside_2027q2_gross_profit, upside_2027q3_gross_profit, upside_2027q4_gross_profit). |
| GAAP operating income ($M) upside_fy2027_operating_income | FY2027 / upside | 6,957.80 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_operating_income, upside_2027q2_operating_income, upside_2027q3_operating_income, upside_2027q4_operating_income). |
| Cash before net deferred-revenue funding ($M) upside_fy2027_cfo_before_funding | FY2027 / upside | 2,496.25 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_cfo_before_funding, upside_2027q2_cfo_before_funding, upside_2027q3_cfo_before_funding, upside_2027q4_cfo_before_funding). |
| Net deferred-revenue cash source ($M) upside_fy2027_customer_funding | FY2027 / upside | 1,900.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_customer_funding, upside_2027q2_customer_funding, upside_2027q3_customer_funding, upside_2027q4_customer_funding). |
| Operating cash flow proxy ($M) upside_fy2027_cfo | FY2027 / upside | 4,396.25 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_cfo, upside_2027q2_cfo, upside_2027q3_cfo, upside_2027q4_cfo). |
| Cash PP&E purchases ($M) upside_fy2027_capex | FY2027 / upside | 310.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_capex, upside_2027q2_capex, upside_2027q3_capex, upside_2027q4_capex). |
| CFO less capex ($M) upside_fy2027_fcf | FY2027 / upside | 4,086.25 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_fcf, upside_2027q2_fcf, upside_2027q3_fcf, upside_2027q4_fcf). |
| Preferred cash dividend ($M) upside_fy2027_preferred_cash | FY2027 / upside | 290.14 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_preferred_cash, upside_2027q2_preferred_cash, upside_2027q3_preferred_cash, upside_2027q4_preferred_cash). |
| Cash after preferred and award taxes ($M) upside_fy2027_cash_after_claims | FY2027 / upside | 3,624.11 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2027q1_cash_after_claims, upside_2027q2_cash_after_claims, upside_2027q3_cash_after_claims, upside_2027q4_cash_after_claims). |
| Revenue ($M) upside_fy2028_revenue | FY2028 / upside | 96,174.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_revenue, upside_2028q2_revenue, upside_2028q3_revenue, upside_2028q4_revenue). |
| GAAP gross profit ($M) upside_fy2028_gross_profit | FY2028 / upside | 12,791.14 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_gross_profit, upside_2028q2_gross_profit, upside_2028q3_gross_profit, upside_2028q4_gross_profit). |
| GAAP operating income ($M) upside_fy2028_operating_income | FY2028 / upside | 9,737.94 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_operating_income, upside_2028q2_operating_income, upside_2028q3_operating_income, upside_2028q4_operating_income). |
| Cash before net deferred-revenue funding ($M) upside_fy2028_cfo_before_funding | FY2028 / upside | 5,275.84 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_cfo_before_funding, upside_2028q2_cfo_before_funding, upside_2028q3_cfo_before_funding, upside_2028q4_cfo_before_funding). |
| Net deferred-revenue cash source ($M) upside_fy2028_customer_funding | FY2028 / upside | 750.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_customer_funding, upside_2028q2_customer_funding, upside_2028q3_customer_funding, upside_2028q4_customer_funding). |
| Operating cash flow proxy ($M) upside_fy2028_cfo | FY2028 / upside | 6,025.84 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_cfo, upside_2028q2_cfo, upside_2028q3_cfo, upside_2028q4_cfo). |
| Cash PP&E purchases ($M) upside_fy2028_capex | FY2028 / upside | 390.00 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_capex, upside_2028q2_capex, upside_2028q3_capex, upside_2028q4_capex). |
| CFO less capex ($M) upside_fy2028_fcf | FY2028 / upside | 5,635.84 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_fcf, upside_2028q2_fcf, upside_2028q3_fcf, upside_2028q4_fcf). |
| Preferred cash dividend ($M) upside_fy2028_preferred_cash | FY2028 / upside | 301.88 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_preferred_cash, upside_2028q2_preferred_cash, upside_2028q3_preferred_cash, upside_2028q4_preferred_cash). |
| Cash after preferred and award taxes ($M) upside_fy2028_cash_after_claims | FY2028 / upside | 5,129.97 USD_millions | derived: Reported year-to-date amount plus remaining forecast quarters, or sum of four forecast quarters. Formula: sum(upside_2028q1_cash_after_claims, upside_2028q2_cash_after_claims, upside_2028q3_cash_after_claims, upside_2028q4_cash_after_claims). |
Model boundaries
- Orders exceeding $60B during FY2026 are not a disclosed $60B ending backlog and are not added to sales. Customer acceptance, product availability and mix determine recognition.
- No automatic repetition of Q4 17.5% GAAP gross margin. Forecast margin is a desk product/pricing sensitivity, not company annual margin guidance.
- Working-capital balances use a standardized 90-day quarter and revenue/COGS run rates. They are illustrative turnover sensitivities, not a full balance sheet or precise cash collection schedule.
- Reported FY2026 CFO includes noncash, factoring and timing effects beyond the simplified bridge. The forecast omits separate receivables-sale proceeds rather than assuming a new permanent funding source.
- September preferred cash uses the declared initial dividend. Later cash payments are a desk election at the 7% contractual rate; terms can permit shares. Mandatory conversion in 2029 is beyond this horizon.
- Cash after preferred and awards is before debt principal, new borrowing, share issuance, acquisitions and optional buybacks. Current loans of $2.040B require separate repayment/refinancing analysis.
- The August 20 internal investigation conclusion is not a government clearance. Control weaknesses and ongoing official investigations remain risks. No complete common EPS or conversion model is supplied.
AI system growth through the working-capital and financing cycle
Can system delivery fund inventory and receivables while preserving cash after senior claims?
FY2026 revenue was $39.063B, gross profit $4.227B and operating income $2.770B. CFO was negative $6.810B, despite $1.881B net deferred-revenue funding, with $8.877B inventory and $3.922B receivable cash uses. PP&E spending adds $162M. June inventory was $12.896B and current receivables $6.125B. Cash $7.521B followed $9.479B financing cash; it is distinct from internally generated cash. Loans totaled about $4.056B including $2.040B current, with convertible carrying value $4.664B and preferred face $4.3125B. Preferred dividends accrue at 7%; the first cash dividend was declared for September 1. Annual sales guidance is $65B-$72B and Q1 $14.5B-$15.5B. The model tests collection and stocking requirements instead of equating sales growth with cash.
The competing explanation
Large orders can turn into expensive inventory or extended customer credit before deployment. Pricing pressure, product transitions and concentrated customers can reduce margin. Capital raised to fund orders can sustain activity while diluting or subordinating common owners.
Risks to track
- Large customer acceptance and shipment timing can move revenue between quarters.
- Component supply, product transitions and inventory obsolescence affect cash and margin.
- Customer credit and receivables-sale dependence can obscure collection quality.
- Bank maturities, convertibles and preferred dividends create financing needs.
- Equity compensation, financing and mandatory conversion dilute ownership.
- Control weaknesses, export compliance and continuing official investigations remain material.
Next checkpoints
- FY2027 Q1 execution · Quarter ending September 30 (estimated). Compare sales with guidance and inspect inventory/receivable turnover.
- Cash funding · Each quarterly filing (estimated). Separate deferred customer funding, receivables sales and external financing.
- Controls and capital · Filings and financing disclosures (estimated). Monitor remediation, government investigations, loan maturities and preferred declarations.
Data coverage and open work
- Orders exceeding $60B during FY2026 are not a disclosed $60B ending backlog and are not added to sales. Customer acceptance, product availability and mix determine recognition.
- No automatic repetition of Q4 17.5% GAAP gross margin. Forecast margin is a desk product/pricing sensitivity, not company annual margin guidance.
- Working-capital balances use a standardized 90-day quarter and revenue/COGS run rates. They are illustrative turnover sensitivities, not a full balance sheet or precise cash collection schedule.
- Reported FY2026 CFO includes noncash, factoring and timing effects beyond the simplified bridge. The forecast omits separate receivables-sale proceeds rather than assuming a new permanent funding source.
- September preferred cash uses the declared initial dividend. Later cash payments are a desk election at the 7% contractual rate; terms can permit shares. Mandatory conversion in 2029 is beyond this horizon.
- Cash after preferred and awards is before debt principal, new borrowing, share issuance, acquisitions and optional buybacks. Current loans of $2.040B require separate repayment/refinancing analysis.
- The August 20 internal investigation conclusion is not a government clearance. Control weaknesses and ongoing official investigations remain risks. No complete common EPS or conversion model is supplied.
What the memory says
State as of the 2026-09-18 close: in a 120-day uptrend, above its 200-day, off the 52-week high, with a clear path above, ordinary volume, closed weak, and crowded with peers
| Vs the market, in points | Low | Middle | High | Share up |
|---|---|---|---|---|
| 1 session | -3.6 | +0.1 | +4.7 | 53% |
| 5 sessions | -13.3 | -0.3 | +11.9 | 48% |
| 10 sessions | -16.7 | +0.0 | +12.6 | 50% |
Historical distributions of what followed similar states, measured before today's news. Not a forecast; no side.