Weatherford International plc (WFRD) 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
Weatherford International plc (WFRD) Bundle
Whether you’re an investor or analyst, this (WFRD) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Weatherford International plc, you can adjust forecasts and instantly observe the results.
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,954.0 | 3,685.0 | 3,645.0 | 4,331.0 | 5,135.0 | 5,272.1 | 5,412.9 | 5,557.5 | 5,705.9 | 5,858.3 |
Revenue Growth, % | 0 | -25.62 | -1.09 | 18.82 | 18.56 | 2.67 | 2.67 | 2.67 | 2.67 | 2.67 |
EBITDA | 4,659.0 | -1,045.0 | 357.0 | 761.0 | 1,015.0 | 1,189.6 | 1,221.4 | 1,254.0 | 1,287.5 | 1,321.9 |
EBITDA, % | 94.05 | -28.36 | 9.79 | 17.57 | 19.77 | 22.56 | 22.56 | 22.56 | 22.56 | 22.56 |
Depreciation | 481.0 | 503.0 | 440.0 | 349.0 | 327.0 | 525.7 | 539.7 | 554.2 | 569.0 | 584.2 |
Depreciation, % | 9.71 | 13.65 | 12.07 | 8.06 | 6.37 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 |
EBIT | 4,178.0 | -1,548.0 | -83.0 | 412.0 | 688.0 | 663.9 | 681.6 | 699.8 | 718.5 | 737.7 |
EBIT, % | 84.34 | -42.01 | -2.28 | 9.51 | 13.4 | 12.59 | 12.59 | 12.59 | 12.59 | 12.59 |
Total Cash | 618.0 | 1,118.0 | 951.0 | 910.0 | 958.0 | 1,144.8 | 1,175.4 | 1,206.8 | 1,239.0 | 1,272.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,241.0 | 826.0 | 825.0 | 989.0 | 1,216.0 | 1,229.6 | 1,262.5 | 1,296.2 | 1,330.8 | 1,366.3 |
Account Receivables, % | 25.05 | 22.42 | 22.63 | 22.84 | 23.68 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 |
Inventories | 972.0 | 717.0 | 670.0 | 689.0 | 788.0 | 935.4 | 960.4 | 986.1 | 1,012.4 | 1,039.4 |
Inventories, % | 19.62 | 19.46 | 18.38 | 15.91 | 15.35 | 17.74 | 17.74 | 17.74 | 17.74 | 17.74 |
Accounts Payable | 585.0 | 325.0 | 380.0 | 460.0 | 679.0 | 578.9 | 594.3 | 610.2 | 626.5 | 643.2 |
Accounts Payable, % | 11.81 | 8.82 | 10.43 | 10.62 | 13.22 | 10.98 | 10.98 | 10.98 | 10.98 | 10.98 |
Capital Expenditure | -250.0 | -154.0 | -85.0 | -132.0 | -209.0 | -196.9 | -202.2 | -207.6 | -213.1 | -218.8 |
Capital Expenditure, % | -5.05 | -4.18 | -2.33 | -3.05 | -4.07 | -3.74 | -3.74 | -3.74 | -3.74 | -3.74 |
Tax Rate, % | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 | 17.59 |
EBITAT | 4,005.1 | -1,620.5 | -103.8 | 152.3 | 567.0 | 551.3 | 566.1 | 581.2 | 596.7 | 612.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2,608.1 | -861.5 | 354.2 | 266.3 | 578.0 | 618.9 | 861.3 | 884.3 | 907.9 | 932.1 |
WACC, % | 11.55 | 11.65 | 11.65 | 10.05 | 11.21 | 11.22 | 11.22 | 11.22 | 11.22 | 11.22 |
PV UFCF | ||||||||||
SUM PV UFCF | 3,036.3 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 960 | |||||||||
Terminal Value | 11,676 | |||||||||
Present Terminal Value | 6,860 | |||||||||
Enterprise Value | 9,897 | |||||||||
Net Debt | 1,102 | |||||||||
Equity Value | 8,795 | |||||||||
Diluted Shares Outstanding, MM | 74 | |||||||||
Equity Value Per Share | 118.85 |
What You Will Get
- Pre-Filled Financial Model: Weatherford’s actual data provides accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates allow you to see results immediately as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics in real-time.
- High-Precision Accuracy: Leverages Weatherford’s actual financial data for credible valuation results.
- Simplified Scenario Analysis: Easily explore various assumptions and evaluate their impacts on outcomes.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Weatherford International plc’s (WFRD) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures as needed.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation scenarios.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your strategic decisions.
Why Choose This Calculator for Weatherford International plc (WFRD)?
- Designed for Industry Experts: A specialized tool favored by geologists, engineers, and financial analysts.
- Comprehensive Data: Weatherford’s historical and projected financial metrics preloaded for precision.
- Forecast Scenarios: Effortlessly test various operational scenarios and financial assumptions.
- Insightful Results: Automatically computes intrinsic value, NPV, and essential performance indicators.
- User-Friendly: Detailed, step-by-step guidance leads you through every calculation.
Who Should Use This Product?
- Investors: Assess the fair value of Weatherford International plc (WFRD) to inform investment choices.
- CFOs: Utilize a high-quality DCF model for accurate financial reporting and analysis.
- Consultants: Efficiently modify the template for client valuation reports.
- Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading companies.
- Educators: Implement it as a resource to teach valuation techniques effectively.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Weatherford International plc (WFRD) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Weatherford International plc (WFRD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.