Component: (Network and Table) | |
---|---|
Network |
01-Heading
(http://www.example.com/Heading)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Heading [Hypercube] | Period [Axis] |
---|---|
2018-12-31
|
|
Heading [Hypercube]
|
|
Heading [Hierarchy]
|
|
Valuation Date
|
|
Share Price on Valuation Date
|
|
Diluted Shares Outstanding
|
|
Component: (Network and Table) | |
---|---|
Network |
02-Selected Operating Data
(http://www.example.com/SelectedOperatingData)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Selected Operating Data [Hypercube] | Period [Axis] | |||||||
---|---|---|---|---|---|---|---|---|
2023-01-01 - 2023-12-31
|
2022-01-01 - 2022-12-31
|
2021-01-01 - 2021-12-31
|
2020-01-01 - 2020-12-31
|
2019-01-01 - 2019-12-31
|
2018-01-01 - 2018-12-31
|
2017-01-01 - 2017-12-31
|
2016-01-01 - 2016-12-31
|
|
Selected Operating Data [Hypercube]
|
|
|
|
|
|
|
|
|
Selected Operating Data [Hierarchy]
|
|
|
|
|
|
|
|
|
Revenue
|
|
|
|
|
|
|
|
|
EBITDA
|
|
|
|
|
|
|
|
|
EBIT
|
|
|
|
|
|
|
|
|
Depreciation and Amortization
|
|
|
|
|
|
|
|
|
Growth Rates, Selected Operating Data [Hierarchy]
|
|
|
|
|
|
|
|
|
Revenue Growth Rate (%)
|
|
|
|
|
|
|||
EBITDA Margin (%)
|
|
|
|
|
|
|||
EBIT Margin (%)
|
|
|
|
|
|
|||
Depreciation and Amortization as Percent of Revenue
|
|
|
|
|
|
Component: (Network and Table) | |
---|---|
Network |
03-Selected Balance Sheet and Other Data
(http://www.example.com/SelectedBalanceSheetAndOtherData)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Selected Balance Sheet and Other Data [Hypercube] | Period [Axis] | |||||||
---|---|---|---|---|---|---|---|---|
2023-01-01 - 2023-12-31
|
2022-01-01 - 2022-12-31
|
2021-01-01 - 2021-12-31
|
2020-01-01 - 2020-12-31
|
2019-01-01 - 2019-12-31
|
2018-12-31
|
2017-12-31
|
2016-12-31
|
|
Selected Balance Sheet and Other Data [Hypercube]
|
|
|
|
|
|
|
|
|
Selected Balance Sheet and Other Data [Hierarchy]
|
|
|
|
|
|
|
|
|
Cash
|
|
|
|
|
|
|
|
|
Accounts Receivable
|
|
|
|
|
|
|
|
|
Inventories
|
|
|
|
|
|
|
|
|
Prepaid Expenses
|
|
|
|
|
|
|
|
|
Accounts Payable
|
|
|
|
|
|
|
|
|
Accrued Expenses
|
|
|
|
|
|
|
|
|
Debt
|
|
|
|
|
|
|
|
|
Property, Plant, and Equipment, Gross
|
|
|
|
|
|
|
|
|
Growth Rates [Hierarchy]
|
|
|
|
|
|
|
|
|
Accounts Receivable Growth (%)
|
|
|
|
|
|
|||
Inventories Growth (%)
|
|
|
|
|
|
|||
Prepaid Expenses Growth (%)
|
|
|
|
|
|
|||
Accounts Payable Growth (%)
|
|
|
|
|
|
|||
Accrued Expenses Growth (%)
|
|
|
|
|
|
|||
Capital Expenditures Growth (%)
|
|
|
|
|
|
Component: (Network and Table) | |
---|---|
Network |
04-Free Cash Flow Buildup
(http://www.example.com/FreeCashFlowBuildup)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Free Cash Flow Buildup [Hypercube] | Period [Axis] | |||||||
---|---|---|---|---|---|---|---|---|
2023-01-01 - 2023-12-31
|
2022-01-01 - 2022-12-31
|
2021-01-01 - 2021-12-31
|
2020-01-01 - 2020-12-31
|
2019-01-01 - 2019-12-31
|
2018-01-01 - 2018-12-31
|
2017-01-01 - 2017-12-31
|
2016-01-01 - 2016-12-31
|
|
Free Cash Flow Buildup [Hypercube]
|
|
|
|
|
|
|
|
|
Free Cash Flow Buildup [Hierarchy]
|
|
|
|
|
|
|
|
|
Total Revenues
|
177,735,883,600
|
161,578,076,000
|
146,889,160,000
|
133,535,600,000
|
121,396,000,000
|
110,360,000,000
|
89,950,000,000
|
85,320,000,000
|
EBITDA
|
71,094,353,440
|
64,631,230,400
|
58,755,664,000
|
53,414,240,000
|
48,558,400,000
|
49,468,000,000
|
34,149,000,000
|
27,616,000,000
|
EBIT
|
53,320,765,080
|
48,473,422,800
|
44,066,748,000
|
40,060,680,000
|
36,418,800,000
|
46,735,000,000
|
31,927,000,000
|
26,373,000,000
|
Tax Rate
|
|
|
|
|
|
|
||
EBIAT
|
|
|
|
|
|
|||
Unlevered Free Cash Flows [Roll Up]
|
|
|
|
|
|
|
|
|
EBIAT
|
41,590,196,762
|
37,809,269,784
|
34,372,063,440
|
31,247,330,400
|
28,406,664,000
|
|||
Depreciation and Amortization
|
14,218,870,688
|
12,926,246,080
|
11,751,132,800
|
10,682,848,000
|
9,711,680,000
|
10,261,000,000
|
8,778,000,000
|
6,622,000,000
|
Accounts Receivable Increase (Decrease)
|
(
|
(
|
(
|
(
|
(
|
|||
Inventories Increase (Decrease)
|
(
|
(
|
(
|
(
|
(
|
|||
Prepaid Expenses Increase (Decrease)
|
(
|
(
|
(
|
(
|
(
|
|||
Accounts Payable Increase (Decrease)
|
|
|
|
|
|
|||
Accrued Expenses Increase (Decrease)
|
|
|
|
|
|
|||
Capital Expenditures
|
(
|
(
|
(
|
(
|
(
|
|||
Unlevered Free Cash Flows
|
|
|
|
|
|
|
|
|
Present Value of Free Cash Flows [Hierarchy]
|
|
|
|
|
|
|
|
|
Unlevered Free Cash Flows
|
42,125,189,009
|
38,487,253,978
|
35,442,596,170
|
32,590,403,400
|
30,021,364,000
|
|
|
|
Discount Rate (WACC)
|
|
|
|
|
|
|
||
Present Value of Free Cash Flows
|
|
|
|
|
|
|
||
Sum of Present Values of FCFs
|
|
Component: (Network and Table) | |
---|---|
Network |
05-Terminal Value
(http://www.example.com/TerminalValue)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Terminal Value [Hypercube] | Period [Axis] | |||||
---|---|---|---|---|---|---|
2023-01-01 - 2023-12-31
|
2022-01-01 - 2022-12-31
|
2021-01-01 - 2021-12-31
|
2020-01-01 - 2020-12-31
|
2019-01-01 - 2019-12-31
|
2018-01-01 - 2018-12-31
|
|
Terminal Value [Hypercube]
|
|
|
|
|
|
|
Terminal Value [Hierarchy]
|
|
|
|
|
|
|
Long Term Growth Rate
|
|
|||||
WACC
|
12.30%
|
12.30%
|
12.30%
|
12.30%
|
12.30%
|
12.30%
|
Free Cash Flow
|
|
|||||
Terminal Value
|
|
|||||
Present Value of Terminal Value
|
|
Component: (Network and Table) | |
---|---|
Network |
06-Weighted Average Cost of Capital (WACC)
(http://www.example.com/WACC)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Weighted Average Cost of Capital [Hypercube] | Period [Axis] | |||||||
---|---|---|---|---|---|---|---|---|
2023-01-01 - 2023-12-31
|
2022-01-01 - 2022-12-31
|
2021-01-01 - 2021-12-31
|
2020-01-01 - 2020-12-31
|
2019-01-01 - 2019-12-31
|
2018-01-01 - 2018-12-31
|
2017-12-31
|
2016-12-31
|
|
Weighted Average Cost of Capital [Hypercube]
|
|
|
|
|
|
|
|
|
Weighted Average Cost of Capital Components [Hierarchy]
|
|
|
|
|
|
|
|
|
Share Price
|
|
|||||||
Diluted Shares Outstanding
|
7,794,000,000
|
|||||||
Cost of Debt
|
|
|||||||
Tax Rate
|
22.00%
|
22.00%
|
22.00%
|
22.00%
|
22.00%
|
22.00%
|
||
After-tax Cost of Debt
|
|
|||||||
Cost of Equity
|
|
|||||||
Total Capital [Roll Up]
|
|
|
|
|
|
|
|
|
Total Debt
|
76,898,000,000
|
76,898,000,000
|
76,898,000,000
|
76,898,000,000
|
76,898,000,000
|
76,898,000,000
|
77,837,000,000
|
40,949,000,000
|
Total Equity
|
|
|||||||
Total Capital
|
|
|
|
|
|
|
|
|
Weightings [Hierarchy]
|
|
|
|
|
|
|
|
|
Debt Weighting
|
|
|||||||
Equity Weighting
|
|
|||||||
Resulting WACC [Hierarchy]
|
|
|
|
|
|
|
|
|
WACC
|
12.30%
|
12.30%
|
12.30%
|
12.30%
|
12.30%
|
12.30%
|
Component: (Network and Table) | |
---|---|
Network |
07-Enterprise Value to Equity Value
(http://www.example.com/EnterpriseValueToEquityValue)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Enterprise Value to Equity Value [Hypercube] | Period [Axis] |
---|---|
2018-12-31
|
|
Enterprise Value to Equity Value [Hypercube]
|
|
Equity Value [Roll Up]
|
|
Enterprise Value
|
|
Less: Net Debt
|
|
Equity Value
|
|
Equity Value per Share [Hierarchy]
|
|
Equity Value
|
1,200,596,676,932
|
Diluted Shares Outstanding
|
7,794,000,000
|
Equity Value per Share
|
|
Component: (Network and Table) | |
---|---|
Network |
08-Conclusion
(http://www.example.com/Conclusion)
|
Table | (Implied) |
Reporting Entity [Axis] | 0000789019 (http://www.sec.gov/CIK) |
Conclusion [Hypercube] | Period [Axis] |
---|---|
2018-12-31
|
|
Conclusion [Hypercube]
|
|
Valuation Gap [Roll Up]
|
|
Equity Value per Share
|
154.04
|
Share Price on Valuation Date
|
112.33
|
Valuation Gap per Share
|
|