Tapestry, Inc. (TPR) 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
Tapestry, Inc. (TPR) Bundle
Gain insight into your Tapestry, Inc. (TPR) valuation analysis with our cutting-edge DCF Calculator! Preloaded with real TPR data, this Excel template lets you adjust forecasts and assumptions to accurately determine Tapestry, Inc.'s intrinsic value.
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 | 4,961.4 | 5,746.3 | 6,684.5 | 6,660.9 | 6,671.2 | 7,204.0 | 7,779.4 | 8,400.8 | 9,071.8 | 9,796.4 |
Revenue Growth, % | 0 | 15.82 | 16.33 | -0.35306 | 0.15463 | 7.99 | 7.99 | 7.99 | 7.99 | 7.99 |
EBITDA | -315.8 | 1,187.4 | 1,371.1 | 1,361.8 | 1,368.7 | 1,091.7 | 1,178.9 | 1,273.1 | 1,374.8 | 1,484.6 |
EBITDA, % | -6.37 | 20.66 | 20.51 | 20.44 | 20.52 | 15.15 | 15.15 | 15.15 | 15.15 | 15.15 |
Depreciation | 248.3 | 218.7 | 195.3 | 182.2 | 229.0 | 257.9 | 278.5 | 300.8 | 324.8 | 350.7 |
Depreciation, % | 5 | 3.81 | 2.92 | 2.74 | 3.43 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
EBIT | -564.1 | 968.7 | 1,175.8 | 1,179.6 | 1,139.7 | 833.8 | 900.4 | 972.3 | 1,050.0 | 1,133.9 |
EBIT, % | -11.37 | 16.86 | 17.59 | 17.71 | 17.08 | 11.57 | 11.57 | 11.57 | 11.57 | 11.57 |
Total Cash | 1,434.4 | 2,015.8 | 953.2 | 741.5 | 7,203.8 | 2,728.6 | 2,946.6 | 3,181.9 | 3,436.1 | 3,710.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 193.3 | 200.2 | 252.3 | 211.5 | 464.4 | 306.8 | 331.3 | 357.7 | 386.3 | 417.1 |
Account Receivables, % | 3.9 | 3.48 | 3.77 | 3.18 | 6.96 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
Inventories | 736.9 | 734.8 | 994.2 | 919.5 | 824.8 | 989.6 | 1,068.6 | 1,154.0 | 1,246.1 | 1,345.7 |
Inventories, % | 14.85 | 12.79 | 14.87 | 13.8 | 12.36 | 13.74 | 13.74 | 13.74 | 13.74 | 13.74 |
Accounts Payable | 130.8 | 445.2 | 520.7 | 416.9 | 452.2 | 449.7 | 485.6 | 524.4 | 566.3 | 611.5 |
Accounts Payable, % | 2.64 | 7.75 | 7.79 | 6.26 | 6.78 | 6.24 | 6.24 | 6.24 | 6.24 | 6.24 |
Capital Expenditure | -205.4 | -116.0 | -93.9 | -184.2 | -108.9 | -172.3 | -186.1 | -201.0 | -217.0 | -234.4 |
Capital Expenditure, % | -4.14 | -2.02 | -1.4 | -2.77 | -1.63 | -2.39 | -2.39 | -2.39 | -2.39 | -2.39 |
Tax Rate, % | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 | 19.36 |
EBITAT | -589.3 | 900.6 | 961.6 | 965.9 | 919.1 | 729.2 | 787.5 | 850.4 | 918.3 | 991.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,345.8 | 1,312.9 | 827.0 | 975.6 | 916.3 | 805.1 | 812.2 | 877.1 | 947.2 | 1,022.8 |
WACC, % | 9.13 | 9.01 | 8.83 | 8.83 | 8.81 | 8.92 | 8.92 | 8.92 | 8.92 | 8.92 |
PV UFCF | ||||||||||
SUM PV UFCF | 3,442.5 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 1,033 | |||||||||
Terminal Value | 13,038 | |||||||||
Present Terminal Value | 8,504 | |||||||||
Enterprise Value | 11,947 | |||||||||
Net Debt | 2,624 | |||||||||
Equity Value | 9,323 | |||||||||
Diluted Shares Outstanding, MM | 233 | |||||||||
Equity Value Per Share | 39.98 |
What You Will Get
- Editable Forecast Inputs: Easily adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Tapestry, Inc.'s (TPR) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Pre-Loaded Data: Tapestry, Inc.'s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Observe Tapestry, Inc.'s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics effectively.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Step 1: Download the prebuilt Excel template containing Tapestry, Inc.'s (TPR) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Tapestry, Inc.'s (TPR) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose Tapestry, Inc. (TPR)?
- Enhance Efficiency: Skip the hassle of complex calculations – our tools are user-friendly and ready to go.
- Boost Precision: Access to verified financial insights minimizes valuation discrepancies.
- Completely Adaptable: Modify the tools to suit your unique assumptions and forecasts.
- Simple to Understand: Intuitive visuals and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Tapestry, Inc. (TPR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Tapestry, Inc. (TPR).
- Consultants: Deliver professional valuation insights on Tapestry, Inc. (TPR) to clients quickly and accurately.
- Business Owners: Understand how large companies like Tapestry, Inc. (TPR) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Tapestry, Inc. (TPR).
What the Template Contains
- Historical Data: Includes Tapestry, Inc.'s (TPR) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Tapestry, Inc.'s (TPR) 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 Tapestry, Inc.'s (TPR) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.