Americold Realty Trust, Inc. (COLD) DCF Valuation

Americold Realty Trust, Inc. (COLD) 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

Americold Realty Trust, Inc. (COLD) 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:

Looking to determine the intrinsic value of Americold Realty Trust, Inc.? Our (COLD) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to adjust forecasts and enhance your investment choices.


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 1,783.7 1,987.7 2,714.8 2,914.7 2,673.3 2,988.1 3,339.9 3,733.2 4,172.8 4,664.1
Revenue Growth, % 0 11.44 36.58 7.37 -8.28 11.77 11.77 11.77 11.77 11.77
EBITDA 300.9 325.2 448.3 467.1 165.8 430.1 480.7 537.4 600.6 671.3
EBITDA, % 16.87 16.36 16.51 16.03 6.2 14.39 14.39 14.39 14.39 14.39
Depreciation 1,640.5 1,834.8 2,587.8 2,781.1 353.7 2,320.2 2,593.4 2,898.8 3,240.1 3,621.7
Depreciation, % 91.97 92.3 95.32 95.42 13.23 77.65 77.65 77.65 77.65 77.65
EBIT -1,339.6 -1,509.6 -2,139.5 -2,314.0 -188.0 -1,890.1 -2,112.7 -2,361.5 -2,639.5 -2,950.3
EBIT, % -75.1 -75.95 -78.81 -79.39 -7.03 -63.26 -63.26 -63.26 -63.26 -63.26
Total Cash 234.3 621.1 83.0 53.1 60.4 307.9 344.1 384.6 429.9 480.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 214.8 324.2 380.0 430.0 426.0
Account Receivables, % 12.04 16.31 14 14.75 15.94
Inventories 9.4 21.5 27.0 29.3 30.7 28.4 31.8 35.5 39.7 44.4
Inventories, % 0.52537 1.08 0.99603 1.01 1.15 0.95159 0.95159 0.95159 0.95159 0.95159
Accounts Payable 109.2 179.0 223.9 215.3 201.1 228.8 255.7 285.9 319.5 357.1
Accounts Payable, % 6.12 9.01 8.25 7.39 7.52 7.66 7.66 7.66 7.66 7.66
Capital Expenditure -302.4 -402.4 -491.8 -322.9 -330.2 -470.6 -526.0 -588.0 -657.2 -734.6
Capital Expenditure, % -16.96 -20.24 -18.12 -11.08 -12.35 -15.75 -15.75 -15.75 -15.75 -15.75
Tax Rate, % -2.48 -2.48 -2.48 -2.48 -2.48 -2.48 -2.48 -2.48 -2.48 -2.48
EBITAT -1,500.2 -2,101.5 -2,034.2 -1,176.3 -192.6 -1,685.7 -1,884.2 -2,106.0 -2,354.0 -2,631.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -277.1 -720.8 45.4 1,221.0 -180.7 183.5 155.5 173.8 194.2 217.1
WACC, % 6.28 6.28 6.2 5.47 6.28 6.1 6.1 6.1 6.1 6.1
PV UFCF
SUM PV UFCF 771.3
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 226
Terminal Value 10,749
Present Terminal Value 7,995
Enterprise Value 8,766
Net Debt 3,432
Equity Value 5,334
Diluted Shares Outstanding, MM 276
Equity Value Per Share 19.34

What You Will Get

  • Pre-Filled Financial Model: Americold Realty Trust’s actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
  • Instant Calculations: Automatic updates ensure you see results as you make changes.
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.

Key Features

  • Pre-Loaded Data: Americold Realty Trust, Inc.'s (COLD) historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Instant Results: View Americold's (COLD) intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.

How It Works

  • Download: Obtain the ready-to-use Excel file containing Americold Realty Trust, Inc. (COLD) financial data.
  • Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to suit your analysis.
  • Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Develop various projections and instantly compare the results.
  • Make Decisions: Leverage the valuation outcomes to inform your investment decisions.

Why Choose This Calculator for Americold Realty Trust, Inc. (COLD)?

  • Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for real estate investment.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
  • Detailed Insights: Automatically computes Americold's intrinsic value and Net Present Value.
  • Preloaded Data: Historical and projected data provide reliable foundations for analysis.
  • Professional Quality: Perfect for real estate analysts, investors, and business consultants.

Who Should Use This Product?

  • Investors: Evaluate Americold Realty Trust’s valuation before making stock transactions.
  • CFOs and Financial Analysts: Optimize valuation processes and assess financial projections.
  • Real Estate Entrepreneurs: Understand how leading real estate investment trusts like Americold are valued.
  • Consultants: Provide expert valuation reports for clients in the real estate sector.
  • Students and Educators: Utilize real-world data to practice and instruct on valuation methodologies.

What the Template Contains

  • Pre-Filled Data: Contains Americold Realty Trust's historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Assess Americold Realty Trust's profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing key valuation outcomes.

No products were found matching.