Stock Analysis on Net

eBay Inc. (NASDAQ:EBAY)

This company has been moved to the archive! The financial data has not been updated since October 24, 2019.

Analysis of Operating Leases

Microsoft Excel

Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)

eBay Inc., future operating lease payments (before adoption of FASB Topic 842)

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Total undiscounted future operating lease payments 577 311 231 222 449
Discount rate1 3.45% 3.30% 3.07% 2.53% 2.41%
 
Total present value of future operating lease payments 515 281 212 206 419

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1 Weighted-average interest rate for eBay Inc. debt

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.45%
2019 136 2019 136 131
2020 104 2020 104 97
2021 91 2021 91 82
2022 76 2022 76 66
2023 51 2023 51 43
2024 and thereafter 119 2024 51 42
2025 51 40
2026 17 13
Total: 577 577 515

Based on: 10-K (reporting date: 2018-12-31).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.30%
2018 68 2018 68 66
2019 73 2019 73 68
2020 62 2020 62 56
2021 36 2021 36 32
2022 25 2022 25 21
2023 and thereafter 47 2023 26 21
2024 21 17
Total: 311 311 281

Based on: 10-K (reporting date: 2017-12-31).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 3.07%
2017 64 2017 64 62
2018 46 2018 46 43
2019 42 2019 42 38
2020 35 2020 35 31
2021 23 2021 23 20
2022 21 2022 21 18
Total: 231 231 212

Based on: 10-K (reporting date: 2016-12-31).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 2.53%
2016 55 2016 55 54
2017 52 2017 52 49
2018 35 2018 35 32
2019 30 2019 30 27
2020 25 2020 25 22
2021 25 2021 25 22
Total: 222 222 206

Based on: 10-K (reporting date: 2015-12-31).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 2.41%
2015 113 2015 113 110
2016 96 2016 96 92
2017 83 2017 83 77
2018 63 2018 63 57
2019 42 2019 42 37
2020 and thereafter 52 2020 42 36
2021 10 8
Total: 449 449 419

Based on: 10-K (reporting date: 2014-12-31).


Adjustments to Financial Statements for Operating Leases

eBay Inc., adjustments to financial statements

US$ in millions

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Adjustment to Total Assets
Total assets (as reported) 22,819 25,981 23,847 17,785 45,132
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 515 281 212 206 419
Total assets (adjusted) 23,334 26,262 24,059 17,991 45,551
Adjustment to Total Debt
Total debt (as reported) 9,231 10,015 8,960 6,779 7,627
Add: Operating lease liability (before adoption of FASB Topic 842)2 515 281 212 206 419
Total debt (adjusted) 9,746 10,296 9,172 6,985 8,046

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

1, 2 Equal to total present value of future operating lease payments.


eBay Inc., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios for Operating Leases (Summary)

eBay Inc., adjusted financial ratios

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Total Asset Turnover1
Reported total asset turnover 0.47 0.37 0.38 0.48 0.40
Adjusted total asset turnover 0.46 0.36 0.37 0.48 0.39
Debt to Equity2
Reported debt to equity 1.47 1.24 0.85 1.03 0.38
Adjusted debt to equity 1.55 1.28 0.87 1.06 0.40
Return on Assets3 (ROA)
Reported ROA 11.09% -3.91% 30.47% 9.70% 0.10%
Adjusted ROA 10.84% -3.87% 30.20% 9.59% 0.10%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. eBay Inc. adjusted total asset turnover ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.
Adjusted debt to equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. eBay Inc. adjusted debt to equity ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. eBay Inc. adjusted ROA deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

eBay Inc., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Net revenues 10,746 9,567 8,979 8,592 17,902
Total assets 22,819 25,981 23,847 17,785 45,132
Activity Ratio
Total asset turnover1 0.47 0.37 0.38 0.48 0.40
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net revenues 10,746 9,567 8,979 8,592 17,902
Adjusted total assets 23,334 26,262 24,059 17,991 45,551
Activity Ratio
Adjusted total asset turnover2 0.46 0.36 0.37 0.48 0.39

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

2018 Calculations

1 Total asset turnover = Net revenues ÷ Total assets
= 10,746 ÷ 22,819 = 0.47

2 Adjusted total asset turnover = Net revenues ÷ Adjusted total assets
= 10,746 ÷ 23,334 = 0.46

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. eBay Inc. adjusted total asset turnover ratio deteriorated from 2016 to 2017 but then improved from 2017 to 2018 exceeding 2016 level.

Adjusted Debt to Equity

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Total debt 9,231 10,015 8,960 6,779 7,627
Stockholders’ equity 6,281 8,063 10,539 6,576 19,906
Solvency Ratio
Debt to equity1 1.47 1.24 0.85 1.03 0.38
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 9,746 10,296 9,172 6,985 8,046
Stockholders’ equity 6,281 8,063 10,539 6,576 19,906
Solvency Ratio
Adjusted debt to equity2 1.55 1.28 0.87 1.06 0.40

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

2018 Calculations

1 Debt to equity = Total debt ÷ Stockholders’ equity
= 9,231 ÷ 6,281 = 1.47

2 Adjusted debt to equity = Adjusted total debt ÷ Stockholders’ equity
= 9,746 ÷ 6,281 = 1.55

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. eBay Inc. adjusted debt-to-equity ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) 2,530 (1,016) 7,266 1,725 46
Total assets 22,819 25,981 23,847 17,785 45,132
Profitability Ratio
ROA1 11.09% -3.91% 30.47% 9.70% 0.10%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net income (loss) 2,530 (1,016) 7,266 1,725 46
Adjusted total assets 23,334 26,262 24,059 17,991 45,551
Profitability Ratio
Adjusted ROA2 10.84% -3.87% 30.20% 9.59% 0.10%

Based on: 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31).

2018 Calculations

1 ROA = 100 × Net income (loss) ÷ Total assets
= 100 × 2,530 ÷ 22,819 = 11.09%

2 Adjusted ROA = 100 × Net income (loss) ÷ Adjusted total assets
= 100 × 2,530 ÷ 23,334 = 10.84%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. eBay Inc. adjusted ROA deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.