Intel Corporation (INTC) Two-Stage Excess Return Model - Discounting Cash Flows
INTC
Intel Corporation
INTC (NASDAQ)

Estimated Value

USD

Market Price 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

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.

High Growth Years

High Growth Years

The estimated number of years during which the company is expected to experience high growth. After this period, the company will transition to a stable growth phase.

Stable Return On Equity

Stable Return on Equity

The stable Return On Equity (ROE) estimated after the last projected period.

Stable Growth In Perpetuity

Stable Growth in Perpetuity

The stable rate at which the company's book value is assumed to grow in perpetuity after the last projected period.

Historical Years

Historical Years

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

Results

Estimated Value 27.15 USD
Book value of equity invested 23.57 USD
Sum of discounted excess returns in Growth Stage 1.75 USD
Terminal stage EPS 0.843 USD
Terminal stage Book Value 6 USD
Terminal stage Equity Cost 0.613 USD
Discounted excess return in terminal stage 1.84 USD
Excess Returns in the Terminal Stage 2.99 USD
Terminal Cost of Equity (the discount rate) 10.21%
Terminal year's excess return 0.23 USD
Average historical Return on Equity 14.05%
Average historical Payout Ratio 513.8%
Payout Ratio in stable stage 82.21%
Yield of the U.S. 10 Year Treasury Bond 4.17%

Historical and Forecasted Data

Monetary values in USD

Edit Chart Values 2025-12-28 2026-12-28 2027-12-28 2028-12-28 2029-12-28

Monetary values in USD

amounts except #

2024
Dec 28
LTM
Jan 16
2025
Dec 28
2026
Dec 28
2027
Dec 28
2028
Dec 28
2029
Dec 28
Beginning Book Value 25.2 23.19 23.19 12.52 8.28 6.48 5.86
Ending Book Value 23.19 23.57 12.52 8.28 6.48 5.86 6.0
EPS -4.38 0.011 3.26 1.76 1.16 0.91 0.823
Return on Equity -17.76% 0.199% 14.05% 14.05% 14.05% 14.05% 14.05%
Dividend per Share
0.5 13.93 6.0 2.96 1.53 0.676
Payout Ratio 427.4% 4,630% 427.4% 341.1% 254.8% 168.5% 82.21%
Retained Earnings
-0.489 -10.67 -4.24 -1.8 -0.624 0.146
Equity Cost 2.57 2.37 2.37 1.28 0.845 0.662 0.598
Cost of Equity 10.21% 10.21% 10.21% 10.21% 10.21% 10.21% 10.21%
Excess Return -6.95 -2.36 0.891 0.481 0.318 0.249 0.225
Discounted Excess Return
0.808 0.396 0.238 0.169 0.138

Monetary values in USD

amounts except #

Average LTM
Jan 16
2024
Dec 28
2023
Dec 31
2022
Dec 31
2021
Dec 31
2020
Dec 31
2019
Dec 31
2018
Dec 31
2017
Dec 31
2016
Dec 31
2015
Dec 31
Net Income 9,577 198 -18,756 1,689 8,014 19,868 20,899 21,048 21,053 9,601 10,316 11,420
Total Stockholders Equity 85,226 106,376 99,270 105,590 101,423 95,391 81,038 77,504 74,563 69,019 66,226 61,085
Return on Equity 14.05% 0.199% -17.76% 1.67% 8.4% 24.52% 26.97% 28.23% 30.5% 14.5% 16.89% 20.44%
Dividends Paid to Common Shareholders 4,819 2,257
3,101 5,998 5,642 5,543 5,565 5,533 5,077 4,919 4,552
Payout Ratio 505.9% 4,630% 427.4% 185% 74.87% 28.43% 26.51% 26.42% 26.26% 52.94% 47.71% 39.83%
Shares Outstanding 4,414 4,514 4,280 4,190 4,108 4,059 4,199 4,417 4,611 4,701 4,730 4,742
Earnings per Share 2.17 0.011 -4.38 0.4 1.95 4.89 4.98 4.77 4.57 2.04 2.18 2.41
Dividend per Share 1.1 0.5
0.74 1.46 1.39 1.32 1.26 1.2 1.08 1.04 0.96
Dividend Growth Rate 0.082%
-49.32% 5.04% 5.3% 4.76% 5% 11.11% 3.85% 8.33% 6.67%
Book Value 19.52 23.57 23.19 25.2 24.69 23.5 19.3 17.55 16.17 14.68 14.0 12.88
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