Hudson Pacific Properties, Inc. (HPP) 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
Hudson Pacific Properties, Inc. (HPP) Bundle
Evaluate the financial outlook of Hudson Pacific Properties, Inc. (HPP) like an expert! This (HPP) DCF Calculator comes with pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your 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 | 818.2 | 805.0 | 896.8 | 1,026.2 | 952.3 | 992.8 | 1,035.1 | 1,079.1 | 1,125.0 | 1,172.9 |
Revenue Growth, % | 0 | -1.62 | 11.41 | 14.43 | -7.2 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
EBITDA | 437.5 | 423.1 | 494.6 | 553.1 | 423.8 | 515.4 | 537.3 | 560.2 | 584.1 | 608.9 |
EBITDA, % | 53.47 | 52.56 | 55.15 | 53.9 | 44.5 | 51.91 | 51.91 | 51.91 | 51.91 | 51.91 |
Depreciation | 653.1 | 677.5 | 731.9 | 865.2 | 397.8 | 738.0 | 769.4 | 802.2 | 836.3 | 871.9 |
Depreciation, % | 79.82 | 84.16 | 81.61 | 84.31 | 41.78 | 74.34 | 74.34 | 74.34 | 74.34 | 74.34 |
EBIT | -215.6 | -254.4 | -237.3 | -312.1 | 25.9 | -222.6 | -232.1 | -242.0 | -252.2 | -263.0 |
EBIT, % | -26.35 | -31.6 | -26.46 | -30.42 | 2.72 | -22.42 | -22.42 | -22.42 | -22.42 | -22.42 |
Total Cash | 187.0 | 248.8 | 225.9 | 255.8 | 100.4 | 227.2 | 236.8 | 246.9 | 257.4 | 268.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 208.3 | 247.8 | 265.6 | 296.7 | 245.4 | 279.1 | 291.0 | 303.3 | 316.2 | 329.7 |
Account Receivables, % | 25.46 | 30.78 | 29.62 | 28.91 | 25.77 | 28.11 | 28.11 | 28.11 | 28.11 | 28.11 |
Inventories | 12.0 | 35.9 | 1.6 | 4.9 | .0 | 13.1 | 13.6 | 14.2 | 14.8 | 15.4 |
Inventories, % | 1.47 | 4.45 | 0.17595 | 0.47884 | 0 | 1.32 | 1.32 | 1.32 | 1.32 | 1.32 |
Accounts Payable | 210.9 | 225.8 | 298.4 | 264.1 | 203.2 | 266.4 | 277.7 | 289.6 | 301.9 | 314.7 |
Accounts Payable, % | 25.77 | 28.05 | 33.28 | 25.73 | 21.34 | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 |
Capital Expenditure | -20.5 | -593.9 | -125.2 | -116.7 | -5.7 | -203.0 | -211.6 | -220.6 | -230.0 | -239.8 |
Capital Expenditure, % | -2.51 | -73.79 | -13.96 | -11.37 | -0.60275 | -20.45 | -20.45 | -20.45 | -20.45 | -20.45 |
Tax Rate, % | -6.09 | -6.09 | -6.09 | -6.09 | -6.09 | -6.09 | -6.09 | -6.09 | -6.09 | -6.09 |
EBITAT | 241.7 | 1,835.5 | 935.6 | -3,144.9 | 27.5 | -89.0 | -92.8 | -96.8 | -100.9 | -105.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 864.8 | 1,870.6 | 1,631.3 | -2,465.1 | 414.9 | 462.5 | 463.9 | 483.6 | 504.2 | 525.7 |
WACC, % | 0.93391 | 0.93391 | 0.93391 | 5.38 | 5.38 | 2.71 | 2.71 | 2.71 | 2.71 | 2.71 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,249.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 536 | |||||||||
Terminal Value | 75,141 | |||||||||
Present Terminal Value | 65,726 | |||||||||
Enterprise Value | 67,975 | |||||||||
Net Debt | 4,300 | |||||||||
Equity Value | 63,674 | |||||||||
Diluted Shares Outstanding, MM | 141 | |||||||||
Equity Value Per Share | 451.74 |
What You Will Receive
- Authentic Hudson Pacific Data: Preloaded financial metrics – from revenue to EBIT – based on real and forecasted figures.
- Complete Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Real-Time Valuation Updates: Automatic recalculations to evaluate the effects of changes on Hudson Pacific's fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and comprehensive projections.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive DCF Model: Offers both unlevered and levered DCF valuation frameworks tailored for Hudson Pacific Properties, Inc. (HPP).
- WACC Analysis Tool: Features a pre-designed Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Hudson Pacific Properties, Inc. (HPP).
- Visual Dashboard and Charts: Graphical representations provide a clear overview of essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Hudson Pacific Properties, Inc. (HPP) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Hudson Pacific Properties, Inc. (HPP)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Hudson Pacific Properties, Inc. (HPP)?
- User-Friendly Interface: Tailored for both novice and seasoned users.
- Customizable Inputs: Adjust parameters to suit your specific analysis needs.
- Real-Time Valuation: Monitor immediate updates to Hudson Pacific's valuation as you change inputs.
- Pre-Loaded Data: Comes with Hudson Pacific's latest financial information for swift evaluations.
- Preferred by Experts: Valued by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Investors: Accurately assess Hudson Pacific Properties, Inc.'s (HPP) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to HPP.
- Consultants: Easily customize the template for valuation reports tailored to HPP clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading real estate firms like HPP.
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to HPP.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations for Hudson Pacific Properties, Inc. (HPP).
- Real-World Data: Hudson Pacific Properties’ historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for deeper insights into HPP's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage relevant to Hudson Pacific Properties.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for HPP stakeholders.