Security National Financial Corporation (SNFCA) 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
Security National Financial Corporation (SNFCA) Bundle
Looking to assess the intrinsic value of Security National Financial Corporation? Our (SNFCA) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment strategies.
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 | 283.1 | 481.5 | 470.7 | 390.3 | 318.5 | 344.3 | 372.1 | 402.3 | 434.8 | 470.0 |
Revenue Growth, % | 0 | 70.09 | -2.24 | -17.08 | -18.4 | 8.09 | 8.09 | 8.09 | 8.09 | 8.09 |
EBITDA | 33.6 | 93.9 | 75.7 | 52.7 | .0 | 42.0 | 45.4 | 49.0 | 53.0 | 57.3 |
EBITDA, % | 11.86 | 19.51 | 16.09 | 13.5 | 0 | 12.19 | 12.19 | 12.19 | 12.19 | 12.19 |
Depreciation | 8.8 | 13.9 | 16.8 | 11.6 | .0 | 8.6 | 9.3 | 10.1 | 10.9 | 11.8 |
Depreciation, % | 3.1 | 2.89 | 3.57 | 2.97 | 0 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 |
EBIT | 24.8 | 80.0 | 58.9 | 41.1 | .0 | 33.4 | 36.1 | 39.0 | 42.1 | 45.5 |
EBIT, % | 8.76 | 16.62 | 12.52 | 10.54 | 0 | 9.69 | 9.69 | 9.69 | 9.69 | 9.69 |
Total Cash | 491.0 | 400.9 | 390.6 | 466.8 | 129.8 | 280.3 | 302.9 | 327.5 | 354.0 | 382.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 25.0 | 26.5 | 33.2 | 43.6 | .0 | 22.4 | 24.2 | 26.2 | 28.3 | 30.6 |
Account Receivables, % | 8.83 | 5.5 | 7.05 | 11.17 | 0 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
Inventories | -246.7 | -151.3 | -156.1 | -174.8 | .0 | -135.3 | -146.3 | -158.1 | -170.9 | -184.7 |
Inventories, % | -87.14 | -31.43 | -33.15 | -44.79 | 0 | -39.3 | -39.3 | -39.3 | -39.3 | -39.3 |
Accounts Payable | 5.1 | 8.9 | 10.2 | 5.4 | 2.9 | 5.6 | 6.0 | 6.5 | 7.0 | 7.6 |
Accounts Payable, % | 1.79 | 1.86 | 2.16 | 1.37 | 0.92213 | 1.62 | 1.62 | 1.62 | 1.62 | 1.62 |
Capital Expenditure | -1.8 | -1.6 | -5.2 | -1.6 | -1.1 | -2.0 | -2.1 | -2.3 | -2.5 | -2.7 |
Capital Expenditure, % | -0.64979 | -0.3387 | -1.11 | -0.40997 | -0.34849 | -0.57119 | -0.57119 | -0.57119 | -0.57119 | -0.57119 |
Tax Rate, % | 11.08 | 11.08 | 11.08 | 11.08 | 11.08 | 11.08 | 11.08 | 11.08 | 11.08 | 11.08 |
EBITAT | 19.4 | 62.3 | 45.0 | 30.7 | .0 | 26.4 | 28.5 | 30.9 | 33.4 | 36.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 253.0 | -18.4 | 55.8 | 44.2 | -134.8 | 148.6 | 45.3 | 49.0 | 53.0 | 57.3 |
WACC, % | 7.73 | 7.72 | 7.7 | 7.69 | 7.86 | 7.74 | 7.74 | 7.74 | 7.74 | 7.74 |
PV UFCF | ||||||||||
SUM PV UFCF | 294.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 58 | |||||||||
Terminal Value | 1,017 | |||||||||
Present Terminal Value | 701 | |||||||||
Enterprise Value | 996 | |||||||||
Net Debt | -21 | |||||||||
Equity Value | 1,017 | |||||||||
Diluted Shares Outstanding, MM | 24 | |||||||||
Equity Value Per Share | 42.71 |
What You Will Get
- Real SNFCA Financial Data: Pre-filled with Security National Financial Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See SNFCA’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Security National Financial Corporation (SNFCA).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to SNFCA.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates relevant to Security National Financial Corporation (SNFCA).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Security National Financial Corporation (SNFCA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Security National Financial Corporation’s (SNFCA) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for Security National Financial Corporation (SNFCA)?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Observe immediate changes in SNFCA’s valuation as you alter inputs.
- Pre-Configured Data: Comes with SNFCA’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate Security National Financial Corporation’s (SNFCA) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established financial firms like Security National Financial Corporation (SNFCA).
- Consultants: Provide expert valuation insights and reports for your clients.
- Students and Educators: Utilize practical data to learn and teach valuation principles effectively.
What the SNFCA Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Security National Financial Corporation (SNFCA).
- Real-World Data: Historical and projected financials for SNFCA preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into SNFCA's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics relevant to SNFCA.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results tailored for SNFCA.