Northern Trust Corporation (NTRS) 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
Northern Trust Corporation (NTRS) Bundle
As an investor or analyst, the Northern Trust Corporation (NTRS) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Northern Trust Corporation, you can adjust forecasts and instantly observe the effects.
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 | 6,087.6 | 5,975.8 | 6,546.0 | 6,749.2 | 6,773.5 | 6,962.6 | 7,157.1 | 7,356.9 | 7,562.4 | 7,773.5 |
Revenue Growth, % | 0 | -1.84 | 9.54 | 3.1 | 0.36004 | 2.79 | 2.79 | 2.79 | 2.79 | 2.79 |
EBITDA | 2,403.0 | 2,127.9 | 2,525.7 | 2,319.9 | 2,099.4 | 2,493.1 | 2,562.7 | 2,634.3 | 2,707.8 | 2,783.4 |
EBITDA, % | 39.47 | 35.61 | 38.58 | 34.37 | 30.99 | 35.81 | 35.81 | 35.81 | 35.81 | 35.81 |
Depreciation | 458.9 | 500.3 | 515.7 | 553.6 | 634.6 | 575.9 | 592.0 | 608.6 | 625.6 | 643.0 |
Depreciation, % | 7.54 | 8.37 | 7.88 | 8.2 | 9.37 | 8.27 | 8.27 | 8.27 | 8.27 | 8.27 |
EBIT | 1,944.1 | 1,627.6 | 2,010.0 | 1,766.3 | 1,464.8 | 1,917.1 | 1,970.7 | 2,025.7 | 2,082.3 | 2,140.4 |
EBIT, % | 31.94 | 27.24 | 30.71 | 26.17 | 21.63 | 27.53 | 27.53 | 27.53 | 27.53 | 27.53 |
Total Cash | 4,464.2 | 4,389.5 | 3,056.8 | 4,686.2 | 4,791.5 | 4,646.3 | 4,776.0 | 4,909.4 | 5,046.5 | 5,187.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 911.3 | 1,171.6 | 1,952.2 | 1,698.3 | .0 | 1,247.2 | 1,282.0 | 1,317.8 | 1,354.6 | 1,392.4 |
Account Receivables, % | 14.97 | 19.61 | 29.82 | 25.16 | 0 | 17.91 | 17.91 | 17.91 | 17.91 | 17.91 |
Inventories | 6,530.5 | 11,119.8 | 6,693.7 | 68,639.4 | .0 | 5,570.1 | 5,725.7 | 5,885.5 | 6,049.9 | 6,218.8 |
Inventories, % | 107.28 | 186.08 | 102.26 | 1017 | 0 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -158.0 | -135.8 | -95.5 | -128.6 | -675.8 | -253.6 | -260.7 | -267.9 | -275.4 | -283.1 |
Capital Expenditure, % | -2.6 | -2.27 | -1.46 | -1.91 | -9.98 | -3.64 | -3.64 | -3.64 | -3.64 | -3.64 |
Tax Rate, % | 24.41 | 24.41 | 24.41 | 24.41 | 24.41 | 24.41 | 24.41 | 24.41 | 24.41 | 24.41 |
EBITAT | 1,492.2 | 1,209.3 | 1,545.2 | 1,336.0 | 1,107.3 | 1,453.8 | 1,494.4 | 1,536.2 | 1,579.0 | 1,623.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -5,648.7 | -3,275.8 | 5,610.9 | -59,930.8 | 71,403.8 | -5,041.1 | 1,635.4 | 1,681.1 | 1,728.0 | 1,776.3 |
WACC, % | 17.6 | 17.22 | 17.62 | 17.43 | 17.42 | 17.46 | 17.46 | 17.46 | 17.46 | 17.46 |
PV UFCF | ||||||||||
SUM PV UFCF | -366.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,812 | |||||||||
Terminal Value | 11,722 | |||||||||
Present Terminal Value | 5,244 | |||||||||
Enterprise Value | 4,877 | |||||||||
Net Debt | -23,821 | |||||||||
Equity Value | 28,698 | |||||||||
Diluted Shares Outstanding, MM | 208 | |||||||||
Equity Value Per Share | 138.26 |
What You Will Get
- Real Northern Trust Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Northern Trust Corporation (NTRS).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Northern Trust’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive NTRS Data: Pre-loaded with Northern Trust's historical financial performance and future forecasts.
- Customizable Assumptions: Tailor inputs for revenue growth, profit margins, weighted average cost of capital (WACC), tax rates, and capital expenditures.
- Interactive Valuation Framework: Automatically refreshes Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Designed to be straightforward and accessible for both seasoned professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Northern Trust Corporation’s (NTRS) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Instant Results: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your decision-making.
Why Choose This Calculator for Northern Trust Corporation (NTRS)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, investment managers, and corporate strategists.
- Accurate Financial Data: Northern Trust’s historical and projected financial information is preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Detailed instructions provide a seamless experience throughout the process.
Who Should Use This Product?
- Investors: Evaluate Northern Trust Corporation's (NTRS) performance before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts.
- Startup Founders: Gain insights into how established financial institutions like Northern Trust are valued.
- Consultants: Provide comprehensive valuation assessments for clients in the finance sector.
- Students and Educators: Utilize real-time data to learn and teach financial valuation principles.
What the Template Contains
- Pre-Filled DCF Model: Northern Trust Corporation’s (NTRS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Northern Trust Corporation’s (NTRS) 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.