# Lam Research (LRCX) Financial Model Free Excel 3-statement financial model and company analysis for Lam Research. - Canonical: https://finamodel.com/companies/lam-research - Industry: Semiconductors - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/LRCX.xlsx ## Model Purpose This model provides a comprehensive equity valuation and scenario planning tool to determine if Lam Research's current share price accurately reflects the anticipated cyclical recovery in memory wafer fabrication equipment spending and structural growth from AI-driven advanced packaging. ## Company Overview Lam Research Corporation designs, manufactures, and services semiconductor wafer fabrication equipment used in front-end processing. The company specialises in deposition, etch, and clean technologies that are critical for manufacturing advanced memory and logic chips. The business operates through two primary segments: Systems, which accounts for approximately 60% of revenue, and the Customer Support Business Group (CSBG), which accounts for the remaining 40%. Key geographies include China, Korea, Taiwan, Japan, the US, and Europe, with China recently serving as a major revenue contributor. Lam Research operates an asset-light manufacturing business model with a highly profitable, recurring-like aftermarket tail driven by an installed base of over 90,000 tools. The company holds a dominant competitive position in an oligopolistic market, competing primarily with Applied Materials, Tokyo Electron, and ASML. Recent major events include a 10-for-1 stock split effective in October 2024 and a $10 billion share repurchase authorisation announced in May 2024. ## Revenue Deep Dive ### Systems - Segment name: Systems - Revenue driver formula: Global Wafer Fabrication Equipment Spend x Lam Research Market Share - Historical growth rate: 5-year CAGR of 8% to 10%, though highly cyclical with steep peaks and troughs. - Key growth levers and headwinds: Driven by AI infrastructure demand (Gate-All-Around and High Bandwidth Memory), memory market recovery, and potential headwinds from US export restrictions to China. - Pricing dynamics: Contractual with volume discounts, featuring high average selling prices in the millions of dollars per tool. - Revenue recognition notes: Point in time upon transfer of control, except for shipments to Japan which are recognised upon customer acceptance and held in deferred revenue until that time. - Seasonality: Mild calendar seasonality, as revenue is driven more by customer fab construction and tooling schedules. ### Customer Support Business Group (CSBG) - Segment name: Customer Support-Related Revenue and Other - Revenue driver formula: Installed Base of Tools x Average Revenue per Tool - Historical growth rate: 11% to 17% CAGR, demonstrating much lower cyclicality than the Systems segment. - Key growth levers and headwinds: Driven by utilisation rates at customer fabs, the complexity of new nodes requiring more frequent servicing, and demand for Reliant legacy tools. - Pricing dynamics: Combination of spot pricing for spares and contractual pricing for long-term service agreements. - Revenue recognition notes: Recognised over time for service contracts and at a point in time for spare parts. - Seasonality: Generally stable, tracking closely with global semiconductor manufacturing volumes. ## Cost Structure ### Variable Costs / COGS - COGS includes direct materials (components and sub-assemblies), manufacturing overhead, field service labour for CSBG, warranty costs, and freight. - Gross margin range: 46.0% to 50.5% over the last 5 years, averaging around 48.0%. - Key input costs and commodity exposures: Specialised machined parts, electronic components, and global supply chain logistics costs. - COGS scales linearly with Systems revenue but benefits from operating leverage and favourable mix shifts when CSBG revenue outpaces Systems revenue. ### Operating Expenses - R&D: Typically 11% to 12% of revenue. It is expensed as incurred and covers the development of next-generation deposition and etch technologies. - SG&A: Typically 5% to 6% of revenue. This is highly scalable and primarily headcount-driven. - Depreciation & Amortisation: Approximately 1.5% to 2.0% of revenue, split mostly towards tangible manufacturing and testing equipment. - Stock-Based Compensation: Typically 2% to 3% of revenue, used heavily for engineering and executive retention. - Restructuring / one-time charges: Infrequent, usually occurring only during severe industry downturns to realign the manufacturing footprint. ### Margin Profile - Gross margin: 46.0% to 50.5%. - EBITDA margin: 31.0% to 36.0%. - Operating margin: 29.0% to 34.5%. - Net margin: 25.0% to 30.0%. - Margin trend: Expanding due to operating leverage, higher CSBG mix, and manufacturing efficiency initiatives. ## Balance Sheet Structure - Total assets: Approximately $21.4 billion. - Key asset categories: Cash and short-term investments ($6.2 billion), Inventory ($4.3 billion), and Accounts Receivable ($3.4 billion). - Goodwill & intangibles as % of total assets: Approximately 8%, reflecting a history of organic growth rather than transformational M&A. - Working capital profile: - Days Sales Outstanding (DSO): 60 to 75 days. - Days Inventory Outstanding (DIO): 100 to 120 days, elevated due to complex supply chains and deferred acceptance in Japan. - Days Payable Outstanding (DPO): 40 to 50 days. - Net working capital as % of revenue: Typically 20% to 25%. - Working capital is positive and acts as a use of cash during cyclical upswings when inventory builds are required. - PP&E: Approximately $2.4 billion, consisting of testing facilities, cleanrooms, and R&D labs. The company uses an asset-light model by outsourcing many sub-assemblies. - Right-of-use assets / operating leases: Material but manageable, representing approximately $300 million to $400 million for global office and warehouse space. ## Capital Expenditure & Investment - Capex as % of revenue: 3.0% to 5.0%. - Maintenance capex vs. growth capex: Estimated 30% maintenance and 70% growth, primarily directed towards new R&D facilities and lab equipment. - Major capex programmes underway or planned: Investments in advanced packaging and Gate-All-Around testing capabilities. - Capitalised software / development costs: Minimal, as the vast majority of R&D is expensed as incurred. - M&A pattern: Organic grower with occasional bolt-on acquisitions for software or niche process technologies. - Typical acquisition multiple paid: Not applicable due to the lack of recent material acquisitions. ## Debt & Capital Structure - Total debt: Approximately $4.5 billion, resulting in a net cash positive position. - Debt/EBITDA ratio: Consistently below 1.0x. - Credit rating: Investment grade (A- range). - Key debt instruments: Senior unsecured notes with staggered maturities. - Maturity profile: Well-laddered with average maturities extending beyond 5 years. - Interest rate profile: Primarily fixed-rate bonds with a weighted average cost of debt around 4.0%. - Covenants: Standard investment-grade covenants with no restrictive financial maintenance hurdles. - Share repurchase programme: Highly active. The board authorised a $10 billion programme in May 2024, aiming to return 75% to 100% of free cash flow to shareholders. - Dividend policy: Yield is approximately 1.2%, with a history of double-digit annual growth, including a 15% increase in late 2024. ## Cash Flow Characteristics - Operating cash flow conversion: OCF / Net Income typically ranges from 1.1x to 1.2x. - Free cash flow margin: 25.0% to 35.0% of revenue. - Major non-cash items: Depreciation, amortisation, stock-based compensation, and deferred income taxes. - Working capital cash flow impact: Significant use of cash during revenue ramps due to inventory builds and deferred revenue timing. - Capex intensity: Low, reflecting the outsourced manufacturing strategy. - Cash tax rate vs. GAAP effective tax rate: Closely aligned, though cash taxes can be slightly lower due to the timing of R&D tax credit realisations. ## Sheet Structure 1. **Assumptions**: Hardcoded drivers, macro wafer fabrication equipment estimates, margin targets, tax rate, and WACC. 2. **Summary**: Dashboard with key charts, DCF output, EPS, and target price. 3. **Revenue Build**: Wafer fabrication equipment total addressable market, Lam Research market share, Systems revenue, Installed base roll-forward, and CSBG revenue per tool. 4. **Income Statement**: Revenue to Net Income, and EPS calculation incorporating the October 2024 10-for-1 stock split. 5. **Balance Sheet**: Assets, Liabilities, and Shareholders' Equity. 6. **Cash Flow Statement**: Operating, Investing, and Financing cash flows. 7. **Working Capital**: Accounts Receivable, Inventory, Accounts Payable, and Deferred Revenue schedules. 8. **Debt & Interest**: Debt tranches, interest expense, and interest income on cash balances. 9. **PPE & Intangibles**: Capex and Depreciation & Amortisation waterfall. 10. **Shareholders Equity**: Share repurchases, dividends, stock-based compensation, and retained earnings. 11. **DCF Valuation**: Unlevered free cash flow, terminal value, and WACC calculation. ## Key Financial Relationships 1. `Total Revenue = Systems Revenue + CSBG Revenue` 2. `Systems Revenue = Global WFE Spend x Lam Systems Market Share` 3. `Ending Installed Base = Beginning Installed Base + (Systems Revenue / Average System ASP) - Retirements` 4. `CSBG Revenue = Average Installed Base x CSBG Revenue per Tool` 5. `Gross Profit = Total Revenue x Gross Margin %` 6. `R&D Expense = Total Revenue x R&D %` 7. `SG&A Expense = Total Revenue x SG&A %` 8. `Operating Income = Gross Profit - R&D Expense - SG&A Expense` 9. `Interest Income = Average Cash Balance x Yield on Cash` 10. `Interest Expense = Average Debt Balance x Weighted Average Interest Rate` 11. `Diluted Shares Outstanding = Beginning Shares - (Share Repurchases / Average Share Price) + Options Dilution` 12. `Deferred Revenue Ending Balance = Beginning Balance + New Invoicing - Recognised Revenue` ## Cross-Sheet Dependencies - The **Revenue Build** sheet feeds the **Income Statement** for top-line figures and the **Working Capital** sheet for Accounts Receivable and Deferred Revenue calculations. - The **Income Statement** feeds the **Cash Flow Statement** starting with Net Income and the **Balance Sheet** via Retained Earnings. - The **Working Capital** sheet feeds the **Cash Flow Statement** for changes in net working capital and the **Balance Sheet** for current assets and liabilities. - The **PPE & Intangibles** sheet feeds the **Income Statement** for depreciation and the **Balance Sheet** for Net PPE. - The **Debt & Interest** sheet feeds the **Income Statement** for interest expense and the **Cash Flow Statement** for debt issuance or repayment. - Circularity risk exists because interest income depends on the cash balance, which depends on net income, which in turn depends on interest income. A circuit breaker toggle must be included in the Assumptions sheet. ## Sign Convention - Revenue and Assets are positive. - Expenses (COGS, R&D, SG&A) are positive in their specific build schedules but subtracted in the Income Statement. - Liabilities and Equity are positive. - On the Cash Flow Statement, cash inflows are positive and cash outflows (capex, dividends, share repurchases) are negative. - Contra-assets like Accumulated Depreciation are positive in their schedules but subtracted from gross assets on the Balance Sheet. ## Things Most Likely to Go Wrong 1. Failing to account for the October 2024 10-for-1 stock split, which will cause historical per-share metrics to mismatch projections if not retroactively adjusted. 2. Mismodelling deferred revenue dynamics because Lam Research does not recognise revenue for Japan shipments until customer acceptance, causing inventory and deferred revenue to swell during high-shipment quarters. 3. Overestimating Systems revenue growth by straight-lining it. Wafer fabrication equipment spending is highly cyclical and must be modelled with peaks and troughs. 4. Underestimating CSBG resilience. CSBG is driven by the installed base and fab utilisation, making it a stabilising force during industry downturns. 5. Ignoring the impact of US export restrictions to China, which can abruptly remove a significant portion of the addressable market for specific advanced tools. 6. Miscalculating interest income. Lam Research holds over $6 billion in cash, generating material interest income that significantly impacts pre-tax income. 7. Failing to model the aggressive share repurchase programme, which artificially inflates EPS growth relative to net income growth. 8. Applying a statutory US tax rate instead of Lam Research's effective tax rate, which benefits heavily from Foreign-Derived Intangible Income and R&D credits. ## Validation Checks 1. Gross margin should remain within the 46.0% to 51.0% band. Flag if outside this range. 2. Operating margin should be between 29.0% and 35.0%. 3. CSBG revenue should not decline year-over-year unless there is a severe drop in global fab utilisation. 4. Capex as a percentage of revenue should remain between 3.0% and 5.0% to reflect the asset-light model. 5. Total Assets must equal Total Liabilities plus Shareholders' Equity in all periods. 6. The effective tax rate should be between 12.0% and 15.0%. 7. Cash flow conversion (Operating Cash Flow / Net Income) should be greater than 1.0x. 8. The Debt-to-Equity ratio should remain below 1.0x. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Global WFE Spend Growth | 8.0 | % | Cyclical recovery driven by AI and advanced packaging | | Lam Systems Market Share | 11.5 | % | Historical average share of total WFE market | | CSBG Revenue Growth | 12.0 | % | Driven by growing installed base and higher complexity nodes | | Gross Margin | 49.0 | % | Recent FY25 performance and favourable product mix | | R&D as % of Revenue | 11.5 | % | Historical average required to maintain technology leadership | | SG&A as % of Revenue | 5.5 | % | Highly scalable cost base consistent with recent quarters | | Effective Tax Rate | 13.0 | % | Benefits from FDII and R&D tax credits | | Capex as % of Revenue | 4.0 | % | Asset-light manufacturing model | | DSO (Days Sales Outstanding) | 65 | Days | Historical average | | DIO (Days Inventory Outstanding) | 110 | Days | Complex supply chain and Japan deferred acceptance | | DPO (Days Payable Outstanding) | 45 | Days | Historical average | | Share Repurchases | 2,500 | $M | Active execution of the $10B authorisation | | Dividend Yield | 1.2 | % | Based on recent payouts and 15% dividend hike | | Yield on Cash | 4.5 | % | Current short-term interest rates | | Cost of Debt | 4.0 | % | Weighted average rate on existing senior notes | | WACC | 9.5 | % | Standard discount rate for semiconductor capital equipment | | Terminal Growth Rate | 3.0 | % | Long-term semiconductor industry growth | ## Data Sources & Benchmarks - SEC EDGAR for Lam Research 10-K, 10-Q, and 8-K filings. - Lam Research Investor Relations page for quarterly earnings presentations and transcripts. - Key peers for benchmarking include Applied Materials (AMAT), Tokyo Electron (8035.T), ASML Holding (ASML), and KLA Corporation (KLAC). - SEMI (Semiconductor Equipment and Materials International) for global wafer fabrication equipment spend forecasts. - Consensus estimates from Bloomberg or FactSet for near-term revenue and EPS validation. ## Sources - Lam Research Corporation Form 10-K for the fiscal year ended June 30, 2024 (SEC EDGAR). - Lam Research Corporation Q2, Q3, and Q4 FY2025 Earnings Releases (investor.lamresearch.com). - Lam Research Press Release regarding the $10 Billion Share Repurchase Authorisation and 10-for-1 Stock Split dated May 21, 2024. - SEMI Global Semiconductor Equipment Market Statistics. --- ## Frequently asked questions ### What does Lam Research Corporation do? Lam Research designs, manufactures, and services semiconductor wafer fabrication equipment, specializing in deposition, etch, and clean technologies. These technologies are critical for manufacturing advanced memory and logic chips, supporting the global semiconductor industry. ### What are the primary revenue drivers for Lam Research? Lam Research's revenue is primarily driven by its Systems segment, accounting for approximately 60% of revenue, and its Customer Support Business Group (CSBG), contributing the remaining 40%. Key drivers include the anticipated cyclical recovery in memory wafer fabrication equipment spending and structural growth from AI-driven advanced packaging. ### What is Lam Research's capital expenditure strategy? Lam Research operates an asset-light manufacturing model, with capex typically ranging from 3.0% to 5.0% of revenue. Approximately 70% of this capex is allocated to growth, primarily funding new R&D facilities and lab equipment for advanced packaging and Gate-All-Around testing capabilities. ### What is the purpose of the financial model for Lam Research? The financial model serves as a comprehensive equity valuation and scenario planning tool for Lam Research. Its primary goal is to assess if the company's current share price accurately reflects the anticipated cyclical recovery in memory wafer fabrication equipment spending and structural growth from AI-driven advanced packaging. ### Can I download an Excel financial model for Lam Research? Yes, a downloadable Excel financial model for Lam Research is available. This model provides a forecast horizon from FY2026 to FY22030, allowing for detailed analysis of the company's future financial performance. ### How does Lam Research manage its working capital? Lam Research maintains a positive net working capital profile, typically 20% to 25% of revenue, which acts as a use of cash during cyclical upswings. The company manages Days Sales Outstanding between 60-75 days, Days Inventory Outstanding between 100-120 days, and Days Payable Outstanding between 40-50 days. [Interactive forecast calculator](https://finamodel.com/companies/lam-research/forecast)