Sun Life Financial Inc. (SLF) 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
Sun Life Financial Inc. (SLF) Bundle
Explore the financial potential of Sun Life Financial Inc. (SLF) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Sun Life Financial Inc. (SLF) and refine your investment approach.
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 | 27,525.8 | 30,063.4 | 24,758.6 | 16,099.0 | 21,401.0 | 20,840.9 | 20,295.5 | 19,764.3 | 19,247.1 | 18,743.3 |
| Revenue Growth, % | 0 | 9.22 | -17.65 | -34.98 | 32.93 | -2.62 | -2.62 | -2.62 | -2.62 | -2.62 |
| EBITDA | 2,947.6 | 2,821.3 | 4,808.8 | 3,320.8 | 3,524.1 | 3,193.2 | 3,109.7 | 3,028.3 | 2,949.0 | 2,871.9 |
| EBITDA, % | 10.71 | 9.38 | 19.42 | 20.63 | 16.47 | 15.32 | 15.32 | 15.32 | 15.32 | 15.32 |
| Depreciation | 262.2 | 281.6 | 303.8 | 496.7 | 414.8 | 339.3 | 330.4 | 321.8 | 313.4 | 305.2 |
| Depreciation, % | 0.95264 | 0.93684 | 1.23 | 3.09 | 1.94 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| EBIT | 2,685.4 | 2,539.7 | 4,505.0 | 2,824.1 | 3,109.2 | 2,853.9 | 2,779.2 | 2,706.5 | 2,635.7 | 2,566.7 |
| EBIT, % | 9.76 | 8.45 | 18.2 | 17.54 | 14.53 | 13.69 | 13.69 | 13.69 | 13.69 | 13.69 |
| Total Cash | 6,642.3 | 9,383.8 | 8,517.4 | 7,782.8 | 19,067.4 | 9,469.5 | 9,221.7 | 8,980.3 | 8,745.3 | 8,516.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | 1,674.6 | 326.2 | 317.6 | 309.3 | 301.2 | 293.3 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 7.82 | 1.56 | 1.56 | 1.56 | 1.56 | 1.56 |
| Inventories | -11,764.7 | -14,173.9 | -13,605.1 | -11,750.1 | .0 | -9,079.3 | -8,841.7 | -8,610.3 | -8,385.0 | -8,165.5 |
| Inventories, % | -42.74 | -47.15 | -54.95 | -72.99 | 0 | -43.56 | -43.56 | -43.56 | -43.56 | -43.56 |
| Accounts Payable | 1,269.5 | 1,691.3 | 1,294.5 | 1,633.0 | 1,729.4 | 1,404.3 | 1,367.5 | 1,331.7 | 1,296.9 | 1,262.9 |
| Accounts Payable, % | 4.61 | 5.63 | 5.23 | 10.14 | 8.08 | 6.74 | 6.74 | 6.74 | 6.74 | 6.74 |
| Capital Expenditure | -79.1 | -109.6 | -56.2 | 2,557.7 | -119.3 | -59.9 | -58.3 | -56.8 | -55.3 | -53.8 |
| Capital Expenditure, % | -0.28731 | -0.36458 | -0.22695 | 15.89 | -0.55754 | -0.28728 | -0.28728 | -0.28728 | -0.28728 | -0.28728 |
| Tax Rate, % | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 | 19.47 |
| EBITAT | 2,444.5 | 2,148.7 | 3,862.4 | 2,176.9 | 2,504.0 | 2,391.5 | 2,329.0 | 2,268.0 | 2,208.6 | 2,150.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 15,661.8 | 5,151.8 | 3,144.4 | 3,714.9 | -10,528.8 | 12,773.7 | 2,335.2 | 2,274.1 | 2,214.6 | 2,156.7 |
| WACC, % | 7.88 | 7.82 | 7.83 | 7.75 | 7.78 | 7.81 | 7.81 | 7.81 | 7.81 | 7.81 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 18,792.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2,200 | |||||||||
| Terminal Value | 37,866 | |||||||||
| Present Terminal Value | 26,000 | |||||||||
| Enterprise Value | 44,792 | |||||||||
| Net Debt | 1,462 | |||||||||
| Equity Value | 43,331 | |||||||||
| Diluted Shares Outstanding, MM | 589 | |||||||||
| Equity Value Per Share | 73.57 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Sun Life Financial Inc.’s (SLF) financial data pre-filled to enhance your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and saving time.
Key Features
- 🔍 Real-Life SLF Financials: Pre-filled historical and projected data for Sun Life Financial Inc. (SLF).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Sun Life’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Sun Life’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-prepared Excel file containing Sun Life Financial Inc.'s (SLF) financial data.
- Customize: Modify projections, including premium growth, claims ratio, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results immediately.
- Make Decisions: Utilize the valuation insights to inform your investment approach.
Why Choose Sun Life Financial Inc. (SLF)?
- Reliability: Comprehensive financial data ensures dependable insights.
- Customizability: Tailored for users to adjust and experiment with various inputs.
- Efficiency: Eliminate the need to create complex financial models from the ground up.
- Expert-Level: Crafted with the precision and functionality expected by finance professionals.
- Intuitive: Simple to navigate, making it accessible for users of all experience levels.
Who Should Use This Product?
- Insurance Professionals: Enhance your understanding of risk management and policy structuring.
- Financial Advisors: Utilize comprehensive tools to create tailored retirement plans for clients.
- Investors: Evaluate investment opportunities and analyze the financial health of Sun Life Financial Inc. (SLF).
- Analysts: Improve your analysis with advanced modeling techniques specific to the insurance sector.
- Individuals Planning for Retirement: Discover strategies to maximize your savings and ensure financial security.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Sun Life Financial Inc. (SLF).
- Real-World Data: Sun Life’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results specific to Sun Life Financial Inc. (SLF).