can someone put this information into a google sheet or Exel and email/share it with the me. The email is deviceseller92@gmail.com
1. Dividend yield = annual dividend per share/current share price. From annual report, quarterly yield prrcentage is given, which can be used to arrive at annual yield prrcentage Annual (Q1 +Q2 + Q3 +Q4)/4 (yield Year dividend(millions) percentage per annum) 2019 1159 2.25% 2018 1160 2.23% 2017 1005 2.78% 2016 866 3.35% 2015 721 2.52% 2.earnings per share: EPS = earnings available to equity share holders/market price per share. From annual reports of BOEING, Year EPS 2019 -$ 1.12 2018 $ 17.85 2017 $ 13.85 2016 $ 7.83 2015 $ 7.44 3. PE ratio is market price/Earnings per share Year PE ratio 2019 30.21 2018 19.78 2017 19.89 2016 18.65 2015 16.33 DATA Boeing 2019 2018 2017 2016 2015 Annual Revenue EPS Total Assets Total Liabilities Shareholder Equity Current Assets Current Liabilities Current Ratio 76,559 - 1.12 1,33,625 141,925 -8,300 102.23 97.31 1.05 1,01,127 17.85 1,17,359 1,16,949 410 87.83 81.59 1.08 94,005 13.85 1,12,362 1,10,649 1,713 85.19 74.65 1.14 93,496 7.83 89,997 89,120 877 62.49 50.13 96,114 7,44 94,408 88,011 6,397 68.23 50.41 1.35 2019 Amount % -24,568 -24.29% -18.97 -106.27% 16,266 13.86% 24,976 21.36% -8,710 2124.39% 14.40 16.40% 15.72 19.27% -0.03 -2.78% Increase / (Decrease) 2018 2017 Amount % Amount % 7,122 7.58% 509 0.54% 4.00 28.88% 6.02 76.88% 4,997 4.45% 22,365 24,85% 6,300 5.69% 21,529 24.16% -1,303 -76.07% 836 95.32% 2.64 3.10% 22.70 36.33% 6.94 9.30% 24.52 48.91% -0.06 -5.26% -0.11 -8.80% 2016 Amount % -2,618 -2.72% 0.39 5.24% -4,411 -4.67% 1,109 1.26% -5,520 -86.29% -5.74 -8.41% -0.28 -0.56% -0.10 -7.41% 1.25 Airbus 2019 2018 2017 2016 2015 2016 Annual Revenue EPS Total Assets Total Liabilities Shareholder Equity Current Assets Current Liabilities Current Ratio 78,935 -0.49 1,28,138 1,21429 6,700 121.43 6.71 18.10 75,238 1.16 1,36,049 1,24,571 11.478 124.57 11.48 10.90 75,467 1.05 1,28,783 1,13,692 15,091 113.09 15.00 7.50 73,679 0.36 1,22,980 1,18,939 4,041 118.94 4.04 29.40 71,565 0.95 1,18,459 1,11,826 6,632 111.83 6.63 16.90 Increase / (Decrease) 2019 2018 2017 Amount % Amount X Amount % 3,697 4.91% 229 0.30N 1,788 2,43% -1.65 -142.24% 0.11 10.48% 0.69 191.67% -7,911 -5.81% 7,266 5.64% 5,803 4.72% -3,142 -2.52% 10,879 9.57% -5,247 4.41% -4,769 41.55% -3,613 -23.94% 11,050 273,45% -3.14 -2.52% 10.88 9.57% -5.25 -4.41 -4.77 41.55 -3.61 -23.92% 11.05 273.51% 7.20 66.06% 3.40 45,33% 21.90 -74,49% Amount 2,114 -0.59 4,521 7,113 -2,591 7.11 -2.59 12.50 % 2.95% -62.11% 3.82% 6.36% -39.07 6.30N - 39.06% 73.96% 1. Dividend yield = annual dividend per share/current share price. From annual report, quarterly yield prrcentage is given, which can be used to arrive at annual yield prrcentage Annual (Q1 +Q2 + Q3 +Q4)/4 (yield Year dividend(millions) percentage per annum) 2019 1159 2.25% 2018 1160 2.23% 2017 1005 2.78% 2016 866 3.35% 2015 721 2.52% 2.earnings per share: EPS = earnings available to equity share holders/market price per share. From annual reports of BOEING, Year EPS 2019 -$ 1.12 2018 $ 17.85 2017 $ 13.85 2016 $ 7.83 2015 $ 7.44 3. PE ratio is market price/Earnings per share Year PE ratio 2019 30.21 2018 19.78 2017 19.89 2016 18.65 2015 16.33 DATA Boeing 2019 2018 2017 2016 2015 Annual Revenue EPS Total Assets Total Liabilities Shareholder Equity Current Assets Current Liabilities Current Ratio 76,559 - 1.12 1,33,625 141,925 -8,300 102.23 97.31 1.05 1,01,127 17.85 1,17,359 1,16,949 410 87.83 81.59 1.08 94,005 13.85 1,12,362 1,10,649 1,713 85.19 74.65 1.14 93,496 7.83 89,997 89,120 877 62.49 50.13 96,114 7,44 94,408 88,011 6,397 68.23 50.41 1.35 2019 Amount % -24,568 -24.29% -18.97 -106.27% 16,266 13.86% 24,976 21.36% -8,710 2124.39% 14.40 16.40% 15.72 19.27% -0.03 -2.78% Increase / (Decrease) 2018 2017 Amount % Amount % 7,122 7.58% 509 0.54% 4.00 28.88% 6.02 76.88% 4,997 4.45% 22,365 24,85% 6,300 5.69% 21,529 24.16% -1,303 -76.07% 836 95.32% 2.64 3.10% 22.70 36.33% 6.94 9.30% 24.52 48.91% -0.06 -5.26% -0.11 -8.80% 2016 Amount % -2,618 -2.72% 0.39 5.24% -4,411 -4.67% 1,109 1.26% -5,520 -86.29% -5.74 -8.41% -0.28 -0.56% -0.10 -7.41% 1.25 Airbus 2019 2018 2017 2016 2015 2016 Annual Revenue EPS Total Assets Total Liabilities Shareholder Equity Current Assets Current Liabilities Current Ratio 78,935 -0.49 1,28,138 1,21429 6,700 121.43 6.71 18.10 75,238 1.16 1,36,049 1,24,571 11.478 124.57 11.48 10.90 75,467 1.05 1,28,783 1,13,692 15,091 113.09 15.00 7.50 73,679 0.36 1,22,980 1,18,939 4,041 118.94 4.04 29.40 71,565 0.95 1,18,459 1,11,826 6,632 111.83 6.63 16.90 Increase / (Decrease) 2019 2018 2017 Amount % Amount X Amount % 3,697 4.91% 229 0.30N 1,788 2,43% -1.65 -142.24% 0.11 10.48% 0.69 191.67% -7,911 -5.81% 7,266 5.64% 5,803 4.72% -3,142 -2.52% 10,879 9.57% -5,247 4.41% -4,769 41.55% -3,613 -23.94% 11,050 273,45% -3.14 -2.52% 10.88 9.57% -5.25 -4.41 -4.77 41.55 -3.61 -23.92% 11.05 273.51% 7.20 66.06% 3.40 45,33% 21.90 -74,49% Amount 2,114 -0.59 4,521 7,113 -2,591 7.11 -2.59 12.50 % 2.95% -62.11% 3.82% 6.36% -39.07 6.30N - 39.06% 73.96%