Global Payments Inc. (GPN) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Global Payments Inc. (GPN) Bundle
Enhance your investment strategies with the Global Payments Inc. (GPN) DCF Calculator! Explore genuine financial data, adjust growth predictions and expenses, and instantly observe how these modifications affect the intrinsic value of Global Payments Inc. (GPN).
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 | 4,911.9 | 7,423.6 | 8,523.8 | 8,975.5 | 9,654.4 | 11,556.8 | 13,834.0 | 16,560.0 | 19,823.1 | 23,729.1 |
| Revenue Growth, % | 0 | 51.13 | 14.82 | 5.3 | 7.56 | 19.7 | 19.7 | 19.7 | 19.7 | 19.7 |
| EBITDA | 1,765.0 | 2,508.4 | 3,233.6 | 2,427.7 | 3,738.6 | 4,008.6 | 4,798.5 | 5,744.0 | 6,875.9 | 8,230.7 |
| EBITDA, % | 35.93 | 33.79 | 37.94 | 27.05 | 38.72 | 34.69 | 34.69 | 34.69 | 34.69 | 34.69 |
| Depreciation | 944.4 | 1,791.2 | 1,895.5 | 1,775.3 | 1,776.7 | 2,398.6 | 2,871.3 | 3,437.0 | 4,114.3 | 4,925.0 |
| Depreciation, % | 19.23 | 24.13 | 22.24 | 19.78 | 18.4 | 20.75 | 20.75 | 20.75 | 20.75 | 20.75 |
| EBIT | 820.6 | 717.2 | 1,338.1 | 652.4 | 1,961.9 | 1,610.0 | 1,927.2 | 2,307.0 | 2,761.6 | 3,305.8 |
| EBIT, % | 16.71 | 9.66 | 15.7 | 7.27 | 20.32 | 13.93 | 13.93 | 13.93 | 13.93 | 13.93 |
| Total Cash | 1,678.3 | 1,945.9 | 1,979.3 | 1,997.6 | 2,088.9 | 2,946.8 | 3,527.5 | 4,222.6 | 5,054.6 | 6,050.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 895.2 | 794.2 | 946.2 | 998.3 | 1,120.1 | 1,450.4 | 1,736.2 | 2,078.3 | 2,487.8 | 2,978.0 |
| Account Receivables, % | 18.23 | 10.7 | 11.1 | 11.12 | 11.6 | 12.55 | 12.55 | 12.55 | 12.55 | 12.55 |
| Inventories | -.5 | .0 | 4.8 | 138.8 | .0 | 36.8 | 44.1 | 52.8 | 63.2 | 75.6 |
| Inventories, % | -0.00960933 | 0.0000000135 | 0.05606679 | 1.55 | 0 | 0.31861 | 0.31861 | 0.31861 | 0.31861 | 0.31861 |
| Accounts Payable | 148.1 | 128.7 | 262.0 | 229.4 | 290.4 | 309.4 | 370.4 | 443.4 | 530.8 | 635.3 |
| Accounts Payable, % | 3.01 | 1.73 | 3.07 | 2.56 | 3.01 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 |
| Capital Expenditure | -307.9 | -436.2 | -493.2 | -615.7 | -658.1 | -730.5 | -874.5 | -1,046.8 | -1,253.1 | -1,500.0 |
| Capital Expenditure, % | -6.27 | -5.88 | -5.79 | -6.86 | -6.82 | -6.32 | -6.32 | -6.32 | -6.32 | -6.32 |
| Tax Rate, % | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 | 15.7 |
| EBITAT | 682.2 | 705.8 | 1,236.8 | 324.3 | 1,653.8 | 1,313.7 | 1,572.6 | 1,882.4 | 2,253.4 | 2,697.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 572.1 | 2,142.0 | 2,615.5 | 1,265.2 | 2,850.5 | 2,633.6 | 3,337.2 | 3,994.8 | 4,782.0 | 5,724.3 |
| WACC, % | 7.08 | 7.33 | 7.23 | 6.52 | 7.09 | 7.05 | 7.05 | 7.05 | 7.05 | 7.05 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 16,341.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 5,839 | |||||||||
| Terminal Value | 115,614 | |||||||||
| Present Terminal Value | 82,238 | |||||||||
| Enterprise Value | 98,580 | |||||||||
| Net Debt | 15,287 | |||||||||
| Equity Value | 83,293 | |||||||||
| Diluted Shares Outstanding, MM | 262 | |||||||||
| Equity Value Per Share | 318.28 |
What You Will Get
- Real Global Payments Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Global Payments Inc. (GPN).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Global Payments Inc.'s (GPN) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections specific to Global Payments Inc. (GPN).
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility in your analysis.
Key Features
- Comprehensive Financial Data: Gain access to precise historical data and future forecasts for Global Payments Inc. (GPN).
- Adjustable Projection Variables: Modify highlighted fields such as WACC, growth rates, and profit margins to tailor your analysis.
- Real-Time Calculations: Enjoy automated updates to DCF, Net Present Value (NPV), and cash flow evaluations.
- Interactive Dashboard: Utilize clear graphs and summaries to effectively visualize your valuation outcomes.
- Designed for All Users: A straightforward, user-friendly format suitable for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based GPN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically refreshes Global Payments Inc.'s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for Global Payments Inc. (GPN)?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Global Payments' valuation as you tweak inputs.
- Preloaded Data: Comes with Global Payments' actual financial metrics for swift evaluations.
- Relied Upon by Experts: A favored tool among investors and analysts for making strategic decisions.
Who Should Use This Product?
- Investors: Accurately assess Global Payments Inc.'s (GPN) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Global Payments Inc. (GPN).
- Consultants: Easily customize the template for valuation reports tailored to clients of Global Payments Inc. (GPN).
- Entrepreneurs: Obtain insights into financial modeling practices employed by leading payment processing companies like Global Payments Inc. (GPN).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to Global Payments Inc. (GPN).
What the Template Contains
- Preloaded GPN Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.