Microsoft Excel LibreOffice Calc

Adjusted Ratios

Difficulty: Advanced


Adjusted Ratios (Summary)

General Electric Co., adjusted ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Activity
Total Asset Turnover
Reported 0.30 0.30 0.21 0.16 0.15
Adjusted 0.30 0.30 0.21 0.16 0.15
Liquidity
Current Ratio
Reported 1.83 1.92 1.58 1.98 2.04
Adjusted 1.83 1.92 1.58 1.98 2.05
Solvency
Debt to Equity
Reported 2.09 1.80 2.02 2.85 2.93
Adjusted 1.70 1.73 1.98 2.71 2.79
Debt to Capital
Reported 0.68 0.64 0.67 0.74 0.75
Adjusted 0.63 0.63 0.66 0.73 0.74
Financial Leverage
Reported 5.88 4.82 5.01 5.06 5.03
Adjusted 4.59 4.53 4.84 4.78 4.77
Profitability
Net Profit Margin
Reported -5.11% 8.00% -5.79% 14.27% 12.99%
Adjusted -5.09% 7.77% 3.65% 4.55% 22.92%
Return on Equity (ROE)
Reported -9.00% 11.65% -6.23% 11.89% 10.00%
Adjusted -7.01% 10.58% 3.79% 3.57% 16.63%
Return on Assets (ROA)
Reported -1.53% 2.42% -1.24% 2.35% 1.99%
Adjusted -1.53% 2.33% 0.78% 0.75% 3.49%

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. General Electric Co.'s adjusted total asset turnover improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. General Electric Co.'s adjusted current ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.
Adjusted debt-to-equity ratio A solvency ratio calculated as adjusted total debt divided by adjusted total equity. General Electric Co.'s adjusted debt-to-equity ratio improved from 2015 to 2016 and from 2016 to 2017.
Adjusted debt-to-capital ratio A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity. General Electric Co.'s adjusted debt-to-capital ratio improved from 2015 to 2016 and from 2016 to 2017.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
General Electric Co.'s adjusted financial leverage declined from 2015 to 2016 but then slightly increased from 2016 to 2017.
Adjusted net profit margin An indicator of profitability, calculated as adjusted comprehensive income divided by total revenue. General Electric Co.'s adjusted net profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
Adjusted ROE A profitability ratio calculated as adjusted comprehensive income divided by adjusted total equity. General Electric Co.'s adjusted ROE improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
Adjusted ROA A profitability ratio calculated as adjusted comprehensive income divided by adjusted total assets. General Electric Co.'s adjusted ROA improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Sales of goods and services 113,192  110,390  105,808  106,758  100,542 
Total assets 377,945  365,183  492,692  648,349  656,560 
Ratio
Total asset turnover1 0.30 0.30 0.21 0.16 0.15
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted total assets2 377,028  367,604  493,625  650,115  660,936 
Ratio
Adjusted total asset turnover3 0.30 0.30 0.21 0.16 0.15

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Total asset turnover = Sales of goods and services ÷ Total assets
= 113,192 ÷ 377,945 = 0.30

2 Adjusted total assets. See Details »

3 Adjusted total asset turnover = Sales of goods and services ÷ Adjusted total assets
= 113,192 ÷ 377,028 = 0.30

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. General Electric Co.'s adjusted total asset turnover improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Adjusted Current Ratio

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Current assets 144,993  157,058  170,827  412,952  422,303 
Current liabilities 79,380  81,997  108,195  208,440  206,572 
Ratio
Current ratio1 1.83 1.92 1.58 1.98 2.04
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted current assets2 145,550  157,533  171,135  413,509  423,023 
Ratio
Adjusted current ratio3 1.83 1.92 1.58 1.98 2.05

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= 144,993 ÷ 79,380 = 1.83

2 Adjusted current assets. See Details »

3 Adjusted current ratio = Adjusted current assets ÷ Current liabilities
= 145,550 ÷ 79,380 = 1.83

Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. General Electric Co.'s adjusted current ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Adjusted Debt to Equity

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Total debt 134,591  136,211  198,276  364,980  383,040 
Total GE shareowners' equity 64,263  75,828  98,274  128,159  130,566 
Ratio
Debt to equity1 2.09 1.80 2.02 2.85 2.93
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted total debt2 139,324  139,990  202,006  368,730  386,971 
Adjusted total equity3 82,099  81,077  102,036  136,048  138,552 
Ratio
Adjusted debt to equity4 1.70 1.73 1.98 2.71 2.79

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Debt to equity = Total debt ÷ Total GE shareowners' equity
= 134,591 ÷ 64,263 = 2.09

2 Adjusted total debt. See Details »

3 Adjusted total equity. See Details »

4 Adjusted debt to equity = Adjusted total debt ÷ Adjusted total equity
= 139,324 ÷ 82,099 = 1.70

Ratio Description The company
Adjusted debt-to-equity ratio A solvency ratio calculated as adjusted total debt divided by adjusted total equity. General Electric Co.'s adjusted debt-to-equity ratio improved from 2015 to 2016 and from 2016 to 2017.

Adjusted Debt to Capital

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Total debt 134,591  136,211  198,276  364,980  383,040 
Total capital 198,854  212,039  296,550  493,139  513,606 
Ratio
Debt to capital1 0.68 0.64 0.67 0.74 0.75
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted total debt2 139,324  139,990  202,006  368,730  386,971 
Adjusted total capital3 221,423  221,067  304,042  504,778  525,523 
Ratio
Adjusted debt to capital4 0.63 0.63 0.66 0.73 0.74

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Debt to capital = Total debt ÷ Total capital
= 134,591 ÷ 198,854 = 0.68

2 Adjusted total debt. See Details »

3 Adjusted total capital. See Details »

4 Adjusted debt to capital = Adjusted total debt ÷ Adjusted total capital
= 139,324 ÷ 221,423 = 0.63

Ratio Description The company
Adjusted debt-to-capital ratio A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity. General Electric Co.'s adjusted debt-to-capital ratio improved from 2015 to 2016 and from 2016 to 2017.

Adjusted Financial Leverage

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Total assets 377,945  365,183  492,692  648,349  656,560 
Total GE shareowners' equity 64,263  75,828  98,274  128,159  130,566 
Ratio
Financial leverage1 5.88 4.82 5.01 5.06 5.03
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted total assets2 377,028  367,604  493,625  650,115  660,936 
Adjusted total equity3 82,099  81,077  102,036  136,048  138,552 
Ratio
Adjusted financial leverage4 4.59 4.53 4.84 4.78 4.77

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Financial leverage = Total assets ÷ Total GE shareowners' equity
= 377,945 ÷ 64,263 = 5.88

2 Adjusted total assets. See Details »

3 Adjusted total equity. See Details »

4 Adjusted financial leverage = Adjusted total assets ÷ Adjusted total equity
= 377,028 ÷ 82,099 = 4.59

Ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
General Electric Co.'s adjusted financial leverage declined from 2015 to 2016 but then slightly increased from 2016 to 2017.

Adjusted Net Profit Margin

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Net earnings (loss) attributable to the Company (5,786) 8,831  (6,126) 15,233  13,057 
Sales of goods and services 113,192  110,390  105,808  106,758  100,542 
Ratio
Net profit margin1 -5.11% 8.00% -5.79% 14.27% 12.99%
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted comprehensive income (loss)2 (5,759) 8,575  3,865  4,857  23,041 
Ratio
Adjusted net profit margin3 -5.09% 7.77% 3.65% 4.55% 22.92%

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Net profit margin = 100 × Net earnings (loss) attributable to the Company ÷ Sales of goods and services
= 100 × -5,786 ÷ 113,192 = -5.11%

2 Adjusted comprehensive income (loss). See Details »

3 Adjusted net profit margin = 100 × Adjusted comprehensive income (loss) ÷ Sales of goods and services
= 100 × -5,759 ÷ 113,192 = -5.09%

Ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted comprehensive income divided by total revenue. General Electric Co.'s adjusted net profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

Adjusted Return on Equity (ROE)

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Net earnings (loss) attributable to the Company (5,786) 8,831  (6,126) 15,233  13,057 
Total GE shareowners' equity 64,263  75,828  98,274  128,159  130,566 
Ratio
ROE1 -9.00% 11.65% -6.23% 11.89% 10.00%
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted comprehensive income (loss)2 (5,759) 8,575  3,865  4,857  23,041 
Adjusted total equity3 82,099  81,077  102,036  136,048  138,552 
Ratio
Adjusted ROE4 -7.01% 10.58% 3.79% 3.57% 16.63%

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 ROE = 100 × Net earnings (loss) attributable to the Company ÷ Total GE shareowners' equity
= 100 × -5,786 ÷ 64,263 = -9.00%

2 Adjusted comprehensive income (loss). See Details »

3 Adjusted total equity. See Details »

4 Adjusted ROE = 100 × Adjusted comprehensive income (loss) ÷ Adjusted total equity
= 100 × -5,759 ÷ 82,099 = -7.01%

Ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted comprehensive income divided by adjusted total equity. General Electric Co.'s adjusted ROE improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Reported
Selected Financial Data (USD $ in millions)
Net earnings (loss) attributable to the Company (5,786) 8,831  (6,126) 15,233  13,057 
Total assets 377,945  365,183  492,692  648,349  656,560 
Ratio
ROA1 -1.53% 2.42% -1.24% 2.35% 1.99%
Adjusted
Selected Financial Data (USD $ in millions)
Adjusted comprehensive income (loss)2 (5,759) 8,575  3,865  4,857  23,041 
Adjusted total assets3 377,028  367,604  493,625  650,115  660,936 
Ratio
Adjusted ROA4 -1.53% 2.33% 0.78% 0.75% 3.49%

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-27).

2017 Calculations

1 ROA = 100 × Net earnings (loss) attributable to the Company ÷ Total assets
= 100 × -5,786 ÷ 377,945 = -1.53%

2 Adjusted comprehensive income (loss). See Details »

3 Adjusted total assets. See Details »

4 Adjusted ROA = 100 × Adjusted comprehensive income (loss) ÷ Adjusted total assets
= 100 × -5,759 ÷ 377,028 = -1.53%

Ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted comprehensive income divided by adjusted total assets. General Electric Co.'s adjusted ROA improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.