PTC logo
PTC Financial Model

Software Company Financials Example (Free Excel Download)

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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

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.

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.

The downloadable PTC financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsPTC financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$1.81B$1.93B$2.10B$2.30B$2.74B
Gross profit$1.44B$1.55B$1.66B$1.85B$2.29B
Operating income$380.7M$447.4M$458.5M$588.1M$982.4M
Net income$476.9M$313.1M$245.5M$376.3M$734.0M

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
13.7%
COGS % of revenue
22.1%
R&D % of revenue
18.0%
SG&A % of revenue
10.9%
D&A % of revenue
5.2%
Effective tax rate
21.0%
See 8 more
Capex % of revenue
2.0%
Net working capital % of revenue
-17.6%
Other assets % of revenue
305.7%
Other liabilities % of revenue
42.9%
Annual debt paydown
5.0%
Interest rate on debt
4.4%
Dividend payout ratio
0.0%
Buybacks % of net income
93.0%

How to build a detailed financial model for PTC

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

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)

AssumptionDefault ValueUnitRationale
PLM ARR Growth Rate10.0%Blended historical growth rate for Windchill/Arena.
CAD ARR Growth Rate8.0%Historical growth rate for Creo/Onshape.
ARR to Revenue Conversion98.0%ASC 606 timing differences cause slight variations between ARR and recognized revenue.
Gross Margin81.0%Based on FY24/FY25 historical averages.
R&D as % of Revenue18.0%Historical average for core platform development.
SG&A as % of Revenue33.0%Historical average, inclusive of go-to-market realignment costs.
Amortisation of Intangibles79.0$MFixed annual run-rate based on FY24 guidance.
Stock-Based Compensation215.0$MMidpoint of FY25 guidance ($210M - $220M).
Capex15.0$MFY25 management guidance.
Cash Tax Payments115.0$MMidpoint of FY25 guidance ($110M - $120M).
Target Share Repurchases300.0$MFY25 stated capital return target.
Average Interest Rate6.5%Blended rate on Senior Notes and Revolver.
Fully Diluted Share Count121.0MillionsFY24 ending share count.
WACC9.5%Standard discount rate for mature, profitable SaaS.
Terminal Growth Rate3.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

Frequently asked

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.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Software Company Financial Models

Browse another company in the same sector.

ADBE.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Adobe logo

Adobe

Adobe is a global software company that provides content creation, document management, and digital marketing solutions through a cloud-based subscription model for creators, businesses, and enterprises.

ADSK.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Autodesk logo

Autodesk

Autodesk is a global leader in 3D design, engineering, and entertainment software, providing essential tools for architects, engineers, manufacturers, and digital artists.

BR.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Broadridge Financial Solutions logo

Broadridge Financial Solutions

Broadridge Financial Solutions is a global financial technology leader providing investor communications and technology-driven solutions to banks, broker-dealers, asset managers, and corporate issuers.

CDNS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Cadence Design Systems logo

Cadence Design Systems

Cadence Design Systems is a leading provider of electronic design automation (EDA) software, semiconductor intellectual property (IP), and system design and analysis products.

CRM.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Salesforce logo

Salesforce

Salesforce is a global cloud computing company that provides enterprise software focused on customer relationship management (CRM), customer service, marketing automation, analytics, and application development.

DDOG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Datadog logo

Datadog

Datadog operates a SaaS-based observability and security platform for cloud applications, integrating infrastructure monitoring, application performance monitoring (APM), log management, and cloud security.

FICO.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Fair Isaac logo

Fair Isaac

Fair Isaac Corporation (FICO) is a leading applied analytics and data decisioning company, best known for the ubiquitous FICO Score used in consumer credit risk assessment.

FIS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Fidelity National Information Services logo

Fidelity National Information Services

Fidelity National Information Services (FIS) is a global financial technology company that provides core banking, payment processing, and capital markets software to financial institutions and corporations.

Explore more Tech & Software financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview