|
Equifax Inc. (EFX) DCF Valuation
US | Industrials | Consulting Services | NYSE
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Equifax Inc. (EFX) Bundle
Evaluate Equifax Inc.'s (EFX) financial prospects like an expert! This EFX DCF Calculator provides pre-filled financial data along with full flexibility to modify revenue growth, WACC, margins, and other essential 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 | 3,507.6 | 4,127.5 | 4,923.9 | 5,122.2 | 5,265.2 | 5,841.6 | 6,481.0 | 7,190.5 | 7,977.6 | 8,850.9 |
Revenue Growth, % | 0 | 17.67 | 19.29 | 4.03 | 2.79 | 10.95 | 10.95 | 10.95 | 10.95 | 10.95 |
EBITDA | 29.0 | 1,217.8 | 1,575.2 | 1,672.8 | 1,570.1 | 1,458.1 | 1,617.7 | 1,794.8 | 1,991.2 | 2,209.2 |
EBITDA, % | 0.82678 | 29.5 | 31.99 | 32.66 | 29.82 | 24.96 | 24.96 | 24.96 | 24.96 | 24.96 |
Depreciation | 331.1 | 391.0 | 480.4 | 560.1 | 619.8 | 600.2 | 665.9 | 738.8 | 819.7 | 909.4 |
Depreciation, % | 9.44 | 9.47 | 9.76 | 10.93 | 11.77 | 10.28 | 10.28 | 10.28 | 10.28 | 10.28 |
EBIT | -302.1 | 826.8 | 1,094.8 | 1,112.7 | 950.3 | 857.8 | 951.7 | 1,055.9 | 1,171.5 | 1,299.8 |
EBIT, % | -8.61 | 20.03 | 22.23 | 21.72 | 18.05 | 14.68 | 14.68 | 14.68 | 14.68 | 14.68 |
Total Cash | 401.3 | 1,684.6 | 224.7 | 285.2 | 216.8 | 777.0 | 862.0 | 956.4 | 1,061.1 | 1,177.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 532.1 | 630.6 | 727.6 | 857.7 | 908.2 | 925.5 | 1,026.8 | 1,139.2 | 1,264.0 | 1,402.3 |
Account Receivables, % | 15.17 | 15.28 | 14.78 | 16.74 | 17.25 | 15.84 | 15.84 | 15.84 | 15.84 | 15.84 |
Inventories | 88.1 | 104.1 | 108.4 | 134.3 | .0 | 115.2 | 127.8 | 141.8 | 157.3 | 174.5 |
Inventories, % | 2.51 | 2.52 | 2.2 | 2.62 | 0 | 1.97 | 1.97 | 1.97 | 1.97 | 1.97 |
Accounts Payable | 148.3 | 159.1 | 211.6 | 250.8 | 197.6 | 245.7 | 272.6 | 302.4 | 335.5 | 372.3 |
Accounts Payable, % | 4.23 | 3.85 | 4.3 | 4.9 | 3.75 | 4.21 | 4.21 | 4.21 | 4.21 | 4.21 |
Capital Expenditure | -399.6 | -421.3 | -469.0 | -624.5 | -601.3 | -639.5 | -709.5 | -787.2 | -873.3 | -968.9 |
Capital Expenditure, % | -11.39 | -10.21 | -9.52 | -12.19 | -11.42 | -10.95 | -10.95 | -10.95 | -10.95 | -10.95 |
Tax Rate, % | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 | 24.04 |
EBITAT | -274.1 | 627.6 | 858.4 | 833.2 | 721.8 | 679.2 | 753.5 | 836.0 | 927.5 | 1,029.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -814.5 | 493.6 | 821.0 | 652.0 | 770.9 | 555.5 | 622.9 | 691.1 | 766.8 | 850.7 |
WACC, % | 10.76 | 10.66 | 10.68 | 10.66 | 10.66 | 10.68 | 10.68 | 10.68 | 10.68 | 10.68 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,543.0 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 885 | |||||||||
Terminal Value | 13,236 | |||||||||
Present Terminal Value | 7,968 | |||||||||
Enterprise Value | 10,511 | |||||||||
Net Debt | 5,494 | |||||||||
Equity Value | 5,016 | |||||||||
Diluted Shares Outstanding, MM | 124 | |||||||||
Equity Value Per Share | 40.49 |
What You Will Get
- Real Equifax Data: Preloaded financials – encompassing revenue to EBIT – based on actual and projected figures.
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Equifax’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive Data: Equifax’s extensive historical financial statements and pre-filled forecasts.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: View Equifax’s intrinsic value recalibrate instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A sophisticated tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based EFX DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically refreshes Equifax’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial decisions.
Why Choose Equifax Inc. (EFX)?
- Save Time: Access comprehensive credit data instantly without extensive setup.
- Enhance Accuracy: Utilize reliable credit reports and analytics to minimize errors in decision-making.
- Fully Customizable: Adjust reports and insights to align with your specific business needs.
- User-Friendly Interface: Intuitive dashboards and visuals simplify data interpretation.
- Trusted by Professionals: Preferred by industry experts for its precision and effectiveness.
Who Should Use This Product?
- Investors: Evaluate Equifax’s valuation before making stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Equifax.
- Consultants: Provide comprehensive valuation assessments for clients.
- Students and Educators: Utilize current data to learn and teach valuation practices.
What the Template Contains
- Pre-Filled DCF Model: Equifax's (EFX) financial data preloaded for immediate use.
- WACC Calculator: Comprehensive calculations for Weighted Average Cost of Capital.
- Financial Ratios: Assess Equifax's profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to tailor your scenarios.
- Financial Statements: Access annual and quarterly reports for thorough analysis.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and outcomes.