Signet Jewelers Limited (SIG) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Signet Jewelers Limited (SIG) Bundle
Looking to assess the intrinsic value of Signet Jewelers Limited? Our SIG DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your forecasts and enhance your investment choices.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 6,137.1 | 5,226.9 | 7,826.0 | 7,842.1 | 7,171.1 | 7,647.0 | 8,154.4 | 8,695.5 | 9,272.6 | 9,887.9 |
| Revenue Growth, % | 0 | -14.83 | 49.73 | 0.20572 | -8.56 | 6.64 | 6.64 | 6.64 | 6.64 | 6.64 |
| EBITDA | 343.9 | 118.3 | 1,064.8 | 629.2 | 801.7 | 622.1 | 663.4 | 707.4 | 754.3 | 804.4 |
| EBITDA, % | 5.6 | 2.26 | 13.61 | 8.02 | 11.18 | 8.14 | 8.14 | 8.14 | 8.14 | 8.14 |
| Depreciation | 178.0 | 176.0 | 163.5 | 164.5 | 161.9 | 194.4 | 207.3 | 221.1 | 235.7 | 251.4 |
| Depreciation, % | 2.9 | 3.37 | 2.09 | 2.1 | 2.26 | 2.54 | 2.54 | 2.54 | 2.54 | 2.54 |
| EBIT | 165.9 | -57.7 | 901.3 | 464.7 | 639.8 | 427.7 | 456.1 | 486.3 | 518.6 | 553.0 |
| EBIT, % | 2.7 | -1.1 | 11.52 | 5.93 | 8.92 | 5.59 | 5.59 | 5.59 | 5.59 | 5.59 |
| Total Cash | 374.5 | 1,172.5 | 1,418.3 | 1,166.8 | 1,378.7 | 1,235.2 | 1,317.1 | 1,404.5 | 1,497.7 | 1,597.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 38.8 | 88.7 | 18.3 | 24.1 | 18.8 | 47.9 | 51.1 | 54.5 | 58.1 | 61.9 |
| Account Receivables, % | 0.63222 | 1.7 | 0.23384 | 0.30732 | 0.26216 | 0.62651 | 0.62651 | 0.62651 | 0.62651 | 0.62651 |
| Inventories | 2,331.7 | 2,032.5 | 2,060.4 | 2,150.3 | 1,936.6 | 2,410.8 | 2,570.8 | 2,741.4 | 2,923.3 | 3,117.3 |
| Inventories, % | 37.99 | 38.89 | 26.33 | 27.42 | 27.01 | 31.53 | 31.53 | 31.53 | 31.53 | 31.53 |
| Accounts Payable | 227.9 | 812.6 | 899.8 | 879.0 | 735.1 | 798.6 | 851.6 | 908.1 | 968.4 | 1,032.6 |
| Accounts Payable, % | 3.71 | 15.55 | 11.5 | 11.21 | 10.25 | 10.44 | 10.44 | 10.44 | 10.44 | 10.44 |
| Capital Expenditure | -136.3 | -83.0 | -129.6 | -138.9 | -125.5 | -137.4 | -146.6 | -156.3 | -166.6 | -177.7 |
| Capital Expenditure, % | -2.22 | -1.59 | -1.66 | -1.77 | -1.75 | -1.8 | -1.8 | -1.8 | -1.8 | -1.8 |
| Tax Rate, % | -26.66 | -26.66 | -26.66 | -26.66 | -26.66 | -26.66 | -26.66 | -26.66 | -26.66 | -26.66 |
| EBITAT | 134.9 | -9.8 | 784.6 | 388.0 | 810.4 | 315.5 | 336.4 | 358.7 | 382.5 | 407.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,966.0 | 917.2 | 948.2 | 297.1 | 921.9 | -67.4 | 287.0 | 306.1 | 326.4 | 348.0 |
| WACC, % | 12.11 | 11.48 | 12.17 | 12.13 | 12.29 | 12.04 | 12.04 | 12.04 | 12.04 | 12.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 790.4 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 352 | |||||||||
| Terminal Value | 3,184 | |||||||||
| Present Terminal Value | 1,804 | |||||||||
| Enterprise Value | 2,594 | |||||||||
| Net Debt | -135 | |||||||||
| Equity Value | 2,729 | |||||||||
| Diluted Shares Outstanding, MM | 54 | |||||||||
| Equity Value Per Share | 50.54 |
What You Will Get
- Real SIG Financial Data: Pre-filled with Signet Jewelers Limited’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: Watch Signet’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
- Real-Time SIG Data: Pre-loaded with Signet Jewelers Limited’s historical financials and future projections.
- Comprehensive Customization: Tailor inputs such as revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Interactive Valuation Framework: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user adjustments.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation possibilities.
- Intuitive Interface: User-friendly design catering to both professionals and novices.
How It Works
- Download the Template: Get instant access to the Excel-based SIG DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Signet Jewelers' intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Signet Jewelers Limited (SIG)?
- User-Friendly Interface: Perfect for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Instantly observe changes in Signet’s valuation as you tweak the inputs.
- Preloaded Data: Comes equipped with Signet’s latest financial information for swift evaluations.
- Preferred by Experts: Widely utilized by investors and financial analysts for strategic decision-making.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Signet Jewelers Limited (SIG) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Signet Jewelers Limited (SIG).
- Consultants: Deliver professional valuation insights on Signet Jewelers Limited (SIG) to clients quickly and accurately.
- Business Owners: Understand how companies like Signet Jewelers Limited (SIG) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Signet Jewelers Limited (SIG).
What the Template Contains
- Pre-Filled DCF Model: Signet Jewelers Limited’s (SIG) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Signet Jewelers Limited’s (SIG) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.