Northern Trust Corporation (NTRS) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 14.97 19.61 29.82 25.16 0
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.