Nordstrom, Inc. (JWN) 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
Nordstrom, Inc. (JWN) Bundle
Whether you’re an investor or analyst, this (JWN) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from Nordstrom, Inc., you can easily adjust forecasts and observe the effects in real-time.
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 | 15,524.0 | 10,715.0 | 14,789.0 | 15,530.0 | 14,693.0 | 14,937.8 | 15,186.7 | 15,439.7 | 15,697.0 | 15,958.5 |
Revenue Growth, % | 0 | -30.98 | 38.02 | 5.01 | -5.39 | 1.67 | 1.67 | 1.67 | 1.67 | 1.67 |
EBITDA | 1,638.0 | -205.0 | 1,283.0 | 1,264.0 | 1,054.0 | 974.7 | 991.0 | 1,007.5 | 1,024.3 | 1,041.3 |
EBITDA, % | 10.55 | -1.91 | 8.68 | 8.14 | 7.17 | 6.53 | 6.53 | 6.53 | 6.53 | 6.53 |
Depreciation | 844.0 | 839.0 | 790.0 | 789.0 | 770.0 | 864.3 | 878.7 | 893.3 | 908.2 | 923.4 |
Depreciation, % | 5.44 | 7.83 | 5.34 | 5.08 | 5.24 | 5.79 | 5.79 | 5.79 | 5.79 | 5.79 |
EBIT | 794.0 | -1,044.0 | 493.0 | 475.0 | 284.0 | 110.4 | 112.3 | 114.1 | 116.0 | 118.0 |
EBIT, % | 5.11 | -9.74 | 3.33 | 3.06 | 1.93 | 0.73927 | 0.73927 | 0.73927 | 0.73927 | 0.73927 |
Total Cash | 853.0 | 681.0 | 322.0 | 687.0 | 628.0 | 678.9 | 690.2 | 701.7 | 713.4 | 725.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 179.0 | 245.0 | 255.0 | 265.0 | 334.0 | 273.2 | 277.7 | 282.3 | 287.0 | 291.8 |
Account Receivables, % | 1.15 | 2.29 | 1.72 | 1.71 | 2.27 | 1.83 | 1.83 | 1.83 | 1.83 | 1.83 |
Inventories | 1,920.0 | 1,863.0 | 2,289.0 | 1,941.0 | 1,888.0 | 2,108.6 | 2,143.8 | 2,179.5 | 2,215.8 | 2,252.7 |
Inventories, % | 12.37 | 17.39 | 15.48 | 12.5 | 12.85 | 14.12 | 14.12 | 14.12 | 14.12 | 14.12 |
Accounts Payable | 1,576.0 | 1,960.0 | 1,529.0 | 1,238.0 | 1,236.0 | 1,648.1 | 1,675.6 | 1,703.5 | 1,731.9 | 1,760.8 |
Accounts Payable, % | 10.15 | 18.29 | 10.34 | 7.97 | 8.41 | 11.03 | 11.03 | 11.03 | 11.03 | 11.03 |
Capital Expenditure | -935.0 | -385.0 | -506.0 | -473.0 | -569.0 | -596.2 | -606.1 | -616.2 | -626.5 | -636.9 |
Capital Expenditure, % | -6.02 | -3.59 | -3.42 | -3.05 | -3.87 | -3.99 | -3.99 | -3.99 | -3.99 | -3.99 |
Tax Rate, % | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 | 8.84 |
EBITAT | 577.5 | -586.6 | 356.7 | 345.3 | 258.9 | 80.6 | 82.0 | 83.4 | 84.7 | 86.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -36.5 | 242.4 | -226.3 | 708.3 | 441.9 | 601.1 | 342.3 | 348.0 | 353.8 | 359.7 |
WACC, % | 9.56 | 9.17 | 9.55 | 9.56 | 9.99 | 9.56 | 9.56 | 9.56 | 9.56 | 9.56 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,571.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 367 | |||||||||
Terminal Value | 4,851 | |||||||||
Present Terminal Value | 3,073 | |||||||||
Enterprise Value | 4,644 | |||||||||
Net Debt | 3,851 | |||||||||
Equity Value | 793 | |||||||||
Diluted Shares Outstanding, MM | 163 | |||||||||
Equity Value Per Share | 4.86 |
What You Will Get
- Real Nordstrom Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Nordstrom, Inc. (JWN).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Nordstrom’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Nordstrom, Inc. (JWN).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility in your financial assessments.
Key Features
- Accurate Nordstrom Financials: Gain access to reliable pre-loaded historical data and future projections for Nordstrom, Inc. (JWN).
- Customizable Forecast Assumptions: Modify highlighted cells to adjust key metrics like WACC, growth rates, and profit margins.
- Dynamic Calculations: Experience automatic updates for DCF, Net Present Value (NPV), and cash flow analysis.
- Visual Dashboard: Utilize easy-to-read charts and summaries for a clear visualization of your valuation outcomes.
- Designed for All Users: An intuitive layout tailored for investors, CFOs, and consultants, suitable for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Nordstrom data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Nordstrom’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Nordstrom, Inc. (JWN)?
- User-Friendly Interface: Perfect for both novices and seasoned analysts.
- Customizable Inputs: Adjust parameters to suit your financial evaluation.
- Real-Time Updates: Observe immediate changes in Nordstrom’s valuation as you tweak inputs.
- Preloaded Data: Comes with Nordstrom’s historical financial information for swift analysis.
- Preferred by Experts: Utilized by investors and financial analysts for well-informed decision-making.
Who Should Use This Product?
- Retail Management Students: Understand inventory management and customer engagement strategies using real-world examples.
- Researchers: Utilize Nordstrom's business model for case studies in retail and consumer behavior.
- Investors: Analyze your investment strategies and evaluate the performance of Nordstrom, Inc. (JWN).
- Market Analysts: Enhance your analysis with a detailed, customizable financial model tailored for retail companies.
- Entrepreneurs: Discover best practices from a leading retailer to apply in your own business ventures.
What the Template Contains
- Historical Data: Includes Nordstrom’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Nordstrom’s 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 Nordstrom’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.