The Western Union Company (WU) DCF Valuation

The Western Union Company (WU) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

The Western Union Company (WU) 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:

Whether you're an investor or analyst, this (WU) DCF Calculator is your essential tool for accurate valuation. Preloaded with real data from The Western Union Company, you can 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 5,292.1 4,835.0 5,070.8 4,475.5 4,357.0 4,159.3 3,970.6 3,790.5 3,618.5 3,454.3
Revenue Growth, % 0 -8.64 4.88 -11.74 -2.65 -4.54 -4.54 -4.54 -4.54 -4.54
EBITDA 1,296.4 1,217.6 1,321.4 1,108.2 1,030.6 1,032.8 985.9 941.2 898.5 857.7
EBITDA, % 24.5 25.18 26.06 24.76 23.65 24.83 24.83 24.83 24.83 24.83
Depreciation 4,227.0 3,820.5 3,904.8 3,567.3 183.6 2,660.5 2,539.7 2,424.5 2,314.5 2,209.5
Depreciation, % 79.87 79.02 77.01 79.71 4.21 63.96 63.96 63.96 63.96 63.96
EBIT -2,930.6 -2,602.9 -2,583.4 -2,459.1 847.0 -1,627.7 -1,553.8 -1,483.3 -1,416.0 -1,351.8
EBIT, % -55.38 -53.83 -50.95 -54.95 19.44 -39.13 -39.13 -39.13 -39.13 -39.13
Total Cash 1,450.5 1,428.2 1,208.3 1,285.9 1,268.6 1,153.2 1,100.8 1,050.9 1,003.2 957.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,230.1 1,135.1 .0 .0 .0
Account Receivables, % 23.24 23.48 0 0 0
Inventories 226.7 312.3 .0 .0 .0 89.4 85.3 81.4 77.7 74.2
Inventories, % 4.28 6.46 0 0 0 2.15 2.15 2.15 2.15 2.15
Accounts Payable 601.9 500.9 450.2 464.0 453.0 427.4 408.0 389.5 371.8 354.9
Accounts Payable, % 11.37 10.36 8.88 10.37 10.4 10.28 10.28 10.28 10.28 10.28
Capital Expenditure -127.7 -156.8 -214.6 -208.2 -147.8 -149.2 -142.4 -135.9 -129.8 -123.9
Capital Expenditure, % -2.41 -3.24 -4.23 -4.65 -3.39 -3.59 -3.59 -3.59 -3.59 -3.59
Tax Rate, % 16.06 16.06 16.06 16.06 16.06 16.06 16.06 16.06 16.06 16.06
EBITAT -2,347.1 -2,265.6 -2,225.5 -2,220.2 710.9 -1,391.6 -1,328.5 -1,268.2 -1,210.7 -1,155.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 897.3 1,306.5 2,861.4 1,152.7 735.7 616.0 1,071.1 1,022.5 976.2 931.9
WACC, % 6.6 6.73 6.71 6.78 6.67 6.7 6.7 6.7 6.7 6.7
PV UFCF
SUM PV UFCF 3,787.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 951
Terminal Value 20,232
Present Terminal Value 14,630
Enterprise Value 18,417
Net Debt 902
Equity Value 17,515
Diluted Shares Outstanding, MM 372
Equity Value Per Share 47.11

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios.
  • Real-World Data: The Western Union Company’s (WU) financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing projections, validating strategies, and saving time.

Key Features

  • Real-Life WU Data: Pre-filled with Western Union’s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Western Union’s preloaded data.
  • 2. Adjust Key Inputs: Modify essential variables such as growth rates, WACC, and capital expenditures.
  • 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV in real-time.
  • 4. Explore Scenarios: Evaluate various forecasts to investigate different valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making.

Why Choose This Calculator for The Western Union Company (WU)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses specifically for The Western Union Company (WU).
  • Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios for The Western Union Company (WU).
  • In-Depth Analysis: Automatically computes The Western Union Company (WU)’s intrinsic value and Net Present Value.
  • Integrated Data: Comes with historical and projected data to provide reliable starting points for The Western Union Company (WU).
  • Expert-Level Tool: Perfect for financial analysts, investors, and business consultants focused on The Western Union Company (WU).

Who Should Use This Product?

  • Investors: Make informed decisions with a reliable tool tailored for evaluating currency transfers.
  • Financial Analysts: Streamline your analysis with a comprehensive model designed for Western Union's services.
  • Consultants: Effortlessly modify the template for client reports or presentations related to international transactions.
  • Finance Enthusiasts: Enhance your knowledge of remittance and currency exchange processes with practical examples.
  • Educators and Students: Utilize it as a hands-on learning resource in finance and international business courses.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations for The Western Union Company (WU).
  • Real-World Data: Historical and projected financials for The Western Union Company (WU) preloaded for analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns to provide deeper insights into The Western Union Company (WU).
  • Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage specific to The Western Union Company (WU).
  • Dashboard with Visual Outputs: Charts and tables designed for clear and actionable insights regarding The Western Union Company (WU).

No products were found matching.