Terreno Realty Corporation (TRNO) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Terreno Realty Corporation (TRNO) Bundle
Explore the financial prospects of Terreno Realty Corporation (TRNO) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Terreno Realty Corporation (TRNO) and enhance your investment strategy.
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 | 171.0 | 186.9 | 221.9 | 276.2 | 323.6 | 379.9 | 446.1 | 523.7 | 614.9 | 722.0 |
| Revenue Growth, % | 0 | 9.27 | 18.75 | 24.46 | 17.15 | 17.41 | 17.41 | 17.41 | 17.41 | 17.41 |
| EBITDA | 115.9 | 141.7 | 156.0 | 287.6 | 206.4 | 286.9 | 336.9 | 395.5 | 464.4 | 545.3 |
| EBITDA, % | 67.75 | 75.8 | 70.29 | 104.13 | 63.77 | 75.52 | 75.52 | 75.52 | 75.52 | 75.52 |
| Depreciation | 112.2 | 118.7 | 134.1 | 167.3 | 59.3 | 204.0 | 239.5 | 281.2 | 330.1 | 387.6 |
| Depreciation, % | 65.6 | 63.53 | 60.41 | 60.58 | 18.32 | 53.69 | 53.69 | 53.69 | 53.69 | 53.69 |
| EBIT | 3.7 | 22.9 | 21.9 | 120.3 | 147.1 | 86.1 | 101.1 | 118.7 | 139.3 | 163.6 |
| EBIT, % | 2.15 | 12.27 | 9.88 | 43.55 | 45.44 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 |
| Total Cash | 110.1 | 107.2 | 204.4 | 26.4 | 165.4 | 208.6 | 244.9 | 287.5 | 337.6 | 396.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 15.9 | .0 | .0 | .0 | .0 | 7.0 | 8.3 | 9.7 | 11.4 | 13.4 |
| Account Receivables, % | 9.27 | 0 | 0 | 0 | 0 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 |
| Inventories | 143.1 | .0 | 205.2 | 29.8 | .0 | 142.0 | 166.8 | 195.8 | 229.9 | 269.9 |
| Inventories, % | 83.67 | 0.000000535 | 92.46 | 10.78 | 0 | 37.38 | 37.38 | 37.38 | 37.38 | 37.38 |
| Accounts Payable | 27.7 | 26.7 | 45.0 | 49.7 | 61.8 | 66.8 | 78.4 | 92.0 | 108.0 | 126.8 |
| Accounts Payable, % | 16.2 | 14.28 | 20.29 | 17.99 | 19.09 | 17.57 | 17.57 | 17.57 | 17.57 | 17.57 |
| Capital Expenditure | -32.1 | -31.6 | -51.3 | -66.6 | -53.1 | -75.4 | -88.6 | -104.0 | -122.1 | -143.4 |
| Capital Expenditure, % | -18.75 | -16.91 | -23.11 | -24.12 | -16.4 | -19.86 | -19.86 | -19.86 | -19.86 | -19.86 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 2.3 | 16.8 | 15.5 | 120.3 | 147.1 | 69.9 | 82.0 | 96.3 | 113.1 | 132.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -48.9 | 261.8 | -88.6 | 401.1 | 195.2 | 54.3 | 218.6 | 256.7 | 301.4 | 353.8 |
| WACC, % | 7.96 | 8.03 | 8.01 | 8.19 | 8.19 | 8.08 | 8.08 | 8.08 | 8.08 | 8.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 901.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 368 | |||||||||
| Terminal Value | 9,023 | |||||||||
| Present Terminal Value | 6,118 | |||||||||
| Enterprise Value | 7,020 | |||||||||
| Net Debt | 606 | |||||||||
| Equity Value | 6,414 | |||||||||
| Diluted Shares Outstanding, MM | 83 | |||||||||
| Equity Value Per Share | 76.93 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real TRNO financials.
- Actual Market Data: Historical performance and projected estimates (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Terreno Realty's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and user-friendliness, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Terreno Realty Corporation (TRNO).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Terreno Realty Corporation (TRNO).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics facilitate straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Terreno Realty Corporation’s (TRNO) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as rental income growth, cap rates, and operating expenses (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Terreno Realty Corporation (TRNO)?
- Accuracy: Utilizes real Terreno Realty financials to ensure precise data.
- Flexibility: Built for users to freely test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Real Estate Students: Understand property valuation methods and apply them using real market data.
- Researchers: Utilize industry-specific models for academic projects or studies.
- Investors: Evaluate your investment strategies and assess valuation metrics for Terreno Realty Corporation (TRNO).
- Financial Analysts: Enhance your analysis with a customizable DCF model tailored for real estate.
- Property Developers: Discover insights into how publicly traded real estate companies like Terreno Realty Corporation (TRNO) operate.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Terreno Realty Corporation (TRNO) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Terreno Realty Corporation (TRNO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.