Discounted Cash Flow

Coca-cola Consolidated, Inc.

COKE · 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 $2.3b $59.0m $-55.6m 2.6% $6.33
2017 $3.2b (36.9%) $50.1m (-15.0%) $-10.6m (81.0%) 1.6% (-37.9%) $5.36 (-15.3%)
2018 $4.6b (46.5%) $-19.9m (-139.7%) $30.6m (389.3%) -0.4% (-127.1%) $-2.13 (-139.7%)
2019 $4.8b (4.3%) $11.4m (157.1%) $119.0m (288.3%) 0.2% (154.7%) $1.21 (156.8%)
2020 $5.0b (3.7%) $172.5m (1416.4%) $292.4m (145.7%) 3.4% (1361.7%) $36.58 (2923.1%)
2021 $5.6b (11.1%) $189.6m (9.9%) $366.1m (25.2%) 3.4% (-1.1%) $40.33 (10.3%)
2022 $6.2b (11.5%) $430.2m (126.9%) $255.9m (-30.1%) 6.9% (103.5%) $91.50 (126.9%)
2023 $6.7b (7.3%) $408.4m (-5.1%) $528.4m (106.5%) 6.1% (-11.5%) $86.88 (-5.0%)
2024 $6.9b (3.7%) $633.1m (55.0%) $505.3m (-4.4%) 9.2% (49.5%) $139.11 (60.1%)
2025 $7.2b (4.8%) $570.6m (-9.9%) $619.6m (22.6%) 7.9% (-14.0%) $13.57 (-90.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