IBM Financial Model

Software

• Segment name: Software (includes Hybrid Platform & Solutions, Transaction Processing).
• Revenue driver formula: Prior Year Revenue x (1 + Segment Growth Rate), driven by Red Hat adoption and generative AI (watsonx) bookings.
• Historical growth rate: 5% to 11% (accelerated to 11% in 2025).
• Key growth levers and headwinds: Enterprise AI adoption and Red Hat OpenShift expansion act as levers, while legacy transaction processing software decline acts as a headwind.
• Pricing dynamics: Largely subscription-based and recurring software licences with built-in pricing escalators.
• Revenue recognition notes: Recognised over the contract term for SaaS and subscriptions, leading to significant deferred revenue balances.
• Seasonality: Q4 is historically the strongest quarter due to enterprise software budget flushes and calendar year-end renewals.

Consulting

• Segment name: Consulting (includes Business Transformation, Technology Consulting, Application Operations).
• Revenue driver formula: Billable Headcount x Utilisation Rate x Average Billing Rate.
• Historical growth rate: Flat to 5% (slowed to 2% in 2025).
• Key growth levers and headwinds: Digital transformation initiatives drive growth, whereas macroeconomic uncertainty and discretionary IT spending cuts act as headwinds.
• Pricing dynamics: Time-and-materials contracts and fixed-price milestone contracts.
• Revenue recognition notes: Recognised over time as services are delivered.
• Seasonality: Relatively smooth, though Q1 can be slightly weaker due to project ramp-ups after the holidays.

Infrastructure

• Segment name: Infrastructure (includes Hybrid Infrastructure, Infrastructure Support).
• Revenue driver formula: Mainframe Cycle Volume x Average Selling Price + Support Contracts.
• Historical growth rate: Highly cyclical, ranging from -5% to +12% depending on the IBM Z product cycle (grew 12% in 2025).
• Key growth levers and headwinds: The launch of new mainframe generations (like the z16) drives massive upgrade cycles, followed by predictable multi-year lulls.
• Pricing dynamics: High-ticket capital expenditure for clients, often bundled with financing.
• Revenue recognition notes: Hardware recognised upon delivery or installation, while support is deferred and recognised over the contract life.
• Seasonality: Extremely Q4 heavy, aligning with enterprise capital expenditure budget exhaustion.

Financing

• Segment name: Financing (Client Financing, Commercial Financing).
• Revenue driver formula: Average Financing Receivables x Net Interest Yield.
• Historical growth rate: Declining to flat as IBM wound down OEM commercial financing to focus solely on IBM products.
• Key growth levers and headwinds: Directly tied to Infrastructure hardware sales and prevailing interest rates.
• Pricing dynamics: Interest rates charged to clients based on credit risk and market rates.
• Revenue recognition notes: Interest income recognised over the term of the lease or loan.
• Seasonality: Mirrors the Infrastructure segment.

• Total assets: Approximately $140 billion to $150 billion.
• Key asset categories: Goodwill and intangible assets dominate the balance sheet, alongside financing receivables and deferred costs.
• Goodwill & intangibles as % of total assets: Exceeds 45%, reflecting the $34 billion Red Hat acquisition and the $6.4 billion HashiCorp acquisition.
• Working capital profile:
• Days Sales Outstanding (DSO): 65 to 75 days.
• Days Inventory Outstanding (DIO): 20 to 25 days (only applicable to the hardware business).
• Days Payable Outstanding (DPO): 55 to 65 days.
• Net working capital as % of revenue: Typically negative due to massive deferred revenue balances from software subscriptions.
• Is working capital positive or negative? Negative, providing a structural cash flow advantage as clients pay upfront for software and support.
• PP&E: Relatively light (around $5 billion to $6 billion), consisting of data centres, research facilities, and manufacturing plants for mainframes.
• Right-of-use assets / operating leases: Material, typically around $3 billion to $4 billion for global office and facility leases.

• Capex as % of revenue: 2% to 3% (very asset-light following the Kyndryl spinoff).
• Maintenance capex vs. growth capex: Roughly 40% maintenance and 60% growth (data centre expansion for hybrid cloud).
• Major capex programmes underway or planned: Expansion of AI supercomputing capacity and watsonx infrastructure.
• Capitalised software / development costs: Highly material, often exceeding $500 million annually, which flatters operating cash flow.
• M&A pattern: Transformational acquisitions (Red Hat, HashiCorp) supplemented by frequent bolt-on acquisitions in consulting and niche software (Apptio, StreamSets).
• Typical acquisition multiple paid: High multiples for software assets (e.g. HashiCorp acquired for roughly 10x forward revenue).

• Total debt: Approximately $55 billion to $60 billion (including global financing debt).
• Debt/EBITDA ratio: Approximately 2.5x to 3.0x.
• Credit rating: A- tier (S&P/Fitch), maintaining solid investment grade status.
• Key debt instruments: Senior unsecured notes across multiple currencies, commercial paper, and term loans.
• Maturity profile: Well-laddered, with $4 billion to $7 billion maturing annually.
• Interest rate profile: Predominantly fixed rate, with a weighted average cost of debt around 3.5% to 4.5%.
• Covenants: Standard interest coverage and leverage covenants, with ample headroom.
• Share repurchase programme: Historically active, but paused or minimised recently to prioritise debt paydown following large acquisitions.
• Dividend policy: Very strong commitment to the dividend, paying out roughly $6 billion annually with a yield typically between 3% and 4%.

• Operating cash flow conversion: Very strong, often exceeding 120% of GAAP net income due to massive depreciation, amortisation, and deferred revenue inflows.
• Free cash flow margin: 20% to 22% (generated $14.7 billion in FCF on $67.5 billion revenue in 2025).
• Major non-cash items that bridge net income to OCF: Depreciation, amortisation of acquired intangibles, stock-based compensation, and pension adjustments.
• Working capital cash flow impact: Deferred revenue growth acts as a major source of cash during periods of software expansion.
• Capex intensity: Low, ensuring the vast majority of operating cash flow converts to free cash flow.
• Cash tax rate vs. GAAP effective tax rate: The cash tax rate is often lower than the statutory rate due to R&D tax credits, foreign tax structures, and the resolution of tax audits (which drove a negative GAAP tax rate in 2025).

1. Control Panel: Toggles for constant currency vs reported growth, mainframe cycle timing, and M&A inclusion.
2. Assumptions: Hardcoded drivers for segment growth, margins, working capital days, and tax rates.
3. Revenue Build: Detailed build for Software, Consulting, Infrastructure, and Financing, including Red Hat specific breakouts.
4. Cost Build: COGS and Opex schedules, separating workforce rebalancing charges and pension settlements from core operations.
5. Income Statement: GAAP and Non-GAAP (Operating) views, mirroring IBM's specific reporting format.
6. Balance Sheet: Assets, liabilities, and equity, with specific lines for deferred revenue and financing receivables.
7. Cash Flow Statement: Operating, investing, and financing cash flows.
8. Free Cash Flow Bridge: Custom schedule reconciling GAAP OCF to IBM's reported FCF (adjusting for financing receivables and capex).
9. Debt Schedule: Tranche-by-tranche debt maturity profile, interest expense calculation, and global financing debt breakout.
10. Working Capital: DSO, DIO, DPO, and deferred revenue roll-forward.
11. Depreciation & Amortisation: Waterfall schedule for PP&E, capitalised software, and acquired intangibles.
12. Valuation: Sum-of-the-parts DCF (valuing Software at a higher multiple than Consulting/Infrastructure) and WACC calculation.

1. Software Revenue = Prior Year Software Revenue x (1 + Software Growth Assumption)
2. Red Hat Revenue = Prior Year Red Hat Revenue x (1 + Red Hat Growth Assumption)
3. Consulting Revenue = Prior Year Consulting Revenue x (1 + Consulting Growth Assumption)
4. Infrastructure Revenue = Prior Year Infrastructure Revenue x (1 + Infrastructure Cyclical Growth Assumption)
5. Total Gross Profit = (Software Rev x Software GM%) + (Consulting Rev x Consulting GM%) + (Infrastructure Rev x Infrastructure GM%) + (Financing Rev x Financing GM%)
6. Non-GAAP Operating Income = Total Gross Profit - R&D Expense - SG&A Expense (excluding acquired intangible amortisation and workforce rebalancing)
7. Deferred Revenue Ending Balance = Beginning Balance + New Billings - Recognised Revenue
8. Financing Interest Income = Average Global Financing Receivables x Average Yield
9. Interest Expense = Average Total Debt x Weighted Average Interest Rate
10. IBM Defined Free Cash Flow = Net Cash from Operating Activities - Capital Expenditures + Net Change in Financing Receivables
11. Non-GAAP Effective Tax Rate = Non-GAAP Pre-Tax Income x Non-GAAP Tax Rate Assumption
12. Dividends Paid = Shares Outstanding x Annual Dividend Per Share

The Assumptions sheet feeds the Revenue Build and Cost Build. The Revenue Build drives the top line of the Income Statement and dictates the deferred revenue additions in the Working Capital sheet. The Cost Build flows into the Income Statement and determines the operating margin. The Income Statement generates net income, which is the starting point for the Cash Flow Statement. The Working Capital and Depreciation & Amortisation sheets feed the non-cash adjustments in the Cash Flow Statement. The Cash Flow Statement determines the ending cash balance and debt paydown capacity, which links to the Debt Schedule. The Debt Schedule calculates interest expense, which flows back to the Income Statement, creating a circular reference that must be managed with an iterative calculation toggle. Finally, the Free Cash Flow Bridge pulls from the Cash Flow Statement to feed the Valuation sheet.

• Revenue and asset balances are positive.
• Expenses (COGS, R&D, SG&A, Interest Expense) are entered as positive numbers in their respective build schedules but subtracted in the Income Statement formulas.
• Liability and equity balances are positive.
• Cash inflows are positive and cash outflows (including Capex and Dividends) are negative on the Cash Flow Statement.
• Margin percentages are positive.

• IBM defines Free Cash Flow uniquely by adding back the net change in financing receivables to Operating Cash Flow. Failing to model this adjustment will cause the model's FCF to miss company guidance by billions.
• The company reports both GAAP and Operating (Non-GAAP) earnings. The model must explicitly separate pension settlement charges and acquisition-related amortisation to reconcile with consensus estimates.
• Infrastructure revenue is highly cyclical. Straight-lining historical growth will fail to capture the massive spikes and subsequent contractions driven by the IBM Z mainframe release schedule.
• Foreign currency translation swings reported revenue significantly. The model should forecast on a constant-currency basis and apply a separate FX overlay.
• Capitalised software development costs artificially boost operating cash flow. Analysts must ensure these are captured in the investing section to understand true cash generation.
• The HashiCorp acquisition closed in 2025, meaning historical financials prior to 2025 do not include its revenue or margin profile. A pro-forma adjustment is required for year-over-year comparability.
• IBM's GAAP tax rate is highly volatile due to audit resolutions (e.g. a negative 2.3% rate in 2025). The model must use the Non-GAAP operating tax rate (around 13.5%) for forecasting.
• Financing segment debt is often viewed separately from core corporate debt by rating agencies. The model should bifurcate global financing debt from core debt to calculate accurate leverage ratios.

• Total Gross Margin should remain between 56% and 60%. Flag if it falls outside this band.
• Software revenue must represent at least 45% of total revenue and grow as a percentage of the total mix over time.
• IBM Defined Free Cash Flow should exceed $12 billion annually.
• The Non-GAAP effective tax rate should be hardcoded around 13.5% to 14.0%.
• Dividend payout ratio (Dividends Paid / Free Cash Flow) should remain between 40% and 50%.
• Debt/EBITDA should not exceed 3.0x to maintain the current credit rating profile.
• Balance sheet must balance: Total Assets = Total Liabilities + Equity in every forecasted period.
• Capex as a percentage of revenue should remain strictly between 2% and 4%.

• SEC EDGAR: IBM 10-K and 10-Q filings (specifically the FY2024 and FY2025 10-K).
• IBM Investor Relations: Quarterly earnings presentations, financial complexity guides, and historical segment restatement files.
• Key Peers for Benchmarking: Microsoft (MSFT) for hybrid cloud/software, Accenture (ACN) for consulting, Oracle (ORCL) for enterprise software, and Hewlett Packard Enterprise (HPE) for infrastructure.
• Industry Data Sources: Gartner IT Spending Forecasts (for consulting and software demand), IDC Cloud Infrastructure Tracker.
• Consensus Estimates: Bloomberg or FactSet for forward-looking revenue and EPS estimates.

• IBM Q4 2025 Earnings Release and Full Year 2025 Results (January 28, 2026).
• IBM Q4 2024 Earnings Release and Full Year 2024 Results (January 29, 2025).
• IBM FY2025 Form 10-K filed with the SEC.
• IBM FY2024 Form 10-K filed with the SEC.