Skyworks Solutions Financial Model

• Total assets: Approximately $8.0 billion to $8.5 billion.
• Key asset categories: Cash and cash equivalents, accounts receivable, inventory, property, plant and equipment (PP&E), and goodwill.
• Goodwill & intangibles as % of total assets: Approximately 35-40%, stemming from historical acquisitions like the Silicon Labs infrastructure and automotive business.
• Working capital profile:
• Days Sales Outstanding (DSO): 40-50 days.
• Days Inventory Outstanding (DIO): 110-130 days (currently elevated due to channel inventory digestion).
• Days Payable Outstanding (DPO): 35-45 days.
• Net working capital as % of revenue: Typically 15-20%.
• Is working capital positive or negative? Positive. The company requires significant inventory to support rapid smartphone launch ramps.
• PP&E: Consists of fabrication facilities in Massachusetts and California, and assembly/test facilities in Mexico and Asia. Useful lives range from 5 to 10 years for machinery.
• Right-of-use assets / operating leases: Present but not a dominant component of the asset base.

• Capex as % of revenue: 4-5% (approximately $150m to $200m annually).
• Maintenance capex vs. growth capex: Roughly 40% maintenance, 60% growth (upgrading tools for next-generation filter technologies).
• Major capex programmes underway or planned: Investments in advanced packaging and heterogeneous integration capabilities.
• Capitalised software / development costs if material: Not a primary driver of capex; most R&D is expensed as incurred.
• M&A pattern: Historically a bolt-on acquirer, but the proposed $22 billion merger with Qorvo represents a transformational shift.

• Total debt: Approximately $1.2 billion.
• Debt/EBITDA ratio: Very conservative, typically below 1.5x.
• Credit rating: Investment grade.
• Key debt instruments: Term loans and senior unsecured notes.
• Maturity profile: Staggered, with a significant term loan maturity approaching in mid-2024/2025 that requires monitoring or refinancing.
• Interest rate profile: A mix of fixed notes and floating-rate term loans.
• Covenants: Standard leverage and interest coverage ratios; the company operates well within these limits.
• Share repurchase programme: Highly active, historically used to return excess free cash flow to shareholders.
• Dividend policy: The company pays a regular quarterly dividend, with a yield typically around 2-3% and a payout ratio of roughly 30-40% of free cash flow.

• Operating cash flow conversion: Very strong, typically generating $1.3 billion to $1.8 billion annually.
• Free cash flow margin: 27-40% of revenue, a standout metric for the business.
• Major non-cash items that bridge net income to OCF: Depreciation, amortisation of intangibles, and stock-based compensation.
• Working capital cash flow impact: Inventory swings can cause significant quarter-to-quarter volatility in operating cash flow.
• Capex intensity: Relatively low for a semiconductor manufacturer (4-5% of revenue) because Skyworks outsources some advanced silicon manufacturing to foundries while keeping proprietary filter and assembly processes in-house.
• Cash tax rate vs. GAAP effective tax rate: Generally aligned, though R&D tax credits and foreign earnings mix can create slight deviations.

1. Assumptions: Hardcoded inputs for macroeconomic drivers, smartphone market growth, Apple concentration adjustments, and margin targets.
2. Summary: A dashboard displaying revenue growth, Non-GAAP gross margin, EPS, and free cash flow generation.
3. Income Statement: GAAP and Non-GAAP views, separating out SBC and acquisition-related amortisation.
4. Balance Sheet: Standard asset, liability, and equity line items mirroring the 10-K.
5. Cash Flow Statement: Indirect method starting from net income, detailing working capital changes and capex.
6. Revenue Build: Segment-level forecasting for Mobile and Broad Markets, including a specific sub-schedule for Apple vs. Non-Apple Mobile revenue.
7. Opex & SBC: Detailed schedules for R&D and SG&A, linking headcount assumptions and stock-based compensation trends.
8. Working Capital: Schedules for accounts receivable, inventory, and accounts payable driven by DSO, DIO, and DPO.
9. Debt & Interest: Tranche-by-tranche debt schedule calculating interest expense and tracking maturities.
10. Capex & Depreciation: PP&E roll-forward, splitting maintenance and growth capex, and calculating depreciation expense.

1. "Mobile Revenue = (Apple Smartphone Units x Skyworks Content per Apple Device) + (Android Units x Skyworks Content per Android Device)"
2. "Broad Markets Revenue = Prior Year Broad Markets Revenue x (1 + Broad Markets Growth Rate)"
3. "Total Revenue = Mobile Revenue + Broad Markets Revenue"
4. "Cost of Goods Sold = Total Revenue x (1 - GAAP Gross Margin %)"
5. "Non-GAAP Gross Profit = Total Revenue - COGS + Stock-Based Compensation in COGS + Amortisation of Intangibles in COGS"
6. "R&D Expense = Total Revenue x R&D % of Revenue"
7. "SG&A Expense = Total Revenue x SG&A % of Revenue"
8. "Operating Income = Total Revenue - COGS - R&D Expense - SG&A Expense"
9. "Accounts Receivable = (Total Revenue / 365) x DSO"
10. "Inventory = (COGS / 365) x DIO"
11. "Accounts Payable = (COGS / 365) x DPO"
12. "Free Cash Flow = Operating Cash Flow - Capital Expenditures"

The Revenue Build sheet is the primary engine of the model, feeding the top line of the Income Statement. The Income Statement generates net income, which flows to the top of the Cash Flow Statement and feeds retained earnings on the Balance Sheet. The Working Capital sheet uses revenue and COGS from the Income Statement to calculate balance sheet accounts, and the period-over-period changes flow into the Cash Flow Statement. The Debt & Interest sheet creates a circular reference: interest expense reduces net income, which reduces cash flow, which dictates the cash available to pay down debt, which in turn recalculates interest expense. A circuit breaker toggle must be included to resolve this circularity.

• Revenues, assets, and cash inflows are represented as positive numbers.
• Expenses, liabilities, and cash outflows (including capital expenditures and dividends) are represented as negative numbers in the cash flow statement and debt schedules.
• Margins and growth rates are represented as positive percentages unless indicating a decline or loss.
• The builder must ensure that subtracting a negative expense does not accidentally add it back to the income statement.

• Failing to separate Apple revenue from the rest of the Mobile segment; the 20-25% reduction in Apple demand must be modelled explicitly to capture the current fundamental reality.
• Confusing GAAP and Non-GAAP gross margins. The model must clearly bridge the two, as management guides to Non-GAAP (which excludes SBC and amortisation).
• Underestimating the impact of factory underutilisation. If Mobile revenue drops sharply, gross margins will compress faster than a linear relationship suggests due to fixed factory overhead.
• Ignoring the seasonality of the business. The December quarter (Q1) is always the strongest; applying a flat quarterly growth rate will produce an inaccurate cash flow profile.
• Miscalculating inventory cash flows. Skyworks is currently working through elevated channel inventory; the model must allow for DIO to normalise downwards, which will act as a source of cash.
• Overlooking the Qorvo merger implications. If the user wishes to model the pro-forma entity, a separate combination schedule is required to account for the $500m in targeted cost synergies.
• Treating stock-based compensation as a cash expense. It must be added back in the cash flow statement to accurately reflect the company's robust free cash flow generation.
• Forgetting the 14th week in certain fiscal years (e.g., Q4 2025), which artificially inflates revenue and opex for that specific quarter.

• "Apple concentration should not exceed 60% in projected years, reflecting the dual-sourcing impact and Broad Markets growth."
• "Non-GAAP Gross margin should remain in the 45-48% range; flag if it drops below 45% or exceeds 49%."
• "Free Cash Flow margin should remain between 25% and 35% of total revenue."
• "Capex as a percentage of revenue should not exceed 6% unless a major new fab expansion is explicitly triggered."
• "The Balance Sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity in every period."
• "Debt/EBITDA should remain below 2.0x, reflecting the company's conservative leverage profile."
• "Dividend payout ratio should remain between 30% and 45% of Free Cash Flow."

• Filings: SEC EDGAR for Skyworks Solutions (SWKS) 10-K and 10-Q filings; Investor Relations page for quarterly earnings presentations and non-GAAP reconciliations.
• Peers for benchmarking: Qorvo (QRVO), Broadcom (AVGO), Qualcomm (QCOM), and Murata Manufacturing.
• Industry data sources: IDC or Gartner for global smartphone shipment forecasts; ABI Research for IoT connection growth.
• Consensus estimates: FactSet or Bloomberg for forward-looking revenue and EPS estimates to validate model outputs.

• Skyworks Solutions Inc. Annual Report on Form 10-K (Fiscal Year 2024/2025)
• Semiconductor Today: Skyworks' Broad Markets revenue returns to year-on-year growth
• MacDailyNews: Skyworks stock plummets as Apple turns to competitor
• Seeking Alpha: Skyworks Solutions: Apple Concentration Discount Keeps Shares Cheap
• GuruFocus: Skyworks Solutions Gross Margin %
• Alpha Spread: Gross Margin - Skyworks Solutions Inc
• Investing.com: Skyworks Relies on Apple for 59% of Sales