FedEx Corporation (FDX) 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
FedEx Corporation (FDX) Bundle
Gain professional insights into FedEx Corporation's (FDX) financial future! This (FDX) DCF Calculator comes with pre-filled financial data and offers you the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 69,217.0 | 83,959.0 | 93,512.0 | 90,155.0 | 87,693.0 | 93,471.0 | 99,629.7 | 106,194.2 | 113,191.3 | 120,649.4 |
| Revenue Growth, % | 0 | 21.3 | 11.38 | -3.59 | -2.73 | 6.59 | 6.59 | 6.59 | 6.59 | 6.59 |
| EBITDA | 6,345.0 | 11,749.0 | 9,767.0 | 10,603.0 | 10,868.0 | 10,797.6 | 11,509.1 | 12,267.4 | 13,075.7 | 13,937.2 |
| EBITDA, % | 9.17 | 13.99 | 10.44 | 11.76 | 12.39 | 11.55 | 11.55 | 11.55 | 11.55 | 11.55 |
| Depreciation | 3,615.0 | 3,793.0 | 3,970.0 | 4,176.0 | 4,287.0 | 4,394.4 | 4,683.9 | 4,992.5 | 5,321.5 | 5,672.1 |
| Depreciation, % | 5.22 | 4.52 | 4.25 | 4.63 | 4.89 | 4.7 | 4.7 | 4.7 | 4.7 | 4.7 |
| EBIT | 2,730.0 | 7,956.0 | 5,797.0 | 6,427.0 | 6,581.0 | 6,403.3 | 6,825.2 | 7,274.9 | 7,754.2 | 8,265.2 |
| EBIT, % | 3.94 | 9.48 | 6.2 | 7.13 | 7.5 | 6.85 | 6.85 | 6.85 | 6.85 | 6.85 |
| Total Cash | 4,881.0 | 7,087.0 | 6,897.0 | 6,823.0 | 6,501.0 | 7,075.7 | 7,541.9 | 8,038.8 | 8,568.5 | 9,133.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 10,102.0 | 12,069.0 | 11,863.0 | 10,188.0 | 10,087.0 | 12,050.1 | 12,844.0 | 13,690.3 | 14,592.3 | 15,553.8 |
| Account Receivables, % | 14.59 | 14.37 | 12.69 | 11.3 | 11.5 | 12.89 | 12.89 | 12.89 | 12.89 | 12.89 |
| Inventories | 572.0 | 587.0 | 637.0 | 604.0 | 614.0 | 668.7 | 712.7 | 759.7 | 809.7 | 863.1 |
| Inventories, % | 0.82639 | 0.69915 | 0.6812 | 0.66996 | 0.70017 | 0.71537 | 0.71537 | 0.71537 | 0.71537 | 0.71537 |
| Accounts Payable | 3,269.0 | 3,841.0 | 4,030.0 | 3,848.0 | 3,189.0 | 4,021.5 | 4,286.5 | 4,568.9 | 4,870.0 | 5,190.8 |
| Accounts Payable, % | 4.72 | 4.57 | 4.31 | 4.27 | 3.64 | 4.3 | 4.3 | 4.3 | 4.3 | 4.3 |
| Capital Expenditure | -5,868.0 | -5,884.0 | -6,763.0 | -6,174.0 | -5,176.0 | -6,630.6 | -7,067.5 | -7,533.1 | -8,029.5 | -8,558.6 |
| Capital Expenditure, % | -8.48 | -7.01 | -7.23 | -6.85 | -5.9 | -7.09 | -7.09 | -7.09 | -7.09 | -7.09 |
| Tax Rate, % | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 | 25.79 |
| EBITAT | 2,103.5 | 6,235.8 | 4,530.1 | 4,760.0 | 4,883.9 | 4,890.2 | 5,212.4 | 5,555.9 | 5,921.9 | 6,312.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -7,554.5 | 2,734.8 | 2,082.1 | 4,288.0 | 3,426.9 | 1,468.7 | 2,255.8 | 2,404.4 | 2,562.8 | 2,731.7 |
| WACC, % | 7.71 | 7.73 | 7.73 | 7.66 | 7.67 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 9,023.3 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 2,814 | |||||||||
| Terminal Value | 59,867 | |||||||||
| Present Terminal Value | 41,315 | |||||||||
| Enterprise Value | 50,338 | |||||||||
| Net Debt | 31,218 | |||||||||
| Equity Value | 19,120 | |||||||||
| Diluted Shares Outstanding, MM | 251 | |||||||||
| Equity Value Per Share | 76.18 |
What You Will Get
- Real FDX Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess FedEx's future performance.
- User-Friendly Design: Designed for experts but easy for newcomers to navigate.
Key Features
- Accurate FedEx Financials: Gain access to reliable pre-loaded historical data and future estimates.
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Get instant access to the Excel-based FDX DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates FedEx’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for FedEx Corporation (FDX)?
- Accurate Data: Up-to-date FedEx financials provide dependable valuation outcomes.
- Customizable: Tailor essential variables such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations mean you won’t have to start from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the logistics sector.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing FedEx Corporation (FDX) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding FedEx Corporation (FDX) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Logistics Enthusiasts: Gain insights into how logistics companies like FedEx Corporation (FDX) are valued in the marketplace.
What the Template Contains
- Preloaded FDX 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.