Brookfield Infrastructure Partners L.P. (BIP-PB) Two-Stage Excess Return Model - Discounting Cash Flows
Brookfield Infrastructure Partners L.P.
BIP-PB (NYSE)

Estimated Value

USD

Market Price 16.19 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 -8.33 USD
Book value of equity invested
Sum of discounted excess returns in Growth Stage -1.87 USD
Terminal stage EPS 0.424 USD
Terminal stage Book Value 9.71 USD
Terminal stage Equity Cost 0.876 USD
Discounted excess return in terminal stage -6.46 USD
Excess Returns in the Terminal Stage -9.95 USD
Terminal Cost of Equity (the discount rate) 9.01%
Terminal year's excess return -0.451 USD
Average historical Return on Equity 4.37%
Average historical Payout Ratio 495.6%
Payout Ratio in stable stage -2.54%
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 13.58 12.18 12.18 10.6 9.69 9.28 9.3
Ending Book Value 12.18 0.0 10.6 9.69 9.28 9.3 9.71
EPS 0.12 0.378 0.532 0.463 0.424 0.406 0.406
Return on Equity 0.914% 1.9% 4.37% 4.37% 4.37% 4.37% 4.37%
Dividend per Share 1.25 1.25 2.11 1.37 0.833 0.394 -0.01
Payout Ratio 1,042% 331% 396% 296.4% 196.7% 97.09% -2.54%
Retained Earnings -1.13 -0.872 -1.57 -0.91 -0.41 0.012 0.416
Equity Cost 1.22 1.1 1.1 0.956 0.874 0.837 0.838
Cost of Equity 9.01% 9.01% 9.01% 9.01% 9.01% 9.01% 9.01%
Excess Return -1.1 -0.72 -0.566 -0.493 -0.45 -0.431 -0.432
Discounted Excess Return
-0.519 -0.414 -0.348 -0.305 -0.28

amounts of USD except for #

Average LTM 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015
Net Income 656.7 107 57 367 1,375 2,719 904 650 329 124 360 232
Total Stockholders Equity 14,481 0 5,622 6,239 25,554 26,391 21,673 22,177 14,668 13,474 4,986 4,027
Return on Equity 4.37% 1.9% 0.914% 1.44% 5.21% 12.55% 4.08% 4.43% 2.44% 2.49% 8.94% 3.67%
Dividends Paid to Common Shareholders 575.2 577 577 574.2 572.6
Payout Ratio 432.3% 331% 1,042% 568.2% 41.67% 396% 396% 396% 396% 396% 396% 396%
Shares Outstanding 426.7 461.6 461.6 459.4 458.1 445.1 442.1 428.4 415.4 396.9 367.1 358.4
Earnings per Share 1.4 0.378 0.12 0.22 3 6.11 2.05 1.52 0.79 -0.027 0.75 0.46
Dividend per Share 1.25 1.25 1.25 1.25 1.25
Dividend Growth Rate
0% 0% 0%
Book Value 33.57 0.0 12.18 13.58 55.78 59.3 49.03 51.77 35.31 33.95 13.58 11.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