Paying users zone. Data is covered by 
.
Get 1 month access to Comcast Corp. for $19.99, or
get full access to entire website for at least 3 months from $49.99.
We accept:
Comcast Corp. (CMCSA)
Analysis of Operating Leases
Difficulty: Advanced
An operating lease is treated like a rental contract. Neither the leased asset nor the associated liability is reported on the lessee balance sheet, but the rights may be very similar to the rights of an owner. The lessee only records the lease payments as a rental expense in income statement.
Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)
Comcast Corp., future operating lease payments (before adoption of FASB Topic 842)
US$ in millions
| Dec 31, 2018 | Dec 31, 2017 | Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | ||
|---|---|---|---|---|---|---|
| Total undiscounted future operating lease payments | |
|
|
|
|
|
| Discount rate1 | |
|
|
|
|
|
| Total present value of future operating lease payments | |
|
|
|
|
|
Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).
1 Weighted-average interest rate for Comcast Corp.’s debt
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2019 | |
2019 | |
|
| 2020 | |
2020 | |
|
| 2021 | |
2021 | |
|
| 2022 | |
2022 | |
|
| 2023 | |
2023 | |
|
| 2024 and thereafter | |
2024 | |
|
| 2025 | |
|
||
| 2026 | |
|
||
| 2027 | |
|
||
| 2028 | |
|
||
| 2029 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2019-01-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2018 | |
2018 | |
|
| 2019 | |
2019 | |
|
| 2020 | |
2020 | |
|
| 2021 | |
2021 | |
|
| 2022 | |
2022 | |
|
| 2023 and thereafter | |
2023 | |
|
| 2024 | |
|
||
| 2025 | |
|
||
| 2026 | |
|
||
| 2027 | |
|
||
| 2028 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2018-01-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2017 | |
2017 | |
|
| 2018 | |
2018 | |
|
| 2019 | |
2019 | |
|
| 2020 | |
2020 | |
|
| 2021 | |
2021 | |
|
| 2022 and thereafter | |
2022 | |
|
| 2023 | |
|
||
| 2024 | |
|
||
| 2025 | |
|
||
| 2026 | |
|
||
| 2027 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2017-02-03).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2016 | |
2016 | |
|
| 2017 | |
2017 | |
|
| 2018 | |
2018 | |
|
| 2019 | |
2019 | |
|
| 2020 | |
2020 | |
|
| 2021 and thereafter | |
2021 | |
|
| 2022 | |
|
||
| 2023 | |
|
||
| 2024 | |
|
||
| 2025 | |
|
||
| 2026 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2016-02-05).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2015 | |
2015 | |
|
| 2016 | |
2016 | |
|
| 2017 | |
2017 | |
|
| 2018 | |
2018 | |
|
| 2019 | |
2019 | |
|
| 2020 and thereafter | |
2020 | |
|
| 2021 | |
|
||
| 2022 | |
|
||
| 2023 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2015-02-27).
Analyst Adjustments for Operating Leases
Comcast Corp., adjustments to financial data
US$ in millions
Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).
1, 2 Equal to total present value of future operating lease payments.
Comcast Corp., Financial Data: Reported vs. Adjusted
Adjusted Ratios for Operating Leases (Summary)
Comcast Corp., adjusted ratios
Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).
| Ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Comcast Corp.’s adjusted total asset turnover improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
| Adjusted debt-to-equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Comcast Corp.’s adjusted debt-to-equity improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Comcast Corp.’s adjusted ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Comcast Corp., Ratios: Reported vs. Adjusted
Adjusted Total Asset Turnover
Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).
2018 Calculations
1 Total asset turnover = Revenue ÷ Total assets
= ÷ =
2 Adjusted total asset turnover = Revenue ÷ Adjusted total assets
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Comcast Corp.’s adjusted total asset turnover improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Adjusted Debt to Equity
Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).
2018 Calculations
1 Debt to equity = Total debt ÷ Total Comcast Corporation shareholders’ equity
= ÷ =
2 Adjusted debt to equity = Adjusted total debt ÷ Total Comcast Corporation shareholders’ equity
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Adjusted debt-to-equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Comcast Corp.’s adjusted debt-to-equity improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |
Adjusted Return on Assets (ROA)
Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).
2018 Calculations
1 ROA = 100 × Net income attributable to Comcast Corporation ÷ Total assets
= 100 × ÷ =
2 Adjusted ROA = 100 × Net income attributable to Comcast Corporation ÷ Adjusted total assets
= 100 × ÷ =
| Ratio | Description | The company |
|---|---|---|
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Comcast Corp.’s adjusted ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018. |