Stock Analysis on Net

Apache Corp. (NYSE:APA)

This company has been moved to the archive! The financial data has not been updated since August 4, 2016.

Analysis of Operating Leases

Microsoft Excel

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

Apache Corp., future operating lease payments (before adoption of FASB Topic 842)

US$ in millions

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Total undiscounted future operating lease payments 406 812 1,077 1,156 975
Discount rate1 5.06% 4.31% 4.87% 4.66% 5.77%
 
Total present value of future operating lease payments 330 709 927 998 810

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 Weighted-average interest rate for Apache Corp. debt

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 5.06%
2016 65 2016 65 62
2017 61 2017 61 55
2018 61 2018 61 53
2019 39 2019 39 32
2020 39 2020 39 30
2021 and thereafter 141 2021 39 29
2022 39 28
2023 39 26
2024 24 15
Total: 406 406 330

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 4.31%
2015 180 2015 180 173
2016 160 2016 160 147
2017 159 2017 159 140
2018 81 2018 81 68
2019 81 2019 81 66
2020 and thereafter 151 2020 81 63
2021 70 52
Total: 812 812 709

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 4.87%
2014 236 2014 236 225
2015 198 2015 198 180
2016 198 2016 198 172
2017 144 2017 144 119
2018 144 2018 144 114
2019 and thereafter 157 2019 144 108
2020 13 9
Total: 1,077 1,077 927

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 4.66%
2013 258 2013 258 247
2014 204 2014 204 186
2015 203 2015 203 177
2016 151 2016 151 126
2017 150 2017 150 119
2018 and thereafter 190 2018 150 114
2019 40 29
Total: 1,156 1,156 998

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

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 5.77%
2012 236 2012 236 223
2013 153 2013 153 137
2014 153 2014 153 129
2015 119 2015 119 95
2016 118 2016 118 89
2017 and thereafter 196 2017 118 84
2018 78 53
Total: 975 975 810

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


Adjustments to Financial Statements for Operating Leases

Apache Corp., adjustments to financial statements

US$ in millions

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Adjustment to Total Assets
Total assets (as reported) 18,842 55,952 61,637 60,737 52,051
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 330 709 927 998 810
Total assets (adjusted) 19,172 56,661 62,564 61,735 52,861
Adjustment to Total Debt
Total debt (as reported) 8,778 11,245 9,725 12,345 7,216
Add: Operating lease liability (before adoption of FASB Topic 842)2 330 709 927 998 810
Total debt (adjusted) 9,108 11,954 10,652 13,343 8,026

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

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


Apache Corp., Financial Data: Reported vs. Adjusted


Adjusted Financial Ratios for Operating Leases (Summary)

Apache Corp., adjusted financial ratios

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Total Asset Turnover1
Reported total asset turnover 0.34 0.25 0.27 0.28 0.32
Adjusted total asset turnover 0.33 0.24 0.26 0.27 0.32
Debt to Equity2
Reported debt to equity 3.42 0.43 0.29 0.39 0.25
Adjusted debt to equity 3.55 0.46 0.32 0.43 0.28
Return on Assets3 (ROA)
Reported ROA -122.70% -9.66% 3.62% 3.29% 8.81%
Adjusted ROA -120.58% -9.54% 3.57% 3.24% 8.67%

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Apache Corp. adjusted total asset turnover ratio deteriorated from 2013 to 2014 but then improved from 2014 to 2015 exceeding 2013 level.
Adjusted debt to equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Apache Corp. adjusted debt to equity ratio deteriorated from 2013 to 2014 and from 2014 to 2015.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Apache Corp. adjusted ROA deteriorated from 2013 to 2014 and from 2014 to 2015.

Apache Corp., Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Oil and gas production revenues 6,383 13,749 16,402 16,947 16,810
Total assets 18,842 55,952 61,637 60,737 52,051
Activity Ratio
Total asset turnover1 0.34 0.25 0.27 0.28 0.32
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Oil and gas production revenues 6,383 13,749 16,402 16,947 16,810
Adjusted total assets 19,172 56,661 62,564 61,735 52,861
Activity Ratio
Adjusted total asset turnover2 0.33 0.24 0.26 0.27 0.32

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

2015 Calculations

1 Total asset turnover = Oil and gas production revenues ÷ Total assets
= 6,383 ÷ 18,842 = 0.34

2 Adjusted total asset turnover = Oil and gas production revenues ÷ Adjusted total assets
= 6,383 ÷ 19,172 = 0.33

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Apache Corp. adjusted total asset turnover ratio deteriorated from 2013 to 2014 but then improved from 2014 to 2015 exceeding 2013 level.

Adjusted Debt to Equity

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Total debt 8,778 11,245 9,725 12,345 7,216
Total Apache shareholders’ equity 2,566 25,937 33,396 31,331 28,993
Solvency Ratio
Debt to equity1 3.42 0.43 0.29 0.39 0.25
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 9,108 11,954 10,652 13,343 8,026
Total Apache shareholders’ equity 2,566 25,937 33,396 31,331 28,993
Solvency Ratio
Adjusted debt to equity2 3.55 0.46 0.32 0.43 0.28

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

2015 Calculations

1 Debt to equity = Total debt ÷ Total Apache shareholders’ equity
= 8,778 ÷ 2,566 = 3.42

2 Adjusted debt to equity = Adjusted total debt ÷ Total Apache shareholders’ equity
= 9,108 ÷ 2,566 = 3.55

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Apache Corp. adjusted debt-to-equity ratio deteriorated from 2013 to 2014 and from 2014 to 2015.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Apache shareholders (23,119) (5,403) 2,232 2,001 4,584
Total assets 18,842 55,952 61,637 60,737 52,051
Profitability Ratio
ROA1 -122.70% -9.66% 3.62% 3.29% 8.81%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Apache shareholders (23,119) (5,403) 2,232 2,001 4,584
Adjusted total assets 19,172 56,661 62,564 61,735 52,861
Profitability Ratio
Adjusted ROA2 -120.58% -9.54% 3.57% 3.24% 8.67%

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

2015 Calculations

1 ROA = 100 × Net income (loss) attributable to Apache shareholders ÷ Total assets
= 100 × -23,119 ÷ 18,842 = -122.70%

2 Adjusted ROA = 100 × Net income (loss) attributable to Apache shareholders ÷ Adjusted total assets
= 100 × -23,119 ÷ 19,172 = -120.58%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Apache Corp. adjusted ROA deteriorated from 2013 to 2014 and from 2014 to 2015.