|
PayPal Holdings, Inc. (PYPL) DCF Valuation
US | Financial Services | Financial - Credit Services | NASDAQ
|
- ✓ 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
PayPal Holdings, Inc. (PYPL) Bundle
Evaluate PayPal Holdings, Inc.'s (PYPL) financial outlook like an expert! This (PYPL) DCF Calculator provides pre-filled financial data and allows you to easily modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 17,772.0 | 21,454.0 | 25,371.0 | 27,518.0 | 29,771.0 | 33,911.1 | 38,626.9 | 43,998.4 | 50,117.0 | 57,086.5 |
| Revenue Growth, % | 0 | 20.72 | 18.26 | 8.46 | 8.19 | 13.91 | 13.91 | 13.91 | 13.91 | 13.91 |
| EBITDA | 3,727.0 | 6,463.0 | 5,596.0 | 4,987.0 | 6,830.0 | 7,746.5 | 8,823.7 | 10,050.8 | 11,448.5 | 13,040.5 |
| EBITDA, % | 20.97 | 30.12 | 22.06 | 18.12 | 22.94 | 22.84 | 22.84 | 22.84 | 22.84 | 22.84 |
| Depreciation | 614.0 | 1,189.0 | 1,265.0 | 1,317.0 | 1,072.0 | 1,517.2 | 1,728.1 | 1,968.5 | 2,242.2 | 2,554.0 |
| Depreciation, % | 3.45 | 5.54 | 4.99 | 4.79 | 3.6 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
| EBIT | 3,113.0 | 5,274.0 | 4,331.0 | 3,670.0 | 5,758.0 | 6,229.3 | 7,095.6 | 8,082.3 | 9,206.2 | 10,486.5 |
| EBIT, % | 17.52 | 24.58 | 17.07 | 13.34 | 19.34 | 18.37 | 18.37 | 18.37 | 18.37 | 18.37 |
| Total Cash | 10,761.0 | 13,083.0 | 9,500.0 | 10,851.0 | 14,060.0 | 16,659.5 | 18,976.3 | 21,615.2 | 24,621.1 | 28,045.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 26,934.0 | 36,764.0 | 41,787.0 | 44,658.0 | 46,000.0 | 33,911.1 | 38,626.9 | 43,998.4 | 50,117.0 | 57,086.5 |
| Account Receivables, % | 151.55 | 171.36 | 164.7 | 162.29 | 154.51 | 100 | 100 | 100 | 100 | 100 |
| Inventories | .0 | .0 | .0 | 17.0 | .0 | 4.2 | 4.8 | 5.4 | 6.2 | 7.1 |
| Inventories, % | 0 | 0 | 0 | 0.06177775 | 0 | 0.01235555 | 0.01235555 | 0.01235555 | 0.01235555 | 0.01235555 |
| Accounts Payable | 24,759.0 | 35,670.0 | 39,038.0 | 40,140.0 | 42,074.0 | 33,911.1 | 38,626.9 | 43,998.4 | 50,117.0 | 57,086.5 |
| Accounts Payable, % | 139.31 | 166.26 | 153.87 | 145.87 | 141.33 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | -704.0 | -866.0 | -908.0 | -706.0 | -623.0 | -1,101.1 | -1,254.2 | -1,428.6 | -1,627.3 | -1,853.6 |
| Capital Expenditure, % | -3.96 | -4.04 | -3.58 | -2.57 | -2.09 | -3.25 | -3.25 | -3.25 | -3.25 | -3.25 |
| Tax Rate, % | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 | 21.53 |
| EBITAT | 2,553.3 | 4,375.4 | 4,405.0 | 2,637.5 | 4,518.3 | 5,174.3 | 5,893.8 | 6,713.5 | 7,647.0 | 8,710.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 288.3 | 5,779.4 | 3,107.0 | 1,462.5 | 5,576.3 | 9,512.2 | 6,367.2 | 7,252.6 | 8,261.2 | 9,410.0 |
| WACC, % | 10.54 | 10.54 | 10.61 | 10.49 | 10.52 | 10.54 | 10.54 | 10.54 | 10.54 | 10.54 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 30,420.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 9,598 | |||||||||
| Terminal Value | 112,401 | |||||||||
| Present Terminal Value | 68,106 | |||||||||
| Enterprise Value | 98,527 | |||||||||
| Net Debt | 595 | |||||||||
| Equity Value | 97,932 | |||||||||
| Diluted Shares Outstanding, MM | 1,107 | |||||||||
| Equity Value Per Share | 88.47 |
What You Will Get
- Real PYPL Financial Data: Pre-filled with PayPal's historical and projected data for accurate analysis.
- Fully Editable Template: Easily modify key inputs such as revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Watch PayPal's intrinsic value update in real-time based on your adjustments.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants seeking precise DCF results.
- User-Friendly Design: Intuitive layout and clear instructions suitable for all experience levels.
Key Features
- Real-Life PYPL Data: Pre-filled with PayPal’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download: Obtain the pre-formatted Excel file containing PayPal's financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose This Calculator for PayPal Holdings, Inc. (PYPL)?
- Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses tailored for PayPal.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes PayPal’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and forecasted data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on PayPal.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio management.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for PayPal Holdings, Inc. (PYPL) to clients.
- Students and Educators: Utilize real market data to enhance learning and practice financial modeling techniques.
- Tech Enthusiasts: Gain insights into the market valuation of fintech companies like PayPal Holdings, Inc. (PYPL).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations specific to PayPal Holdings, Inc. (PYPL).
- Real-World Data: PayPal’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results tailored to PayPal Holdings, Inc. (PYPL).