United Parcel Service, Inc. (UPS) 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
United Parcel Service, Inc. (UPS) Bundle
Designed for accuracy, our (UPS) DCF Calculator enables you to assess the valuation of United Parcel Service, Inc. with real-world financial data and complete flexibility to modify all key 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 | 74,094.0 | 84,628.0 | 97,287.0 | 100,338.0 | 90,958.0 | 96,179.7 | 101,701.2 | 107,539.6 | 113,713.3 | 120,241.3 |
| Revenue Growth, % | 0 | 14.22 | 14.96 | 3.14 | -9.35 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 |
| EBITDA | 10,194.0 | 10,366.0 | 15,821.0 | 17,005.0 | 12,714.0 | 14,079.7 | 14,888.0 | 15,742.7 | 16,646.5 | 17,602.1 |
| EBITDA, % | 13.76 | 12.25 | 16.26 | 16.95 | 13.98 | 14.64 | 14.64 | 14.64 | 14.64 | 14.64 |
| Depreciation | 2,360.0 | 2,698.0 | 2,953.0 | 3,188.0 | 3,366.0 | 3,132.8 | 3,312.7 | 3,502.9 | 3,704.0 | 3,916.6 |
| Depreciation, % | 3.19 | 3.19 | 3.04 | 3.18 | 3.7 | 3.26 | 3.26 | 3.26 | 3.26 | 3.26 |
| EBIT | 7,834.0 | 7,668.0 | 12,868.0 | 13,817.0 | 9,348.0 | 10,946.9 | 11,575.3 | 12,239.8 | 12,942.5 | 13,685.5 |
| EBIT, % | 10.57 | 9.06 | 13.23 | 13.77 | 10.28 | 11.38 | 11.38 | 11.38 | 11.38 | 11.38 |
| Total Cash | 5,741.0 | 6,316.0 | 10,593.0 | 7,595.0 | 6,072.0 | 7,760.7 | 8,206.3 | 8,677.4 | 9,175.5 | 9,702.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 9,934.0 | 11,029.0 | 12,845.0 | 12,891.0 | 11,453.0 | 12,519.1 | 13,237.8 | 13,997.8 | 14,801.4 | 15,651.1 |
| Account Receivables, % | 13.41 | 13.03 | 13.2 | 12.85 | 12.59 | 13.02 | 13.02 | 13.02 | 13.02 | 13.02 |
| Inventories | 511.0 | 620.0 | 717.0 | 889.0 | 935.0 | 783.5 | 828.5 | 876.1 | 926.4 | 979.5 |
| Inventories, % | 0.68966 | 0.73262 | 0.73699 | 0.88601 | 1.03 | 0.81465 | 0.81465 | 0.81465 | 0.81465 | 0.81465 |
| Accounts Payable | 5,555.0 | 6,455.0 | 7,523.0 | 7,512.0 | 6,340.0 | 7,177.8 | 7,589.9 | 8,025.6 | 8,486.3 | 8,973.5 |
| Accounts Payable, % | 7.5 | 7.63 | 7.73 | 7.49 | 6.97 | 7.46 | 7.46 | 7.46 | 7.46 | 7.46 |
| Capital Expenditure | -6,380.0 | -5,412.0 | -4,194.0 | -4,769.0 | -5,158.0 | -5,720.8 | -6,049.3 | -6,396.5 | -6,763.7 | -7,152.0 |
| Capital Expenditure, % | -8.61 | -6.4 | -4.31 | -4.75 | -5.67 | -5.95 | -5.95 | -5.95 | -5.95 | -5.95 |
| Tax Rate, % | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 | 21.75 |
| EBITAT | 6,154.1 | 5,216.9 | 9,995.1 | 10,762.8 | 7,314.4 | 8,328.5 | 8,806.6 | 9,312.2 | 9,846.8 | 10,412.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2,755.9 | 2,198.9 | 7,909.1 | 8,952.8 | 5,742.4 | 5,663.7 | 5,718.5 | 6,046.7 | 6,393.9 | 6,760.9 |
| WACC, % | 7.98 | 7.89 | 7.97 | 7.97 | 7.98 | 7.96 | 7.96 | 7.96 | 7.96 | 7.96 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 24,275.6 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 6,964 | |||||||||
| Terminal Value | 140,451 | |||||||||
| Present Terminal Value | 95,774 | |||||||||
| Enterprise Value | 120,050 | |||||||||
| Net Debt | 23,523 | |||||||||
| Equity Value | 96,527 | |||||||||
| Diluted Shares Outstanding, MM | 860 | |||||||||
| Equity Value Per Share | 112.24 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real UPS financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on UPS’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Historical Data: UPS’s (UPS) financial statements and projected forecasts are readily available.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and operating margins as needed.
- Real-Time Calculations: Observe UPS’s (UPS) intrinsic value update instantly.
- Intuitive Visualizations: Interactive dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered UPS data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for UPS’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose the UPS Shipping Calculator?
- Reliability: Accurate shipping rates based on real UPS data.
- Convenience: Tailored for users to easily input and adjust shipping parameters.
- Efficiency: Eliminate the need for manual calculations and guesswork.
- Industry-Standard: Built with the expertise of logistics professionals in mind.
- Intuitive: Simple interface designed for users of all experience levels.
Who Should Use This Product?
- Investors: Accurately estimate United Parcel Service, Inc.’s (UPS) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to United Parcel Service, Inc. (UPS).
- Consultants: Quickly adapt the template for valuation reports for clients focused on United Parcel Service, Inc. (UPS).
- Entrepreneurs: Gain insights into financial modeling practices used by leading logistics companies like United Parcel Service, Inc. (UPS).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to United Parcel Service, Inc. (UPS).
What the Template Contains
- Pre-Filled Data: Includes United Parcel Service, Inc.'s (UPS) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze United Parcel Service, Inc.'s (UPS) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.