AT&T Inc. (T) Simple Excess Return Model - Discounting Cash Flows
T
AT&T Inc.
T (NYSE)

Estimated Value

USD

Market Price USD

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

Simple Excess Return Model

Used to estimate the value of companies that have reached maturity and earn stable excess returns with little to no high growth chance. 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).

See our GitHub Documentation

Interactive Assumptions

Discount Rate

Discount Rate

Discount Rate = Cost of Equity = Risk Free Rate + Beta * Market Premium

The cost of equity is the theoretical rate of return that an equity investment should generate. It is calculated using the CAPM formula.

Read More

↳ Beta

Beta

Beta is a value that measures the price fluctuations (volatility) of a stock with respect to fluctuations in the overall stock market.

↳ Risk Free Rate

Risk-Free Rate

The risk-free rate represents the interest an investor would expect from an absolutely risk-free investment over a specified period of time. By default, it is equal to the current yield of the U.S. 10 Year Treasury Bond.

↳ Market Premium

Market Premium

Market risk premium represents the excess returns over the risk-free rate that investors expect for taking on the incremental risks connected to the equities market.

Return On Equity

Return on Equity

Return On Equity (ROE) is used to estimate the Earnings Per Share (EPS) expressed as a percentage of Book Value.

Growth In Perpetuity

Growth in Perpetuity

The rate at which the company's free cash flow is assumed to grow in perpetuity. By default, this is equal to the yield of the U.S. 10 Year Treasury Bond.

Historical Years

Historical Years

The number of historical years used to calculate averages for historical data.

Results

Estimated Value 32.6 USD
Book value of equity invested 15.42 USD
Next year's estimated book value 15.8 USD
Present value of future excess returns 17.18 USD
Excess Return per share 0.731 USD
Cost of Equity (the discount rate) 6.75%
Average historical Return on Equity 11.49%
Average historical Payout Ratio 18.23%
Payout Ratio used 78.24%
Risk Free Rate of the 10 Year U.S. Treasury Note 4.04%

Historical and Forecasted Data

Monetary values in USD

Monetary values in USD

amounts except #

2025
Dec 31
LTM
Feb 14
2026
Dec 31
2027
Dec 31
2028
Dec 31
2029
Dec 31
2030
Dec 31
Beginning Book Value 14.5 15.42 15.42 15.8 16.2 16.6 17.02
Ending Book Value 15.42 15.42 15.8 16.2 16.6 17.02 17.44
EPS 3.04 3.06 1.77 1.82 1.86 1.91 1.96
Return on Equity 20.97% 19.8% 11.49% 11.49% 11.49% 11.49% 11.49%
Dividend per Share 1.11 1.11 1.39 1.42 1.46 1.49 1.53
Retained Earnings 1.93 1.95 0.385 0.395 0.405 0.415 0.425
Equity Cost per Share 0.979 1.04 1.04 1.07 1.09 1.12 1.15
Cost of Equity 6.75% 6.75% 6.75% 6.75% 6.75% 6.75% 6.75%
Excess Return 2.06 2.02 0.731 0.749 0.767 0.787 0.806

Monetary values in USD

amounts except #

Average LTM
Feb 14
2025
Dec 31
2024
Dec 31
2023
Dec 31
2022
Dec 31
2021
Dec 31
2020
Dec 31
2019
Dec 31
2018
Dec 31
2017
Dec 31
2016
Dec 31
Net Income 13,746 21,889 21,889 10,948 14,400 -8,524 20,081 -5,176 13,903 19,370 29,450 12,976
Total Equity 135,141 110,533 110,533 104,372 103,297 97,500 166,332 161,673 184,221 184,089 140,861 123,135
Return on Equity 11.49% 19.8% 20.97% 10.6% 14.77% -5.12% 12.42% -2.81% 7.55% 13.75% 23.92% 10.58%
Dividends Paid to Common Shareholders 11,251 7,958 7,958 7,991 7,971 9,674 14,909 14,887 14,931 13,556 12,081 11,843
Payout Ratio 18.23% 36.27% 36.51% 74.5% 56.35% -110.7% 75.09% -277.3% 107.4% 69.93% 41.09% 91.43%
Shares Outstanding 6,967 7,169 7,169 7,199 7,181 7,166 7,168 7,157 7,319 6,778 6,164 6,168
EPS 2.0 3.06 3.04 1.49 1.97 -1.22 2.77 -0.75 1.9 2.86 4.77 2.1
Dividend per Share 1.62 1.11 1.11 1.11 1.11 1.35 2.08 2.08 2.04 2.0 1.96 1.92
Book Value 19.48 15.42 15.42 14.5 14.38 13.61 23.2 22.59 25.17 27.16 22.85 19.96
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
Want to become our sponsor?
Check out our Affiliate Program