Pegasystems Inc. (PEGA) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Pegasystems Inc. (PEGA) Bundle
Engineered for accuracy, our (PEGA) DCF Calculator allows you to evaluate Pegasystems Inc. valuation using real-world financial data while providing complete flexibility to modify all essential parameters for enhanced projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 911.4 | 1,017.5 | 1,211.7 | 1,317.8 | 1,432.6 | 1,605.2 | 1,798.7 | 2,015.4 | 2,258.2 | 2,530.3 |
Revenue Growth, % | 0 | 11.65 | 19.08 | 8.76 | 8.71 | 12.05 | 12.05 | 12.05 | 12.05 | 12.05 |
EBITDA | -113.2 | -67.9 | -94.7 | -119.3 | 121.1 | -88.4 | -99.0 | -110.9 | -124.3 | -139.3 |
EBITDA, % | -12.42 | -6.68 | -7.82 | -9.05 | 8.45 | -5.5 | -5.5 | -5.5 | -5.5 | -5.5 |
Depreciation | 35.9 | 37.6 | 41.9 | 34.7 | 18.7 | 48.3 | 54.1 | 60.6 | 67.9 | 76.1 |
Depreciation, % | 3.94 | 3.69 | 3.46 | 2.63 | 1.31 | 3.01 | 3.01 | 3.01 | 3.01 | 3.01 |
EBIT | -149.1 | -105.5 | -136.6 | -154.0 | 102.3 | -136.6 | -153.1 | -171.5 | -192.2 | -215.3 |
EBIT, % | -16.36 | -10.37 | -11.27 | -11.69 | 7.14 | -8.51 | -8.51 | -8.51 | -8.51 | -8.51 |
Total Cash | 68.4 | 465.2 | 362.8 | 297.2 | 423.3 | 434.3 | 486.6 | 545.2 | 610.9 | 684.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 385.5 | 438.3 | 422.0 | 468.9 | 558.6 | 625.3 | 700.6 | 785.1 | 879.7 | 985.7 |
Account Receivables, % | 42.3 | 43.07 | 34.83 | 35.58 | 38.99 | 38.95 | 38.95 | 38.95 | 38.95 | 38.95 |
Inventories | -57.3 | -88.8 | .0 | .0 | .0 | -48.2 | -54.0 | -60.5 | -67.8 | -76.0 |
Inventories, % | -6.29 | -8.72 | 0.0000000825 | 0.0000000759 | 0 | -3 | -3 | -3 | -3 | -3 |
Accounts Payable | 17.5 | 24.0 | 15.3 | 18.2 | 11.3 | 24.7 | 27.7 | 31.1 | 34.8 | 39.0 |
Accounts Payable, % | 1.92 | 2.36 | 1.26 | 1.38 | 0.78807 | 1.54 | 1.54 | 1.54 | 1.54 | 1.54 |
Capital Expenditure | -10.6 | -25.4 | -10.5 | -35.4 | -16.8 | -26.9 | -30.1 | -33.8 | -37.8 | -42.4 |
Capital Expenditure, % | -1.16 | -2.49 | -0.86295 | -2.68 | -1.17 | -1.68 | -1.68 | -1.68 | -1.68 | -1.68 |
Tax Rate, % | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 |
EBITAT | -100.0 | -51.9 | -65.2 | -328.9 | 72.7 | -91.5 | -102.6 | -114.9 | -128.8 | -144.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -385.4 | -54.4 | -115.0 | -373.6 | -22.0 | -75.2 | -145.2 | -162.7 | -182.3 | -204.2 |
WACC, % | 9 | 8.95 | 8.94 | 9.1 | 9.01 | 9 | 9 | 9 | 9 | 9 |
PV UFCF | ||||||||||
SUM PV UFCF | -578.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -208 | |||||||||
Terminal Value | -2,975 | |||||||||
Present Terminal Value | -1,933 | |||||||||
Enterprise Value | -2,512 | |||||||||
Net Debt | 351 | |||||||||
Equity Value | -2,863 | |||||||||
Diluted Shares Outstanding, MM | 85 | |||||||||
Equity Value Per Share | -33.72 |
What You Will Get
- Pre-Filled Financial Model: Pegasystems Inc.’s (PEGA) actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive Financial Data: Pegasystems Inc.'s historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Pegasystems Inc.'s intrinsic value recalculating instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-built Excel file featuring Pegasystems Inc.'s (PEGA) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and analyze outcomes instantly.
- Make Decisions: Leverage the valuation results to inform your investment approach.
Why Choose This Calculator for Pegasystems Inc. (PEGA)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Financials: Pegasystems' historical and projected financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Accurately assess Pegasystems Inc.’s (PEGA) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis of Pegasystems Inc. (PEGA).
- Consultants: Easily customize the template for valuation reports tailored to Pegasystems Inc. (PEGA) clients.
- Entrepreneurs: Acquire insights into financial modeling techniques employed by leading tech firms like Pegasystems Inc. (PEGA).
- Educators: Implement it as a teaching resource to showcase valuation methodologies relevant to Pegasystems Inc. (PEGA).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Pegasystems Inc. (PEGA).
- Real-World Data: Pegasystems’ historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Pegasystems’ performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Pegasystems Inc. (PEGA).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights.