# PTC (PTC) Financial Model Free Excel 3-statement financial model and company analysis for PTC. - Canonical: https://finamodel.com/companies/ptc - Industry: Software - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/PTC.xlsx ## Model Purpose This model forecasts Annual Recurring Revenue (ARR), free cash flow generation, and capital return capacity to determine the intrinsic equity valuation of PTC Inc., helping an equity analyst decide whether the stock offers a margin of safety given its transition to a pure-play SaaS industrial software model. ## Company Overview PTC Inc. is a global software company that provides digital transformation solutions for industrial and manufacturing enterprises, enabling them to design, manufacture, and service physical products. The company has successfully transitioned from a legacy perpetual license model to a cloud-native, SaaS-driven subscription model, with 93% of its revenue now recurring. **Business Segments:** * **PLM (Product Lifecycle Management):** ~64% of revenue. Includes Windchill, Arena, and ALM/SLM solutions for product data management and process orchestration. * **CAD (Computer-Aided Design):** ~36% of revenue. Includes Creo and Onshape for product data authoring and 3D design. **Key Geographies:** North America (~50%), Europe (~30%), Asia Pacific (~20%). **Business Model:** Asset-light, SaaS/subscription software model driven by Annual Recurring Revenue (ARR) growth and high retention rates. **Competitive Position:** A market leader in industrial software, competing in a duopoly/oligopoly structure against Dassault Systèmes, Siemens Digital Industries, and Autodesk. **Recent Major Events:** In early 2026, PTC divested its IoT and AR businesses (Kepware and ThingWorx) for approximately $600 million upfront to focus entirely on its core CAD and PLM growth vectors. The company also previously acquired ServiceMax, Onshape, and Arena to bolster its cloud and service lifecycle capabilities. ## Revenue Deep Dive ### PLM (Product Lifecycle Management) * **Segment Name:** PLM * **Revenue Driver Formula:** `Beginning PLM ARR x (1 + Net Retention Rate + New Logo Growth) x ARR-to-Revenue Conversion %` * **Historical Growth Rate:** 10-12% CAGR. * **Key Growth Levers and Headwinds:** Driven by industrial digital transformation, "Digital Thread" adoption, and cross-selling ServiceMax. Headwinds include macroeconomic industrial slowdowns and long enterprise sales cycles. * **Pricing Dynamics:** Contractual subscription pricing with built-in annual escalators and seat-based expansion. * **Revenue Recognition Notes:** Subject to ASC 606. Term-based on-premises software licenses bundled with support/cloud services require significant judgment. The software license portion is often recognized upfront, while support/cloud is recognized over time, creating a timing disconnect between ARR and GAAP revenue. * **Seasonality:** Q1 and Q4 are typically the strongest quarters for bookings, but revenue recognition is smoothed over the year. ### CAD (Computer-Aided Design) * **Segment Name:** CAD * **Revenue Driver Formula:** `Beginning CAD ARR x (1 + Net Retention Rate + New Logo Growth) x ARR-to-Revenue Conversion %` * **Historical Growth Rate:** 7-9% CAGR. * **Key Growth Levers and Headwinds:** Driven by migration to cloud-native CAD (Onshape) and upgrades to Creo. Headwinds include high market saturation and intense competition from Dassault (SolidWorks). * **Pricing Dynamics:** Subscription-based, highly sticky due to the high switching costs of proprietary design files. * **Revenue Recognition Notes:** Similar to PLM, upfront recognition for the on-premise license component of hybrid deployments, with SaaS recognized ratably. * **Seasonality:** Consistent with PLM; heavy Q4 enterprise renewals. ## Cost Structure ### Variable Costs / COGS * **Line-by-line breakdown:** Cloud hosting infrastructure (AWS/Azure), customer support personnel, professional services delivery costs, and software royalties. * **Gross margin range:** 79% - 82% (historically expanding as the mix shifts away from lower-margin professional services). * **Key input costs:** Cloud computing compute/storage, technical support headcount. * **How COGS scales with revenue:** High operating leverage. Cloud hosting scales linearly, but software gross margins expand as the customer base grows on multi-tenant architectures. ### Operating Expenses * **R&D:** ~17-19% of revenue. Covers software engineering for core platforms. Some development costs are capitalised, but the majority is expensed as incurred. * **SG&A:** ~32-35% of revenue. Heavily weighted towards sales commissions, go-to-market realignment costs, and marketing. * **Depreciation & Amortisation:** ~4-5% of revenue. Dominated by the amortisation of acquired intangible assets (~$79M annually) from historical M&A (ServiceMax, Arena). * **Stock-Based Compensation:** ~$200M - $230M annually (~9-10% of revenue). A major non-cash expense that flatters non-GAAP margins. * **Restructuring / one-time charges:** Frequent due to M&A integration and go-to-market realignments (e.g., $20M outflow in FY25). ### Margin Profile * **Gross margin:** ~80-81%. * **EBITDA margin:** ~35-38% (Adjusted). * **Operating margin:** ~20-25% (GAAP), ~38-40% (Non-GAAP). * **Net margin:** ~28% (LTM, aided by tax benefits). * **Margin trend:** Expanding due to the completion of the SaaS transition, divestiture of lower-margin IoT businesses, and operating leverage. ## Balance Sheet Structure * **Total assets:** ~$6.0 - $6.5 billion. * **Key asset categories:** Goodwill and Intangible Assets dominate the asset base due to serial acquisitions. Cash and cash equivalents typically sit around $200M - $250M. * **Goodwill & intangibles as % of total assets:** ~70-75%. * **Working capital profile:** * **DSO:** 60-70 days. * **DIO:** N/A (software company). * **DPO:** 30-45 days. * **Net working capital as % of revenue:** Negative. * **Working capital dynamic:** The company operates with negative net working capital due to massive Deferred Revenue balances (unearned revenue) from customers paying annual subscriptions upfront. This is a significant source of cash flow funding. * **PP&E:** Minimal (~$150M), mostly leasehold improvements and IT equipment. * **Right-of-use assets:** ~$100M - $150M for global office leases. ## Capital Expenditure & Investment * **Capex as % of revenue:** < 1.0% (Extremely asset-light). * **Maintenance capex vs. growth capex:** Almost entirely maintenance (IT infrastructure, office facilities). * **Major capex programmes:** None material. FY25 capex guidance is ~$15M. * **Capitalised software:** Minimal relative to total R&D; the company primarily expenses software development. * **M&A pattern:** Historically a serial acquirer (ServiceMax for $1.46B, Onshape for $470M), but recently shifted to portfolio optimization (divesting Kepware/ThingWorx in 2026). ## Debt & Capital Structure * **Total debt:** ~$1.2B - $1.4B gross debt. * **Debt/EBITDA ratio:** ~1.2x - 1.7x. Management's target is to keep this below 3.0x. * **Key debt instruments:** Revolving credit facility and Senior Notes. * **Maturity profile:** The company actively manages maturities, recently retiring a $500M bond using cash and the revolver. * **Interest rate profile:** Mix of fixed (Senior Notes) and floating (Revolver). Cash interest payments run ~$80M - $90M annually. * **Share repurchase programme:** Highly active. The company targets returning ~50% of Free Cash Flow to shareholders. FY25 target is $300M in repurchases. * **Dividend policy:** No dividend. All capital return is executed via share buybacks. ## Cash Flow Characteristics * **Operating cash flow conversion:** >1.2x OCF / Net Income. * **Free cash flow margin:** ~30-35% (FCF / Revenue). * **Major non-cash items:** Depreciation & Amortisation (~$100M+), Stock-Based Compensation (~$200M+), and Deferred Income Taxes. * **Working capital cash flow impact:** Deferred revenue growth is a major source of operating cash flow. * **Capex intensity:** Negligible (~$15M on $2.3B+ revenue). * **Seasonality:** Due to invoicing seasonality, the majority of cash collections occur in H1 (Q1 and Q2), making Q4 the lowest cash flow generation quarter. ## Sheet Structure 1. **Assumptions:** Hardcoded inputs for ARR growth, margins, tax rates, capex, and capital allocation targets. 2. **ARR & Revenue Build:** Forecasts PLM ARR, CAD ARR, and translates ARR into GAAP Revenue using historical conversion ratios. Includes a pro-forma adjustment column for the 2026 Kepware/ThingWorx divestiture. 3. **Income Statement:** GAAP view. Revenue (Recurring vs. Perpetual/Services), COGS, Gross Profit, R&D, SG&A, Amortisation of Intangibles, Operating Income, Interest Expense, Tax, Net Income. 4. **Balance Sheet:** Cash, Accounts Receivable, Prepaid Expenses, PP&E, Goodwill, Intangible Assets, ROU Assets, Accounts Payable, Accrued Expenses, Deferred Revenue (Current & Long-Term), Debt, Equity. 5. **Cash Flow Statement:** Net Income, D&A, SBC, Deferred Taxes, Change in NWC (specifically calling out Deferred Revenue), OCF, Capex, FCF, Debt Issuance/Repayment, Share Repurchases. 6. **Debt & Interest Schedule:** Tracks Revolver and Senior Notes balances, calculates interest expense based on weighted average rates, and models mandatory vs. optional paydowns. 7. **Working Capital Schedule:** Calculates AR, AP, and Deferred Revenue based on days outstanding and billing assumptions. 8. **DCF Valuation:** Unlevered Free Cash Flow calculation, WACC assumptions, terminal value (Gordon Growth), and implied share price. ## Key Financial Relationships 1. `PLM ARR = Prior Period PLM ARR * (1 + PLM ARR Growth Rate)` 2. `CAD ARR = Prior Period CAD ARR * (1 + CAD ARR Growth Rate)` 3. `Total ARR = PLM ARR + CAD ARR` 4. `Recognized Recurring Revenue = Total ARR * ARR-to-Revenue Conversion %` 5. `Total Revenue = Recognized Recurring Revenue + Perpetual License Revenue + Professional Services Revenue` 6. `Gross Profit = Total Revenue - (Cloud Hosting Costs + Support Personnel + Services COGS)` 7. `Operating Expenses = R&D + SG&A + Amortisation of Acquired Intangibles + Restructuring Charges` 8. `Non-GAAP Operating Income = GAAP Operating Income + Stock-Based Compensation + Amortisation of Acquired Intangibles + Restructuring Charges` 9. `Deferred Revenue Ending Balance = Beginning Balance + Total Invoiced Billings - Recognized Recurring Revenue` 10. `Free Cash Flow = Operating Cash Flow - Capital Expenditures` 11. `Share Repurchases = IF(Debt/EBITDA < 3.0x, Free Cash Flow * 50%, 0)` 12. `Interest Expense = (Beginning Debt + Ending Debt) / 2 * Weighted Average Interest Rate` ## Cross-Sheet Dependencies * **ARR & Revenue Build** is the engine of the model. It feeds the top line of the **Income Statement** and drives the Billings calculation in the **Working Capital Schedule**. * The **Working Capital Schedule** calculates the change in Deferred Revenue, which is a critical positive adjustment in the **Cash Flow Statement**. * The **Cash Flow Statement** generates Free Cash Flow, which feeds the **Debt & Interest Schedule** (for debt paydown) and the Equity account (for share repurchases). * **Circularity Risk:** Interest expense on the **Income Statement** lowers Net Income, which lowers OCF, which reduces cash available for debt paydown on the **Debt & Interest Schedule**, which in turn affects the average debt balance and interest expense. A circularity toggle (breaker) must be included. ## Sign Convention * **Income Statement:** Revenue is positive. All expenses (COGS, Opex, Interest, Tax) are entered as positive numbers and subtracted in subtotal formulas. * **Balance Sheet:** All assets, liabilities, and equity balances are positive. * **Cash Flow Statement:** Net Income is positive. Non-cash add-backs (D&A, SBC) are positive. Increases in assets are negative (cash outflows). Increases in liabilities (like Deferred Revenue) are positive (cash inflows). Capex, debt repayments, and share repurchases are negative. ## Things Most Likely to Go Wrong 1. **ARR vs. Revenue Disconnect:** PTC's ARR does not perfectly match GAAP revenue due to ASC 606 rules regarding upfront recognition of on-premise licenses bundled in subscriptions. The model must use a conversion ratio rather than equating ARR to Revenue. 2. **Divestiture Modeling:** The model must strip out Kepware and ThingWorx revenue and associated operating expenses starting in Q2 FY2026 to avoid overstating the core business growth. 3. **Stock-Based Compensation:** SBC runs at ~$200M+ annually. Excluding it from 'adjusted' figures flatters margins by ~900 bps. The DCF must treat SBC as a real economic cost (either via dilution or deducting it from FCF). 4. **Cash Flow Seasonality:** H1 (Q1/Q2) generates the vast majority of cash flow due to annual billing cycles. If building a quarterly model, applying a flat 25% cash collection per quarter will break the cash balance logic. 5. **Deferred Revenue:** This is the primary driver of working capital cash flow. Failing to link ARR growth to Deferred Revenue growth will severely understate Operating Cash Flow. 6. **Tax Rate Volatility:** GAAP EPS is frequently impacted by non-cash tax benefits/charges related to IRS procedural guidance. The cash tax rate (~$110M on ~$600M pre-tax income) is a better proxy for cash flow modeling than the GAAP effective rate. 7. **Amortisation of Intangibles:** This is a fixed, declining schedule based on past M&A. It should not be modeled as a percentage of revenue. 8. **Share Count:** PTC aggressively buys back stock to offset SBC dilution. The model must dynamically reduce the share count based on the $300M annual repurchase target. ## Validation Checks 1. "Gross margin should be in the 79-82% range; flag if outside this band." 2. "Capex as % of revenue must be < 1.0% (company is highly asset-light)." 3. "OCF/Net Income conversion should be > 1.2x due to deferred revenue and SBC add-backs." 4. "Debt/EBITDA should remain below 3.0x per management's capital allocation framework." 5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period." 6. "Share repurchases should equal approximately 50% of Free Cash Flow in normalized years." 7. "Cash interest expense should reconcile to ~$80M - $90M annually based on current debt loads." 8. "Total ARR growth should not exceed 15% without flagging (historical organic growth is high single to low double digits)." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | PLM ARR Growth Rate | 10.0 | % | Blended historical growth rate for Windchill/Arena. | | CAD ARR Growth Rate | 8.0 | % | Historical growth rate for Creo/Onshape. | | ARR to Revenue Conversion | 98.0 | % | ASC 606 timing differences cause slight variations between ARR and recognized revenue. | | Gross Margin | 81.0 | % | Based on FY24/FY25 historical averages. | | R&D as % of Revenue | 18.0 | % | Historical average for core platform development. | | SG&A as % of Revenue | 33.0 | % | Historical average, inclusive of go-to-market realignment costs. | | Amortisation of Intangibles | 79.0 | $M | Fixed annual run-rate based on FY24 guidance. | | Stock-Based Compensation | 215.0 | $M | Midpoint of FY25 guidance ($210M - $220M). | | Capex | 15.0 | $M | FY25 management guidance. | | Cash Tax Payments | 115.0 | $M | Midpoint of FY25 guidance ($110M - $120M). | | Target Share Repurchases | 300.0 | $M | FY25 stated capital return target. | | Average Interest Rate | 6.5 | % | Blended rate on Senior Notes and Revolver. | | Fully Diluted Share Count | 121.0 | Millions | FY24 ending share count. | | WACC | 9.5 | % | Standard discount rate for mature, profitable SaaS. | | Terminal Growth Rate | 3.0 | % | Long-term GDP + industrial software pricing power. | ## Data Sources & Benchmarks * **Filings:** SEC EDGAR (PTC Inc. 10-K, 10-Q, 8-K), PTC Investor Relations website (investor.ptc.com). * **Key Peers for Benchmarking:** Dassault Systèmes (DSY.PA), Siemens Digital Industries (SIE.DE), Autodesk (ADSK), Bentley Systems (BSY). * **Industry Data Sources:** Gartner Magic Quadrant for PLM, Forrester Wave for Industrial IoT/Digital Twin. * **Consensus Estimates:** Bloomberg, FactSet, or Quartr for ARR and FCF consensus. ## Sources * PTC Inc. Q1 2025 Earnings Release: https://www.ptc.com/en/investor-relations * PTC Inc. Q3 2025 Earnings Release: https://www.ptc.com/en/investor-relations * PTC Inc. Q4 2024 and Full Year Results: https://investor.ptc.com * PTC Inc. 2024 Annual Report (Form 10-K): https://www.sec.gov/edgar * Seeking Alpha PTC Analysis (August 2025): https://seekingalpha.com * Quartr PTC M&A Announcement Summary (March 2026): https://quartr.com --- ## Frequently asked questions ### What does PTC Inc. do? PTC Inc. is a global software company providing digital transformation solutions for industrial and manufacturing enterprises. It enables them to design, manufacture, and service physical products, operating primarily through its PLM and CAD business segments. The company has successfully transitioned to a cloud-native, SaaS-driven subscription model, with 93% of its revenue now recurring. ### How does PTC Inc. generate revenue? PTC Inc. generates revenue through an asset-light, SaaS/subscription software model, primarily driven by Annual Recurring Revenue (ARR) growth and high retention rates. Its main revenue streams come from its Product Lifecycle Management (PLM) and Computer-Aided Design (CAD) solutions. ### What is the projected revenue growth rate for PTC Inc. in the financial model? The financial model for PTC Inc. assumes a revenue growth rate of approximately 13.68%. This key assumption drives the top-line forecast for the company's performance from FY2026 to FY2030. ### What is PTC Inc.'s capital expenditure profile? PTC Inc. operates with an extremely asset-light business model, reflected in its low capital expenditure. Capex as a percentage of revenue is assumed to be around 2.01% in the financial model, primarily consisting of maintenance investments for IT infrastructure and office facilities. ### What is the purpose of the PTC Inc. financial model? The PTC Inc. financial model is designed to forecast Annual Recurring Revenue (ARR), free cash flow generation, and capital return capacity. Its primary purpose is to determine the intrinsic equity valuation of PTC Inc., assisting equity analysts in evaluating the stock's margin of safety. ### Can I download an Excel financial model for PTC Inc.? Yes, an Excel financial model for PTC Inc. is available for download. This model provides forecasts for the company's financials from fiscal year 2026 through fiscal year 2030, covering key aspects like ARR and free cash flow. [Interactive forecast calculator](https://finamodel.com/companies/ptc/forecast)