Caterpillar Inc. (CAT) Simple Excess Return Model - Discounting Cash Flows
CAT
Caterpillar Inc.
CAT (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 204.5 USD
Book value of equity invested 38.04 USD
Next year's estimated book value 41.79 USD
Present value of future excess returns 166.4 USD
Excess Return per share 9.85 USD
Cost of Equity (the discount rate) 10.27%
Average historical Return on Equity 34.87%
Average historical Payout Ratio -199.6%
Payout Ratio used 87.53%
Risk Free Rate of the 10 Year U.S. Treasury Note 4.35%

Historical and Forecasted Data

Monetary values are in USD

amounts of USD except for #

2024 LTM 2025 2026 2027 2028 2029
Beginning Book Value 38.18 40.05 40.05 41.79 43.61 45.5 47.48
Ending Book Value 40.05 38.04 41.79 43.61 45.5 47.48 49.55
EPS 22.17 20.57 13.96 14.57 15.21 15.87 16.56
Return on Equity 55.36% 50.99% 34.87% 34.87% 34.87% 34.87% 34.87%
Dividend per Share 5.42 5.74 12.22 12.75 13.31 13.89 14.49
Retained Earnings 16.75 14.83 1.74 1.82 1.9 1.98 2.07
Equity Cost per Share 3.92 4.11 4.11 4.29 4.48 4.67 4.88
Cost of Equity 10.27% 10.27% 10.27% 10.27% 10.27% 10.27% 10.27%
Excess Return 18.25 16.46 9.85 10.28 10.73 11.19 11.68

amounts of USD except for #

Average LTM 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015
Net Income 5,700 9,939 10,792 10,335 6,705 6,489 2,998 6,093 6,147 754 -67 2,512
Total Equity 15,910 18,067 19,491 19,494 15,869 16,484 15,331 14,588 14,039 13,697 13,137 14,809
Return on Equity 34.87% 50.99% 55.36% 65.13% 40.68% 42.33% 20.55% 43.4% 44.88% 5.74% -0.452% 15%
Dividends Paid to Common Shareholders 2,215 2,726 2,638 2,553 2,434 2,328 2,242 2,123 1,940 1,835 1,800 1,747
Payout Ratio -199.6% 27.9% 24.45% 24.7% 36.29% 35.88% 74.77% 34.84% 31.57% 244.1% -2,800% 69.5%
Shares Outstanding 546.4 474.9 486.7 510.6 526.9 544 544.1 561.6 591.4 591.8 584.3 594.3
EPS 10.89 20.57 22.17 20.24 12.73 11.93 5.51 10.85 10.39 1.27 -0.11 4.23
Dividend per Share 4.12 5.74 5.42 5.0 4.62 4.28 4.12 3.78 3.28 3.1 3.08 2.94
Book Value 29.56 38.04 40.05 38.18 30.12 30.3 28.18 25.98 23.74 23.14 22.48 24.92
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