Telenet Group Holding N.V. (TNET.BR) Nathan Winklepleck, CFA's Nathan's Discounted Free Cash Flow - Discounting Cash Flows
TNET.BR
Telenet Group Holding N.V.
TNET.BR (BRU)

Estimated Value

EUR

Market Price EUR

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

Nathan's Discounted Free Cash Flow Model

The Discounted Free Cash Flow (DCF) model calculates the value of a company by estimating its future Free Cash Flows to the Firm (FCFF) and discounting them to their present value. The value of a share is then derived by adjusting for net debt and dividing by the number of shares outstanding.

Check out Nathan's YouTube Channel

Interactive Assumptions

Discount Rate

Discount Rate

Discount Rate = 10 Year Treasury Note Yield + 4%

Growth In Perpetuity

Growth in Perpetuity

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

Historical Years

Historical Years

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

Projection Years

Projection Years

The number of years into the future for which the analysis projects financial performance and metrics.

Revenue Growth Rate

Revenue Growth Rate

The annual growth rate applied to projected revenue, starting from the second projection year onward.

Operating Cash Flow Margin

Operating Cash Flow Margin

Projected Operating Cash Flow = Projected Revenue * Operating Cash Flow Margin

This margin represents the percentage of revenue used to estimate future Operating Cash Flow.

Capital Expenditure Margin

Capital Expenditure Margin

Projected Free Cash Flow = Projected Operating Cash Flow - Projected Revenue * Capital Expenditure Margin

This margin is used to estimate future capital expenditures as a percentage of revenue, which in turn is subtracted from Operating Cash Flow to calculate Free Cash Flow.

Results

Terminal Value 21.01 Bil. EUR
Discounted Terminal Value 9.69 Bil. EUR
Sum of Discounted Free Cash Flow 5.35 Bil. EUR
Enterprise Value 15.04 Bil. EUR
Cash and Equivalents 1.02 Bil. EUR
Total Debt 6.58 Bil. EUR
Equity Value 9.48 Bil. EUR
Shares Outstanding 108.6 Mil. EUR
Estimated Value per Share 87.3 EUR
Yield of the U.S. 10 Year Treasury Note 4.05%
Average Cash from Operating Activities Margin 37.67%
Average Capital Expenditure Margin -19.28%

Monetary values in EUR

Edit Chart Values 2023-12-31 2024-12-31 2025-12-31 2026-12-31 2027-12-31 2028-12-31 2029-12-31 2030-12-31 2031-12-31 2032-12-31

Monetary values in EUR

amounts except #

2023
Dec 31
2024
Dec 31
2025
Dec 31
2026
Dec 31
2027
Dec 31
2028
Dec 31
2029
Dec 31
2030
Dec 31
2031
Dec 31
2032
Dec 31
Revenue 2,830 2,999 3,171 3,345 3,520 3,697 3,873 4,048 4,222 4,393
Revenue Growth Rate 6.2% 5.96% 5.73% 5.49% 5.25% 5.01% 4.77% 4.53% 4.29% 4.05%
Operating Cash Flow 1,066 1,130 1,194 1,260 1,326 1,393 1,459 1,525 1,590 1,655
Operating Cash Flow Margin 37.67% 37.67% 37.67% 37.67% 37.67% 37.67% 37.67% 37.67% 37.67% 37.67%
Capital Expenditure -545.7 -578.2 -611.3 -644.9 -678.7 -712.7 -746.7 -780.5 -814 -846.9
Capital Expenditure Margin -19.28% -19.28% -19.28% -19.28% -19.28% -19.28% -19.28% -19.28% -19.28% -19.28%
Free Cash Flow 520.5 551.5 583.1 615.1 647.4 679.8 712.2 744.5 776.4 807.8
Free Cash Flow Margin 18.39% 18.39% 18.39% 18.39% 18.39% 18.39% 18.39% 18.39% 18.39% 18.39%
Compounded Discount Rate 0% 0% 0% 6.64% 15.22% 24.52% 34.55% 45.38% 57.08% 69.76%
Discounted Free Cash Flow 520.5 551.5 583.1 576.8 561.9 545.9 529.3 512.1 494.3 475.9

Monetary values in EUR

amounts except #

Average LTM
Mar 03
2022
Dec 31
2021
Dec 31
2020
Dec 31
2019
Dec 31
2018
Dec 31
2017
Dec 31
2016
Dec 31
2015
Dec 31
2014
Dec 31
2013
Dec 31
Revenue 2,350 2,780 2,665 2,596 2,575 2,584 2,535 2,528 2,429 1,808 1,707 1,641
Revenue Growth Rate 6.2% 4.33% 2.67% 0.8% -0.337% 1.94% 0.267% 4.07% 34.33% 5.93% 4.01% 10.24%
Cost of Revenue 1,292 1,466 1,350 1,283 1,402 1,353 1,401 1,592 1,450 984.5 934.8 994.8
Gross Profit 1,058 1,315 1,315 1,313 1,174 1,231 1,134 935.6 979.2 823.9 772.3 646.5
Gross Margin 44.79% 47.29% 49.36% 50.59% 45.57% 47.63% 44.75% 37.01% 40.31% 45.56% 45.24% 39.39%
Operating Income 536.9 414.9 575.5 397.8 833.2 685.5 599.5 449.6 485.4 543.1 532.2 389.2
Operating Margin 23.37% 14.92% 21.59% 15.32% 32.35% 26.53% 23.65% 17.78% 19.98% 30.03% 31.18% 23.71%
Net Income 269.6 192.2 997.6 394 338.9 234.5 253.4 112.2 41.81 175.6 109.3 116.4
Net Margin 11.01% 6.91% 37.43% 15.18% 13.16% 9.07% 10% 4.44% 1.72% 9.71% 6.4% 7.09%
Cash from Operating Activities 891.9 1,054 1,093 1,030 1,057 1,092 1,076 831.6 749.1 665.5 571.6 590.5
Cash from Operating Activities Margin 37.67% 37.93% 41% 39.66% 41.06% 42.28% 42.43% 32.9% 30.84% 36.8% 33.48% 35.98%
Capital Expenditure -447.9 -561.6 -521.1 -479.1 -471.8 -411.9 -403.7 -485.2 -483.9 -382.7 -333.1 -392.8
Free Cash Flow 444 492.9 571.5 550.5 585.6 680.6 671.9 346.5 265.2 282.8 238.5 197.7
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