Analysis
mauridelostapas
NewMicrosoftExcelWorksheet.xlsxSheet1
| Apple | Microsoft | Starbucks | DowPont Inc. | Amazon | Adobe | Home Depot | SAP | Caterpillar | ||
| no of shares outstanding | 4,745,398,000 | 7,700,000,000 | 1,309,100,000 | 2,254,762,058 | 695,297,530 | 491,202,890 | 491,578,529 | 1,103,903,507 | 1,228,502,232 | 590,972,792 |
| Return on equity (ROE) | 55.53% | 23.02% | 384.27% | 4.06% | 20.15% | 36.35% | 30.62% | -592.17% | 13.30% | 44.65% |
| dividends per share | 2.72 | 1.68 | $1.3318 | $1.5483 | $0.0000 | $0.0000 | $0.0000 | $4.2576 | $1.7000 | $3.0983 |
| net income | 59,500,000,000.00 | 16,571,000,000.00 | 4,518,300,000.00 | 3,844,000,000.00 | 30,736,000,000.00 | $10,073,000,000.00 | $2,590,774,000.00 | $11,121,000,000.00 | $4,083,000,000.00 | $6,147,000,000.00 |
| Shareholders Equity | 107147000000 | 71997000000 | 1175800000 | $94,571,000,000.00 | 152502000000 | 27709000000 | 8459869000 | -1878000000 | 30704000000 | 13766000000 |
| Total dividends paid | 12907482560 | 12936000000 | 1743400000 | 3491000000 | 0 | 0 | 0 | 4700000000 | 2088453794 | 1831000000 |
| dividend payout ratio | 21.69% | 78.06% | 38.59% | 90.82% | 0.00% | 0.00% | 0.00% | 42.26% | 51.15% | 29.79% |
| plowback ratio | 78.31% | 21.94% | 61.41% | 9.18% | 100.00% | 100.00% | 100.00% | 57.74% | 48.85% | 70.21% |
| sustainable growth rate | 43.48% | 5.05% | 236.00% | 0.37% | 20.15% | 36.35% | 30.62% | -341.91% | 6.50% | 31.35% |
| PE ratio | 16.26 | 57.33 | 22.04 | 22.88 | 27.97 | 90.78 | 51.34 | 20.41 | 33.99 | 13.78 |
| Apple | Microsoft | Starbucks | DowPont Inc. | Amazon | Adobe | Home Depot | SAP | Caterpillar | ||
| Shareholders' equity | $ 107,147,000,000.00 | $ 71,997,000,000.00 | $ 1,175,800,000.00 | $94,571,000,000.00 | $ 152,502,000,000 | $ 27,709,000,000 | $ 8,459,869,000 | $ (1,878,000,000) | $ 30,704,000,000 | $ 13,766,000,000 |
| Operating Cash flows | $ 77,434,000,000.00 | $ 43,884,000,000.00 | $ 11,937,800,000.00 | $ 4,731,000,000 | $ 47,971,000,000 | $ 30,723,000,000 | $ 4,029,304,000 | $ 13,038,000,000 | $ 4,302,000,000 | $ 6,558,000,000 |
| Sales Revenue | $ 265,595,000,000.00 | $ 110,360,000,000.00 | $ 24,719,500,000.00 | $ 85,977,000,000 | $ 136,819,000,000 | $ 232,887,000,000 | $ 9,030,008,000 | $ 108,203,000,000 | $ 24,708,000,000 | $ 54,722,000,000 |
| Current Stock price | $ 203.86 | $ 123.37 | $ 76.06 | $ 39.00 | $ 1,236.37 | $ 1,861.69 | $ 270.57 | $ 205.66 | $ 112.97 | $ 143.36 |
| Apple | Microsoft | Starbucks | Toyota | Amazon | Adobe | Home Depot | SAP | Caterpillar | ||
| Price to Book ratio | $9.03 | $13.19 | $84.68 | $0.93 | $5.64 | $33.00 | $15.72 | -$120.89 | $4.52 | $6.15 |
| Price to sales ratio | $3.64 | $8.61 | $4.03 | $1.02 | $6.28 | $3.93 | $14.73 | $2.10 | $5.62 | $1.55 |
| Price to Cash flow ratio | $12.49 | $21.65 | $8.34 | $18.59 | $17.92 | $29.76 | $33.01 | $17.41 | $32.26 | $12.92 |
| Apple | Microsoft | Starbucks | DowPont Inc. | Amazon | Adobe | Home Depot | SAP | Caterpillar | ||
| Three year's EPS growth | 10.83% | 13.29% | 23.78% | -34.80% | 24.62% | 154.09% | 61.98% | 28.84% | 5.38% | 35.51% |
| SGR | 43.48% | 5.05% | 236.00% | 0.37% | 20.15% | 36.35% | 30.62% | -341.91% | 6.50% | 31.35% |
| EPS 2018 | 12.54 | 2.15 | 3.45 | 1.70 | 44.21 | 20.51 | 5.27 | 10.07 | 3.32 | 10.40 |
| EPS 2015 | 9.21 | 1.48 | 1.82 | 6.15 | 22.84 | 1.25 | 1.24 | 4.71 | 2.84 | 4.18 |
P/E and Growth rate comparison
P/E and Growth rate comparison 16.258770357647059 57.325991189427313 22.037081645751723 22.876097882934442 27.968668895305175 90.78402742818426 51.338481315440866 20.414422736230556 33.990667927758999 13.782635344252483 0.4348466820349613 5.0488214786727235E-2 2.3600102058173156 3.7326453141026299E-3 0.20154489777183249 0.36352809556461801 0.30624280352331695 -3.4190628328008517 6.4960467886920267E-2 0.31352607874473343
P/E ratio
Growth rate
price ratios
Price to Book ratio Apple Microsoft Starbucks Toyota Google Amazon Adobe Home Depot SAP Caterpillar 9.0286880293428666 13.194285873022487 84.682893349209053 0.92983811381924697 5.6369425133185134 33.002544598653863 15.722040446670038 -120.88860236933972 4.5200591828113605 6.154428262466948 Price to sales ratio Apple Microsoft Starbucks Toyota Google Amazon Adobe Home Depot SAP Caterpillar 3.6423759343361137 8.6077292497281626 4.0279999999999996 1.0227819098363515 6.2830820804573921 3.9266575991107273 14.729378156866527 2.0981746832307793 5.6169620021466731 1.5482230083169477 Price to Cash flow ratio Apple Microsoft Starbucks Toyota Google Amazon Adobe Home Depot SAP Caterpillar 12.493179175555959 21.646818886154406 8.3407450283971922 18.587131740012683 17.920097708325862 29.764915805230608 33.009771065059873 17.412854367972081 32.260320118326362 12.918856276474537
The diagram does not show any relationship between P/E ratio and Growth rate
The ratios show a positive relationship as they are moving in the same direction. when P/B ratio increases, P/S and P/CF ratio also show a increase and vice versa.
The SGR is no correlated with Three year's earnings. The above table shows that there is huge difference between SGR values and three year's earnings growth.
