City Office REIT, Inc. (CIO) DCF Valuation

City Office REIT, Inc. (CIO) 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

City Office REIT, Inc. (CIO) 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:

Optimize your time and improve precision with our City Office REIT, Inc. (CIO) DCF Calculator! Utilizing real data from City Office REIT and customizable assumptions, this tool enables you to forecast, analyze, and value City Office REIT like a seasoned investor.


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 156.3 160.8 164.0 180.5 179.1 185.4 192.0 198.8 205.8 213.1
Revenue Growth, % 0 2.91 1.99 10.02 -0.76959 3.54 3.54 3.54 3.54 3.54
EBITDA 87.9 91.8 90.5 97.7 94.3 102.1 105.7 109.5 113.3 117.3
EBITDA, % 56.25 57.1 55.2 54.16 52.63 55.07 55.07 55.07 55.07 55.07
Depreciation 127.5 129.4 130.8 144.0 63.0 132.3 137.0 141.8 146.8 152.0
Depreciation, % 81.6 80.43 79.74 79.79 35.17 71.35 71.35 71.35 71.35 71.35
EBIT -39.6 -37.5 -40.3 -46.3 31.3 -30.2 -31.3 -32.4 -33.5 -34.7
EBIT, % -25.35 -23.33 -24.55 -25.64 17.46 -16.28 -16.28 -16.28 -16.28 -16.28
Total Cash 70.1 25.3 21.3 28.2 30.1 39.3 40.7 42.1 43.6 45.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 32.1 33.0 30.4 44.4 53.5
Account Receivables, % 20.55 20.5 18.54 24.62 29.85
Inventories -.7 145.6 93.6 104.8 .0 76.1 78.8 81.6 84.5 87.5
Inventories, % -0.44786 90.54 57.07 58.05 0 41.04 41.04 41.04 41.04 41.04
Accounts Payable 28.8 25.4 27.1 35.8 29.1 32.2 33.3 34.5 35.7 37.0
Accounts Payable, % 18.42 15.8 16.52 19.81 16.23 17.36 17.36 17.36 17.36 17.36
Capital Expenditure -3.9 -7.8 -8.2 -9.6 .0 -6.5 -6.8 -7.0 -7.3 -7.5
Capital Expenditure, % -2.51 -4.84 -4.99 -5.3 0 -3.53 -3.53 -3.53 -3.53 -3.53
Tax Rate, % -31.79 -31.79 -31.79 -31.79 -31.79 -31.79 -31.79 -31.79 -31.79 -31.79
EBITAT 431.7 159.8 -40.2 -66.0 41.2 -18.1 -18.7 -19.4 -20.1 -20.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 552.7 130.8 138.7 52.0 193.3 45.8 108.4 112.2 116.2 120.3
WACC, % 3.3 3.3 6.91 6.91 6.91 5.47 5.47 5.47 5.47 5.47
PV UFCF
SUM PV UFCF 422.7
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 125
Terminal Value 6,326
Present Terminal Value 4,847
Enterprise Value 5,270
Net Debt 639
Equity Value 4,631
Diluted Shares Outstanding, MM 40
Equity Value Per Share 115.99

What You Will Get

  • Real CIO Financial Data: Pre-filled with City Office REIT’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See City Office REIT’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Customizable Investment Metrics: Adjust essential factors such as rental income growth, occupancy rates, and operating expenses.
  • Instant DCF Analysis: Automatically computes intrinsic value, NPV, and other financial metrics in real-time.
  • High-Precision Valuations: Leverages City Office REIT's (CIO) actual financial data for accurate investment assessments.
  • Streamlined Scenario Testing: Easily evaluate varying assumptions and analyze different financial outcomes.
  • Efficiency Booster: Remove the hassle of constructing complex valuation frameworks from the ground up.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based CIO DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other parameters.
  3. Instant Calculations: The model automatically recalculates City Office REIT’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
  5. Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.

Why Choose This Calculator for City Office REIT, Inc. (CIO)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio assessments tailored for real estate investment.
  • Flexible Inputs: Modify the highlighted cells to explore different investment scenarios.
  • In-Depth Analysis: Automatically computes City Office REIT’s intrinsic value and Net Present Value.
  • Preloaded Information: Access to both historical and projected data for reliable analysis.
  • Expert-Level Tool: Perfect for real estate analysts, investors, and financial advisors.

Who Should Use This Product?

  • Investors: Evaluate City Office REIT, Inc. (CIO)'s performance before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
  • Real Estate Professionals: Understand how publicly traded REITs like City Office REIT, Inc. (CIO) are valued.
  • Consultants: Create detailed valuation reports for real estate clients.
  • Students and Educators: Utilize current market data to learn and teach valuation strategies in real estate.

What the Template Contains

  • Pre-Filled DCF Model: City Office REIT, Inc.’s (CIO) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to City Office REIT, Inc. (CIO).
  • Financial Ratios: Assess City Office REIT, Inc.’s (CIO) profitability, leverage, and efficiency metrics.
  • Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis of City Office REIT, Inc. (CIO).
  • Financial Statements: Access annual and quarterly reports for in-depth evaluation of City Office REIT, Inc. (CIO).
  • Interactive Dashboard: Visualize key valuation metrics and results for City Office REIT, Inc. (CIO) with ease.

No products were found matching.