Visa Inc Class A (V) Extended Graph Analysis

July 2nd, 2020 Posted by Extended Analysis No Comment yet

Company Profile

VISA logo

Visa Inc Class A (NYSE:V) is a payment technology company operating globally that allows consumers, businesses, banks and governments to use digital currency. The company introduced the electronic payment system over 60 years ago. There are more than 3 billion Visa accounts worldwide in more than 200 countries and regions. In 2019 there were 200 billion payments and cash transactions that were counting with the Visa card, and there were 11 trillion in payments and cash volumes. It uses artificial intelligent technology that analyses every detail of transactions. Visa network is made up of Fiber, Internet, Wireless and Virtual Connections that tie-up consumers, businesses, governments and financial institutions.

The company was founded in 1958 as BankAmericard by Dee Hock, and in 1976 BankAmericard became VISA. Headquartered in Foster City, California, USA.

 

Visa Inc Class A (V) Extended Graph Analysis

 

1. V Cash Flow

V CASH FLOW

2015 2016 2017 2018 2019 2020
Net cash flow provided by operating activitIes 6,584,000,000 5,574,000,000 9,208,000,000 12,713,000,000 12,784,000,000 12,768,000,000
Net cash used for investing activities -1,435,000,000 -10,916,000,000 735,000,000 -3,084,000,000 -591,000,000 2,246,000,000
Net cash provided by (used for) financing activities -3,603,000,000 7,477,000,000 -5,924,000,000 -11,240,000,000 -12,061,000,000 -12,462,000,000
Capital expenditure -414,000,000 -523,000,000 -707,000,000 -718,000,000 756,000,000 -850,000,000
Free cash flow 6,170,000,000 5,051,000,000 8,501,000,000 11,995,000,000 12,028,000,000 11,918,000,000
Working Capital 5,518,000,000 6,267,000,000 9,029,000,000 6,911,000,000 7,555,000,000 7,555,000,000

Facts:

  • Net cash from operations was $12.8 billion in 2020 trailing twelve months.
  • Net cash from investing was $2.45 billion in 2020 in trailing twelve months.
  • Cash provided by (used for) financing activities was $-12.46 billion in 2020 in trailing twelve months.
  • Capital expenditures were $-850 million in 2020 trailing twelve months.
  • Free cash flow was $11.92 billion in 2020 in trailing twelve months.
  • Working capital was $7.56 billion in 2020 in trailing twelve months.

Explanation

  • Cash from operations increased year-over-year due to increases in net income. 
  • Cash from operations grew 94 percent in five years.
  • Cash used for investing activities were sales/maturities of investments, investment in property, plant and equipment, acquisitions and purchases of investments.
  • Net cash provided by (used for) financing activities were common stock repurchased, dividends paid and other financing activities.
  • Capital expenditures were investment in property, plant and equipment.
  • Free cash flow increases year over year and has a growth of 93 percent in five years.
  • Working capital grew 37 percent in five years.

Interpretation

The company has the capability of providing cash from operations year-over-year by providing a sufficient net income.

 

2. V BALANCE SHEET

V BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 6,015,000,000 8,938,000,000 13,438,000,000 11,709,000,000 12,074,000,000
Current Assets 10,892,000,000 14,313,000,000 19,023,000,000 18,216,000,000 20,970,000,000
Net property, plant and equipment 1,888,000,000 2,150,000,000 2,253,000,000 2,472,000,000 2,695,000,000
Total non-current assets 29,344,000,000 49,722,000,000 48,954,000,000 51,009,000,000 51,604,000,000
Total assets 40,236,000,000 64,035,000,000 67,977,000,000 69,225,000,000 72,574,000,000
Current liabilities 5,374,000,000 8,046,000,000 9,994,000,000 11,305,000,000 13,415,000,000
Non-current liabilities 5,020,000,000 23,077,000,000 25,223,000,000 23,914,000,000 24,475,000,000
Total liabilities 10,394,000,000 31,123,000,000 35,217,000,000 35,219,000,000 37,890,000,000
Retained earnings 11,843,000,000 10,462,000,000 9,508,000,000 11,318,000,000 13,502,000,000
Stockholders equity 29,842,000,000 32,912,000,000 32,760,000,000 34,006,000,000 34,684,000,000

Facts

  • Total cash was $12.07 billion in 2019.
  • Current assets were $20.97 billion in 2019.
  • Net property, plant and equipment was $2.7 billion in 2019.
  • Non-current assets were $51.6 billion in 2019.
  • Total assets were $72.57 billion in 2019.
  • Current liabilities were $13.42 billion in 2019.
  • Non-current liabilities were $24.48 billion in 2019
  • Total liabilities were $37.89 billion in 2019.
  • Retained earnings were $13.5 billion in 2019.
  • Stockholders equity was $34.68 billion in 2019.

Explanation

  • Total cash has increased 52 percent in five years although it has an erratic movement.
  • Total cash represents 17 percent of the total assets.
  • Current assets grew 93 percent in five years and it represents 29 percent of the total assets.
  • Net property, plant and equipment increased year-over-year and it grew 43 percent in five years. It represents 4 percent of the total assets.
  • Non-current assets grew 76 percent in five years and it represents 71 percent of the total assets.
  • Total assets increased year-over-year and it has a growth of 80 percent in five years.
  • Current liabilities represent 35 percent of total liabilities.
  • Non-current liabilities represent 65 percent of total liabilities.
  • Total liabilities represent 52 percent of total liabilities and shareholders equity.
  • Retained earnings was 39 percent of total equity.
  • Shareholders equity represents 48 percent of total liabilities and shareholders equity.

Interpretation

The balance sheet of Visa Inc was healthy and the company is liquid. The company has the ability to pay its current obligations in due time. The company is using both investors and creditors money at 48 and 52 percent, respectively in its business operations.

 

3. V INCOME AND MARKET

V INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 13,880,000,000 15,082,000,000 18,358,000,000 20,609,000,000 22,977,000,000 23,885,000,000
EBIT 9,078,000,000 9,762,000,000 12,163,000,000 13,561,000,000 15,401,000,000 15,962,000,000
Net Income 6,328,000,000 5,991,000,000 6,699,000,000 10,301,000,000 12,080,000,000 12,482,000,000
EBITDA 9,572,000,000 8,941,000,000 12,813,000,000 14,031,000,000 18,057,000,000 16,552,000,000
Market Capitalization 186,088,000,000 186,817,000,000 266,145,000,000 299,355,000,000 416,792,000,000 428,863,000,000
Intrinsic Value 234,104,000,000 232,119,000,000 388,515,000,000 410,963,000,000 594,397,000,000 540,593,000,000

Facts:

  • Revenue was $24 billion in 2020 trailing twelve months.
  • EBIT was $16 billion in 2020 trailing twelve months.
  • Net income was $12.5 in 2020 trailing twelve months.
  • EBITDA was $17 billion in 2020 trailing twelve months.
  • Market Capitalization was $428.88 billion in 2020 trailing twelve months.
  • Intrinsic value was $540.59 billion in 2020 trailing twelve months.

Explanation

  • The revenue increased year-over-year and it grew 72 percent in five years.
  • EBIT increases year-over-year and it grew 76 percent in five years.
  • EBIT is 67 percent of revenue.
  • Net income grew 97 percent in 5 years and increases year-over-year. 
  • Net income represented 52 percent of revenue.
  • EBITDA increases year-over-year and it grew 73 percent in five years.
  • EBITDA represented 59 percent of the total revenue.
  • Market capitalization increased year-over-year and it grew 130 percent in five years.
  • Intrinsic value was greater by 26 percent compared to the market capitalization.

Interpretation

The company is profitable and financially healthy. The management has the ability to produce sufficient revenue for the operation of the business and it showed in the last five years. Moreover, net margin was 52 percent,  In other words, the management has the ability and efficiency to earn an impressive profit. The stock price of VISA is undervalued by 26 percent.

 

4. V FINANCIAL RATIOS

V FINANCIAL RATIOS

2015 2016 2017 2018 2019 2020
Asset turnover (average) 0.35 0.29 0.28 0.30 0.32 0.33
Return on assets % 16.02 11.37 9.80 14.49 17.04 17.50
Return on equity % 22.05 20.79 23.76 35.65 41.83 43.09
Return on invested capital % 22.05 14.07 15.05 23.44 26.52 25.88
Debt/Equity 0.00 0.58 0.61 0.58 0.57 0.47

Facts:

  • Asset turnover was averaging 0.33 ratio in 2020 trailing twelve months.
  • Return on assets was 17.5 percent in 2020 trailing twelve months.
  • Return on equity was 43.09 percent in 2020 trailing twelve months.
  • Return on invested capital was 25.88 percent in 2020 trailing twelve months.
  • Debt/Equity ratio was 0.47 in 2020 trailing twelve months.

Explanation

  • Asset turnover ratio indicates that for every dollar of assets it generated 33 cents of sales.
  • Return on assets indicates that the company is generating $0.175 for every dollar invested in assets.
  • Return on equity indicates that for every dollar in shareholders equity it generated $0.43 in net profit.
  • Return on invested capital indicates that the company made $0.43 for every dollar invested in capital.
  • Debt/Equity ratio indicates that for every dollar in equity, the company has 47 cents in leverage.

Interpretation

The company is in good standing and financial health. The company was able to generate a good return on its investments.

 

5. V KEY EXECUTIVE COMPENSATION

V KEY EXECUTIVE COMPENSATION

2015 2016 2017 2018 2019
Key Executive Compensation
Salary 2,047,674 2,350,090 4,100,912 4,775,172 4,875,220
Bonus 6,875,000 3,125,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 10,947,425 9,353,088 25,802,382 31,198,595 38,432,445
Securities Options 1,800,260 4,104,755 7,894,994 108,750,019 10,425,006
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 3,842,153 3,344,438 16,112,600 17,954,467 12,213,725
Other Compensation 1,015,585 165,776 152,428 115,916 139,486
Total 26,571,982 22,489,867 54,071,010 64,927,046 66,094,540
Alfred F. Kelly Jr., Chairman and CEO
Salary 1,150,799 1,300,038 1,400,059
Bonus 0 0 0
Annual Other Income 0 0 0
Restricted Stock Award 11,883,298 8,693,984 14,246,423
Securities Options 2,749,995 3,500,008 4,312,489
LTIP Payout 0 0 0
Non-Equity Compensation 5,875,000 5,973,500 4,270,000
Other Compensation 75,362 26,416 36,800
Total 21,734,454 19,493,946 24,265,771
Vasant M. Prabhu, Vice Chairman and CFO
Salary 547,616 850,032 850,032 1,000,038 1,000,040
Bonus 6,875,000 3,125,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 7,500,041 1,757,160 3,017,648 5,848,193 6,493,501
Securities Options 0 1,031,255 1,387,503 1,999,994 1,625,005
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,081,253 1,230,375 3,221,500 3,704,000 2,440,000
Other Compensation 979,180 124,626 16,200 16,500 26,800
Total 16,997,563 8,134,100 8,494,072 12,569,940 11,586,718
Ryan Mcinerney, President
Salary 750,029 750,029 750,029 900,035 900,047
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 1,951,504 3,984,063 4,363,957 6,777,537 7,133,141
Securities Options 928,242 1,476,498 1,437,500 2,250,003 1,825,008
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,498,275 10,153,125 2,842,500 3,333,600 2,196,000
Other Compensation 20,505 22,550 20,066 21,500 30,621
Total 5,163,379 7,401,817 9,417,311 13,286,026 12,088,417
Rajat Taneja, President Technology
Salary 750,029 750,029 750,029 900,035 900,047
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 1,495,880 3,611,865 4,575,318 6+803356 6,977,836
Securities Options 872,018 1,597,002 1,549,999 2,125,007 1,712,503
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,262,625 960,938 2,820,000 3,306,600 2,196,000
Other Compensation 15,900 18,600 17,450 17,750 22,215
Total 4,411,040 6,953,950 9,714,526 13,154,517 11,810,570
Kelly Mahon Tullier, EVP, General Counsel and corporate Secretary
Salary 600,023 675,026 675,027
Bonus 0 0 0
Annual Other Income 0 0 0
Restricted Stock Award 19,662,161 3,075,525 3,581,544
Securities Options 769,997 999,997 950,001
LTIP Payout 0 0 0
Non-Equity Compensation 1,353,600 1,636,767 1,111,725
Other Compensation 23,350 33,750 23,050
Total 4,710,647 6,422,617 6,343,064

Facts:

  • The key executive compensation in 2015 was $26,572,000.
  • Key executive compensation in 2016 was $22,490,000.
  • Key executive compensation in 2017 was $54,071,000.
  • Executive compensation in 2018 was $64,927,000.
  • The key executive compensation in 20149 was $66,095,000.

Explanation

  • The total key executive compensation represents 0.53 percent of the net income.
  • Total compensation of Alfred F. Kelly, CEO represented 37 percent of the total key executive compensation.
  • Total compensation of Vasant M. Prabhu, CFO represents 18 percent of the total key executive compensation.
  • Compensation of Ryan Mcinemey, President was 18 percent of the total key executive compensation.
  • Compensation of Rajat Taneja, President Technology was 18 percent of total key executive compensation.
  • The total compensation of Kelly Mahon Tullier, EVP, General Counsel and corporate Secretary represents 10 percent of the total key executive compensation.

Interpretation

Total executive compensation includes salary, restricted stock award, securities options, non-equity compensation and other compensation.

 

 

6. V LOBBYING AND CONTRIBUTIONS

V LOBBYING AND CONTRIBUTIONS

PERIOD AMOUNT
1998 $3,550,000
1999 $2,410,000
2000 $2,269,000
2001 $2,232,276
2002 $3,126,476
2003 $3,079,441
2004 $2,935,545
2005 $3,927,059
2006 $4,909,687
2007 $5,340,000
2008 $4,810,000
2009 $6,010,000
2010 $5,430,000
2011 $6,880,000
2012 $5,550,000
2013 $5,210,000
2014 $4,310,000
2015 $3,840,000
2016 $3,800,000
2017 $3,750,000
2018 $3,740,000
2019 $3,760,000
2020 $860,000

Facts:

Since 1998 to the current date, Visa Inc Class A is incurring lobbying and contributions expenditure to politicians. The annual record shows above.

Explanation

A note from OpenSecret.org Center for Responsive Politics, quoted below:

“NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on April 22, 2020 and includes spending from January 1 – March 31. Prior years include spending from January through December.”

Interpretation

Lobbying and contributions to politicians vary every cycle; it may increase or decrease in amount depending on the attention given by the federal government on the issues of the company.

 

7. V FINANCIAL STRENGTH

V FINANCIAL STRENGTH

DATA

Working Capital $7,555,000,000
Total Assets $72,574,000,000
Sales $23,885,000,000
EBIT $15,962,000,000
Market value of equity $409,197,500,000
Book value of total liabilities $37,890,000,000
Retained earnings $13,502,000,000

 

CALCULATIONS

Ratio Score Result
A – Working Capital / Total Assets 0.10 1.20 0.12
B – Retained Earnings / Total Assets 0.19 1.40 0.26
C – EBIT / Total Assets 0.22 3.30 0.73
D – Market Value of Equity / Book Value of Total Liabilities 10.80 0.60 6.48
E – Sales / Total Assets 0.33 1.00 0.33
Z-Score 7.92

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The Z-Score of Visa Inc Class A was calculated at 7.92 score. It indicates that the company is very far in declaring bankruptcy in near future or in other terms, the company is not close to insolvency according to Dr. Altman’s grading scale. The main factors of this statistical measurement are profitability, liquidity, leverage and efficiency. Visa Inc has a strong financial health.

Overview

VISA Inc. Class A is financially healthy and stable. The profit and loss account shows that the company is profitable, which represents that the management is capable of producing a net income of half of the total revenue. Moreover, the stock price of VISA Inc is undervalued, in other words, the stock price is below the fair market value, moreover, per calculation there is a margin of safety in buying the stocks of VISA Inc Class A.

CITATION

https://www.morningstar.com/stocks/xnys/v/quote

https://investor.visa.com/

https://www.opensecrets.org/federal-lobbying/clients/summary?cycle=2020&id=D000029689

Researched and written by Criselda

Invesco Ltd (IVZ) Extended Graph Analysis

June 17th, 2020 Posted by Extended Analysis No Comment yet

Company Profile

Invesco logo

Investco Ltd (NYSE:IVZ) is an investment management firm helping investors around the globe in achieving their goal profitably. They specialized in managing investment portfolios of $1.142 billion in assets on behalf of their clients worldwide. They have 8,000 employees in 25 countries which focus on their investment styles.

 

Invesco Ltd (IVZ) Extended Graph Analysis

 

1. IVZ CASH FLOW

IVZ CASH FLOW

2015 2016 2017 2018 2019 2020
Net cash flow provided by operating activitIes 1,053,500,000 129,300,000 1,370,700,000 828,800,000 1,116,600,000 1,160,000,000
Net cash used for investing activities -664,800,000 -990,600,000 -961,100,000 -2,898,700,000 -1,425,400,000 -1,544,000,000
Net cash provided by (used for) financing activities 23,300,000 470,100,000 169,000,000 1,540,000,000 201,300,000,000 384,600,000
Capital expenditure -124,500,000 -147,700,000 -111,700,000 -102,500,000 -124,300,000 -122,400,000
Free cash flow 929,000,000 -18,400,000 1,259,000,000 726,300,000 992,300,000 1,037,600,000
Working Capital 1,921,000,000 1,462,000,000 1,872,000,000 967,000,000 -10,463,000,000 -10,463,000,000

Facts:

  • Net cash flow provided by operating activities was $1.16 billion in 2020 trailing twelve months.
  • Net cash used for investing activities was S-1.54 billion in 2020 trailing twelve months.
  • Net cash provided by (used for) financing activities was $385 million in 2020 trailing twelve months.
  • Capital expenditure was $-122 million in 2020 trailing twelve months.
  • Free cash flow was $1 billion in the 2020 trailing twelve months.
  • Working capital was $-10.46 billion in 2020 trailing twelve months.

Explanation

  • Cash from operating activities was erratic in movement in the last five years due to unstable net income.
  • Cash used for investing activities were investment in property, plant and equipment and a significant amount on purchases of investment.
  • Cash provided by (used for) financing activities was debt issued.
  • Capital expenditure was investment in property, plant and equipment.
  • Free cash flow was erratic in movement in the last five years, however it grew 12 percent in five years.
  • Working capital was unstable and it suffered a negative amount in 2019, hence current liabilities are greater than that the current assets in significant amounts. However, the company managed to have a positive working capital from 2010 to 2018.  

Interpretation

The company was efficient in providing cash from operating activities in the last five years. There was free cash flow, however the company suffered negative working capital due to its current assets being lesser than the current liabilities. 

 

2. IVZ BALANCE SHEET

IVZ BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 2,533,800,000 2,070,200,000 2,517,700,000 1,805,400,000 1,701,200,000
Current Assets 9,974,400,000 11,734,600,000 16,634,400,000 14,223,400,000 3,036,400,000
Net property, plant and equipment 426,900,000 464,700,000 490,700,000 468,700,000 583,500,000
Total non-current assets 15,098,800,000 13,999,700,000 15,034,400,000 16,755,000,000 36,383,900,000
Total assets 25,073,200,000 25,734,300,000 31,668,800,000 30,978,400,000 39,420,300,000
Current liabilities 8,053,900,000 10,272,000,000 14,762,700,000 13,256,300,000 13,499,500,000
Non-current liabilities 9,134,000,000 7,958,500,000 8,210,000,000 9,143,300,000 12,058,300,000
Total liabilities 17,187,900,000 18,230,500,000 22,972,700,000 22,399,600,000 25,557,800,000
Retained earnings 4,439,600,000 4,833,400,000 5,489,100,000 5,884,500,000 5,917,800,000
Stockholders equity 7,885,300,000 7,503,800,000 8,696,100,000 8,578,800,000 13,862,500,000
Total Liabilities and Stockholders Equity 25,073,200,000 25,734,300,000 31,668,800,000 30,978,400,000 39,420,300,000

Facts:

  • Total cash was $1.7 billion in 2019.
  • Current assets were $3 billion in 2019.
  • Net property, plant and equipment was $564 million in 2019.
  • Non-current assets were $36 billion in 2019.
  • Total assets were $39 billion in 2019.
  • Current liabilities were $13 billion in 2019.
  • Non-current liabilities were $12 billion in 2019.
  • Total liabilities were $26 billion in 2019.
  • Retained earnings were $5.9 billion in 2019.
  • Stockholders’ equity was $13.86 billion in 2019.

Explanation

  • Total cash was erratic in movement in the last five years and has a negative growth of 33 percent in five years.
  • Current assets were erratic in movement in the last five years and have a negative growth of 70 percent in five years.
  • Net property, plant and equipment grew 37 percent in five years.
  • Non-current assets grew 141 percent in five years.
  • Total assets grew 57 percent in five years.
  • Current liabilities represent 53 percent of the total liabilities.
  • Non-current liabilities represent 47 percent of total liabilities.
  • Total liabilities represent 65 percent of total liabilities and equity.
  • Retained earnings represents 44 percent of equity.
  • Stockholders equity represents 35 percent of total liabilities and equity and it grew 76 percent in five years.

Interpretation

IVZ is not liquid and its liabilities are two-thirds against the total equity in 2019. The stockholders equity was increasing year-over-year in five years.. The company is using more of creditors money than the shareholders investment in operating the business.

 

3. IVZ INCOME AND MARKET

IVZ INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 5,122,900,000 4,734,400,000 5,160,300,000 5,314,100,000 6,117,400,000 6,501,700,000
EBIT 1,358,400,000 1,176,400,000 1,277,100,000 1,341,200,000 1,481,200,000 1,627,400,000
Net Income 968,100,000 854,200,000 1,127,300,000 882,800,000 688,300,000 651,300,000
EBITDA 1,726,300,000 1,401,200,000 1,640,800,000 1,391,700,000 1,286,200,000 1,222,100,000
Market Capitalization 13,978,000,000 12,395,000,000 14,875,000,000 6,647,000,000 8,150,000,000 3,956,000,000
Intrinsic Value 22,276,000,000 22,107,000,000 47,930,000,000 22,344,000,000 27,936,000,000 14,502,000,000

Facts:

  • Revenue was $6.5 billion in 2020 trailing twelve months.
  • EBIT was $1.6 billion in 2020 trailing twelve months.
  • Net income was $651 million in 2020 trailing twelve months.
  • EBITDA was $1.22 billion in 2020 trailing twelve months.
  • Market capitalization was $3.956 billion in 2020 trailing twelve months.
  • Intrinsic value was $14.5 billion in 2020 trailing twelve months.

Explanation

  • Revenue is increasing year-over-year and it grew 27 percent in five years.
  • EBIT represents 25 percent of the revenue.
  • Net income represents 10 percent of the revenue.
  • EBITDA represents 19 percent of the revenue generated.
  • Market capitalization was lower than the calculated intrinsic value.
  • Intrinsic value was higher than market capitalization by 267 percent.

Interpretation

The company is capable of producing enough revenue for its business operations. The net income was acceptable and has not suffered negative in the last five years.

 

4. IVZ FINANCIAL RATIOS

IVZ FINANCIAL RATIOS

2015 2016 2017 2018 2019 2020
Asset turnover (average) 0.23 0.19 0.18 0.17 0.17 0.19
Return on assets % 4.14 3.26 3.81 2.73 1.6 1.35
Return on equity % 11.64 10.78 13.5 9.91 6.13 5.16
Return on invested capital % 6.22 6.04 7.84 5.83 3.72 3.17
Debt/Equity 0.95 0.86 0.79 0.89 0.88 0.92

Facts:

  • Asset turnover was averaging 0.19 in 2020 trailing twelve months.
  • Return on assets was 1.35 percent in 2020 trailing twelve months.
  • Return on equity was 5.16 percent in 2020 trailing twelve months.
  • Return on invested capital was 3.17 percent in 2020 trailing twelve months.
  • Debt/Equity ratio was 0.92 in 2020 trailing twelve months.

Explanation

  • Asset turnover indicate that for every $1 in asset it generated $0.19 
  • The return on assets indicate that the company can earn a return of $.0135 net income.
  • Return on equity indicates that for every dollar invested in equity the company generated 317 cents of net income.
  • Return on invested capital indicates that the company makes $0.317 return on its invested capital.
  • Debt/Equity ratio indicates that for every dollar in equity, the company has 92 cents in leverage.

Interpretation

The company managed to produce returns on the investments made in assets and capital. Debt was high against equity.

 

5. IVZ KEY EXECUTIVE COMPENSATION

IVZ KEY EXECUTIVE COMPENSATION

2015 2016 2017 2018 2019
Key Executive Compensation    
Salary 2,201,884 2,183,408 3,091,877 3,090,422 3,079,436
Bonus 0 0 0 0 0
Annual Other income 0 0 0 0 0
Restricted Stock Award 20,192,299 19,241,890 22,282,447 22,542,672 21,984,802
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-equity Compensation 9,805,000 8,547,100 12,340,261 11,042,255 11,395,090
Other Compensation 266,218 241,109 305,860 306,709 345,970
Total 32,465,401 30,213,507 38,020,455 36,982,058 36,805,298
Martin L. Flanagan/ President and CEO
Salary 790,000 790,000 790,000 790,000 790,000
Bonus 0 0 0 0 0
Annual Other income 0 0 0 0 0
Restricted Stock Award 10,284,957 9,644,970 8,622,702 8,714,798 6,909,962
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-equity Compensation 4,650,000 4,045,500 4,268,003 3,300,000 3,704,000
Other Compensation 151,018 126,585 124,490 116,901 114,987
Total 15,875,975 14,607,055 13,805,195 12,921,699 11,518,949
Loren M. Starr/Senior Managing Director and Head of the Americas  
Salary 450,000 450,000 450,000 450,000 450,000
Bonus 0 0 0 0 0
Annual Other income 0 0 0 0 0
Restricted Stock Award 2,414,991 2,293,987 2,050,470 2,072,928 2,037,854
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-equity Compensation 1,080,000 939,600 991,278 911,976 912,000
Other Compensation 27,816 28,374 29,709 30,830 31,934
Total 3,972,807 3,711,961 3,521,457 3,465,734 3,431,788
Philip A. Taylor/Vice Chairman     
Salary 499,283 481,346 491,458 492,444 481,366
Bonus 0 0 0 0 0
Annual Other income 0 0 0 0 0
Restricted Stock Award 4,709,413 4,519,953 4,034,918 433,222 4,283,471
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-equity Compensation 2,600,000 2,262,000 2,352,480 2,234,856 1,459,090
Other Compensation 19,530 17,494 16,579 18,617 147,097
Total 7,828,226 7,280,793 6,895,435 7,079,139 6,241,024
Andrew R. Schlossberg/Senior Managing Director and Head of the Americas   
Salary 450,000 450,000 450,000
Bonus 0 0 0
Annual Other income 0 0 0
Restricted Stock Award 1,749,922 2,159,940 3,274,988
Securities Options 0 0 0
LTIP Payout 0 0 0
Non-equity Compensation 1,440,000 1,457,600 1,820,000
Other Compensation 41,210 47,442 87,966
Total 3,681,132 4,114,982 5,632,954
Gregory G. Mcgreeve/Senior Managing Director   
Salary 450,000 450,000 450,000
Bonus 0 0 0
Annual Other income 0 0 0
Restricted Stock Award 3,274,988 2,632,942 2,749,364
Securities Options 0 0 0
LTIP Payout 0 0 0
Non-equity Compensation 1,917,000 1,800,610 2,100,000
Other Compensation 27,861 29,349 30,309
Total 5,669,849 4,912,901 5,329,673
Andrew Tak Shing Lo/Senior Managing Director and Head of Invesco Asia Pacific 
Salary 462,601 462,062 460,419 457,978 458,070
Bonus 0 0 0 0 0
Annual Other income 0 0 0 0 0
Restricted Stock Award 2,782,938 2,782,980 2,549,447 2,628,842 2,729,163
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-equity Compensation 1,475,000 1,300,000 1,371,500 1,337,213 1,400,000
Other Compensation 67,854 68,656 66,011 63,570 63,677
Total 4,788,393 4,613,698 4,447,377 4,487,603 4,650,910

Facts

  • Total key executive compensation in 2015 was $32.465 million.
  • Key executive compensation in 2016 was $30.214 million.
  • Key executive compensation in 2017 was $38.020 million.
  • The executive compensation in 2018 was $36.982 million.
  • The executive compensation in 2019 was $36.805 million.

Explanation

  • The total key executive compensation represents 5.35 percent of the net income  in 2019.
  • The total compensation of the CEO represents 31 percent of the total key executive compensation in 2019.
  • Total compensation of Loren M. Starr, Senior Managing Director and Head of the Americas represents 9.32 percent of the total key executive compensation in 2019.
  • Total compensation of Philip A. Taylor, Vice Chairman represents 17 percent of the total key executive compensation in 2019.
  • Compensation of Andrew R. Scholssberg, Senior Managing Director and Head of the Americas represents 15 percent of the total key executive compensation.
  • Compensation of Gregory Mcgreeve, Senior Managing director represents 14 percent of the total key executive compensation.
  • Compensation of Andrew Tak Shing Lo, Senior Managing Director and Head of Invesco Asia Pacific represents 13 percent of the total key executive compensation.

Interpretation

Key executive compensation includes salary, restricted stock award, non-equity compensation and other compensation.

 

6. IVZ LOBBYING AND CONTRIBUTIONS

IVZ LOBBYING AND CONTRIBUTIONS

PERIOD USD
2006 $20,000
2007 $0
2008 $50,000
2009 $210,000
2010 $280,000
2011 $280,000
2012 $170,000
2013 $40,000
2014 $40,000
2015 $0
2016 $0
2017 $0
2018 $2,550,000
2019 $3,210,000
2020 $790,000

Facts:

Invesco Ltd is incurring lobbying and contributions expenses annually since 2006.

Explanation:

The lobbying expenses vary per cycle depending on the attention given by the federal government on their issues.

Note from OpenSecret.org, Center for Responsive Politics, quoted below:
NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on April 22, 2020 and includes spending from January 1 – March 31. Prior years include spending from January through December.” 

 

7. IVZ FINANCIAL STRENGTH

IVZ FINANCIAL STRENGTH

DATA

Working Capital -$10,463,000,000
Total Assets $39,420,300,000
Sales $6,501,700,000
EBIT $1,627,400,000
Market value of equity $3,956,000,000
Book value of total liabilities $25,557,800,000
Retained earnings $5,917,800,000

 

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets -0.27 1.2 -0.32
B – Retained Earnings / Total Assets 0.15 1.4 0.21
C – EBIT / Total Assets 0.04 3.3 0.14
D – Market Value of Equity / Book Value of Total Liabilities 0.15 0.6 0.09
E – Sales / Total Assets 0.16 1 0.16
Z-Score     0.29

 

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

 

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

According to Dr. Altman grading scale of measurement 0 – 1.80 indicates that the company will declare bankruptcy in the future.In other terms, the company is close to insolvency. IVZ is a higher risk investment.

Overview

Overall, the financial strength of the company was unstable and risky due to its liabilities which impacted the company’s working capital structure. Investing with Invesco Ltd (IVZ) might be risky according to Dr. Altman measurement.

CITATION

https://www.invesco.com/corporate

https://www.opensecrets.org/federal-lobbying/clients/summary?cycle=2020&id=D000026669

https://www.morningstar.com/stocks/xnys/ivz/quote

Researched and written by Criselda

 

Northrop Grumman Corporation (NOC) Extended Graph Analysis

June 3rd, 2020 Posted by Extended Analysis No Comment yet

Company Profile

NOC logo

Northrop Grumman Corporation (NOC) is an American Corporation that provides solutions in space,  aeronautics, defense and cyberspace worldwide. It is the third defense company in the US and the number two provider of information technology to the federal government and is the largest naval shipbuilder in the world. The company also provides information technology solutions to the government and commercial clients.

NOC was founded in 1994 in Denver, Colorado, United States, headquartered in Falls Church, Virginia, US. The company has more than 90,000 employees as of 2020.

 

Northrop Grumman Corporation (NOC) Extended Graph Analysis

 

1. NOC CASH FLOW

NOC CASH FLOW

2015 2016 2017 2018 2019 2020
Net cash flow provided by operating activitIes 2,162,000,000 2,813,000,000 2,613,000,000 3,827,000,000 4,297,000,000 4,217,000,000
Net cash used for investing activities -431,000,000 -805,000,000 -889,000,000 -8,878,000,000 -1,207,000,000 -1,197,000,000
Net cash provided by (used for) financing activities -3,275,000,000 -1,786,000,000 6,960,000,000 -4,595,000,000 -2,424,000,000 -590,000,000
Capital expenditure -471,000,000 -920,000,000 -928,000,000 -1,249,000,000 -1,264,000,000 -1,252,000,000
Free cash flow 1,691,000,000 1,893,000,000 1,685,000,000 2,578,000,000 3,033,000,000 2,965,000,000
Working Capital 877,000,000 1,226,000,000 9,384,000,000 1,406,000,000 1,251,000,000 1,251,000,000


Facts:

  • Cash provided by operating activities was $4.2 billion in 2020.
  • Cash used for investing activities was -$1.2 billion in 2020.
  • Cash provided by (used for) financing activities was -$590 million in 2020.
  • Capital expenditures were -$1.252 billion in 2020.
  • Free cash flow was $3 billion in 2020.
  • Working capital was $1.251 in 2020.

Explanation

  • Cash flow from operations grew 95 percent in five years.
  • Cash from investing activities was investment in property, plant and equipment.
  • Net cash provided by (used for) financing activities were debt repayment, common stock repurchased, dividends paid and other financing activities.
  • Capital expenditure was investment in property, plant and equipment.
  • Free cash flow grew 75 percent in five years. 
  • Working capital grew 45 percent in five years.

Interpretation

The company was able to generate cash from operations in the last five years. There was free cash flow and working capital in the last five years.

 

2. NOC BALANCE SHEET

NOC BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 2,319,000,000 2,541,000,000 11,225,000,000 1,579,000,000 2,245,000,000
Current Assets 6,334,000,000 6,856,000,000 16,349,000,000 9,680,000,000 10,685,000,000
Net property, plant and equipment 3,064,000,000 3,588,000,000 4,225,000,000 6,372,000,000 8,423,000,000
Total non-current assets 18,120,000,000 18,758,000,000 18,568,000,000 27,973,000,000 30,404,000,000
Total assets 24,454,000,000 25,614,000,000 34,917,000,000 37,653,000,000 41,089,000,000
Current liabilities 5,457,000,000 5,630,000,000 6,965,000,000 8,274,000,000 9,434,000,000
Non-current liabilities 13,475,000,000 14,725,000,000 20,904,000,000 21,192,000,000 22,836,000,000
Total liabilities 18,932,000,000 20,355,000,000 27,869,000,000 29,466,000,000 32,270,000,000
Retained earnings 10,661,000,000 10,630,000,000 11,548,000,000 8,068,000,000 8,748,000,000
Stockholders equity 5,522,000,000 5,259,000,000 7,048,000,000 8,187,000,000 8,819,000,000

Facts:

  • Total cash was $2.2 billion in 2019.
  • Current assets were $10.7 billion in 2019.
  • Net property, plant and equipment was $8.4 billion in 2019.
  • Non-current assets were $30.4 billion in 2019.
  • Total assets were $41 billion in 2019.
  • Current liabilities were $9.4 billion in 2019.
  • Non-current liabilities were $23 billion in 2019.
  • Total liabilities were $32 billion in 2019.
  • Retained earnings were $8.7 billion in 2019.
  • Stockholders equity was $8.8 billion in 2019.

Explanation

  • Total cash represents 5 percent of total assets and 21 percent of current liabilities.
  • Current assets grew 67 percent and represent 26 percent of total assets.
  • Net property, plant and equipment grew 175 percent and it represents 21 percent of total assets.
  • Non-current assets grew 68 percent in five years and it represents 74 percent of total assets.
  • Total assets grew 68 percent in five years.
  • Current liabilities represent 29 percent of total liabilities.
  • Non-current liabilities represent 71 percent of total liabilities.
  • Total liabilities represent 79 percent of total liabilities and stockholders equity.
  • Retained earnings represents 99 percent of total stockholders equity.
  • Stockholders equity represents 21 percent of total liabilities and stockholders equity.

Interpretation

The company has enough resources to meet its current obligations. The company is using borrowed money more than the investor’s investment in the operation of its business.

 

3. INCOME AND MARKET

NOC INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 23,526,000,000 24,508,000,000 25,803,000,000 30,095,000,000 33,841,000,000 34,272,000,000
EBIT 3,076,000,000 3,193,000,000 3,299,000,000 3,780,000,000 3,969,000,000 3,967,000,000
Net Income 1,990,000,000 2,200,000,000 2,015,000,000 3,229,000,000 2,248,000,000 2,253,000,000
EBITDA 3,558,000,000 3,680,000,000 3,884,000,000 5,104,000,000 4,094,000,000 4,095,000,000
Intrinsic Value 36,610,000,000 54,474,519,777 89,267,000,000 79,353,016,543 178,677,000,000 354,091,000,000
Market Capitalization 34,232,000,000 40,995,000,000 53,426,000,000 41,782,000,000 57,735,000,000 55,124,000,000

Facts:

  • Revenue was $34 billion in 2020.
  • EBIT was $39.7 billion in 2020.
  • Net income was $2.3 billion in 2020.
  • EBITDA was $4 billion in 2020.
  • Intrinsic value was $354 billion the trailing twelve months 2020.
  • Market capitalization was $55 billion in the trailing twelve months 2020.

Explanation:

  • Revenue increased 46 percent in five years. 
  • EBIT increased 29 percent in five years and it represents 12 percent of revenue.
  • Net income grew 13 percent in five years and it represents 7 percent of total revenue.
  • EBITDA increased 15 percent of the revenue and it represented 12 percent of revenue.
  • Intrinsic value was greater by more than 500 percent of the market capitalization.
  • Market capitalization is only 16 percent of the intrinsic value.

Interpretation

Revenue and EBIT was increasing year-over-year and was capable of producing a fair net profit. Its earning per share was 13.38 in the trailing twelve months of 2020. NOC has a stable balance sheet.

 

4. NOC FINANCIAL RATIOS

NOC FINANCIAL RATIOS

2015 2016 2017 2018 2019 2020
Asset turnover (average) 0.92 0.97 0.85 0.83 0.86 0.83
Return on assets % 7.80 8.79 6.66 8.90 5.71 5.43
Return on equity % 31.20 40.81 32.75 42.39 26.44 25.31
Return on invested capital % 17.57 20.01 13.35 17.07 12.07 10.42
Debt/Equity 1.16 1.34 2.04 1.70 1.60 1.72

Facts:

  • Asset turnover was averaging 0.83 in 2020 trailing twelve months.
  • Return on assets was 5.43 percent in 2020 trailing twelve months.
  • Return on equity was 25.31 percent in 2020 trailing twelve months.
  • Return on invested capital was 10.42 percent in 2020 trailing twelve months.
  • Debt/Equity ratio was 1.72 in 2020 trailing twelve months.

Explanation

  • Asset turnover indicates that for every dollar invested in assets it generated 83 cents of sales.
  • Return on assets indicates that for every dollar invested in assets it generated 5.43 cents of net income.
  • Return on equity indicates that for every dollar invested in stockholders equity it generated a return of 0.2531 cents of net income.
  • Return on invested capital indicates that the company generated a return of 0.4142 cents per share.
  • Debt/Equity ratio means that the company has $1.72 in debt for every dollar invested in equity. Debt level is 172 percent of equity.

Interpretation

The company is efficient in using its assets to generate a good sales and return on net income. Financial ratios show a good return on the invested capital. The company is profitable.

 

5. NOC KEY EXECUTIVE COMPENSATION

NOC KEY EXECUTIVE COMPENSATION

  2015 2016 2017 2018 2019
Key Executive Compensation     
Salary 1,386,154 1,529,039 2,299,931 3,391,347 4,783,904
Bonus 0 0 100,000 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 6,200,145 6,499,836 10,250,040 20,899,981 26,499,659
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,654,000 2,504,000 2,963,000 5,880,000 10,044,000
Other Compensation 622,561 480,320 1,590,371 1,139,525 11,631,569
Total 9,883,642 11,213,415 17,960,756 31,310,853 46,384,546
Kathy J. Warden/Chairman of the Board, President and CEO 
Salary 701,077 772,500 807,116 963,462 1,488,462
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 3,200,053 3,499,856 3,499,993 9,999,869 13,000,159
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 814,000 1,272,000 1,061,000 1,920,000 4,509,000
Other Compensation 425,783 165,596 206,548 458,976 622,758
Total 5,161,675 5,910,172 5,962,672 13,342,307 20,307,994
Kenneth L. Bedingfield/Former Corporated VP and CFO    
Salary 685,077 756,539 790,192 811,154 834,385
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 3,000,092 2,999,980 3,250,106 3,500,008 3,499,779
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 840,000 1,232,000 1,041,000 1,304,000 1,401,000
Other Compensation 196,798 314,724 351,426 312,214 296,756
Total 4,721,967 5,303,243 5,432,724 5,927,376 6,031,920
Janis Pamiljans/Corporate VP and President, Aerospace Systems    
Salary 702,623 826,154 850,192
Bonus 100,000 0 0
Annual Other Income 0 0 0
Restricted Stock Award 3,499,941 3,500,008 3,499,779
Securities Options 0 0 0
LTIP Payout 0 0 0
Non-Equity Compensation 861,000 1,328,000 1,428,000
Other Compensation 1,032,397 241,318 356,125
Total 6,565,360 5,895,480 7,222,256
Mark A. Caylor/Corporate VP and President, Mission Systems 
Salary 790,577 850,192
Bonus 0 0
Annual Other Income 0 0
Restricted Stock Award 3,900,096 3,499,779
Securities Options 0 0
LTIP Payout 0 0
Non-Equity Compensation 1,328,000 1,428,000
Other Compensation 127,017 129,727
Total 6,145,690 6,794,344
Christopher T. Jones/Corporate VP and President, Technology Services 
Salary 790,673
Bonus 0
Annual Other Income 0
Restricted Stock Award 3,000,163
Securities Options 0
LTIP Payout 0
Non-Equity Compensation 1,278,000
Other Compensation 226,203
Total 6,028,032

Facts:

  • Total key executive compensation was $9,883,642 in 2015.
  • Total key executive compensation in 2016 was $11,213,415.
  • Key executive compensation in 2017 was $17,960,756.
  • Key executive compensation in 2018 was $31,310,853.
  • Executive compensation in 2019 was $46,384,546.

Explanation

  • Total key executive compensation represents 2 percent of the net income in 2019
  • Kathy J. Warden, CEO total compensation represents 44 percent of the total key executive compensation in 2019.
  • Kenneth L Bedingfield, CFO total compensation represents 13 percent of the total key executive compensation.
  • Janis Pamiljans, VP and President Aerospace System total compensation in 2019 represents 16 percent of total key executive compensation.
  • Mark A. Caylor, Corporate VP and President, Mission Systems total compensation for 2019 represents 15 percent of the total executive compensation.
  • Christopher T. Jones, Corporate VP and President, Technology Services total salary represents 13 percent of total key executive compensation compensation.

Interpretation

Total executive compensation includes salary, restricted stock award, non-equity compensation and other compensation.

 

6. NOC LOBBYING AND CONTRIBUTIONS

NOC LOBBYING ND CONTRIBUTIONS

PERIOD USD LOBBYING CONTRIBUTIONS
1998 6,120,000 6,120,000
1999 5,130,000 5,130,000
2000 7,000,000 7,000,000
2001 12,510,000 12,510,000
2002 11,770,000 11,770,000
2003 10,410,000 10,410,000
2004 12,650,000 12,650,000
2005 13,720,000 13,720,000
2006 16,830,000 16,830,000
2007 11,180,000 11,180,000
2008 20,930,000 20,930,000
2009 15,180,000 15,180,000
2010 15,740,000 15,740,000
2011 12,770,000 12,770,000
2012 20,437,387 17,540,000 2,897,387
2013 20,590,000 20,590,000
2014 14,271,739 10,216,960 4,054,779
2015 11,020,000 11,020,000
2016 16,284,706 12,050,000 4,234,706
2017 14,460,000 14,460,000
2018 19,987,039 14,390,000 5,597,039
2019 17,314,233 13,620,000 3,694,233
2020 13,620,000 13,620,000

Facts:

Northrop Grumman Corp is incurring lobbying and contributions from 1998 to the present date.

Explanation:

A note from Center for Responsive Politics, OpenSecrets.org, quoted as follows:

“Campaign finance totals for the current election cycle were released by the FEC on May 21, 2020 and by the IRS on April 03, 2019, lobbying data was released by the Senate Office of Public Records on March 19, 2019, outside spending data was released by the FEC on May 29, 2020, and personal finances data was released by the House, Senate, and US Office of Government Ethics starting in June 2011.”

Interpretation

The amount of lobbying and contributions spent by Northrop Grumman Corp. varies per cycle.

 

7. NOC FINANCIAL STRENGTH

NOC FINANCIAL STRENGTH

DATA

Working Capital $1,251,000,000
Total Assets $41,089,000,000
Sales $34,272,000,000
EBIT $3,967,000,000
Market value of equity $54,330,100,000
Book value of total liabilities $32,270,000,000
Retained earnings $8,748,000,000

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets 0.03 1.2 0.04
B – Retained Earnings / Total Assets 0.21 1.4 0.30
C – EBIT / Total Assets 0.10 3.3 0.32
D – Market Value of Equity / Book Value of Total Liabilities 1.68 0.6 1.01
E – Sales / Total Assets 0.83 1 0.83
Z-Score 2.50


Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

 

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The calculated Z-Score of Northrop Grumman was 2.50.Dr. Altman’s grading scale of below 3.0 indicates that the company is likely to declare bankruptcy in near future. Altman score weights different profitability and liquidity metrics to arrive at the overall score. It is then compared to his grading scale. The formula does not reflect cash flows, the company might be able to pay liabilities however, may have difficulty in the operations and may gradually lead to insolvency.

Overview

Northrop Grumman Corporation is financially strong due to its innovative and advanced technology solutions. The company focused on high technology solutions for its customers. The company was able to solve critical problems in space, aeronautics, defense and cyberspace.

CITATION

https://www.northropgrumman.com/

https://www.morningstar.com/stocks/xnys/noc/quote

https://www.opensecrets.org/orgs/summary?id=D000000170

Researched and written by Criselda

Texas Instruments Inc (TXN) Extended Graph Alalysis

May 18th, 2020 Posted by Extended Analysis No Comment yet

Company Profile

TXN LOGO

Texas Instruments Incorporated (NASDAQ: TXN) designs and manufactures, tests and sells analog and embedded semiconductor chips around the world. The company was founded in 1930 as Geophysical Service Inc., an oil and gas exploration company however in the 1950s became officially Texas Instruments Incorporated a semiconductor conductor industry. Headquartered in Dallas, Texas in the United States.

The company market in electronic systems includes industrial, automotive, personal electronics, communications equipment and enterprise systems.

 

Texas Instruments (TXN) Extended graph Analysis

 

1. TXN CASH FLOW

TXN CASH FLOW

2015 2016 2017 2018 2019 2020
Net cash flow provided by operating activitIes 4,268,000,000 4,614,000,000 5,363,000,000 7,189,000,000 6,649,000,000 6,393,000,000
Net cash used for investing activities -302,000,000 -650,000,000 -1,127,000,000 -78,000,000 -1,920,000,000 -2,267,000,000
Net cash provided by (used for) financing activities -4,165,000,000 -3,810,000,000 -3,734,000,000 -6,329,000,000 -4,730,000,000 -5,328,000,000
Capital expenditure -551,000,000 -531,000,000 -695,000,000 -1,131,000,000 -847,000,000 -757,000,000
Free cash flow 3,717,000,000 4,083,000,000 4,668,000,000 6,058,000,000 5,802,000,000 5,636,000,000
Working Capital 4,519,000,000 5,193,000,000 6,476,000,000 5,623,000,000 6,638,000,000 6,638,000,000

Facts:

  • Cash provided by operating activities was $6 billion in the trailing twelve months.
  • Net cash from investing activities was $-2 billion in the trailing twelve months.
  • Cash provided by (used for) financing activities was $-5 billion in the trailing twelve months.
  • Capital expenditures were $-757 million in the trailing twelve months.
  • Free cash flow was $6 billion in the trailing twelve months.
  • Working capital was $7 billion in the trailing twelve months.

Explanation:

  • Cash from operations has a growth rate of 50% in five years, moreover, the management was able to generate cash from operations in the last five years.
  • Cash from investing activities were investment in property, plant and equipment, and purchases of investments.
  • The cash provided by financing activities were common stock repurchased, dividends paid and other financing activities.
  • Capital expenditures was investment in property, plant and equipment.
  • Free cash flow grew 52 percent in five years.
  • Working capital grew 47 percent in five years.

Interpretation

The management is efficient and capable of producing cash from operations, positive free cash flow and working capital in the last five years.

 

2. TXN BALANCE SHEET

TXN BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 3,218,000,000 3,490,000,000 4,469,000,000 4,233,000,000 5,387,000,000
Current Assets 7,074,000,000 7,457,000,000 8,734,000,000 8,097,000,000 8,761,000,000
Net property, plant and equipment 2,596,000,000 2,512,000,000 2,664,000,000 3,183,000,000 3,303,000,000
Total non-current assets 9,156,000,000 8,974,000,000 8,908,000,000 9,040,000,000 9,257,000,000
Total assets 16,230,000,000 16,431,000,000 17,642,000,000 17,137,000,000 18,018,000,000
Current liabilities 2,555,000,000 2,264,000,000 2,258,000,000 2,474,000,000 2,123,000,000
Non-current liabilities 3,729,000,000 3,694,000,000 5,047,000,000 5,669,000,000 6,988,000,000
Total liabilities 6,284,000,000 5,958,000,000 7,305,000,000 8,143,000,000 9,111,000,000
Retained earnings 31,176,000,000 33,107,000,000 34,662,000,000 37,906,000,000 39,898,000,000
Stockholders equity 9,946,000,000 10,473,000,000 10,337,000,000 8,994,000,000 8,907,000,000

Facts:

  • Total cash was $5 billion in 2019.
  • Current assets were $9 billion in 2019.
  • Net property, plant and equipment was $3 billion in 2019.
  • Non-current assets were $9 billion in 2019.
  • Total assets were $18 billion in 2019.
  • Current liabilities were $2 billion in 2019.
  • Non-current liabilities were $7 billion in 2019.
  • Total liabilities were $9 billion in 2019.
  • Retained earnings were $40 billion in 2019.
  • Stockholders equity was $9 billion in 2019.

Explanation

  • Total cash grew 67 percent in five years and it represents 30 percent of the total assets.
  • Current assets grew 24 percent in five years and it represented 49 percent of total assets.
  • Net property, plant and equipment grew 27 percent in five years and it represented 18 percent of total assets.
  • Non-current assets represented 51 percent of the total assets.
  • Total assets grew 11 percent in five years.
  • Current liabilities represent 23 percent of total liabilities.
  • Non-current liabilities represent 77 percent of total liabilities.
  • Total liabilities represents 51 percent of total liabilities and stockholders equity.
  • Retained earnings increased year-over-year in the last five years.
  • Stockholders equity represents 49 percent of total liabilities and stockholders equity.

Interpretation

The company is liquid and stable, and capable of meeting current obligations in due time. Retained earnings was huge compared to total assets, it was over 121 percent of the total assets. The shareholders have 50 percent stake in the total assets and creditors have also 50 percent stake in total assets.

 

3. TXN INCOME AND MARKET

TXN INCOME AND MARKET

2015 2016 2017 2018 2019 TTM
Revenue 13,000,000,000 13,370,000,000 14,961,000,000 15,784,000,000 14,383,000,000 14,118,000,000
EBIT 4,532,000,000 5,103,000,000 6,531,000,000 7,034,000,000 5,975,000,000 5,811,000,000
Net Income 2,986,000,000 3,595,000,000 3,682,000,000 5,580,000,000 5,017,000,000 4,976,000,000
EBITDA 5,439,000,000 5,965,000,000 7,062,000,000 7,765,000,000 6,948,000,000 6,794,000,000
Market Capitalization 55,428,000,000 72,932,000,000 102,932,000,000 89,317,000,000 119,570,000,000 105,526,000,000
Intrinsic Value 99,968,027,187 125,687,492,273 171,079,397,912 158,840,889,167 232,349,843,836 268,195,183,423

Facts:

  • Revenue was $14 billion in the trailing twelve months.
  • EBIT was $6 billion in the trailing twelve months.
  • Net income was $5 billion in the trailing twelve months.
  • EBITDA was $7 billion the trailing twelve months.
  • Market capitalization was $105.526 billion in the trailing twelve months.
  • Intrinsic value was $268.195 billion in the trailing twelve months.

Explanation

  • Revenue grew 9 percent in five years.
  • EBIT represents 41 percent of revenue.
  • Net income represents 35 percent of revenue and it grew 67 percent in five years.
  • EBITDA represents 48 percent of revenue.
  • Market capitalization grew 90 percent in five years.
  • Intrinsic value was over 154 percent of the market capitalization.

Interpretation

The management was able to generate sufficient revenue for its business operations and net income represents one-third of the revenue which is impressive. The stock price of TXN was undervalued.

 

4. TXN FINANCIAL RATIOS

TXN FINANCIAL RATIOS

2015 2016 2017 2018 2019 TTM
Asset turnover (average) 0.77 0.82 0.88 0.91 0.82 0.81
Return on assets % 17.34 21.74 21.41 31.84 28.54 28.66
Return on equity % 28.94 34.77 35.06 57.29 56.05 61.23
Return on invested capital % 20.6 25.60 25.94 39.62 35.59 35.89
Debt/Equity 0.31 0.28 0.34 0.48 0.62 0.71

Facts:

  • Asset turnover was averaging 0.81 in the trailing twelve months.
  • Return on assets  was 28.66 percent in the trailing twelve months.
  • Return on equity was 61.23 percent in the trailing twelve months.
  • Return on invested capital was 35.89 percent in the trailing twelve months.
  • Debt to Equity ratio was 0.71 in the trailing twelve months.

Explanation:

  • Asset turnover indicates that TXN is generating 81 cents of sales for every dollar invested in assets.
  • Return on assets indicates that the company generates 28.66 cents of net income for every dollar invested in assets.
  • Return on equity indicates that for every dollar invested in common equity it generated 61.23 cents of net income.
  • Debt/Equity ratio indicates that TXN has $0.71 in debt for every dollar of assets.

Interpretation

The financial ratios show that Texas Instruments is in good financial health and liquid. The company was able to generate a good return on the investments made.

 

5. KEY EXECUTIVE COMPENSATION

TXN KEY EXECUTIVE COMPENSATION

2015 2016 2017 2018 2019
Key Executive Compensation
Salary 1,140,250 1,164,083 2,375,087 3,774,169 4,102,917
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 4,900,017 4,900,048 9,300,131 12,800,422 13,600,237
Securities Options 4,900,006 4,900,007 8,300,033 12,800,070 13,600,039
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 3,653,877 3,682,817 6,050,018 9,104,833 8,580,583
Other Compensation 317,702 325,510 407,131 642,455 0
Total 14,925,802 15,080,069 25,090,172 39,123,826 42,670,368
Richard K. Templetion/ Chairman of the Board, President and Chief Executive Officer   
Salary 1,140,250 1,164,083 1,188,004 1,131,252 1,295,833
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 4,900,017 4,900,048 5,500,010 6,000,091 6,500,045
Securities Options 4,900,006 4,900,007 5,500,004 600,019 6,500,012
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 3,653,877 3,682,817 3,862,601 4,026,250 3,809,167
Other Compensation 317,702 325,510 329,825 418,612 326,162
Total 14,925,802 15,080,069 16,546,722 17,576,224 18,633,807
Rafael R. Lizardi/ SVP and CFO     
Salary 488,333 591,667 655,000
Bonus 0 0 0
Annual Other Income 0 0 0
Restricted Stock Award 2,000,047 1,200,084 1,500,058
Securities Options 1,000,013 1,200,013 1,500,006
LTIP Payout 0 0 0
Non-Equity Compensation 947,667 1,118,333 1,081,000
Other Compensation 60,814 77,072 125,671
Total 4,496,874 4,187,169 4,861,735
R. Gregory (greg) Delagi / Former Senior VP    
Salary 698,750 713,750 728,750.00
Bonus 0 0 0.00
Annual Other Income 0 0 0.00
Restricted Stock Award 1,800,074 1,800,071 1,800,028.00
Securities Options 1,800,016 1,800,008 1,800,003.00
LTIP Payout 0 0 0.00
Non-Equity Compensation 1,239,750 1,292,750 1,125,750.00
Other Compensation 16,492 5,500 6,045.00
Total 7,046,576 5,613,956 7,414,651.00
Niels Anderskouv / Senior VP     
Salary 668,750 711,667.00
Bonus 0 0.00
Annual Other Income 0 0.00
Restricted Stock Award 1,900,088 1,900,053.00
Securities Options 1,900,015 1,900,009.00
LTIP Payout 0 0.00
Non-Equity Compensation 1,333,750 1,282,333.00
Other Compensation 89,458 103,898.00
Total 5,892,061 5,897,960.00
Haviv Ilan / Senior Vice President     
Salary 668,750 711,667.00
Bonus 0 0.00
Annual Other Income 0 0.00
Restricted Stock Award 1,900,088 1,900,053.00
Securities Options 1,900,015 1,900,009.00
LTIP Payout 0 0.00
Non-Equity Compensation 1,333,750 1,282,333.00
Other Compensation 51,813 68,153.00
Total 5,854,416 5,862,215

Facts:

  • The total key executive compensation in 2015 was $ 14,925,802.
  • Total key executive compensation in 2016 was $15,080,069.
  • Total key executive compensation in 2017 was $16,546,722.
  • Key executive compensation in 2018 was $39,123,826.
  • Key executive compensation in 2019 was $42,670,368.

Explanation

  • Total executive compensation represents 0.85 percent of the net income in 2019.
  • Richard K. Templetion, CEO compensation represents 44 percent of the total executive compensation in 2019.
  • Rafael R. Lizardi, CFO compensation represents 11 percent of the total executive compensation in 2019.
  • R. Gregory (greg) Delagi, Former Senior VP compensation represents 17 percent of the total executive compensation in 2019.
  • Niels Anderskouv / Senior VP compensation represents 14 percent of the total executive compensation in 2019.
  • Haviv Ilan / Senior Vice President compensation represents 14 percent of the total executive compensation in 2019.

Interpretation

Total executive compensation includes salary, restricted stock award, securities options, non-equity compensation and other compensation.

 

6. TXN LOBBYING AND CONTRIBUTIONS

TXN LOBBYING AND CONTRIBUTIONS

PERIOD AMOUNT PERIOD AMOUNT
1998 $2,226,000 2010 $1,600,000
1999 $1,910,000 2011 $1,880,000
2000 $2,200,000 2012 $1,810,000
2001 $2,090,000 2013 $1,740,000
2002 $2,600,000 2014 $1,680,000
2003 $1,740,000 2015 $2,050,000
2004 $2,120,000 2016 $1,860,000
2005 $2,200,000 2017 $2,160,000
2006 $2,310,000 2018 $1,960,000
2007 $2,760,000 2019 $1,540,000
2008 $2,140,000 2020 $1,739,631
2009 $1,800,000

Facts:

Texas Instruments Inc is spending lobbying and contributions annually and record shows above lobbying from 1998 to 2019.

Explanation:

Note from OpenSecret.org Center for Responsive Politics, quoted below:

NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on April 22, 2020 and includes spending from January 1 – March 31. Prior years include spending from January through December.

Interpretation

Annually the lobbying may increase or decrease depending on the federal government on how much attention they are giving their issues. 

 

7. TXN FINANCIAL STRENGTH

TXN FINANCIAL STRENGTH

DATA

Working capital $6,638,000,000
Total assets $18,018,000,000
Sales $14,118,000,000
EBIT $5,811,000,000
Market value of equity $106,526,000,000
Book value of total liabilities $9,111,000,000
Retained earnings $39,898,000,000

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets 0.37 1.20 0.44
B – Retained Earnings / Total Assets 2.21 1.40 3.10
C – EBIT / Total Assets 0.32 3.30 1.06
D – Market Value of Equity / Book Value of Total Liabilities 11.69 0.60 7.02
E – Sales / Total Assets 0.78 1.00 0.78
Z-Score     12.41

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The calculated Z-Score of Texas Instruments Inc was 12.41. Dr. Altman’s grading scale of 3.0 and above indicates that the company will not declare bankruptcy in near future. In other terms, the company is not close to insolvency. The main factors of this statistical measurement are profitability, liquidity, leverage and efficiency. Texas Instruments has a strong financial health and is very far from insolvency.

Overview

Texas Instruments Inc is stable and healthy, the income statement shows that the company is profitable in the last five years of operations. The management is very efficient in generating sufficient and impressive revenue for its normal business operations in five years. The stock price of TXN is undervalued at the time this article was published and might be a good candidate for a Buy.

 

CITATION

http://www.ti.com/about-ti/company/history.html

https://www.morningstar.com/stocks/xnas/txn/quote

https://www.opensecrets.org/federal-lobbying/clients/summary?cycle=2019&id=D000000722

Researched and written by Criselda

Microsoft Corporation (MSFT) Extended Graph Analysis

May 4th, 2020 Posted by Extended Analysis No Comment yet

Microsoft Corporation (MSFT) Extended Graph Analysis

Company Profile

MSFT logo

Microsoft Corporation (Nasdaq: MSFT) is a technology American multinational corporation headquartered in Redmond, Washington. According to Wikipedia, it develops, manufactures, licenses, supports, and sells computer software, consumer electronics, personal computers, and related services.

The company enables digital transformation that empowers users and organizations in achieving more. Microsoft has a variety of products and services including Microsoft Office, Microsoft Word, Microsoft Excel, Onedrive, Microsoft Outlook, Microsoft PowerPoint, Microsoft Teams, Microsoft Windows, Microsoft Azure, Microsoft Visual Studio, Microsoft Onenote, Microsoft Exchange Server, Xbox and Microsoft System Center Configuration Manager.

Microsoft Corporation (MSFT) Extended Graph Analysis

 

1. MSFT CASH FLOW

MSFT CASH FLOW

2015 2016 2017 2018 2019 2020
Net cash flow provided by operating activites 29,080,000,000 33,325,000,000 39,507,000,000 42,884,000,000 52,185,000,000 54,126,000,000
Net cash used for investing activities -23,001,000,000 -23,950,000,000 -46,781,000,000 6,061,000,000 -15,773,000,000 -16,432,000,000
Net cash provided by (used for) financing activities -9,080,000,000 -8,393,000,000 8,408,000,000 -33,590,000,000 -36,887,000,000 -35,411,000,000
Capital expenditure -5,944,000,000 -8,343,000,000 -8,129,000,000 -11,632,000,000 -13,925,000,000 -13,546,000,000
Free cash flow 23,136,000,000 24,982,000,000 31,378,000,000 32,252,000,000 38,260,000,000 40,580,000,000
Working Capital 74,854,000,000 80,303,000,000 95,324,000,000 111,174,000,000 106,132,000,000 106,132,000,000

Facts:

  • Cash provided by operating activities was $54 billion in the trailing twelve months 2020.
  • Cash used for investing activities was $-16 billion in 2020 trailing twelve months.
  • Net cash provided by (used for) financing activities was $-35 billion in 2020 trailing twelve months.
  • Capital expenditure was $-14 billion in 2020 trailing twelve months.
  • Free cash flow was $41 billion in 2020 trailing twelve months.
  • Working capital was $106 billion in 2020 trailing twelve months.

Explanation

  • Cash from operating activities increased year-over-year and had a growth rate of 86 percent in five years.
  • Cash used for investing activities were investment in property, plant and equipment; and purchases of investment.
  • Net cash provided by (used for) financing activities were debt repayment, common stock repurchase and dividend paid.
  • Capital expenditures were investment in property, plant and equipment.
  • Free cash flow increased year-over-year and had a growth rate of 75 percent in five years.
  • Working capital had a growth rate of 42 percent in five years.

Interpretation

MSFT is efficient in maintaining cash from operations in the last five years and it is increasing year-over-year as the net income increases as well. Moreover, the company is capable of generating a positive cash and working capital in the last five years.

 

2. MSFT BALANCE SHEET

MSFT BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 96,526,000,000 113,240,000,000 132,981,000,000 133,768,000,000 133,819,000,000
Current Assets 124,712,000,000 139,660,000,000 159,851,000,000 169,662,000,000 175,552,000,000
Net property, plant and equipment 14,731,000,000 18,356,000,000 23,734,000,000 36,146,000,000 43,856,000,000
Total non-current assets 51,511,000,000 54,034,000,000 81,235,000,000 89,186,000,000 111,004,000,000
Total assets 176,223,000,000 193,694,000,000 241,086,000,000 258,848,000,000 286,556,000,000
Current liabilities 49,858,000,000 59,357,000,000 64,527,000,000 58,488,000,000 69,420,000,000
Non-current liabilities 46,282,000,000 62,640,000,000 104,165,000,000 117,642,000,000 114,806,000,000
Total liabilities 96,140,000,000 121,697,000,000 168,692,000,000 176,130,000,000 184,226,000,000
Retained earnings 9,096,000,000 2,282,000,000 2,648,000,000 13,682,000,000 24,150,000,000
Stockholders equity 80,083,000,000 71,997,000,000 72,394,000,000 82,718,000,000 102,330,000,000
Total Liabilities and Stockholders Equity 176,223,000,000 193,694,000,000 241,018,600,000 258,848,000,000 286,556,000,000

Facts:

  • Total cash was $134 billion in 2019.
  • Current assets were $176 billion in 2019.
  • Net property, plant and equipment was $44 billion in 2019.
  • Total non-current assets were $111 billion in 2019.
  • Total assets were $287 billion in 2019.
  • Current liabilities were $69 billion in 2019.
  • Non-current liabilities were $184 billion in 2019.
  • Total liabilities were $184 billion in 2019.
  • Retained earnings were $24 billion in 2019.
  • Stockholders equity was $102 billion in 2019.

Explanation:

  • Total cash increased year-over-year and has a growth rate of 39 percent in five years.
  • Total cash represents 47 percent of total assets.
  • Current assets increased year-over-year and have a growth rate of 61 percent in five years.
  • Current assets represent 61 percent of total assets.
  • Net property, plant and equipment increased year-over-year and have grown 198 percent in five years.
  • Net property, plant and equipment represent 15 percent of the total assets.
  • Total non-current assets increased year-over-year and grew 116 percent in five years.
  • Non-current assets represent 39 percent of total assets.
  • Total assets increased year-over-year and it grew 63 percent in five years.
  • Current liabilities represent 38 percent of total liabilities.
  • Non-current liabilities represent 62 percent of total liabilities.
  • Current liabilities represent 64 percent of total liabilities and equities.
  • Retained earnings represent 24 percent of total equities.
  • Total liabilities represent 64 percent of total liabilities and stockholders equity.
  • Stockholders equity represents 36 percent of total liabilities and stockholders equity.

Interpretation

The balance sheet is stable and the company is liquid; its total cash is more than enough to pay for its current obligations.

3. MSFT INCOME AND MARKET

MSFT INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 93,580,000,000 85,320,000,000 89,950,000,000 110,360,000,000 125,843,000,000 134,249,000,000
EBIT 28,172,000,000 21,292,000,000 22,632,000,000 35,058,000,000 42,959,000,000 49,323,000,000
Net Income 12,193,000,000 16,798,000,000 21,204,000,000 16,571,000,000 39,240,000,000 44,323,000,000
EBITDA 25,245,000,000 27,616,000,000 34,149,000,000 49,468,000,000 58,056,000,000 64,508,000,000
Market Capitalization 439,679,000,000 483,160,000,000 659,906,000,000 780,362,000,000 1,200,255,000,000 1,303,800,000,000
Intrinsic Value 401,084,844,920 573,333,286,219 993,423,476,928 2,363,321,837,249 3,311,254,516,335 4,673,490,334,265

Facts:

  • Revenue was $134 billion in  2020.
  • EBIT was $49 billion in 2020.
  • Net income was $44 billion in 2020.
  • EBITDA was $65 billion in 2020.
  • The market capitalization was $1.304 trillion in the trailing twelve months of 2020.
  • Intrinsic value was $4.7 trillion in the trailing twelve months 2020.

Explanation

  • Revenue grew 43 percent in five years.
  • EBIT grew 75 percent in five years and represented 37 percent of revenue.
  • Net income grew 264 percent in five years and it represented 33 percent of revenue.
  • EBITDA grew 131 percent in five years and it represented 48 percent of revenue.
  • Market capitalization is lesser than the intrinsic value.
  • Intrinsic value is higher than the market capitalization.
  • The stock price of MSFT is undervalued.

Interpretation

Microsoft Corporation has been profitable in the last five years. The company was able to maintain a net income of one/third of its revenue. Market capitalization was lesser than the intrinsic value of the stock. In other terms the stock price of Microsoft was undervalued.

 

4. MSFT FINANCIAL RATIOS

MSFT FINANCIAL RATIOS

2015 2016 2017 2018 2019 2020
Asset turnover (average) 0.54 0.46 0.41 0.44 0.46 0.50
Return on assets % 7.00 9.08 9.75 6.63 14.39 16.37
Return on equity % 14.36 22.09 29.37 21.37 42.41 43.83
Return on invested capital % 11.16 14.81 16.39 11.49 24.13 26.08
Debt/Equity 0.35 0.57 1.05 0.94 0.71 0.64

Facts

  • Asset turnover was averaging 0.50 in 2020.
  • Return on assets was 16.37 percent in 2020.
  • Return on equity was 43.83 percent in 2020.
  • Return on invested capital was 26.08 percent in 2020.
  • Debt/Equity ratio was 0.64 in 2020.

Explanation:

  • Asset turnover ratio means that every dollar invested in assets it generates $0.50 in sales.
  • Return on assets indicate that every dollar invested in the asset it generated $0.16 net income.
  • Return on equity indicates that every dollar invested in equity it generated 44 cents in profit.
  • Return on invested capital indicates that the company generated $0.26 profit for every dollar invested in capital.
  • Debt/Equity indicate that for every dollar in equity the company has 64 cents in leverage.

Interpretation

Financial ratios indicate that the company was efficient in producing a good return on the investments made in equity, assets and capital.

 

5. MSFT KEY EXECUTIVE COMPENSATION

MSFT KEY EXECUTIVE COMPENSATION

2015 2016 2017 2018 2019
Key Executive Compensation
Salary 3,065,189 3,339,584 4,554,804 4,723,000 5,654,666
Bonus 11,393,000 106,949,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 33,866,330 29,339,737 43,286,384 48,925,444 76,879,883
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 18,830,384 20,055,199 22,993,561
Other Compensation 58,991 65,442 419,890 459,964 500,139
Total 48,383,510 43,393,763 67,091,602 74,163,607 106,028,249
Satya Nadella, CEO and Director
Salary 1,200,000 1,200,000 1,450,000 1,500,000 2,333,333
Bonus 4,320,000 4,464,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 12,761,263 12,013,927 11,434,557 16,807,208 29,668,651
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 7,032,406 7,425,000 10,796,868
Other Compensation 13,007 14,104 97,189 111,055 111,363
Total 18,294,270 17,692,031 20,014,152 25,843,263 42,910,215
Amy Hood, Executive VP and CFO
Salary 675,985 731,250 852,917 875,000 958,333
Bonus 1,978,000 2,304,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 6,090,606 7,326,650 7,015,071 10,232,265 15,316,653
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 3,624,896 3,718,750 3,855,040
Other Compensation 10,372 12,730 89,260 98,442 97,608
Total 8,754,963 10,374,630 11,582,144 14,924,457 20,227,634
Bradford L. Smith, President and Chief Legal Officer
Salary 650,000 704,167 785,833 800,000 850,000
Bonus 1,300,000 1,972,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 4,833,835 5,915,948 6,193,370 9,033,868 13,045,437
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 3,241,543 3,566,700 3,366,148
Other Compensation 16,847 18,497 98,989 111,055 111,412
Total 6,800,682 8,610,612 10,319,735 13,511,623 17,372,997
Jean-philippe Courtois, EVP and President Global Sales Marketing and Operations
Salary 751,054 833,000 798,000
Bonus 0 0 0
Annual Other Income 0 0 0
Restricted Stock Award 14,735,464 7,149,549 11,309,474
Securities Options 0 0 0
LTIP Payout 0 0 0
Non-Equity Compensation 2,762,884 3,092,513 2,889,049
Other Compensation 45,214 51,187 88,231
Total 18,294,616 11,126,249 15,084,754
Margaret L. Johnson, EVP, Business Development
Salary 539,204 704,167 715,000 715,000 715,000
Bonus 3,795,000 1,909,000 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 10,180,626 4,083,212 3,907,922 5,702,554 7,539,668
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 2,168,795 2,252,236 2,086,456
Other Compensation 18,765 20,111 89,238 88,225 91,525
Total 14,533,595 6,716,490 6,880,955 8,758,015 10,432,649

Facts:

  • The total key executive compensation in 2015 was $48,383,510.
  • Total key executive compensation in 2016 was $43,393,763.
  • Total key executive compensation in 2017 was $67,091,602.
  • Key executive compensation in 2018 was $74,163,607.
  • The total key executive compensation in 2019 was $106,028,249.

Explanation:

  • Total key compensation represents 0.24 percent of the net income in 2019.
  • Total compensation of Satya Nadella, CEO and Director represents 40 percent of the total key executive compensation in 2019.
  • Total compensation of Amy Hood, Executive VP and CFO represents19 percent of the total key executive compensation in 2019.
  • Total compensation of Bradford L. Smith, President and Chief Legal Officer representing 16 percent of the total compensation in 2019.
  • Total compensation of Jean-philippe Courtois, EVP and President Global Sales Marketing and Operations represent 14 percent of the total compensation in 2019.
  • Total compensation of Margaret L. Johnson, EVP, Business Development represents 10 percent of the total compensation in 2019.

Interpretation

The total key executive compensation increased year-over-year at a different level. Compensation includes salary, bonus, restricted stock award and non-equity compensation and some other income.

 

6. MSFT LOBBYING AND CONTRIBUTIONS

MSFT LOBBYING AND CONTRIBUTIONS

PERIOD USD
1998 3,920,000
1999 4,860,000
2000 6,520,000
2001 6,640,000
2002 6,500,000
2003 8,740,000
2004 9,460,000
2005 8,700,000
2006 8,880,000
2007 9,000,000
2008 8,900,000
2010 6,910,000
2011 7,340,000
2012 8,090,000
2013 10,490,000
2014 8,330,000
2015 8,490,000
2016 8,710,000
2017 8,660,000
2018 9,590,000
2019 10,260,000

Facts:

Microsoft Corp is incurring lobbying and contributions to politicians since 1998 to the current period.

Explanation:

A note from OpenSecret.org

Campaign finance totals for the current election cycle were released by the FEC on March 23, 2020 and by the IRS on April 03, 2019, lobbying data was released by the Senate Office of Public Records on March 19, 2019, outside spending data was released by the FEC on April 24, 2020, and personal finances data was released by the House, Senate, and US Office of Government Ethics starting in June 2011.

 

7. MSFT FINANCIAL STRENGTH

MSFT FINANCIAL STRENGTH

DATA

USD
Working capital 106,132,000,000
Total assets 286,556,000,000
Sales 134,249,000,000
EBIT 49,323,000,000
Market value of equity 1,199,550,000,000
Book value of total liabilities 184,226,000,000
Retained earnings 24,150,000,000

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets 0.37 1.2 0.44
B – Retained Earnings / Total Assets 0.08 1.4 0.12
C – EBIT / Total Assets 0.17 3.3 0.57
D – Market Value of Equity / Book Value of Total Liabilities 6.51 0.6 3.91
E – Sales / Total Assets 0.47 1 0.47
Z-Score     5.51

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The calculated Z-Score of Microsoft Corp was 5.51. Dr. Altman’s grading scale of 3.0 and above indicates that the company will not declare bankruptcy in near future. In other terms, the company is not close to insolvency. The main factors of this statistical measurement are profitability, liquidity, leverage and efficiency. MSFT has a strong financial health and is very far from insolvency.

OVERVIEW

Microsoft Corp is financially stable and net margin was 33 percent of revenue. The balance sheet is liquid and its current is more than enough to settle current obligations in due period.The management was efficient in maintaining a positive cash from operations and free cash flow in the five years. The company has been profitable in the last five years. Market capitalization was undervalued.

CITATION

https://www.microsoft.com

https://www.morningstar.com/stocks/xnas/msft/quote

https://www.opensecrets.org/orgs/summary?id=D000000115

Researched and written by Criselda

Facebook Inc (FB) Extended Graph Analysis

April 17th, 2020 Posted by Extended Analysis No Comment yet

Company Profile

FB logo

Facebook, Inc. is an online social media and social networking service available in 140 multilingual. Founded by Mark Zuckerberg and was launched on February 4, 2004. Headquartered in Menlo Park, California. 

Facebook active users are more than 2 billion worldwide. And there are about 140 million businesses that use the apps to connect with customers, and more than 100 billion messages are shared daily.

 

Facebook Inc (FB) Extended Graph Analysis

1. FB CASH FLOW

FB CASH FLOWS

2015 2016 2017 2018 2019 2020
Net cash flow provided by operating activities 8,599,000,000 16,108,000,000 24,216,000,000 29,274,000,000 36,314,000,000 36,314,000,000
Net cash used for investing activities -9,434,000,000 -11,739,000,000 -20,038,000,000 -11,603,000,000 -19,864,000,000 -19,864,000,000
Net cash provided by (used for) financing activities 1,582,000,000 -310,000,000 -5,235,000,000 -15,572,000,000 -7,299,000,000 -7,299,000,000
Capital expenditure -2,523,000,000 -4,491,000,000 -6,733,000,000 -13,915,000,000 -15,102,000,000 -15,102,000,000
Free cash flow 6,076,000,000 11,617,000,000 17,483,000,000 15,359,000,000 21,212,000,000 21,212,000,000
Working Capital 19,727,000,000 31,526,000,000 44,803,000,000 43,463,000,000 51,172,000,000 51,172,000,000

Facts:

  • Cash provided by operating activities was $ 36 billion in 2020.
  • Cash used for investing activities was $ -20 billion in 2020.
  • Net cash provided by (used for) financing activities was $ -7 billion in 2020.
  • Capital expenditure was $ -15 billion in 2020.
  • Free cash flow was $21 billion in 2020.
  • Working capital was $51 billion in 2020.

Explanation:

  • Cash from operating activities increased year-over-year and grew 322 percent in five years.
  • Net cash used from investing activities were investment in property, plant and equipment and purchases of investments and net acquisitions.
  • Cash provided by financing activities were debt repayment, common stock repurchases and other financing activities.
  • Capital expenditure was investment in property, plant and equipment.
  • Free cash flow increases year-over-year and has a growth of 249 percent in five years.
  • Working capital increased 149 percent in five years.

Interpretation

Facebook Inc. managed to generate cash from operations year-over-year in five years from regular business operations. The company’s cash was stable by managing a positive cash flow.

 

2. FB BALANCE SHEET

FB BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 18,434,000,000 29,449,000,000 41,711,000,000 41,114,000,000 54,855,000,000
Current Assets 21,652,000,000 34,401,000,000 48,563,000,000 50,480,000,000 66,225,000,000
Net property, plant and equipment 5,687,000,000 8,591,000,000 13,721,000,000 24,683,000,000 44,783,000,000
Total non-current assets 27,755,000,000 30,560,000,000 35,961,000,000 46,854,000,000 67,151,000,000
Total assets 49,407,000,000 64,961,000,000 84,524,000,000 97,334,000,000 133,376,000,000
Current liabilities 1,925,000,000 2,875,000,000 3,760,000,000 7,017,000,000 15,053,000,000
Non-current liabilities 3,264,000,000 2,892,000,000 6,417,000,000 6,190,000,000 17,269,000,000
Total liabilities 5,189,000,000 5,767,000,000 10,177,000,000 13,207,000,000 32,322,000,000
Retained earnings 9,787,000,000 21,670,000,000 33,990,000,000 41,981,000,000 55,692,000,000
Stockholders equity 44,218,000,000 59,194,000,000 74,347,000,000 84,127,000,000 101,054,000,000

Facts:

  • Total cash was $55 billion in 2019.
  • Current assets were $66 billion in 2019.
  • Net property, plant and equipment was $45 billion in 2019.
  • Non-current assets were $67 billion in 2019.
  • Total assets were $133 billion in 2019.
  • Current liabilities were $32 billion in 2019.
  • Retained earnings were $56 billion in 2019.
  • Stockholders equity were $101 billion in 2019.

Explanation:

  • Total cash increased year-over-year and grew 198 percent in five years. Cash represents 41 percent of total assets.
  • Current assets increased year-over-year and grew 206 percent in five years.
  • Current assets represent 50 percent of total assets.
  • Net property, plant and equipment grew 687 percent in five years and it represents 34 percent of total assets.
  • Total non-current assets grew 142 percent in five years and it represents 50 percent of the total assets.
  • Total assets grew 170 percent in five years.
  • Current liabilities represent 47 percent of total liabilities.
  • Non-current liabilities represent 53 percent of total liabilities.
  • Total liabilities represents 24 percent of total liabilities and stockholders equity.
  • Retained earnings represent 55 percent of total stockholders equity.
  • Stockholders equity represents 76 percent of total liabilities and equity.

Interpretation

The balance sheet of the company is financially healthy and is liquid. The management is very efficient in maintaining a strong balance sheet, cash was capable to meet obligations in due period. 

 

3. FB INCOME AND MARKET

FB INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 17,928,000,000 27,638,000,000 40,653,000,000 55,838,000,000 70,697,000,000 70,697,000,000
EBIT 6,225,000,000 12,427,000,000 20,203,000,000 24,913,000,000 23,986,000,000 23,986,000,000
Net Income 3,688,000,000 10,217,000,000 15,934,000,000 22,112,000,000 18,485,000,000 18,485,000,000
EBITDA 8,162,000,000 14,870,000,000 23,625,000,000 29,685,000,000 30,573,000,000 30,573,000,000
Market Capitalization 303,330,000,000 340,120,000,000 516,130,000,000 382,790,000,000 585,370,000,000 507,923,000,000
Intrinsic Value 0 0 86,576,736,693 108,416,979,226 243,076,122,705 279,125,593,215

Facts:

  • Revenue was $71 billion in 2020.
  • EBIT was $24 billion in 2020.
  • Net income was $18 billion in 2020.
  • EBITDA was $31 billion in 2020.
  • Market capitalization was $508 billion in 2020 trailing twelve months.
  • Intrinsic value was $279 billion in 2020 trailing twelve months.

Explanation:

  • Revenue increases year-over-year and has grown 294 percent in five years.
  • EBIT grew 285 percent in five years and it represented 34 percent of revenue.
  • Net income grew 401 percent in five years and represented 26 percent of the total revenue.
  • EBITDA increases year-over-year and it grew 275 percent in five years.
  • Market capitalization grew 67 percent in five years.
  • Intrinsic value is lower by 45 percent of the market capitalization, in other terms the stock of Facebook is undervalued by 45 percent.

Interpretation

The company was profitable by maintaining a positive bottom line averaging 31 percent in the last five years. 

 

4. FB FINANCIAL RATIOS

FB FINANCIAL RATIOS

2015 2016 2017 2018 2019 TTM
Asset turnover (average) 0.40 0.46 0.54 0.61 0.61 0.51
Return on assets % 8.19 17.82 21.30 24.32 16.02 16.02
Return on equity % 9.14 19.70 23.84 27.90 19.96 19.96
Return on invested capital % 9.03 19.42 23.39 27.02 17.32 17.32

Facts:

  • Asset turnover was averaging 0.51 2020 trailing twelve months.
  • Return on assets were 16.02 percent in 2020.
  • Return on equity was 19.96 percent in 2020.
  • Return on invested capital was 17.32 percent in 2020.

Explanation:

  • Asset turnover indicates that for every $1 invested in assets Facebook generated 51 cents of sales.
  • Return on assets indicates that for every dollar invested in assets it generated 16 cents of net income.
  • Return on equity indicates that for every dollar invested in equity it generated a $0.20 return.
  • Return on invested capital means that the return made by the company was 17% or .17.

Interpretation

Financial ratios indicate that the company has the ability to generate good returns on the investments made.

 

5. FB KEY EXECUTIVE COMPENSATION

FB KEY EXECUTIVE COMPENSATION

2014 2015 2016 2017 2018
Key Executive Compensation  
Salary 2,080,168 2,659,617 2,718,462 2,930,387 3,104,616
Bonus 3,037,293 3,756,059 4,026,621 2,474,416 2,208,042
Annual Other Income 0 0 0 0 0
Restricted Stock Award 47,406,563 51,552,744 64,703,214 84,289,724 73,694,092
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 0 0 0
Other Compensation 6,244,925 6,318,204 8,653,231 11,816,608 26,405,800
Total 58,768,949 64,286,624 80,101,528 101,511,135 105,412,550
Mark Zuckerberg/CEO
Salary 1 1 1 1 1
Bonus 0 0 0 0 0
Annual Other Income 0 0 0 0 0
Restricted Stock Award 0 0 0 0 0
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 0 0 0
Other Compensation 6,213,106 5,037,840 6,015,431 9,101,965 22,554,542
Total 6,213,107 5,037,841 6,015,432 9,101,966 22,554,543
David M. Wehner/CFO
Salary 418,051 665,385 662,692 711,539 753,846
Bonus 535,077 653,365 940,421 633,317 499,494
Annual Other Income 0 0 0 0 0
Restricted Stock Award 11,024,750 15,465,667 14,931,596 21,072,431 18,423,523
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 0 0 0
Other Compensation 9,905 9,000 9,566 9,000 9,250
Total 11,987,783 16,793,417 16,544,275 22,426,287 19,689,113
Sheryl K Sandberg/COO
Salary 592,885 715,385 738,077 795,769 843,077
Bonus 624,204 1,265,193 1,293,635 640,378 638,310
Annual Other Income 0 0 0 0 0
Restricted Stock Award 14,332,313 15,465,667 19,908,426 21,072,431 18,423,523
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 0 0 0
Other Compensation 0 1,252,724 2,609,318 2,687,643 3,823,508
Total 15,549,402 18,698,969 24,549,457 25,196,221 23,728,418
Michael Schroepfer/ Chief Technology Officer
Salary 535,577 639,423 658,846 711,539 753,846
Bonus 979,021 943,360 859,356 633,317 570,744
Annual Other Income 0 0 0 0 0
Restricted Stock Award 11,024,750 10,310,705 14,931,596 21,072,431 18,423,523
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 0 0 0
Other Compensation 9,164 9,140 9,377 9,000 9,250
Total 12,548,512 11,902,628 16,459,175 22,426,287 19,757,363
Christopher K. Cox/Former Chief Product Officer
Salary 533,654 639,423 658,846 711,539 753,846
Bonus 898,991 894,141 933,209 567,204 499,494
Annual Other Income 0 0 0 0 0
Restricted Stock Award 11,024,750 10,310,705 14,931,596 21,072,431 18,423,523
Securities Options 0 0 0 0 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 0 0 0 0 0
Other Compensation 12,750 9,500 9,538 9,000 9,250
Total 12,470,145 11,853,769 16,533,189 22,360,374 19,686,113

Facts:

  • Total key executive compensation in 2018 was $105,412,550.
  • Total compensation of Mark Zuckerburg/CEO in 2018 was $22,554,542.
  • Compensation of David M. Wehner/CFO in 2018 was $19,689,113.
  • Compensation of Sheryl K Sandberg/COO in 2018 was $23,728,418.
  • Total compensation of Michael Schroepfer/ Chief Technology Officer in 2018 was $19,757,363.
  • Compensation of Christopher K. Cox/Former Chief Product Officer in 2018 was $19,686,113.

Explanation

  • The total key executive compensation represents 0.57% of the total net income in 2018.
  • Mark Zuckerberg, CEO total compensation in 2018 represents 21.40% of the total key executive compensation.
  • David M. Webner, CFO total compensation in 2018 represents 18.68% of the total key executive compensation.
  • Sheryl K. Sandberg, COO total compensation in 2018 represents 22.51% of the total key executive compensation.
  • Michael Schroepfer, CTO total compensation in 2018 represents 18.74% of the total key executive compensation. 
  • Christopher K. Cox, Former Chief Product Officer total compensation in 2018 represents 18.68% of total key executive compensation.

Interpretation

The total key executive compensation in 2018 was less one percent of the total net income. The executive salary includes basic salary, bonuses, restricted stock award and other compensation. 

 

6. FB LOBBYING AND CONTRIBUTIONS

FB LOBBYING AND CONTRIBUTIONS

PERIOD USD
2009 207,878
2010 351,390
2011 1,350,000
2012 3,850,000
2013 6,430,000
2014 9,340,000
2015 9,850,000
2016 8,692,000
2017 11,510,000
2018 12,620,000
2019 16,710,000

Facts:

  • Facebook Inc was spending lobbying and contributions from 2009 to the current period.

Explanation:

A note from OpenSecret.org

“NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on March 18, 2020 and includes spending from January 1 – December 31. Prior years include spending from January through December.”

Source: OpenSecret.org Center for Responsive Politics

 

7. FB FINANCIAL STRENGTH

FB FINANCIAL STRENGTH

DATA:

USD
Working capital 51,172,000,000
Total assets 133,376,000,000
Sales 70,697,000,000
EBIT 23,986,000,000
Market value of equity 507,923,000,000
Book value of total liabilities 32,322,000,000
Retained earnings 55,692,000,000

 

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets 0.38 1.2 0.46
B – Retained Earnings / Total Assets 0.42 1.4 0.58
C – EBIT / Total Assets 0.18 3.3 0.59
D – Market Value of Equity / Book Value of Total Liabilities 15.71 0.6 9.43
E – Sales / Total Assets 0.53 1 0.53
Z-Score 11.60

 

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

Facebook calculated Z-Score 11.60. Dr. Altman’s grading scale of 3.0 and above indicates that the company will not declare bankruptcy in near future. In other terms, the company is not close to insolvency. The main factors of this statistical measurement are profitability, liquidity, leverage and efficiency. Facebook Inc has a strong financial health and is very far from insolvency.

Overview

Facebook Inc. has a strong balance sheet and is liquid. The income statement shows that the company has been profitable in the last five years. The company has a very strong financial strength. 

 

CITATION

https://www.morningstar.com/stocks/xnas/fb/quote

https://www.facebook.com/

https://www.opensecrets.org/federal-lobbying/clients/summary?cycle=2019&id=D000033563

Researched and written by Criselda

 

Alibaba Group Holding Ltd ADR (BABA N) Extended Graph Analysis

April 3rd, 2020 Posted by Extended Analysis No Comment yet

Company Profile

BABA logo

Alibaba Group Holding Ltd Company is a Chinese multinational online company. Specializing in e-commerce, retail, internet and technology. Founded by Jack Ma on 4 April 1999 in Hangzhou, Zhejiang. Alibaba is a public company and traded as NYSE: BABA.

 

Alibaba Group Holding Ltd ADR (BABA N) Extended Graph Analysis

 

1. BABA CASH FLOWS

BABA CASH FLOWS

2015 2016 2017 2018 2019 2020
Net cash provided by operating activities 41,217,000,000 56,836,000,000 80,326,000,000 125,171,000,000 150,975,000,000 196,996,000,000
Net cash used for investing activities -53,454,000,000 -42,831,000,000 -78,364,000,000 -83,890,000,000 -151,060,000,000 -97,828,000,000
Net cash provided by (used for) financing activities 87,497,000,000 -15,846,000,000 32,914,000,000 20,359,000,000 -7,392,000,000 68,605,000,000
Capital expenditures -7,705,000,000 -10,845,000,000 -17,546,000,000 -29,836,000,000 -49,643,000,000 -49,643,000,000
Free cash flow 33,512,000,000 45,991,000,000 62,780,000,000 95,335,000,000 101,332,000,000 147,353,000,000
Working capital 102,437,000,000 82,031,000,000 88,745,000,000 121,045,000,000 62,604,000,000 62,604,000,000

Facts:

  • Cash provided by operating activities was CNY 196.996 billion in 2020.
  • Cash used for investing activities were CNY -97.8 in 2020.
  • Net cash provided by financing activities was CNY 68.605 billion in 2020.
  • Capital expenditure was CNY -49.6 billion in 2020.
  • Free cash flow was CNY 147 billion.
  • Working capital was CNY 62.6 billion in 2020.

Explanation

  • Cash from operations was increasing year-over-year and has a growth rate of 378 percent in five years.
  • Cash from investing activities were purchases of property, plant and equipment, acquisitions and purchases of investments.
  • Cash provided by (used for) financing activities were debt repayment and common stock repurchase.
  • Capital expenditures were purchases of property, plant and equipment and purchases of intangibles.
  • Free cash flow increases year-over-year and has a growth rate of 340% in five years.
  • Working capital was erratic in movement in the last five years.

Interpretation

Alibaba was capable and efficient in maintaining a positive cash from operations, free cash flow and working capital in the last five years. 

 

2. BABA BALANCE SHEET

BABA BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 125,999,000,000 115,696,000,000 150,801,000,000 210,210,000,000 203,165,000,000
Current Assets 142,109,000,000 134,070,000,000 182,516,000,000 256,855,000,000 270,273,000,000
Net property, plant and equipment 12,244,000,000 16,505,000,000 24,897,000,000 75,866,000,000 98,449,000,000
Total non-current assets 113,325,000,000 230,380,000,000 324,296,000,000 460,269,000,000 694,803,000,000
Total assets 255,434,000,000 364,450,000,000 506,812,000,000 717,124,000,000 965,076,000,000
Current liabilities 39,672,000,000 52,039,000,000 93,771,000,000 135,810,000,000 207,669,000,000
Non-current liabilities 70,323,000,000 95,424,000,000 134,242,000,000 215,492,000,000 265,150,000,000
Total liabilities 109,995,000,000 147,463,000,000 228,013,000,000 351,302,000,000 472,819,000,000
Retained earnings 24,842,000,000 78,752,000,000 108,558,000,000 172,353,000,000 257,886,000,000
Stockholders equity 145,439,000,000 216,987,000,000 278,799,000,000 365,822,000,000 492,257,000,000

Facts:

  • Total cash was CNY 203 billion in 2019.
  • Current assets were CNY 270 billion in 2019.
  • Net property, plant and equipment was CNY 98 billion in 2019.
  • Non-current assets were CNY 695 billion in 2019.
  • Total assets were CNY 965 billion in 2019.
  • Current liabilities were CNY 208 billion in 2019.
  • Non-current liabilities were CNY 265 billion in 2019.
  • Total liabilities were CNY 473 billion in 2019.
  • Retained earnings were CNY 258 billion in 2019.
  • Stockholders equity was CNY 492 billion in 2019.

Explanation

  • Cash was increasing year-over-year and has a growth rate of 61% in five years. It represents 21 percent of the total assets.
  • Current assets represent 28 percent of total assets and have a growth rate of 90 percent in five years.
  • Net property plant and equipment represents 10 percent of total assets. It grew 704 percent in five years.
  • Non-current assets was 72 percent of total assets and it grew 513 percent in five years.
  • Total assets grew 278 percent in five years.
  • Current liabilities represent 44 percent of total liabilities.
  • Non-current liabilities represent 56 percent of total liabilities.
  • Total liabilities represents 49 percent of total equities and liabilities.
  • Retained earnings represent 52 percent of total equities.
  • Stockholders equity represents 41 percent of total equities and liabilities.

Interpretation

The balance was strong and in good health. The company was efficient in maintaining a solid balance sheet in the last five years. 

 

3. BABA INCOME AND MARKET

BABA INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 76,204,000,000 101,143,000,000 158,273,000,000 250,266,000,000 376,844,000,000 488,895,000,000
EBIT 23,637,000,000 29,958,000,000 48,055,000,000 70,363,000,000 57,750,000,000 94,306,000,000
Net Income 24,261,000,000 71,460,000,000 43,675,000,000 64,985,000,000 87,886,000,000 172,126,000,000
EBITDA 39,491,000,000 90,115,000,000 76,992,000,000 125,989,000,000 138,491,000,000 212,655,000,000
Market Capitalization 0 1,356,753,374,878 2,601,380,048,653 2,601,380,048,653 3,231,462,292,833 3,231,462,292,833
Intrinsic Value 0 0 5,454,154,281,120 7,219,369,371,316 13,772,141,627,743 12,164,643,972,274

Facts:

  • Revenue was CNY 489 billion in 2020.
  • EBIT was CNY 94 billion in 2020.
  • Net Income was CNY 172 billion in 2020.
  • EBITDA was CNY 213 billion in 2020.
  • Market capitalization was CNY 3 trillion in trailing twelve months.
  • The calculated intrinsic value was CNY 12 trillion in trailing twelve months.

Explanation:

  • Revenue increases year-over-year and has grown 542 percent in five years.
  • EBIT has a growth of 299 percent in five years.
  • Net income grew 609 percent in five years.
  • Market capitalization increased year-over-year and grew 138 percent in five years.
  • Intrinsic value was over 276 percent against market capitalization, therefore market price was undervalued.

Interpretation

Alibaba was profitable in the last five years. The management was able to generate more than enough revenue for the operation of the business.

 

4. BABA FINANCIAL RATIOS

BABA FINANCIAL RATIOS

2015 2016 2017 2018 2019 2020
Asset turnover (average) 0.42 0.33 0.36 0.4 0.45 0.43
Return on assets % 13.16 23.06 10.03 10.46 10.41 15.37
Return on equity % 27.63 39.43 17.62 19.85 20.42 28.54
Debt/Equity 0.35 0.25 0.28 0.33 0.23 0.16
Return on invested capital % 13.99 11.08 12.13 9.72 9.89 12.16
Interest coverage 12.72 42.86 23.47 29.16 19.54 37.63

Facts:

  • Asset turnover was averaging 0.43 in 2020.
  • Return on assets was 15.37 percent in 2020.
  • Return on equity was 28.54 percent in 2020.
  • Debt/Equity ratio was 0.16 in 2020.
  • Return on invested capital was 12.16 percent in 2020.
  • Interest coverage was 37.63 in 2020.

Explanation

  • Asset turnover indicates that for every $1 in asset, the company generates 0.43 CNY.
  • Return on assets indicates that the company produces .15 CNY of net income for every CNY invested in assets.
  • Return on equity indicates that for every CNY invested in equity, it earns .2854 CNY net income.
  • Debt/Equity ratio indicates that for every CNY in equity, the company has .16 CNY in leverage.
  • Return on invested capital means the company earns .12 CNY profit for its invested capital.
  • Interest coverage means that the company can afford to pay its interest payment 38 times of its current financial obligations.

Interpretation

The financial ratios show that the company is managed very well from its business operations. The company is profitable.

 

5. BABA KEY EXECUTIVE

NAME TITLE
Sophie Minzhi WU Chief Customer Officer
Timothy A. Steinert General counsel and Corporate Secretary
Luyuan Fan Pres, Alibaba Digital Media and Entertainment
J. Michael Evans Director and President
Shan Trudy Dai President Wholesale Marketplaces
Jeff Jianfeng Zhang Chief Technology Officer and President
Junfang Jessie Zheng Chief Risk Officer and Chief Platform Governance Officer
Pen-Hung Chris Tung Chief Marketing Officer
Judy Wenhong Tong Chief People Officer

Facts:

Alibaba does not reveal the key executive compensation.

 

6. BABA LOBBYING AND CONTRIBUTIONS

BABA LOBBYING AND CONTRIBUTIONS

Period USD
2011 100,000
2012 461,000
2013 430,000
2014 450,000
2015 410,000
2016 1,020,000
2017 2,010,000
2018 2,740,000
2019 2,620,000

Facts:

Alibaba has been spending annual lobbying and contributions since 2011. The figures vary  every period. A Note from OpenSecrets is quoted as follows:

NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on January 23, 2020 and includes spending from January 1 – December 31. Prior years include spending from January through December.

Source: OpenSecret.org Center for Responsive Politics

 

7. BABA FINANCIAL STRENGTH

BABA FINANCIAL STRENGTH

DATA CNY
Working capital 62,604,000,000
Total assets 965,076,000,000
Sales 488,895,000,000
EBIT 94,306,000,000
Market value of equity 3,404,603,312,500
Book value of total liabilities 472,819,000,000
Retained earnings 257,886,000,000

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets 0.06 1.2 0.08
B – Retained Earnings / Total Assets 0.27 1.4 0.37
C – EBIT / Total Assets 0.10 3.3 0.32
D – Market Value of Equity / Book Value of Total Liabilities 7.20 0.6 4.32
E – Sales / Total Assets 0.51 1 0.51
Z-Score 5.60


Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

Alibaba. has a Z-Score of 5.60. Dr. Altman’s grading scale of 3.0 and above indicates that the company will not declare bankruptcy in near future. In other terms, the company is not close to insolvency. The main factors of this statistical measurement are profitability, liquidity, leverage and efficiency.

Overview

Alibaba Group Holding Ltd ADR has a strong balance sheet and is financially healthy. The income statement shows that the company was profitable and liquid. The stock price of Alibaba was undervalued, therefore, could be a good Buy.

CITATION

https://www.morningstar.com/stocks/xnys/baba/quote

https://www.opensecrets.org/federal-lobbying/clients/summary?cycle=2011&id=D000064488

https://www.alibabagroup.com/en/global/home

Researched and written by Criselda

 

ConocoPhillips (COP) Extended Graph analysis

March 14th, 2020 Posted by Extended Analysis No Comment yet

Company Profile

COP logo

ConocoPhillips is one of the largest American multinational energy Corporations engaged in the exploration, production, transportation and marketing of crude oil, gas, petroleum  and other products. ConocoPhillip is a public company traded as NYSE: COP. The company was founded in 1875 by Frank Phillips, headquartered in Houston Energy Corridor, Houston Texas, USA.

 

ConocoPhillips (COP) Extended Graph Analysis

1. COP CASH FLOW

COP CASH FLOW

2015 2016 2017 2018 2019 TTM
Net cash flow provided by operating activites 7,572,000,000 4,403,000,000 7,077,000,000 12,934,000,000 11,104,000,000 11,104,000,000
Net cash used for investing activities -8,655,000,000 -3,859,000,000 7,762,000,000 -3,843,000,000 -6,618,000,000 -6,618,000,000
Net cash provided by (used for) financing activities -1,429,000,000 764,000,000 -12,356,000,000 -9,359,000,000 -5,229,000,000 -5,229,000,000
Capital expenditure -10,050,000,000 -4,869,000,000 -4,591,000,000 -6,750,000,000 -6,636,000,000 -6,636,000,000
Free cash flow -2,478,000,000 -466,000,000 2,486,000,000 6,184,000,000 4,468,000,000 4,468,000,000
Working Capital -467,000,000 1,700,000,000 7,115,000,000 5,879,000,000 9,870,000,000 9,870,000,000

Facts:

  • Cash provided by operating activities was $11.104 billion in the trailing twelve months.
  • Cash used for investing activities were -$6.6 billion in the trailing twelve months.
  • Net cash used for financing activities were -$5 billion in the trailing twelve months.
  • Capital expenditures were -$6.6 billion in the trailing twelve months.
  • Free cash flow was $4.5 billion in the trailing twelve months.
  • Working capital was $9.87 billion in the trailing twelve months.

Explanation:

  • Cash provided by operating activities is erratic in movement in the last five years. It has a negative growth of 14% from 2018.
  • Cash used for investment activities are investment in property, plant and equipment.
  • Cash provided by financing activities are debt repayment, common stock repurchased and dividends paid.
  • Capital expenditures are investment in property, plant and equipment.
  • Free cash flow was erratic in movement in the last five years and has a negative growth of 28% from 2018.
  • Working capital grew 68% in the last five years.

Interpretation

The cash flow statements were stable although there was negative growth within five years period. The company has the ability to provide cash from operations in five years and has not seen any negative cash from operations in five years.

 

2. COP BALANCE SHEET

COP BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 2,368,000,000 3,660,000,000 10,097,000,000 7,625,000,000 10,227,000,000
Current Assets 8,789,000,000 8,609,000,000 16,512,000,000 13,274,000,000 16,913,000,000
Net property, plant and equipment 66,446,000,000 58,331,000,000 45,683,000,000 45,698,000,000 42,269,000,000
Total non-current assets 88,695,000,000 81,163,000,000 56,850,000,000 56,706,000,000 53,601,000,000
Total assets 97,484,000,000 89,772,000,000 73,362,000,000 69,980,000,000 70,514,000,000
Current liabilities 9,256,000,000 6,909,000,000 9,397,000,000 7,395,000,000 7,043,000,000
Non-current liabilities 48,466,000,000 47,889,000,000 33,358,000,000 30,646,000,000 28,490,000,000
Total liabilities 57,722,000,000 54,798,000,000 42,755,000,000 38,041,000,000 35,533,000,000
Retained earnings 36,414,000,000 31,548,000,000 29,391,000,000 34,010,000,000 39,742,000,000
Stockholders equity 39,762,000,000 34,974,000,000 30,607,000,000 31,939,000,000 34,981,000,000

Facts:

  • Cash was $10 billion in 2019.
  • Current assets were $16.9 billion in 2019.
  • Net property, plant and equipment was $42 billion in 2019.
  • Non-current assets were $53.6 billion in 2019.
  • Total assets were $70.5 billion in 2019.
  • Current liabilities were $7 billion in 2019.
  • Non-current liabilities $28 billion in 2019.
  • Total liabilities were $35.5 billion in 2019.
  • Retained earnings were $39.7 billion in 2019.
  • Stockholders equity was $35 billion in 2019.

Explanation

  • Cash represents 15% of total assets.
  • Current assets represent 24% of total assets.
  • Net property, plant and equipment represent 60% of total assets.
  • Non-current assets represent 76% of total assets.
  • Total assets grew 0.76% in one year, 2018 to 2019.
  • Current liabilities represent 20% of the total liabilities.
  • Non-current liabilities represent 80% of the total liabilities.
  • Total liabilities represents 50% of the total liabilities and stockholders equity.
  • Stockholders equity represents 50% of the total liabilities and equity.

Interpretation

The company is liquid and financially healthy. The balance sheet is strong and stable.

 

3. COP INCOME AND MARKET

COP INCOME AND MARKET

2015 2016 2017 2018 2019 TTM
Revenue 29,564,000,000 23,693,000,000 29,106,000,000 36,417,000,000 32,567,000,000 32,567,000,000
EBIT -5,440,000,000 -4,634,000,000 2,360,000,000 8,859,000,000 7,278,000,000 7,278,000,000
Net Income -4,428,000,000 -3,615,000,000 -855,000,000 6,257,000,000 7,189,000,000 7,189,000,000
EBITDA 2,794,000,000 4,777,000,000 5,328,000,000 16,664,000,000 16,392,000,000 16,392,000,000
Market Capitalization 57,709,000,000 62,125,000,000 65,622,000,000 70,976,000,000 70,549,000,000 52,348,000,000
Intrinsic Value 106,536,316,910 184,383,385,632 323,869,764,451 218,122,508,960 115,498,848,453 167,935,607,654

Facts:

  • Revenue was $33 billion in the trailing twelve months.
  • EBIT was $7 billion in the trailing twelve months.
  • Net income was $7 billion the trailing twelve months.
  • EBITDA was $16 billion in the trailing twelve months.
  • Market capitalization was $52.348 billion in the trailing twelve months.
  • Intrinsic value was $168 billion in the trailing twelve months.

Explanation

  • Revenue was down by 11% from 2018 to 2019.
  • EBIT represents 22% of revenue.
  • Net income represents 22% of revenue.
  • EBITDA represents 50% of revenue.
  • Market capitalization was down 28% from 2019 to the trailing twelve months.
  • Intrinsic value was up by more than 200% of the market capitalization.

Interpretation

The earnings of the company shows improvements in the last three years. Bottomline was impressive.

 

4. COP FINANCIAL RATIOS

COP FINANCIAL RATIOS

2015 2016 2017 2018 2019 TTM
Asset turnover (average) 0.28 0.25 0.36 0.51 0.46 0.46
Return on assets % -4.14 -3.86 -1.05 8.73 10.23 10.23
Return on equity % -9.66 -9.67 -2.61 20.01 21.49 21.49
Debt/Equity 0.59 0.75 0.56 0.47 0.42 0.42
Return on invested capital % -5.61 -4.49 -0.47 13.7 15.82 15.82
Interest coverage -6.87 -3.44 -1.38 14.57 13.24 13.24

Facts:

  • Asset turnover was averaging 0.46 in the trailing twelve months.
  • Return on assets was 10.23% in the trailing twelve months.
  • Return on equity was 21.49% in the trailing twelve months
  • Debt/Equity was 0.42 in the trailing twelve months.
  • Return on invested capital was 15.82% in the trailing twelve months.
  • Interest coverage was 13.24 in the trailing twelve months.

Explanation

  • Asset turnover indicates that for every $1 invested in assets, COP generated 46 cents of sales.
  • Return on assets indicates that every $1 invested in assets, the company produced 10.23 cents of net income.
  • Return on equity indicates that for every $1 invested in equity, it generated 21.49 cents of earnings.
  • Debt/Equity means that for every dollar in equity COP has 42 cents in leverage. 
  • Return on invested capital means the percent of return on the invested capital.
  • Interest coverage means the company has the ability to pay its current interest in cash 13 times more on due date.

Interpretation

The company’s financial ratios were impressive. The company is healthy and profitable.

 

5. COP KEY EXECUTIVE COMPENSATION

COP Key Executive Compensation

2014 2015 2016 2017 2018
Key Executive Compensation
Salary 5,653,527 5,671,032 5,818,782 5,868,032 6,046,315
Bonus 0 0 0 0 200,000
Annual other income 0 0 0 0 0
Restricted Stock Award 15,271,390 15,906,476 15,850,148 17,274,323 30,769,372
Securities options 13,426,434 13,892,148 10,602,130 11,492,442 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 8,992,090 6,457,004 6+904518 12,568,554 12,679,435
Other compensation 1,021,157 798,083 590,167 853,753 4,097,176
Total 60,785,066 49,678,375 48,458,456 55,612,133 67,594,977
Ryan M. Lance/Chairman of the Board and CEO
Salary 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000
Bonus 0 0 0 0 0
Annual other income 0 0 0 0 0
Restricted Stock Award 6,116,797 6,630,693 6,607,217 6,993,660 11,006,296
Securities options 5,790,798 5,790,780 4,419,261 4,652,424 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 3,568,640 2,524,160 2,638,400 4,596,800 4,868,800
Other compensation 467,776 301,786 245,437 327,393 372,815
Total 27,577,071 21,339,719 19,212,038 21,848,930 23,405,270
Don E Wallette/Executive VP and CFO
Salary 874,000 874,000 939,550 961,400 985,444
Bonus 0 0 0 0 1
Annual other income 0 0 0 0 0
Restricted Stock Award 1,800,494 1,951,740 1,944,837 2,264,449 3,563,725
Securities options 1,704,492 1,704,798 1,301,146 1,506,438 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,102,988 811,072 911,364 1,720,906 1,763,945
Other compensation 1,333,181 85,414 61,530 109,606 109,403
Total 7,878,314 6,518,635 7,406,824 9,498,081 10,272,497
Alan Hirshberg/EVP, Production Drilling & Projects
Salary 1,085,667 1,096,000 1,178,200 1,205,600 1,205,600
Bonus 0 0 0 0 0
Annual other income 0 0 0 0 0
Restricted Stock Award 3,219,979 2,761,283 2,751,504 3,203,706 5,040,839
Securities options 2,016,711 2,411,712 1,840,685 2,131,596 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,602,444 1,169,651 1,314,282 2,481,728 2,343,084
Other compensation 146,230 159,072 121,457 170,957 156,827
Total 11,747,432 8,787,738 9,468,653 9,632,808 12,970,551
Matthew J. Fox/EVP and COO
Salary 1,241,000 1,241,000 1,241,000 1,241,000 1,241,000
Bonus 0 0 0 0 0
Annual other income 0 0 0 0 0
Restricted Stock Award 2,884,300 3,126,619 3,115,552 3,297,776 5,189,837
Securities options 2,730,645 2,730,348 2,083,774 2,194,020 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 1,872,421 1,324,395 1,384,336 2,625,956 2,554,599
Other compensation 177,039 159,327 91,371 149,519 150,731
Total 9,323,404 8,707,373 8,330,391 9,946,434 9,394,458
Janet L Carrig/Former Senior VP, Legal General Counsel & Corporate ecretary
Salary 752,860 760,032 760,032 760,032 672,333
Bonus 0 0 0 0 0
Annual other income 0 0 0 0 0
Restricted Stock Award 1,249,820 1,436,141 1,431,038 1,514,732 2,383,843
Securities options 1,183,788 1,254,510 957,264 1,007,964 0
LTIP Payout 0 0 0 0 0
Non-Equity Compensation 845,597 627,726 656,136 1,143,164 806,641
Other compensation 96,931 92,484 70,372 96,278 3,281,368
Total 4,258,845 4,324,910 4,040,550 4,685,880 7,144,185
Kelly Brunetti Rose/Senior VP, Legal General Counsel & Corporate Secretary
Salary 241,938
Bonus 200,000
Annual other income 0
Restricted Stock Award 3,583,832
Securities options 0
LTIP Payout 0
Non-Equity Compensation 342,366
Other compensation 26,031
Total 4,407,016

Facts:

  • The total key executive compensation was $67.594,977 in 2018.
  • Ryan M. Lance, Chairman of the Board and CEO compensation was $23,405,270 in 2018.
  • Don E. Wallette, EVP and CFO compensation was $10,292,497 in 2018.
  • Alan Hirshberg, EVP Production Drilling and Project compensation was $12,970,551 in 2018.
  • Mathew J. Fox, EVP and COO compensation was $9,394,458 in 2018.
  • Janet L. Carrig, Former Senior VP, Legal General Counsel & Corporate Secretary compensation was $7,144,185 in 2018.
  • Kelly Brunetti Rose/Senior VP, Legal General Counsel & Corporate Secretary compensation was $4,407,016 in 2018.

Explanation

  • The total key executive compensation represents 0.94% of the net income.
  • CEO compensation represents 35% of the total key executive compensation.
  • CFO compensation represents 15% of the total key executive compensation.
  • EVP Production Drilling and Project compensation represents 19% of the total key executive compensation.
  • EVP and COO compensation represents 14% of the total key executive compensation.
  • Former Senior VP, Legal General Counsel & Corporate Secretary compensation represents 11% of the total key executive compensation.
  • Senior VP, Legal General Counsel & Corporate Secretary compensation represents 7% of the total key executive compensation.

Interpretation

The key executive compensation was  less than 1 percent which is fair enough for the compensation of the executives.

 

6. COP LOBBYING AND CONTRIBUTIONS

COP LOBBYING AND CONTRIBUTIONS

Period Amount Period Amount
2020 1,473,459 2008 8,459,053
2019 4,870,000 2007 4,089,568
2018 3,080,000 2006 2,038,291
2017 3,010,000 2005 5,218,084
2016 2,498,000 2004 2,670,438
2015 3,135,583 2003 1,380,000
2014 3,969,840 2002 1,157,000
2013 4,242,353 2001 878,639
2012 3,863,736 2000 1,235,159
2011 20,557,043 1999 1,340,812
2010 19,626,382 1998 10,000
2009 18,069,858

Explanation

ConocoPhillips has been spending annual lobbying and contributions since 1998. The amount varies annually. A Note from OpenSecrets is quoted as follows:

“NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on January 23, 2020 and includes spending from January 1 – December 31. Prior years include spending from January through December.”

Source: OpenSecret.org Center for Responsive Politics

 

7. COP FINANCIAL STRENGTH

COP FINANCIAL STRENGTH

DATA

Working capital 9,870,000,000
Total assets 70,514,000,000
Sales 32,567,000,000
EBIT 7,278,000,000
Market value of equity $52,348,000,000
Book value of total liabilities 35,533,000,000
Retained earnings 39,742,000,000

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets 0.1400 1.20 0.17
B – Retained Earnings / Total Assets 0.56 1.40 0.79
C – EBIT / Total Assets 0.10 3.30 0.34
D – Market Value of Equity / Book Value of Total Liabilities 1.47 0.60 0.88
E – Sales / Total Assets 0.46 1.0 0.46
Z-Score 2.64

 

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

 

Explanation:

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The Z-Score of COP was 2.64.  According to Dr. Edward Altman a grading scale of 1.8 – 3.0 is more likely to declare bankruptcy. The figures used above are based on the latest financial reports. The Altman score weights different profitability and liquidity metrics to arrive at the overall score. This measurement is not calculated for the purpose of estimating the company will declare bankruptcy but it helps in comparing other companies that have become insolvent.

Hence, this measurement categorized the profitability or return on investment, liquidity, leverage and the efficiency in operating.

Conclusion

ConocoPhillips has been in the industry for more than a century and has been managed successfully. The company is stable and has a strong balance sheet and is  profitable. 

CITATION

http://www.conocophillips.com/

https://www.opensecrets.org/federal-lobbying/clients/summary?cycle=2019&id=D000000303

https://www.morningstar.com/stocks/xnys/cop/quote

Researched and written by Criselda

PepsiCo Inc (PEP) Extended Graph Analysis

March 5th, 2020 Posted by Extended Analysis No Comment yet

Company Profile

PEP logo

PepsiCo is leading in the food and beverage multinational company, well known for its product diversification selling products in around 200 countries and territories. Their products caters to the tastes of their customers young and adults. They faced the challenge of providing their consumers nutritious food and beverages. Its main competitors is The Coca-Cola Company.

PepsiCo was founded by Caleb Bradham, headquartered in Purchase, Harrison, New York, United States. It is a public company registered under NASDAQ with ticker symbol PEP.

 

PepsiCo (PEP) Extended Graph Analysis

 

1. PEP CASH FLOW

PEP CASH FLOW

2015 2016 2017 2018 2019 TTM
Net cash flow provided by operating activites 10,580,000,000 10,404,000,000 9,994,000,000 9,415,000,000 9,649,000,000 9,649,000,000
Net cash used for investing activities -3,569,000,000 -7,148,000,000 -4,403,000,000 4,564,000,000 -6,437,000,000 -6,437,000,000
Net cash provided by (used for) financing activities -3,828,000,000 -2,942,000,000 -4,186,000,000 -13,769,000,000 -8,489,000,000 -8,489,000,000
Capital expenditure -2,758,000,000 -3,040,000,000 -2,969,000,000 -3,282,000,000 -4,232,000,000 -4,232,000,000
Free cash flow 7,822,000,000 7,364,000,000 7,025,000,000 6,133,000,000 5,417,000,000 5,417,000,000
Working Capital 5,453,000,000 5,954,000,000 10,525,000,000 -245,000,000 -2,816,000,000 -2,816,000,000

Facts:

  • Cash from operating activities was $9.649 billion in the trailing twelve months.
  • Cash used for investing activities was -$6.437 billion in the trailing twelve months.
  • Net cash from financing activities was -$8.489 billion in the trailing twelve months.
  • Capital expenditure was -$4.232 billion in the trailing twelve months.
  • Free cash flow was $5.417 billion in the trailing twelve months.
  • Working capital was -$2.816 billion in the trailing twelve months.

Explanation:

  • Cash from operating increased 2.49% from 2018 to trailing twelve months.
  • Investing activities were purchase of property, plant and equipment and acquisitions.
  • Financing activities were debt repayment, common stock repurchased and dividend payments.
  • Capital expenditure was investment in property, plant and equipment.
  • Free cash flow decreased 12 percent from 2018.
  • Working capital was negative from 2018, current liabilities were higher than the current assets.

Interpretation

The company was able to provide cash from its operating activities in the last five years. PEP had a number of business acquisitions in recent years as one of their strategic moves.

 

2. PEP BALANCE SHEET

PEP BALANCE SHEET

2015 2016 2017 2018 2019
Total cash 12,009,000,000 16,125,000,000 19,510,000,000 8,993,000,000 5,738,000,000
Current Assets 23,031,000,000 27,089,000,000 31,027,000,000 21,893,000,000 17,645,000,000
Net property, plant and equipment 16,317,000,000 16,591,000,000 17,240,000,000 17,589,000,000 20,853,000,000
Total non-current assets 46,636,000,000 47,040,000,000 48,777,000,000 55,755,000,000 60,902,000,000
Total assets 69,667,000,000 74,129,000,000 79,804,000,000 77,648,000,000 78,547,000,000
Current liabilities 17,578,000,000 21,135,000,000 20,502,000,000 22,138,000,000 20,461,000,000
Non-current liabilities 40,166,000,000 41,899,000,000 48,413,000,000 40,992,000,000 43,300,000,000
Total liabilities 57,744,000,000 63,034,000,000 68,915,000,000 63,130,000,000 63,761,000,000
Retained earnings 50,472,000,000 52,518,000,000 52,839,000,000 59,947,000,000 61,946,000,000
Stockholders equity 11,923,000,000 11,095,000,000 10,889,000,000 14,518,000,000 14,786,000,000

Facts:

  • Total cash was $5.738 billion in 2019.
  • Current assets were $17.645 billion in 2019.
  • Net property, plant and equipment was $20.853 in 2019.
  • Total non-current assets were $60.902 billion in 2019.
  • Total assets were $78.547 billion in 2019.
  • Current liabilities were $20.641 billion in 2019.
  • Non-current liabilities were $43.300 in 2019.
  • Total liabilities were $63.761 in 2019.
  • Retained earnings were $61.946 in 2019.
  • Stockholders equity was $14.786 in 2019

Explanation:

  • Total cash represents 7.31% of total assets.
  • Current assets represent 22.46% of total assets.
  • Net property, plant and equipment represents 26.55% of total assets.
  • Total non-current assets represent 77.54% of total assets.
  • Total assets grew 13% in five years.
  • Current liabilities represent 32% of total liabilities.
  • Non-current liabilities represent 68% of total liabilities.
  • Total liabilities represents 81% to total liabilities and equity.
  • Stockholder equity represents 19% of total liabilities and equity.

Interpretation

The company is highly leveraged, using four-fifth of creditors money in its business operation, nearly 20% of investors money is utilized in the operation. In other words, the creditors have more stake than the investors. 

 

3. PEP INCOME AND MARKET

PEP INCOME AND MARKET

2015 2016 2017 2018 2019 2020
Revenue 63,056,000,000 62,799,000,000 63,525,000,000 64,661,000,000 67,161,000,000 67,161,000,000
EBIT 9,712,000,000 9,785,000,000 10,509,000,000 10,110,000,000 10,291,000,000 10,291,000,000
Net Income 5,452,000,000 6,329,000,000 4,857,000,000 12,515,000,000 7,314,000,000 7,314,000,000
EBITDA 10,828,000,000 12,263,000,000 13,122,000,000 13,113,000,000 12,879,000,000 12,879,000,000
Market Capitalization 144,684,000,000 150,059,000,000 170,543,000,000 155,666,000,000 190,108,000,000 197,550,000,000
Intrinsic Value 209,836,396,353 745,025,154,189 839,073,420,473 2,631,653,205,144 4,029,094,790,996 4,718,747,139,220

Facts:

  • Revenue was $67.161 billion in trailing twelve months.
  • EBIT was $10.291 billion in the trailing twelve months.
  • Net income was $7.314 billion in the trailing twelve months.
  • EBITDA was $12.879 billion in the trailing twelve months.
  • The market capitalization was $197.550 billion.
  • Intrinsic value was $4.719 trillion in the trailing twelve months.

Explanation:

  • Revenue grew 7% in five years and from 2018 it grows 3.87%.
  • EBIT grew 6% in five years and shows an increase of 1.79% from 2018.
  • Net income grew 34% in five years. It has a negative growth of 41.56% from 2018.
  • EBITDA grew 19% in five years. It has a negative growth from 2018 at 1.78%.
  • Market capitalization was erratic in movement in the last five years and it increased 4% from 2019 to the last quarter.
  • The calculated intrinsic value shows a very high value at $4.719 trillion.

Interpretation

The company is investing heavily in advertising and marketing, the reason its sales, general and administrative expense was high at 72% of gross profit which impacted the net income.

 

4. PEP FINANCIAL RATIOS

PEP FINANCIAL RATIOS

2015 2016 2017 2018 2019 2020
Asset turnover (average) 0.90 0.87 0.83 0.82 0.86 0.86
Return on assets % 7.77 8.79 6.31 15.89 9.37 9.37
Return on equity % 37.20 55.14 44.32 98.66 49.92 49.92
Debt/Equity 2.46 2.72 3.12 1.95 1.97 1.97
Return on invested capital % 13.38 15.55 11.00 27.64 17.11 17.11
Interest coverage 8.67 7.37 9.34 7.03 9.20 9.20

Facts:

  • Asset turnover was 0.86 in the trailing twelve months.
  • Return on asset was 9.37% in the trailing twelve months.
  • Return on equity was 49.92% in the trailing twelve months.
  • Return on invested capital was 17.11% in the trailing twelve months.
  • Interest coverage was 9.20 in the trailing twelve months.

Explanation:

  • Asset turnover means that the company is generating $0.86 of sales for every $1 investment in assets.
  • Return on assets means for every $1 invested in assets the company generates 9.37 cents of net income.
  • Return on equity indicates that for every $1 of shareholders equity, PEP generated 49 or 50 cents in profit.
  • Return on invested capital indicates that the invested capital yielded 17.11 percent of return.
  • Interest coverage indicates that the company earns 9 times earnings than its current interest payment.

Interpretation

The company’s financial ratios show acceptable ratios. The company is liquid

 

5. PEP KEY EXECUTIVE COMPENSATION

PEP KEY EXECUTIVE COMPENSATION

Name/Title 2014 2015 2016 2017 2018
Key Executive Compensation 37,399,250 48,405,262 56,275,124 63,116,455 65,489,721
Indra K. Nooy/ Chairman of the Board and Chief Executive Officer 22,485,574 26,444,990 29,783,416 31,082,648 24,491,117
Ramon L Laquarta/Chairman of the Board and CEO 5,655,039 6,113,574 10,157,245 10,827,396
Albert P. Carey/CEO North America 7,712,149 7,744,388 10,071,299 10,160,310 7,868,118
Laxman Narasimhan/Global Chief Commercial Officer and CEO Latin America 7,009,990
Silviu Popovici/CEO Europe Sub Saharan Africa 6,151,034
Hugh F. Johnston/Vice Chairman, Executive Vice President and Chief Financial Officer 7,201,527 8,560,845 10,306,835 11,716,252 9,142,066

Facts:

  • The key executive compensation was $65,489,721 in 2018.
  • The CEO compensation was $24,491,117 in 2018.
  • Chairman of the Board and CEO compensation was $10,827,396 in 2018.
  • CEO North America compensation was $7,868,118 in 2018.
  • Chief Commercial Officer and CEO Latin America compensation was $7,009,990 in 2018.
  • CEO Europe Sub Saharan Africa compensation was 6,151,034 in 2018.
  • Vice Chairman, Executive Vice President and Chief Financial Officer compensation was $9,142,066 in 2018.

Explanation:

  • The total key executive compensation represents 0.90% of net income.
  • CEO compensation represents 37.40% of the total key executive compensation.
  • Chairman of the Board and CEO compensation represents 16.53% of the total key executive compensation.
  • CEO North America compensation represents 12% of the total key executive compensation.
  • Chief Commercial Officer and CEO Latin America compensation represents 11% of the total key executive compensation.
  • CEO Europe Sub Saharan Africa compensation represents 9.39% of the total key executive compensation.
  • Vice Chairman, Executive Vice President and Chief Financial Officer compensation represents 14% of the total key executive compensation.

Interpretation

The company’s key executive compensation represents 0.90% of the net income.

 

6. PEP LOBBYING AND CONTRIBUTIONS

PEP LOBBYING AND CONTRIBUTIONS

Period USD Period USD
1998 960,000 2009 9,373,000
1999 1,300,000 2010 6,874,800
2000 1,320,000 2011 3,260,000
2001 1,035,000 2012 3,330,000
2002 960,000 2013 3,720,000
2003 860,000 2014 3,510,000
2004 720,000 2015 4,470,000
2005 740,000 2016 3,140,000
2006 880,318 2017 2,880,000
2007 1,000,636 2018 3,470,000
2008 1,096,000 2019 3,490,000

Explanation:

PepsiCo has been spending annual lobbying and contributions since 1998. The amount varies annually. NOTE: Figures on this page are calculations by the Center for Responsive Politics based on data from the Senate Office of Public Records. Data for the most recent year was downloaded on January 23, 2020 and includes spending from January 1 – December 31. Prior years include spending from January through December.

Source: OpenSecret.org Center for Responsive Politics

 

6. PEP FINANCIAL STRENGTH

PEP FINANCIAL STRENGTH

DATA

Working capital -$2,816,000,000
Total assets $78,547,000,000
Sales $67,161,000,000
EBIT $10,291,000,000
Market value of equity $197,550,000,000
Book value of total liabilities $63,761,000,000
Retained earnings $61,946,000,000

 

CALCULATION

Ratio Score Result
A – Working Capital / Total Assets -0.0359 1.20 -0.04
B – Retained Earnings / Total Assets 0.79 1.40 1.10
C – EBIT / Total Assets 0.13 3.30 0.43
D – Market Value of Equity / Book Value of Total Liabilities 3.10 0.60 1.86
E – Sales / Total Assets 0.86 1.0 0.86
Z-Score 4.21

 

Formula: Z-Score = 1.2A + 1.4B + 3.3C + 0.6D + 1.0E

 

Explanation

Z-Score is a statistical measurement that compares data points from different sets of data to find correlations. This measurement by Dr. Edward Altman is a significant measure in determining the financial strength of the company because it relies on different weighted financial liquidity and profitability metrics to come up with the overall score. This measure indicates the probability of bankruptcy.

Interpretation

The overall Z-Score of PEP was 4.21, the grading scale for 3.00 and over according to Altman indicates that the company will not declare bankruptcy. This measurement is not calculated for the purpose of estimating the company will declare bankruptcy but it helps in comparing other companies that have become insolvent.

Conclusion

PepsiCo was liquid and has great potential for accelerating its revenue in the long run due to its diversification strategy. The company manufactures and sells a variety of food and beverages that caters to young people and adults. Although the company is highly leveraged, PEP is stable and has a strong financial strength.

CITATION

https://www.opensecrets.org/federal-lobbying/firms/summary?cycle=1998&id=D000000200

https://www.pepsico.com/about/about-the-company

https://www.morningstar.com/stocks/xnas/pep/quote

Researched and written by Criselda

Chevron Corp (CVX) Extended Graph Analysis

February 20th, 2020 Posted by Extended Analysis No Comment yet

Company Profile

CVX logo

Chevron Corporation is a public multinational energy corporation traded as NYSE:CVX, headquartered in San Ramon, California USA. Chevron and was founded on September 10, 1879. CVX is one of the largest oil companies as of 2019. The company produced fuel products, base oils and process oils, lubricants, chemicals, aviation fuels and marine fuels. The company is engaged in hydrocarbon exploration and production and refining. 

 

Chevron Corp (CVX) Extended Graph Analysis

1. CVX CASH FLOW

CVX CASH FLOW

2014 2015 2016 2017 2018 2019
Net cash flow provided by operating activities 31,475,000,000 19,456,000,000 12,846,000,000 20,515,000,000 30,618,000,000 30,808,000,000
Net cash provided by (used for) financing activities -4,999,000,000 2,815,000,000 25,000,000 -14,554,000,000 -13,699,000,000 -15,243,000,000
Net cash used for investing activities -29,893,000,000 -23,808,000,000 -16,852,000,000 -8,201,000,000 -12,290,000,000 -13,468,000,000
Capital expenditure -35,407,000,000 -29,504,000,000 -18,109,000,000 -13,404,000,000 -13,792,000,000 -13,897,000,000
Free cash flow -3,932,000,000 -10,048,000,000 5,263,000,000 7,111,000,000 16,826,000,000 16,911,000,000

Facts:

  • Net cash flow provided by operating activities were $30.8 billion in the trailing twelve months.
  • Net cash used for investing activities was -$13.5 billion in the trailing twelve months.
  • Cash provided by (used for) financing activities was -$15 billion in the trailing twelve months.
  • Capital expenditure was -$13.9 billion in the trailing twelve months.
  • Free cash flow was $16.9 billion in the trailing twelve months.

Explanation

  • Net income and depreciation have a significant amount in cash provided by operating activities.
  • Cash used for investing activities were investment in property, plant and equipment, and purchases of investment.
  • Cash provided by (used for) financing activities were debt issued and repayment, and dividend payments.
  • Capital expenditure is investment in property, plant and equipment.
  • Free cash flow had less one percent increase from 2018 to the trailing twelve months.

Interpretation

CVX was able to provide cash from operations in the last five years. Moreover, the company was able to generate a free cash flow from 2017 to the trailing twelve months.

 

2. CVX BALANCE SHEET

CVX BALANCE SHEET

2014 2015 2016 2017 2018 2019
Total cash 13,215,000,000 11,332,000,000 7,001,000,000 4,822,000,000 10,345,000,000 11,755,000,000
Current Assets 42,232,000,000 35,347,000,000 29,619,000,000 28,560,000,000 34,021,000,000 33,988,000,000
Net property, plant and equipment 183,173,000,000 188,396,000,000 182,186,000,000 177,712,000,000 169,207,000,000 164,363,000,000
Total non-current assets 223,794,000,000 230,756,000,000 230,459,000,000 225,246,000,000 219,842,000,000 222,549,000,000
Total assets 266,026,000,000 266,103,000,000 260,078,000,000 253,806,000,000 253,863,000,000 256,537,000,000
Current liabilities 31,926,000,000 26,464,000,000 31,785,000,000 27,737,000,000 27,171,000,000 30,233,000,000
Non-current liabilities 79,072,000,000 86,923,000,000 82,737,000,000 77,945,000,000 72,138,000,000 70,463,000,000
Total liabilities 110,998,000,000 113,387,000,000 114,522,000,000 105,682,000,000 99,309,000,000 100,696,000,000
Retained earnings 184,987,000,000 181,578,000,000 173,046,000,000 174,106,000,000 180,987,000,000 183,783,000,000
Stockholders equity 155,028,000,000 152,716,000,000 145,556,000,000 148,124,000,000 154,554,000,000 155,841,000,000

Facts:

  • Total cash was $11.8 billion in Q3 2019.
  • Current assets were $34 billion in Q3 2019.
  • Net property, plant and equipment was $164 billion in Q3 2019.
  • Total non-current assets were $223 billion in Q3 2019.
  • Total assets were $257 billion in Q3 2019.
  • Current liabilities were $30 billion in Q3 2019.
  • Non-current liabilities were $70 billion in Q3 2019.
  • Total liabilities were $107 billion in Q3 2019.
  • Retained earnings were $184 billion in Q3 2019.
  • Stockholders equity was $156 billion in Q3 2019.

Explanation

  • Total cash was erratic in movement in the last five years. It grows 14 percent from 2018. It represents 35 percent of current assets.
  • Current assets were erratic in movement in the last five years. It represents 13 percent of total assets.
  • Net property, plant and equipment represents 74 percent of total non-current assets.
  • Total non-current assets represents 87 percent of total assets.
  • Total assets grew 1 percent from 2018.
  • Current liabilities represent 30 percent of total liabilities.
  • Non-current liabilities represent 70 percent of total liabilities.
  • Total liabilities was 39 percent of total liabilities and stockholders equity.
  • Retained earnings was 118 percent of equity.
  • Stockholders equity represents 61 percent of total liabilities and shareholders equity.

Interpretation

The balance sheet is liquid. The company’s current assets are sufficient for its current obligations. CVX is using more of the shareholders investment than the sources from creditors in the usual business operations. In other words the shareholders have more stake than the creditors in the trailing twelve months.

3. CVX INCOME AND MARKET

CVX INCOME AND MARKET

2014 2015 2016 2017 2018 2019
Revenue 200,494,000,000 129,925,000,000 110,215,000,000 134,674,000,000 158,902,000,000 145,629,000,000
EBIT 19,726,000,000 -3,710,000,000 -6,216,000,000 2,480,000,000 14,446,000,000 13,295,000,000
Net Income 19,241,000,000 4,587,000,000 -497,000,000 9,195,000,000 14,824,000,000 13,264,000,000
Market Capitalization 211,347,120,000 169,378,000,000 222,190,000,000 237,783,000,000 207,010,000,000 202,588,000,000
Intrinsic Value 209,073,862,419 212,683,314,721 333,795,619,400 423,503,597,323 716,272,790,115 995,200,421,499

Facts:

  • Revenue was $146 billion in the trailing twelve months.
  • EBIT was $13 billion in the trailing twelve months.
  • Net income was $13 billion in the trailing twelve months.
  • The market capitalization was $202.588 billion in the trailing twelve months.
  • Intrinsic value was $995 billion in the trailing twelve months.

Explanation:

  • Revenue was erratic in movement. It was down 8 percent from 2018.
  • EBIT represents 9 percent of revenue in the trailing twelve months.
  • Net income was 9 percent of revenue in the trailing twelve months.
  • Market capitalization was erratic in movement in the last five years. It shows a decrease of 2 percent from 2018.
  • Intrinsic value was higher than the market capitalization by 3x in the trailing twelve months.

Interpretation

The company was able to generate sufficient revenue for the operation of the business in the trailing twelve months.

 

4. CVX FINANCIAL RATIOS

CVX FINANCIAL RATIOS

2014 2015 2016 2017 2018 TTM
Asset turnover (average) 0.77 0.49 0.42 0.52 0.63 0.57
Return on assets % 7.4 1.72 -0.19 3.58 5.84 5.17
Return on equity % 12.65 2.98 -0.33 6.26 9.8 8.57
Debt/Equity 0.15 0.22 0.24 0.23 0.19 0.16
Return on invested capital % 10.92 2.45 -0.2 5.02 8.17 7.31
Interest coverage 0 0 -9.75 31.04 28.51 24.25

Facts:

  • Asset turnover was averaging 0.57 in the trailing twelve months.
  • Return on asset was 5.17 percent in the trailing months.
  • Return on equity was $8.57 percent in the trailing twelve months.
  • Debt/Equity was 0.16 in the trailing twelve months.
  • Return on invested capital was 7.31 percent in the trailing twelve months.
  • Interest coverage was 24.25 in the trailing twelve months.

Explanation

  • Asset turnover indicates that for every dollar invested in assets, the company generates 57 cents of sales.
  • Return on asset indicates that for every dollar invested in assets, CVX generated 5.17 cents of net income.
  • Return on equity indicates that for every dollar of the capital that the shareholders invested, the company generates 8.57 cents profit.
  • Debt to Equity indicates that the company has $0.16 debt for every dollar of assets.
  • Return on invested capital indicates that the company generated a 7.31 percent return from the company’s investments.
  • The interest coverage indicates that the company has the ability to make interest payments on its debt in due date.

Interpretation

The company has the ability to generate cash for its daily business operations. CVX is using more of the investors money than creditors.

 

5. CVX KEY EXECUTIVE COMPENSATION

CVX KEY EXECUTIVE COMPENSATION

2014 2015 2016 2017 2018
Key Executive Compensation 44,239,015 46,489,214 57,690,075 64,632,139 55,846,538
John S. Watson/Chairman of the Board and Chief Executive Officer 25,970,417 22,029,809 24,657,491 24,781,568 1,241,499
Patricia E. Yarrington/Vice President and Chief Financial Officer 9,781,357 7,379,867 6,541,425 8,152,053 7,159,079
Michael K. Wirth/Vice Chairman of the Board and Executive Vice President, Midstream & Development 8,487,241 8,123,840 9,129,645 11,669,681 20,640,623
James William Johnson/Executive Vice President, Upstream 8,955,698 9,416,320 11,024,515 10,925,982
Pierre R. Breber/Executive Vice President, Downstream & Chemicals 8,030,044
Joseph C. Geagea/Executive Vice President, Technology, Projects and Services 7,945,194 9,004,322 7,849,411

Facts:

  • Total key executive compensation was $55,846,538 in 2018.
  • Chairman of the Board and CEO compensation was $1,241,499 in 2018.
  • Vice President and CFO compensation was $7,159,079 in 2018.
  • Vice Chairman of the Board and EVP Mainstream & Development compensation was $20,640,623 in 2018.
  • EVP Upstream compensation was $10,925,982 in 2018.
  • EVP Downstream and Chemicals compensation was $8,030,044 in 2018.
  • EVP Technology, Projects and Services compensation was $7,849,411 in 2018.

Explanation:

  • The key executive total compensation represents 0.38 percent of net income in 2018.
  • Chairman of the Board and CEO compensation represents 2 percent of the total key executive compensation.
  • Vice President and CFO compensation represents 13 percent of the total key executive compensation in 2018.
  • Vice Chairman of the Board and EVP Mainstream & Development compensation represents 37 percent of the total key executive compensation in 2018.
  • EVP Upstream compensation represents 20 percent of the total key executive compensation in 2018.
  • EVP Downstream and Chemicals compensation represents 14 percent of the total key executive compensation in 2018.
  • EVP Technology, Projects and Services compensation  represents 14 percent of the total key executive compensation in 2018.

Interpretation

The company is spending less than one percent of its net income in its key executive compensation.

 

6. CVX LOBBYING AND CONTRIBUTIONS

CVX LOBBYING AND CONTRIBUTIONS

PERIOD USD PERIOD USD
2019 9,270,000 2008 12,994,000
2018 9,600,000 2007 9,030,000
2017 9,290,000 2006 7,480,000
2016 7,470,000 2005 9,490,000
2015 7,200,000 2004 5,220,000
2014 8,280,000 2003 4,620,000
2013 10,530,000 2002 4,620,000
2012