Guaranty Bancshares, Inc. (GNTY) Two-Stage Excess Return Model - Discounting Cash Flows
Guaranty Bancshares, Inc.
GNTY (NASDAQ)

Estimated Value

USD

Market Price 41.985 USD

+
* Values are not guaranteed, please do your own
research before making investment decisions.

#Two-Stage Excess Return Model

Used to estimate the value of companies based on two stages of growth. An initial period of high growth, represented by [Sum of discounted excess returns in Growth Stage], followed by a period of stable growth, represented by [Discounted excess return in terminal stage]. Excess Return models are better suited to calculate the intrinsic value of a financial company than an enterprise valuation model (such as the Discounted Free Cash Flow Model).

Read more: GitHub Documentation

Interactive Assumptions

Results

Estimated Value 22.57 Thou. USD
Book value of equity invested 28.52 USD
Sum of discounted excess returns in Growth Stage 185.8 USD
Terminal stage EPS 1.33 Thou. USD
Terminal stage Book Value 12.2 Thou. USD
Terminal stage Equity Cost 771.5 USD
Discounted excess return in terminal stage 22.35 Thou. USD
Excess Returns in the Terminal Stage 30.38 Thou. USD
Terminal Cost of Equity (the discount rate) 6.33%
Terminal year's excess return 560.5 USD
Average historical Return on Equity 10.92%
Average historical Payout Ratio 12,030%
Payout Ratio in stable stage 58.97%
Yield of the U.S. 10 Year Treasury Bond 4.48%

Historical and Forecasted Data

In USD

Edit Chart Values 2025 2026 2027 2028 2029

amounts of USD except for #

2024 LTM 2025 2026 2027 2028 2029
Beginning Book Value 26.1 27.8 27.8 -261.6 1778 -7439 11674
Ending Book Value 27.8 28.52 -261.6 1778 -7439 11674 12197
EPS 0.001 2.93 3.04 -28.57 194.2 -812.4 1274
Return on Equity 10.4% 10.51% 10.92% 10.92% 10.92% 10.92% 10.92%
Dividend per Share 0.96 0.97 292.5 -2068 9412 -19926 751.8
Payout Ratio 96,000% 33.11% 9,634% 7,240% 4,847% 2,453% 58.97%
Retained Earnings -0.959 1.96 -289.4 2040 -9217 19113 523.0
Equity Cost 1.65 1.76 1.76 -16.55 112.5 -470.5 738.4
Cost of Equity 6.33% 6.33% 6.33% 6.33% 6.33% 6.33% 6.33%
Excess Return -1.65 1.17 1.28 -12.02 81.72 -341.8 536.4
Discounted Excess Return
1.2 -10.63 67.98 -267.5 394.8

amounts of USD except for #

Average LTM 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015
Net Income 26.02 33.49 31.54 30.04 40.45 39.81 27.4 26.28 20.6 14.44 12.12 10.11
Total Stockholders Equity 255.5 325.2 318.5 303.3 295 302.2 272.6 261.6 244.6 207.3 141.9 137.7
Return on Equity 10.92% 10.51% 10.4% 10.18% 13.38% 14.6% 10.48% 10.74% 9.93% 10.17% 8.8% 10.92%
Dividends Paid to Common Shareholders 9.83 11.06 11 10.69 10.54 9.65 9.09 8.96 7.63
Payout Ratio 11,380% 33.11% 96,000% 35.52% 26.04% 24.24% 33.07% 34.15% 37.04% 9,634% 9,634% 9,634%
Shares Outstanding 11.55 11.4 11.46 11.62 11.98 12.07 12.22 12.8 12.72 11.25 9.87 9.68
Earnings per Share 1.97 2.93 0.001 2.59 3.38 3.3 2.25 2.05 1.62 1.28 1.23 1.04
Dividend per Share 0.822 0.97 0.96 0.92 0.88 0.8 0.744 0.7 0.6
Dividend Growth Rate 7.2% 1.04% 4.35% 4.54% 10% 7.53% 6.29% 16.67%
Book Value 21.92 28.52 27.8 26.1 24.62 25.05 22.31 20.43 19.23 18.42 14.39 14.24
discounting cash flows home logo

Discounting Cash Flows

Are you finding our services helpful? Review us on trustpilot logo Trustpilot
Have a question? Contact us