Inspire Medical Systems, Inc. (INSP) Two-Stage Excess Return Model - Discounting Cash Flows
Inspire Medical Systems, Inc.
INSP (NYSE)

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

Results

Estimated Value -39.35 Thou. USD
Book value of equity invested 21.4 USD
Sum of discounted excess returns in Growth Stage -3.61 Thou. USD
Terminal stage EPS -2.98 Thou. USD
Terminal stage Book Value 2.07 Thou. USD
Terminal stage Equity Cost 203.5 USD
Discounted excess return in terminal stage -35.76 Thou. USD
Excess Returns in the Terminal Stage -57.09 Thou. USD
Terminal Cost of Equity (the discount rate) 9.81%
Terminal year's excess return -3.18 Thou. USD
Average historical Return on Equity -143.4%
Average historical Payout Ratio 403.6%
Payout Ratio in stable stage 103%
Yield of the U.S. 10 Year Treasury Bond 4.24%

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 19.54 23.17 23.17 104.1 377.7 1044 1990
Ending Book Value 23.17 21.4 104.1 377.7 1044 1990 2074
EPS 1.8 2.23 -33.23 -149.2 -541.6 -1498 -2854
Return on Equity 9.35% 9.64% -143.4% -143.4% -143.4% -143.4% -143.4%
Dividend per Share
9 -114.1 -422.9 -1208 -2443 -2938
Payout Ratio 343.5% 403.6% 343.5% 283.3% 223.2% 163.1% 103%
Retained Earnings
-6.77 80.9 273.6 667.3 945.3 84.39
Equity Cost 1.92 2.27 2.27 10.21 37.04 102.5 195.2
Cost of Equity 9.81% 9.81% 9.81% 9.81% 9.81% 9.81% 9.81%
Excess Return -0.116 -0.043 -35.5 -159.4 -578.6 -1601 -3049
Discounted Excess Return
-32.33 -132.2 -437.0 -1101 -1909

amounts of USD except for #

Average LTM 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015
Net Income -14.34 66.51 53.51 -21.15 -44.88 -42.04 -57.2 -33.24 -21.83 -17.51 -18.53 -21.34
Total Stockholders Equity 315.1 635.7 689.7 572.5 496 229 229.7 139.8 164 1.48 -6.61 0
Return on Equity -143.4% 9.64% 9.35% -4.26% -19.59% -18.3% -40.91% -20.27% -1,471% 265% -143.4% -143.4%
Dividends Paid to Common Shareholders 267.3 267.3
Payout Ratio 349% 403.6% 343.5% 343.5% 343.5% 343.5% 343.5% 343.5% 343.5% 343.5% 343.5% 343.5%
Shares Outstanding 22.45 29.7 29.76 29.3 28.07 27.26 26.07 23.8 14.58 13.49 12.46 12.46
Earnings per Share -0.856 2.23 1.8 -0.72 -1.6 -1.54 -2.19 -1.4 -1.5 -1.3 -1.49 -1.71
Dividend per Share 9.0 9
Dividend Growth Rate
Book Value 11.57 21.4 23.17 19.54 17.67 8.4 8.81 5.87 11.25 0.11 -0.53 0.0
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