F5 Financial Model

• Total assets: Approximately $5.5 billion.
• Key asset categories: Cash and short-term investments (~$1.3 billion), Goodwill and Intangible Assets (~$2.5 billion).
• Goodwill & intangibles as % of total assets: Roughly 45%, reflecting a history of strategic software acquisitions.
• Working capital profile:
• Days Sales Outstanding (DSO): 45 to 50 days.
• Days Inventory Outstanding (DIO): 20 to 30 days (hardware inventory is kept lean via contract manufacturers).
• Days Payable Outstanding (DPO): 35 to 45 days.
• Net working capital as % of revenue: Consistently negative.
• Is working capital positive or negative? Negative. The company funds growth from working capital because it collects cash upfront for annual maintenance and software subscriptions, recording massive deferred revenue liabilities.
• PP&E: Asset-light. Consists mostly of corporate leasehold improvements, testing lab equipment, and internal IT hardware.
• Right-of-use assets / operating leases: Material, typically representing $150 million to $200 million for global office space.

• Capex as % of revenue: 1.5% to 2.5% (e.g., $16 million in Q4 2025 on $810 million in revenue).
• Maintenance capex vs. growth capex: Almost entirely maintenance for internal IT, testing labs, and facility upgrades.
• Major capex programmes underway or planned: None material; the company leverages public cloud providers for its SaaS infrastructure rather than building proprietary data centres.
• Capitalised software / development costs: Minimal relative to total R&D spend.
• M&A pattern: Bolt-on acquirer focused on software and security (historical acquisitions include NGINX, Shape Security, and Volterra).
• Typical acquisition multiple paid: Historically paid high revenue multiples (5x to 10x) for high-growth SaaS assets.

• Total debt: Zero traditional long-term debt. The company operates with a pristine balance sheet.
• Debt/EBITDA ratio: 0.0x.
• Credit rating: Unrated (no public debt outstanding).
• Key debt instruments: None. The company maintains a revolving credit facility for liquidity but rarely draws on it.
• Maturity profile: Not applicable.
• Interest rate profile: The company generates interest income on its $1.3 billion cash pile rather than paying interest expense.
• Covenants: Standard facility covenants tied to interest coverage and leverage, which the company easily clears.
• Share repurchase programme: Highly active. The Board authorised an additional $1 billion for share repurchases in late 2024.
• Dividend policy: No regular dividend. All capital return is executed via share repurchases.

• Operating cash flow conversion: Consistently >1.3x (OCF / GAAP Net Income).
• Free cash flow margin: 28% to 30% (FCF / Revenue). FY2025 generated $906 million in FCF on $3.1 billion in revenue.
• Major non-cash items: Stock-based compensation and amortisation of acquired intangibles bridge the gap between GAAP net income and OCF.
• Working capital cash flow impact: Deferred revenue is a massive source of cash. When bookings grow, cash is collected immediately, boosting OCF well ahead of recognised P&L revenue.
• Capex intensity: Extremely low, driving near 100% conversion of OCF to FCF.
• Cash tax rate vs. GAAP effective tax rate: Cash taxes are typically lower than the statutory rate due to tax benefits from stock-based compensation and R&D tax credits.

1. Assumptions

• Contains all hardcoded drivers for revenue growth, margins, working capital days, tax rates, and valuation metrics.

1. Revenue & Bookings

• Calculates Systems, Software, and Global Services revenue.
• Requires a Deferred Revenue roll-forward schedule (Beginning Balance + Billings - Recognised Revenue = Ending Balance).

1. Income Statement

• Projects GAAP and Non-GAAP profitability.
• Requires specific line items: Product Revenue, Services Revenue, Product COGS, Services COGS, Sales and Marketing, Research and Development, General and Administrative.

1. Balance Sheet

• Projects Assets, Liabilities, and Shareholders' Equity.
• Must explicitly break out Cash and Short-Term Investments, Goodwill, and Deferred Revenue (Current and Non-Current).

1. Cash Flow Statement

• Reconciles Net Income to Cash from Operations, Investing, and Financing.
• Must include add-backs for Stock-Based Compensation and Depreciation & Amortisation.

1. Debt & Equity Schedule

• Tracks the share repurchase programme.
• Calculates basic and diluted shares outstanding, factoring in SBC dilution.

1. DCF Valuation

• Calculates Unlevered Free Cash Flow, applies WACC, and determines implied share price.

1. Total Revenue = Systems Revenue + Software Revenue + Global Services Revenue
2. Systems Revenue = Prior Year Systems Revenue x (1 + Systems Growth Rate)
3. Software Revenue = Prior Year Software Revenue x (1 + Software Growth Rate)
4. Global Services Revenue = (Beginning Deferred Revenue x Recognition Rate) + (In-Period Services Billings x In-Period Recognition Rate)
5. Total Deferred Revenue Ending Balance = Deferred Revenue Beginning Balance + Total Billings - Total Recognised Revenue
6. GAAP Gross Profit = Total Revenue - (Product COGS + Services COGS)
7. Non-GAAP Operating Income = GAAP Operating Income + Stock-Based Compensation + Amortisation of Acquired Intangible Assets
8. Free Cash Flow = Cash Provided by Operating Activities - Purchases of Property and Equipment
9. Diluted Shares Outstanding = Beginning Shares - (Share Repurchases / Average Share Price) + SBC Dilution
10. Interest Income = Average Cash and Investments Balance x Yield on Cash

The Assumptions sheet dictates the growth and margin profiles feeding the Revenue & Bookings and Income Statement sheets. The Revenue & Bookings sheet calculates recognised revenue for the P&L and ending deferred revenue for the Balance Sheet. The Income Statement generates Net Income, which flows to the top of the Cash Flow Statement. The Cash Flow Statement calculates the ending cash balance, which links back to the Balance Sheet to ensure it balances. The Debt & Equity Schedule uses free cash flow from the Cash Flow Statement to determine affordable share repurchases, which in turn reduces the share count used to calculate EPS on the Income Statement.

• Revenue, Gross Profit, and Net Income are POSITIVE.
• Expenses (COGS, R&D, SG&A, Taxes) are NEGATIVE on the Income Statement to allow for simple summation.
• Assets, Liabilities, and Equity balances are POSITIVE.
• Cash inflows are POSITIVE.
• Cash outflows (Capital Expenditures, Share Repurchases) are NEGATIVE.

• Failing to model the Deferred Revenue roll-forward will completely break the cash flow dynamics; Global Services revenue cannot simply be grown by a percentage without tying to billings and cash collection.
• Mixing GAAP and Non-GAAP margins will result in massive valuation errors. F5 reports ~84% Non-GAAP gross margins, but GAAP is lower due to SBC and amortisation. The model must explicitly separate these.
• Underestimating Stock-Based Compensation will artificially inflate free cash flow. SBC is a real cost to shareholders via dilution and must be captured in the share count roll-forward.
• Extrapolating the late 2025 Systems revenue surge (up 42% YoY) into the future will overstate long-term growth. Hardware revenue is cyclical and driven by tech refresh cycles.
• Ignoring the near-term impact of the late 2025 security incident will result in overly optimistic FY2026 projections. Management guided to conservative 0% to 4% growth due to sales cycle disruptions.
• Modeling interest expense for a company with zero debt is a common template error. F5 generates interest income on its cash pile.
• Failing to sweep excess cash into share repurchases will result in an artificially bloated cash balance, lowering the company's modeled return on equity.
• Using the statutory tax rate instead of the effective cash tax rate will understate operating cash flow.

• Total Assets must equal Total Liabilities + Shareholders' Equity in every projected period.
• Non-GAAP Gross Margin should remain in the 82% to 85% range based on historical performance; flag if outside this band.
• Free Cash Flow margin (FCF / Revenue) should remain between 25% and 32%.
• Operating Cash Flow to Net Income conversion must be >1.2x due to high SBC and deferred revenue dynamics.
• Capex as a percentage of revenue should not exceed 3%.
• The Deferred Revenue balance must remain above $1.8 billion and grow roughly in line with Software and Services billings.
• Debt/EBITDA must remain at 0.0x unless a hypothetical acquisition scenario is triggered.

• Filings: SEC EDGAR for F5, Inc. (FFIV) 10-K and 10-Q filings; investor relations page (investors.f5.com) for earnings presentations and financial supplements.
• Key Peers: Cisco Systems (CSCO), Juniper Networks (JNPR), Cloudflare (NET), A10 Networks (ATEN), and Radware (RDWR).
• Industry Data: Gartner Magic Quadrant for Web Application and API Protection (WAAP) to track competitive positioning.
• Consensus Estimates: Bloomberg or FactSet for forward-looking revenue and EPS consensus to validate model outputs.

• F5, Inc. Q4 2025 Earnings Release and Call Transcript (October 2025)
• F5, Inc. Q1 2026 Earnings Release (January 2026)
• F5, Inc. FY2025 Annual Report on Form 10-K
• Macrotrends and GuruFocus historical financial data for F5, Inc.
• SEC EDGAR database for F5, Inc. filings