Piedmont Office Realty Trust, Inc. (PDM) DCF Valuation

Piedmont Office Realty Trust, Inc. (PDM) 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

Piedmont Office Realty Trust, Inc. (PDM) 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:

Designed for accuracy, our (PDM) DCF Calculator enables you to evaluate the valuation of Piedmont Office Realty Trust, Inc. using authentic financial data and offers complete flexibility to modify all essential parameters for improved projections.


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 533.2 535.0 528.7 563.8 577.8 589.7 601.9 614.4 627.1 640.1
Revenue Growth, % 0 0.34623 -1.18 6.63 2.48 2.07 2.07 2.07 2.07 2.07
EBITDA 283.9 491.5 218.1 234.4 231.1 316.0 322.6 329.2 336.1 343.0
EBITDA, % 53.25 91.87 41.26 41.58 39.99 53.59 53.59 53.59 53.59 53.59
Depreciation 432.0 446.3 378.4 405.6 153.8 394.6 402.8 411.1 419.6 428.3
Depreciation, % 81.02 83.41 71.57 71.94 26.62 66.91 66.91 66.91 66.91 66.91
EBIT -148.1 45.3 -160.3 -171.2 77.3 -78.6 -80.2 -81.8 -83.5 -85.3
EBIT, % -27.77 8.46 -30.31 -30.36 13.37 -13.32 -13.32 -13.32 -13.32 -13.32
Total Cash 13.5 7.3 7.4 16.5 .8 9.9 10.1 10.3 10.5 10.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 140.6 159.6 284.1 176.8 191.8
Account Receivables, % 26.36 29.83 53.74 31.36 33.19
Inventories .0 .0 302.8 3.1 .0 68.2 69.6 71.0 72.5 74.0
Inventories, % 0.000000188 0.000000187 57.28 0.54349 0 11.56 11.56 11.56 11.56 11.56
Accounts Payable 117.5 112.0 114.5 110.3 131.5 126.1 128.7 131.4 134.1 136.9
Accounts Payable, % 22.04 20.93 21.65 19.57 22.76 21.39 21.39 21.39 21.39 21.39
Capital Expenditure -103.6 -112.6 -122.6 -121.4 -158.2 -132.8 -135.5 -138.3 -141.2 -144.1
Capital Expenditure, % -19.42 -21.04 -23.19 -21.53 -27.38 -22.51 -22.51 -22.51 -22.51 -22.51
Tax Rate, % -0.02067098 -0.02067098 -0.02067098 -0.02067098 -0.02067098 -0.02067098 -0.02067098 -0.02067098 -0.02067098 -0.02067098
EBITAT -107.3 34.1 -8,603.9 -317.7 77.3 -70.3 -71.8 -73.3 -74.8 -76.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 198.1 343.2 -8,773.0 369.4 82.2 103.9 192.4 196.4 200.4 204.6
WACC, % 5.83 5.92 6.72 6.72 6.72 6.38 6.38 6.38 6.38 6.38
PV UFCF
SUM PV UFCF 737.5
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) 207
Terminal Value 3,842
Present Terminal Value 2,820
Enterprise Value 3,557
Net Debt 2,054
Equity Value 1,504
Diluted Shares Outstanding, MM 124
Equity Value Per Share 12.16

What You Will Get

  • Real PDM Financial Data: Pre-filled with Piedmont Office Realty Trust’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 Piedmont Office Realty Trust’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

  • Comprehensive Financial Data: Gain access to precise historical data and future forecasts for Piedmont Office Realty Trust, Inc. (PDM).
  • Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
  • Real-Time Calculations: Enjoy automatic updates to DCF, Net Present Value (NPV), and cash flow evaluations.
  • User-Friendly Dashboard: Intuitive charts and summaries that make it easy to interpret your valuation insights.
  • Suitable for All Levels: A straightforward and accessible design tailored for investors, CFOs, and consultants alike.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Piedmont Office Realty Trust, Inc.'s (PDM) preloaded data.
  • 2. Modify Key Assumptions: Adjust critical inputs such as growth projections, WACC, and capital expenditures.
  • 3. Instant Results: The DCF model automatically computes intrinsic value and NPV in real-time.
  • 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
  • 5. Make Informed Decisions: Deliver professional valuation insights to bolster your strategic choices.

Why Choose This Calculator for Piedmont Office Realty Trust, Inc. (PDM)?

  • User-Friendly Interface: Perfect for both novice and experienced users.
  • Customizable Inputs: Tailor assumptions to suit your specific analysis needs.
  • Real-Time Valuation: Observe immediate updates to Piedmont's valuation as you tweak inputs.
  • Preloaded Data: Comes with Piedmont's current financial figures for swift evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts in making strategic choices.

Who Should Use This Product?

  • Investors: Accurately estimate Piedmont Office Realty Trust, Inc.'s (PDM) fair value before making investment decisions.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Piedmont Office Realty Trust, Inc. (PDM).
  • Consultants: Easily customize the template for valuation reports tailored to clients interested in Piedmont Office Realty Trust, Inc. (PDM).
  • Entrepreneurs: Discover insights into financial modeling practices employed by leading real estate investment trusts like Piedmont Office Realty Trust, Inc. (PDM).
  • Educators: Implement it as a teaching resource to illustrate valuation methodologies in the real estate sector, focusing on Piedmont Office Realty Trust, Inc. (PDM).

What the Template Contains

  • Preloaded PDM Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.