Paying users zone. Data is covered by hidden.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Phillips 66 (PSX)


Analysis of Goodwill and Intangible Assets

Difficulty: Advanced


Goodwill and Intangible Assets Accounting Policy

Goodwill

Goodwill represents the excess of the purchase price over the estimated fair value of the net assets acquired in a business combination. It is not amortized, but is tested for impairment annually and when events or changes in circumstance indicate that the fair value of a reporting unit with goodwill is below its carrying value. The impairment test requires allocating goodwill and other assets and liabilities to reporting units. The fair value of each reporting unit is determined and compared to the book value of the reporting unit. If the fair value of the reporting unit is less than the book value, an impairment is recognized for the amount by which the book value exceeds the reporting unit’s fair value. A goodwill loss cannot exceed the total amount of goodwill allocated to that reporting unit. For purposes of testing goodwill for impairment, Phillips 66 has three reporting units with goodwill balances: Transportation, Refining, and Marketing and Specialties.

Intangible Assets Other Than Goodwill

Intangible assets with finite useful lives are amortized using the straight-line method over their useful lives. Intangible assets with indefinite useful lives are not amortized, but are tested at least annually for impairment. Each reporting period, Phillips 66 evaluates the remaining useful lives of intangible assets not being amortized to determine whether events and circumstances continue to support the indefinite useful life classification. Indefinite-lived intangible assets are considered impaired if their fair value is lower than their net book value. The fair value of intangible assets is determined based on quoted market prices in active markets, if available. If quoted market prices are not available, the fair value of intangible assets is determined based upon the present values of expected future cash flows using discount rates and other assumptions believed to be consistent with those used by principal market participants, or upon estimated replacement cost, if expected future cash flows from the intangible asset are not determinable.

Source: 10-K (filing date: 2019-02-22).


Goodwill and Intangible Assets Disclosure

Phillips 66, balance sheet: goodwill and intangible assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Trade names and trademarks hidden hidden hidden hidden hidden
Refinery air and operating permits hidden hidden hidden hidden hidden
Other hidden hidden hidden hidden hidden
Indefinite-lived intangible assets hidden hidden hidden hidden hidden
Amortized intangible asset balance hidden hidden hidden hidden hidden
Intangible assets hidden hidden hidden hidden hidden
Goodwill hidden hidden hidden hidden hidden
Goodwill and intangibles hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).

Item Description The company
Intangible assets Sum of the carrying amounts of all intangible assets, excluding goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Phillips 66’s intangible assets declined from 2016 to 2017 and from 2017 to 2018.
Goodwill Amount after accumulated impairment loss of an asset representing future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognized.
Goodwill and intangibles Sum of the carrying amounts of all intangible assets, including goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Phillips 66’s goodwill and intangibles declined from 2016 to 2017 and from 2017 to 2018.

Analyst Adjustments: Removal of Goodwill

Phillips 66, adjustments to financial data

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Adjustment to Total Assets
Total assets (as reported) hidden hidden hidden hidden hidden
Less: Goodwill hidden hidden hidden hidden hidden
Total assets (adjusted) hidden hidden hidden hidden hidden
Adjustment to Stockholders’ Equity
Stockholders’ equity (as reported) hidden hidden hidden hidden hidden
Less: Goodwill hidden hidden hidden hidden hidden
Stockholders’ equity (adjusted) hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).


Phillips 66, Financial Data: Reported vs. Adjusted


Adjusted Ratios: Removal of Goodwill (Summary)

Phillips 66, adjusted ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Total Asset Turnover
Reported total asset turnover hidden hidden hidden hidden hidden
Adjusted total asset turnover hidden hidden hidden hidden hidden
Financial Leverage
Reported financial leverage hidden hidden hidden hidden hidden
Adjusted financial leverage hidden hidden hidden hidden hidden
Return on Equity (ROE)
Reported ROE hidden hidden hidden hidden hidden
Adjusted ROE hidden hidden hidden hidden hidden
Return on Assets (ROA)
Reported ROA hidden hidden hidden hidden hidden
Adjusted ROA hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Phillips 66’s adjusted total asset turnover improved from 2016 to 2017 and from 2017 to 2018.
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.
Phillips 66’s adjusted financial leverage declined from 2016 to 2017 but then slightly increased from 2017 to 2018.
Adjusted ROE A profitability ratio calculated as net income divided by adjusted shareholders’ equity. Phillips 66’s adjusted ROE improved from 2016 to 2017 and from 2017 to 2018.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Phillips 66’s adjusted ROA improved from 2016 to 2017 and from 2017 to 2018.

Phillips 66, Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Sales and other operating revenues hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden
Ratio
Total asset turnover1 hidden hidden hidden hidden hidden
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Sales and other operating revenues hidden hidden hidden hidden hidden
Adjusted total assets hidden hidden hidden hidden hidden
Ratio
Adjusted total asset turnover2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).

2018 Calculations

1 Total asset turnover = Sales and other operating revenues ÷ Total assets
= hidden ÷ hidden = hidden

2 Adjusted total asset turnover = Sales and other operating revenues ÷ Adjusted total assets
= hidden ÷ hidden = hidden

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Phillips 66’s adjusted total asset turnover improved from 2016 to 2017 and from 2017 to 2018.

Adjusted Financial Leverage

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Selected Financial Data (US$ in millions)
Total assets hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden
Ratio
Financial leverage1 hidden hidden hidden hidden hidden
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted total assets hidden hidden hidden hidden hidden
Adjusted stockholders’ equity hidden hidden hidden hidden hidden
Ratio
Adjusted financial leverage2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).

2018 Calculations

1 Financial leverage = Total assets ÷ Stockholders’ equity
= hidden ÷ hidden = hidden

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted stockholders’ equity
= hidden ÷ hidden = hidden

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.
Phillips 66’s adjusted financial leverage declined from 2016 to 2017 but then slightly increased from 2017 to 2018.

Adjusted Return on Equity (ROE)

Microsoft Excel LibreOffice Calc
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 attributable to Phillips 66 hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden
Ratio
ROE1 hidden hidden hidden hidden hidden
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net income attributable to Phillips 66 hidden hidden hidden hidden hidden
Adjusted stockholders’ equity hidden hidden hidden hidden hidden
Ratio
Adjusted ROE2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).

2018 Calculations

1 ROE = 100 × Net income attributable to Phillips 66 ÷ Stockholders’ equity
= 100 × hidden ÷ hidden = hidden

2 Adjusted ROE = 100 × Net income attributable to Phillips 66 ÷ Adjusted stockholders’ equity
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted ROE A profitability ratio calculated as net income divided by adjusted shareholders’ equity. Phillips 66’s adjusted ROE improved from 2016 to 2017 and from 2017 to 2018.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
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 attributable to Phillips 66 hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden
Ratio
ROA1 hidden hidden hidden hidden hidden
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Net income attributable to Phillips 66 hidden hidden hidden hidden hidden
Adjusted total assets hidden hidden hidden hidden hidden
Ratio
Adjusted ROA2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-02-22), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-17), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-20).

2018 Calculations

1 ROA = 100 × Net income attributable to Phillips 66 ÷ Total assets
= 100 × hidden ÷ hidden = hidden

2 Adjusted ROA = 100 × Net income attributable to Phillips 66 ÷ Adjusted total assets
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Phillips 66’s adjusted ROA improved from 2016 to 2017 and from 2017 to 2018.