# Autodesk (ADSK) Financial Model Free Excel 3-statement financial model and company analysis for Autodesk. - Canonical: https://finamodel.com/companies/autodesk - Industry: Software - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/ADSK.xlsx ## Model Purpose This model projects Autodesk's revenue, billings, and free cash flow generation to determine its equity valuation, specifically assessing how the company's transition to a new direct-billing transaction model impacts working capital and long-term margin expansion. ## Company Overview Autodesk is a global leader in 3D design, engineering, and entertainment software, providing essential tools for architects, engineers, manufacturers, and digital artists. The company operates through four primary revenue segments: Architecture, Engineering, Construction and Operations (AECO, ~50% of revenue); AutoCAD and AutoCAD LT (~25%); Manufacturing (MFG, ~20%); and Media and Entertainment (M&E, ~5%). Geographically, revenue is split across the Americas (~44%), EMEA (~39%), and APAC (~17%). Autodesk operates a highly profitable, asset-light, subscription-based business model with over 97% recurring revenue. Its competitive position is dominant, effectively serving as the industry standard in construction and engineering design software. A major recent event is the global rollout of a "new transaction model" (an agency model where Autodesk bills customers directly rather than through channel partners), which structurally changes billings timing, deferred revenue recognition, and channel margin capture. ## Revenue Deep Dive ### Architecture, Engineering, Construction and Operations (AECO) - **Segment name**: AECO - **Revenue driver formula**: AECO Subscriptions x Average Revenue Per User (ARPU) - **Historical growth rate**: 18-22% YoY - **Key growth levers and headwinds**: Driven by the digitization of the construction industry, adoption of Building Information Modelling (BIM), and the Autodesk Build platform. Headwinds include commercial real estate slowdowns and high interest rates impacting new construction starts. - **Pricing dynamics**: High pricing power due to high switching costs and industry-standard status (Revit, Civil 3D). - **Revenue recognition notes**: Subscription revenue recognised rateably over the contract term. - **Seasonality**: Q4 (ending January 31) is typically the strongest quarter for enterprise renewals and billings. ### AutoCAD and AutoCAD LT - **Segment name**: AutoCAD and AutoCAD LT - **Revenue driver formula**: AutoCAD Subscriptions x ARPU - **Historical growth rate**: 12-17% YoY - **Key growth levers and headwinds**: A mature product line driven by steady price increases and conversion of legacy non-compliant users to paid subscriptions. - **Pricing dynamics**: Contractual subscription pricing with regular inflationary increases. - **Revenue recognition notes**: Rateable recognition over the subscription period. - **Seasonality**: Follows the standard enterprise software renewal cycle, peaking in Q4. ### Manufacturing (MFG) - **Segment name**: MFG - **Revenue driver formula**: MFG Subscriptions x ARPU - **Historical growth rate**: 15-20% YoY - **Key growth levers and headwinds**: Growth is heavily driven by Fusion 360 cloud adoption and convergence of design and manufacturing. - **Pricing dynamics**: Highly competitive pricing against peers like Dassault Systèmes and PTC to capture market share in cloud manufacturing. - **Revenue recognition notes**: Rateable recognition. - **Seasonality**: Q4 peak for billings. ### Media and Entertainment (M&E) - **Segment name**: M&E - **Revenue driver formula**: M&E Subscriptions x ARPU - **Historical growth rate**: 5-8% YoY - **Key growth levers and headwinds**: Driven by gaming and film visual effects (Maya, 3ds Max). Headwinds include Hollywood strikes and studio budget cuts. - **Pricing dynamics**: Standard subscription pricing, highly sensitive to studio headcount. - **Revenue recognition notes**: Rateable recognition. - **Seasonality**: Less pronounced than AECO, but still Q4 weighted. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown**: Cost of subscription and maintenance revenue (cloud hosting via AWS, customer support, software royalties) and Cost of other revenue (consulting and training). - **Gross margin range**: 84% to 86% historically. - **Key input costs and commodity exposures**: Cloud infrastructure costs and third-party technology licensing fees. - **How COGS scales with revenue**: Highly scalable with massive operating leverage. Cloud costs step up in tranches but grow significantly slower than top-line revenue. ### Operating Expenses - **R&D**: Typically 20-23% of revenue. Autodesk expenses the vast majority of its R&D, with minimal capitalisation of software development costs compared to peers. - **SG&A**: Typically 38-42% of revenue. Heavily driven by sales commissions, marketing events (Autodesk University), and corporate overhead. The new transaction model is expected to optimise sales efficiency. - **Depreciation & Amortisation**: Low as a % of revenue (~3-5%), primarily related to amortisation of acquired intangibles from M&A (e.g., PlanGrid, Innovyze). - **Stock-Based Compensation**: Massive expense, typically running at 12-15% of revenue. - **Restructuring / one-time charges**: Frequent in recent years, including a major sales optimisation plan in FY26/FY27 incurring $135-$160 million in charges. ### Margin Profile - **Gross margin**: ~85% (stable). - **EBITDA margin**: ~25-28% (GAAP). - **Operating margin**: GAAP operating margin ranges from 20-22%. Non-GAAP operating margin ranges from 36-38%. - **Margin trend**: Expanding. The transition to the new transaction model and AI-driven internal efficiencies are pushing Non-GAAP operating margins toward 39%. ## Balance Sheet Structure - **Total assets**: Approximately $10-11 billion. - **Key asset categories**: Cash and cash equivalents, Accounts Receivable, Goodwill, and Intangible Assets. - **Goodwill & intangibles as % of total assets**: Very high (typically 40-50% of total assets) due to a history of strategic acquisitions. - **Working capital profile**: - **Days Sales Outstanding (DSO)**: 45-55 days. - **Days Inventory Outstanding (DIO)**: 0 days (software company). - **Days Payable Outstanding (DPO)**: 30-40 days. - **Net working capital as % of revenue**: Deeply negative. - **Is working capital positive or negative?**: Negative. Autodesk collects cash upfront for annual and multi-year subscriptions but recognises revenue over time. This negative working capital is a massive structural advantage that funds operations and share repurchases. - **PP&E**: Minimal (mostly leasehold improvements for corporate offices and internal IT equipment). - **Right-of-use assets / operating leases**: Material, representing global office space leases. ## Capital Expenditure & Investment - **Capex as % of revenue**: 1-2% (extremely asset-light). - **Maintenance capex vs. growth capex**: Almost entirely maintenance (IT infrastructure and office facilities). - **Major capex programmes underway or planned**: None material. - **Capitalised software / development costs if material**: Autodesk capitalises very little software development cost, preferring to expense R&D as incurred. - **M&A pattern**: Serial bolt-on acquirer. Focuses on adjacent technologies in construction (PlanGrid, BuildingConnected) and water infrastructure (Innovyze). - **Typical acquisition multiple paid**: High revenue multiples (often 10x-15x ARR) for high-growth SaaS targets. ## Debt & Capital Structure - **Total debt**: Approximately $2.5-$3.0 billion in senior unsecured notes. - **Debt/EBITDA ratio**: ~1.5x to 2.0x (conservative leverage). - **Credit rating**: Investment grade (typically BBB/Baa2). - **Key debt instruments**: Fixed-rate senior notes with staggered maturities. - **Maturity profile**: Well-laddered over the next 5-10 years. - **Interest rate profile**: Predominantly fixed-rate bonds. - **Covenants**: Standard investment-grade incurrence covenants; no restrictive financial maintenance covenants. - **Share repurchase programme**: Highly active. Autodesk repurchased $1.4 billion in shares in FY26, consistently using free cash flow to offset SBC dilution and reduce share count. - **Dividend policy**: No dividend. 100% of shareholder return is via share repurchases. ## Cash Flow Characteristics - **Operating cash flow conversion**: Consistently >1.0x (OCF is significantly higher than GAAP Net Income). - **Free cash flow margin**: 30-35% (FY26 FCF was $2.41 billion on $7.21 billion revenue). - **Major non-cash items that bridge net income to OCF**: Stock-based compensation, amortisation of intangibles, and the positive change in deferred revenue. - **Working capital cash flow impact**: Massive source of cash. As billings grow, deferred revenue grows, providing upfront cash before revenue is recognised. - **Capex intensity**: Negligible. - **Cash tax rate vs. GAAP effective tax rate**: Cash taxes are often lower than GAAP taxes due to tax deductions from stock option exercises and R&D tax credits. ## Sheet Structure 1. **Assumptions**: Contains all hardcoded inputs for macroeconomic drivers, segment growth rates, margin targets, tax rates, and WACC. 2. **Revenue & Billings**: Projects AECO, AutoCAD, MFG, and M&E revenue. Calculates Total Revenue. Includes the Deferred Revenue roll-forward and calculates Total Billings. 3. **Income Statement**: Standard P&L from Total Revenue down to Net Income. Includes a clear bridge from GAAP Operating Income to Non-GAAP Operating Income. 4. **Balance Sheet**: Assets, Liabilities, and Equity. Must explicitly break out Deferred Revenue (Current and Non-Current). 5. **Cash Flow Statement**: OCF, CFI, CFF. Must explicitly show the add-back of SBC and the working capital benefit of Deferred Revenue. 6. **Debt Schedule**: Tracks senior notes, interest expense, and maturity repayments. 7. **Working Capital**: Schedules for Accounts Receivable, Prepaid Expenses, Accounts Payable, and Accrued Liabilities. 8. **DCF Valuation**: Unlevered Free Cash Flow calculation, WACC build-up, terminal value, and implied share price. ## Key Financial Relationships 1. `Total Revenue = AECO Revenue + AutoCAD Revenue + MFG Revenue + M&E Revenue + Other Revenue` 2. `Total Billings = Total Revenue + (Ending Deferred Revenue - Beginning Deferred Revenue)` 3. `AECO Revenue = Prior Year AECO Revenue * (1 + AECO YoY Growth Rate)` 4. `Gross Profit = Total Revenue - Cost of Subscription and Maintenance Revenue - Cost of Other Revenue` 5. `GAAP Operating Income = Gross Profit - R&D Expense - SG&A Expense - Amortisation of Acquired Intangibles - Restructuring Charges` 6. `Non-GAAP Operating Income = GAAP Operating Income + Stock-Based Compensation + Amortisation of Acquired Intangibles + Restructuring Charges` 7. `Ending Deferred Revenue = Beginning Deferred Revenue + Total Billings - Total Revenue Recognised` 8. `Free Cash Flow = Cash Flow from Operating Activities - Capital Expenditures` 9. `SBC Expense = Total Revenue * SBC % of Revenue` 10. `Interest Expense = Average Debt Balance * Weighted Average Interest Rate` 11. `Diluted Shares Outstanding = Basic Shares + Dilutive Effect of Stock Options - (Share Repurchases / Average Share Price)` 12. `Unlevered Free Cash Flow = Non-GAAP Operating Income * (1 - Cash Tax Rate) + D&A - Capital Expenditures + Change in Net Working Capital` ## Cross-Sheet Dependencies - The **Assumptions** sheet feeds growth rates and margin profiles into the **Revenue & Billings** and **Income Statement** sheets. - The **Revenue & Billings** sheet feeds Total Revenue to the **Income Statement** and Ending Deferred Revenue to the **Balance Sheet**. - The **Income Statement** generates Net Income, which is the starting line for the **Cash Flow Statement**. - The **Cash Flow Statement** calculates the change in cash, which feeds the Cash line on the **Balance Sheet**. - The **Debt Schedule** calculates Interest Expense, which feeds the **Income Statement**, creating a minor circularity if interest income on cash balances is modelled (recommend using a switch to break circularity). - The **Working Capital** sheet uses Total Revenue and COGS to calculate AR and AP, feeding both the **Balance Sheet** and the **Cash Flow Statement**. ## Sign Convention - **Income Statement**: Revenue is positive. All expenses (COGS, R&D, SG&A, Interest, Taxes) are positive numbers, subtracted in subtotal formulas (e.g., `Gross Profit = Revenue - COGS`). - **Balance Sheet**: Assets are positive. Liabilities and Equity are positive. - **Cash Flow Statement**: Cash inflows are positive. Cash outflows (Capex, share repurchases, debt repayment) are negative. - **Working Capital**: An increase in an asset (e.g., AR) is a negative adjustment to cash flow. An increase in a liability (e.g., Deferred Revenue) is a positive adjustment to cash flow. ## Things Most Likely to Go Wrong - **Misunderstanding the New Transaction Model**: The shift to an agency model changes the timing of billings and reduces deferred revenue balances slightly, while increasing net revenue retention. The model must account for this structural shift in the deferred revenue roll-forward. - **Ignoring Stock-Based Compensation**: Autodesk issues massive amounts of equity. Valuing the company on Non-GAAP FCF without deducting SBC or accounting for share dilution will severely overvalue the equity. - **Confusing Billings with Revenue**: Billings represent cash invoiced; Revenue is recognised rateably. The model must explicitly calculate Billings as a derivative of Revenue and the change in Deferred Revenue. - **Overestimating Capex**: Autodesk is a mature software company. Capex should not exceed 1-2% of revenue. Modelling higher capex will artificially depress FCF. - **Mismodelling Working Capital**: Standard DSO/DPO models fail here. The primary driver of working capital is Deferred Revenue. If Deferred Revenue is not modelled as a function of Billings and Revenue, the cash flow statement will be entirely wrong. - **Constant Currency vs. Reported**: Autodesk frequently reports constant currency growth rates. The model must use reported GAAP figures for historicals to ensure the balance sheet balances. - **Restructuring Add-backs**: Management excludes restructuring charges from Non-GAAP metrics. The model must include these cash outflows in the Cash Flow Statement, even if excluded from Non-GAAP Operating Income. - **Share Count Dynamics**: Share repurchases are funded by FCF, but SBC constantly dilutes the share base. The model must net these two forces to project the correct Diluted Shares Outstanding. ## Validation Checks - "Gross margin should remain in the 84-86% range; flag if outside this band." - "Non-GAAP Operating Margin should trend towards 38.5-39.0% based on FY27 management guidance." - "Free Cash Flow margin (FCF / Total Revenue) should consistently exceed 30%." - "Total Assets must equal Total Liabilities + Equity in every projected period." - "Deferred Revenue must be the largest liability on the balance sheet." - "Operating Cash Flow must be significantly higher than GAAP Net Income (typically 1.5x to 2.0x)." - "Capex as a % of revenue must remain under 2%." - "Net Working Capital should remain deeply negative throughout the forecast period." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | AECO Revenue Growth | 20.0 | % | Blended FY26 actual growth and Q4 outperformance | | AutoCAD Revenue Growth | 15.0 | % | FY26 actuals, reflecting steady legacy transition | | MFG Revenue Growth | 18.0 | % | FY26 actuals, driven by Fusion 360 adoption | | M&E Revenue Growth | 7.0 | % | FY26 actuals, reflecting slower end-market growth | | Gross Margin | 85.0 | % | Historical 3-year average | | R&D as % of Revenue | 22.0 | % | Historical GAAP average | | SG&A as % of Revenue | 38.0 | % | Historical GAAP average | | Non-GAAP Operating Margin Target | 38.5 | % | FY27 management guidance | | Capex as % of Revenue | 1.0 | % | Asset-light software model historical average | | Effective Tax Rate (Non-GAAP) | 17.0 | % | FY26 actual and FY27 management guidance | | Share Repurchases | 1.4 | $B | FY26 actual run-rate | | WACC | 8.5 | % | Standard cost of capital for mature, large-cap software | | Terminal FCF Growth Rate | 3.0 | % | Long-term GDP plus inflation | ## Data Sources & Benchmarks - **Filings**: SEC EDGAR (Autodesk 10-K, 10-Q, 8-K) and the Autodesk Investor Relations website. - **Key Peers for Benchmarking**: Dassault Systèmes (DSY.PA), Bentley Systems (BSY), PTC Inc. (PTC), Adobe (ADBE), Nemetschek (NEM.DE). - **Industry Data Sources**: Deloitte Construction Industry Outlook, Statista Market Insights for SaaS and Manufacturing software. - **Consensus Estimates**: Bloomberg, FactSet, or Quartr for forward-looking analyst estimates on Billings and FCF. ## Sources - Autodesk FY26 Q4 Earnings Release and Presentation (autodesk.com) - Autodesk FY25 Annual Report / Form 10-K (SEC EDGAR) - Quartr Earnings Summaries for Autodesk Q3 FY25 and Q4 FY26 - AlphaStreet Autodesk Earnings Previews and Transcripts - Seeking Alpha: Autodesk Pre-Earnings Assessment --- ## Frequently asked questions ### What does Autodesk do? Autodesk is a global leader in 3D design, engineering, and entertainment software, providing essential tools for professionals across architecture, manufacturing, and media. The company operates a highly profitable, subscription-based business model with over 97% recurring revenue. ### How does Autodesk generate revenue? Autodesk generates revenue primarily through its subscription-based software model, with key segments including Architecture, Engineering, Construction and Operations (AECO), AutoCAD, Manufacturing, and Media & Entertainment. A recent shift to a direct-billing "new transaction model" is influencing billings timing and deferred revenue recognition. ### What are the key assumptions in the Autodesk financial model? Key assumptions in the Autodesk financial model include a revenue growth rate of approximately 13.8% and a COGS percentage of revenue around 9.4%. Research and Development (R&D) is projected at about 25% of revenue, while Selling, General & Administrative (SGA) expenses are assumed to be around 11.6% of revenue. ### How does Autodesk's working capital impact its valuation? Autodesk's deeply negative net working capital, resulting from collecting cash upfront for annual and multi-year subscriptions, is a significant structural advantage. This negative working capital effectively funds operations and share repurchases, positively impacting free cash flow generation and, consequently, its equity valuation. ### What is the forecast horizon for the downloadable Autodesk financial model? The downloadable Excel financial model for Autodesk projects financial performance from fiscal year 2027 through fiscal year 2031. This model aims to assess the company's revenue, billings, and free cash flow generation. ### What is the significance of Autodesk's 'new transaction model' for its financials? The global rollout of Autodesk's 'new transaction model,' where it bills customers directly, structurally changes billings timing and deferred revenue recognition. This transition is also expected to impact channel margin capture and long-term margin expansion, which is a key focus of the financial model. [Interactive forecast calculator](https://finamodel.com/companies/autodesk/forecast)