Discounted Cash Flow

Terreno Realty Corp. REIT

TRNO · Based on 10 years of SEC filings

Average annual growth rates

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Average annual growth is the mean year-over-year change across each period.

Endpoint CAGR (better for long term trend)

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Endpoint CAGR is the compound annual rate from the first to last year in each period.

Projections use average year-over-year growth. Change this in Settings.

Projected growth rate

Free cash flow growth
10-year: — 5-year: — 3-year: —
Averaged growth (FCF & NI)
10-year: — 5-year: — 3-year: —
Net income growth
10-year: — 5-year: — 3-year: —
Sales growth (not added to calculations)
10-year: — 5-year: — 3-year: —

Click a greyed-out slider to switch metrics. Slide between the 10-year, 5-year, and 3-year historic growth rates for FCF, net income, or their average.

%
%

Historical inputs (10 fiscal years)

YEAR Sales Net Income Free Cash Flow Net Margin EPS (diluted)
2016 $108.4m $15.1m $49.2m 13.9% $0.26
2017 $132.5m (22.2%) $53.1m (251.2%) $69.5m (41.1%) 40.1% (187.4%) $0.95 (265.4%)
2018 $151.7m (14.5%) $63.3m (19.2%) $77.6m (11.7%) 41.7% (4.1%) $1.09 (14.7%)
2019 $171.0m (12.8%) $55.5m (-12.3%) $94.7m (22.0%) 32.5% (-22.2%) $0.86 (-21.1%)
2020 $186.9m (9.3%) $79.8m (43.7%) $101.0m (6.7%) 42.7% (31.5%) $1.17 (36.0%)
2021 $221.9m (18.8%) $87.3m (9.3%) $132.2m (30.8%) 39.3% (-7.9%) $1.23 (5.1%)
2022 $276.2m (24.5%) $198.0m (126.9%) $76.6m (-42.1%) 71.7% (82.3%) $2.61 (112.2%)
2023 $323.6m (17.2%) $151.5m (-23.5%) $126.6m (65.3%) 46.8% (-34.7%) $1.81 (-30.7%)
2024 $382.6m (18.2%) $184.5m (21.8%) $186.3m (47.1%) 48.2% (3.0%) $1.92 (6.1%)
2025 $476.4m (24.5%) $403.0m (118.4%) $208.5m (11.9%) 84.6% (75.4%) $3.92 (104.2%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

Projected cash flows

Year Projected cash flow Discount Factor Present Value

PV of projected FCF:

Terminal FCF:

Terminal value:

PV of terminal value:

Enterprise value (DCF):

DCF price per share:

Current price:

Alternative DCF Models

Model Fair Value Upside PV(FCFs) PV(Terminal) Total Years
Standard (10yr→TV) 10 + TV
Alt A (Gradual Decline)
Alt B (30yr Hard Stop) N/A

This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.

+ 10YR Financials Balance Sheet (10YR) Cash Flow (10YR) DCF Model