|
Fidelity National Financial, Inc. (FNF) DCF Valuation
US | Financial Services | Insurance - Specialty | NYSE
|
- ✓ 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
Fidelity National Financial, Inc. (FNF) Bundle
Discover the true potential of Fidelity National Financial, Inc. (FNF) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how alterations affect Fidelity National Financial, Inc. (FNF) valuation – all within a single Excel template.
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 | 8,469.0 | 10,778.0 | 15,643.0 | 11,556.0 | 11,788.0 | 13,210.9 | 14,805.6 | 16,592.7 | 18,595.6 | 20,840.3 |
Revenue Growth, % | 0 | 27.26 | 45.14 | -26.13 | 2.01 | 12.07 | 12.07 | 12.07 | 12.07 | 12.07 |
EBITDA | 1,594.0 | 2,170.0 | 3,842.0 | 2,336.0 | 1,460.0 | 2,539.6 | 2,846.1 | 3,189.6 | 3,574.7 | 4,006.2 |
EBITDA, % | 18.82 | 20.13 | 24.56 | 20.21 | 12.39 | 19.22 | 19.22 | 19.22 | 19.22 | 19.22 |
Depreciation | 178.0 | 296.0 | 645.0 | 491.0 | 593.0 | 482.2 | 540.4 | 605.7 | 678.8 | 760.7 |
Depreciation, % | 2.1 | 2.75 | 4.12 | 4.25 | 5.03 | 3.65 | 3.65 | 3.65 | 3.65 | 3.65 |
EBIT | 1,416.0 | 1,874.0 | 3,197.0 | 1,845.0 | 867.0 | 2,057.3 | 2,305.7 | 2,584.0 | 2,895.9 | 3,245.5 |
EBIT, % | 16.72 | 17.39 | 20.44 | 15.97 | 7.35 | 15.57 | 15.57 | 15.57 | 15.57 | 15.57 |
Total Cash | 3,958.0 | 30,805.0 | 36,361.0 | 37,729.0 | 26,557.0 | 11,803.6 | 13,228.3 | 14,825.1 | 16,614.6 | 18,620.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 346.0 | .0 | .0 | .0 | 442.0 | 207.0 | 232.0 | 260.0 | 291.4 | 326.6 |
Account Receivables, % | 4.09 | 0 | 0 | 0 | 3.75 | 1.57 | 1.57 | 1.57 | 1.57 | 1.57 |
Inventories | -2,939.0 | -4,623.0 | -6,144.0 | -6,262.0 | .0 | -4,519.7 | -5,065.3 | -5,676.7 | -6,362.0 | -7,129.9 |
Inventories, % | -34.7 | -42.89 | -39.28 | -54.19 | 0 | -34.21 | -34.21 | -34.21 | -34.21 | -34.21 |
Accounts Payable | 44.0 | 115.0 | 129.0 | 156.0 | 339.0 | 175.4 | 196.5 | 220.2 | 246.8 | 276.6 |
Accounts Payable, % | 0.51954 | 1.07 | 0.82465 | 1.35 | 2.88 | 1.33 | 1.33 | 1.33 | 1.33 | 1.33 |
Capital Expenditure | -96.0 | -110.0 | -131.0 | -138.0 | -132.0 | -140.2 | -157.1 | -176.1 | -197.3 | -221.1 |
Capital Expenditure, % | -1.13 | -1.02 | -0.83744 | -1.19 | -1.12 | -1.06 | -1.06 | -1.06 | -1.06 | -1.06 |
Tax Rate, % | 25.4 | 25.4 | 25.4 | 25.4 | 25.4 | 25.4 | 25.4 | 25.4 | 25.4 | 25.4 |
EBITAT | 1,098.5 | 1,499.0 | 2,900.4 | 1,555.3 | 646.8 | 1,675.5 | 1,877.7 | 2,104.3 | 2,358.4 | 2,643.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 3,817.5 | 3,786.0 | 4,949.4 | 2,053.3 | -5,413.2 | 6,608.6 | 2,802.8 | 3,141.1 | 3,520.2 | 3,945.2 |
WACC, % | 9.41 | 9.43 | 9.53 | 9.47 | 9.38 | 9.44 | 9.44 | 9.44 | 9.44 | 9.44 |
PV UFCF | ||||||||||
SUM PV UFCF | 15,740.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 4,024 | |||||||||
Terminal Value | 54,055 | |||||||||
Present Terminal Value | 34,425 | |||||||||
Enterprise Value | 50,165 | |||||||||
Net Debt | 1,514 | |||||||||
Equity Value | 48,651 | |||||||||
Diluted Shares Outstanding, MM | 271 | |||||||||
Equity Value Per Share | 179.52 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real FNF financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on Fidelity National Financial’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 FNF Data: Pre-loaded with Fidelity National Financial's historical performance metrics and future projections.
- Customizable Assumptions: Modify revenue growth rates, profit margins, discount rates, tax considerations, and capital expenditure plans.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your personalized inputs.
- Flexible Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Designed for ease of use, making it accessible for both industry professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template with Fidelity National Financial, Inc.'s (FNF) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Fidelity National Financial, Inc.'s (FNF) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Fidelity National Financial, Inc. (FNF)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to FNF’s valuation as you modify inputs.
- Preloaded Data: Comes equipped with Fidelity National Financial’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive and trustworthy valuation models for property investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for Fidelity National Financial, Inc. (FNF) to clients.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Insurance Professionals: Gain insights into how companies like Fidelity National Financial, Inc. (FNF) are valued in the insurance sector.
What the Template Contains
- Historical Data: Includes Fidelity National Financial’s (FNF) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Fidelity National Financial’s (FNF) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Fidelity National Financial’s (FNF) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.