Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | Dec'24 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EV/Gross Profit LTM | 2.3x | 2.6x | 2.3x | 2.2x | 2.3x | 2.9x | 2.8x | 4.0x | 4.2x | 5.2x | 4.7x | 4.4x | 7.7x | 6.0x | 8.2x | 8.9x | 11.6x | 8.2x | 8.7x | 8.7x |
Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | Dec'24 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 7,190.7 17.6% | 7,809.8 8.6% | 8,005.3 2.5% | 7,979.7 (0.3%) | 7,094.2 (11.1%) | 7,776.4 9.6% | 8,765.7 12.7% | 9,534.5 8.8% | 10,185.5 6.8% | 11,129.5 9.3% | 11,339.3 1.9% | 11,855.6 4.6% | 14,983.8 26.4% | 17,534.5 17.0% | 17,900.8 2.1% | 18,361.7 2.6% | 19,944.6 8.6% | 22,148.9 11.1% | 23,051.9 4.1% | 23,098.5 0.2% |
Cost of Goods Sold (COGS) | 4,110.3 | 4,395.1 | 4,407.0 | 4,480.9 | 3,831.1 | 4,295.3 | 5,021.1 | 5,312.2 | 5,569.0 | 5,965.0 | 5,780.1 | 5,933.3 | 8,202.6 | 10,115.9 | 9,864.7 | 9,679.1 | 11,401.9 | 12,823.8 | 12,293.8 | 11,903.4 |
% margin | 3,080.4 42.8% | 3,414.6 43.7% | 3,598.3 44.9% | 3,498.8 43.8% | 3,263.2 46.0% | 3,481.1 44.8% | 3,744.6 42.7% | 4,222.2 44.3% | 4,616.6 45.3% | 5,164.5 46.4% | 5,559.2 49.0% | 5,922.3 50.0% | 6,781.2 45.3% | 7,418.6 42.3% | 8,036.1 44.9% | 8,682.6 47.3% | 8,542.7 42.8% | 9,325.1 42.1% | 10,758.1 46.7% | 11,195.1 48.5% |
Operating Expenses | 2,326.2 | 2,512.9 | 2,597.5 | 2,643.6 | 2,626.2 | 2,731.9 | 2,960.8 | 3,195.6 | 3,467.7 | 3,823.0 | 3,913.5 | 4,159.4 | 4,992.2 | 5,351.9 | 5,587.7 | 5,791.3 | 5,882.0 | 6,331.6 | 7,065.4 | 7,422.1 |
Research & Development Expenses (R&D) | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 44.6 | 47.0 | 50.0 | 57.7 | 58.0 | 58.5 | 51.9 | 103.1 | 97.1 | 115.9 | 119.3 | 196.6 | 0.0 |
Selling, General & Administrative Expenses (SG&A) | 2,326.2 | 2,512.9 | 2,597.5 | 2,643.6 | 2,568.4 | 2,728.1 | 2,960.8 | 3,195.6 | 3,467.7 | 3,823.0 | 3,913.5 | 4,159.4 | 4,785.4 | 5,033.8 | 5,274.9 | 5,477.9 | 5,572.5 | 6,014.5 | 7,071.0 | 7,422.1 |
% margin | 807.1 11.2% | 926.6 11.9% | 1,031.2 12.9% | 614.6 7.7% | 480.2 6.8% | 576.8 7.4% | 606.6 6.9% | 855.0 9.0% | 960.9 9.4% | 1,123.5 10.1% | 1,412.2 12.5% | 1,562.3 13.2% | 1,793.7 12.0% | 1,862.7 10.6% | 2,418.5 13.5% | 2,858.3 15.6% | 2,583.3 13.0% | 2,979.4 13.5% | 3,517.2 15.3% | 3,773.0 16.3% |
Interest Income | 0.0 | 0.0 | 14.1 | 3.9 | 2.4 | 2.9 | 3.7 | 2.9 | 3.2 | 3.0 | 1.4 | 5.0 | 8.6 | 5.3 | 25.9 | 3.6 | 4.9 | 8.0 | 25.2 | (4.7) |
Interest Expense | 0.0 | 0.0 | 71.6 | 65.7 | 40.0 | 70.6 | 42.5 | 42.8 | 62.7 | 64.2 | 61.8 | 154.1 | 263.5 | 366.7 | 349.3 | 336.8 | 334.7 | 390.8 | 432.5 | 415.7 |
Pre-tax Income | 656.2 | 834.3 | 912.9 | 714.5 | 622.8 | 677.8 | 741.5 | 987.3 | 1,086.0 | 1,258.2 | 1,549.0 | 1,595.2 | 1,528.2 | 1,359.7 | 1,981.8 | 2,519.2 | 2,248.6 | 2,573.1 | 3,109.9 | 3,451.8 |
% effective tax rate | 191.6 29.2% | 258.3 31.0% | 297.4 32.6% | 237.6 33.3% | 187.0 30.0% | 215.3 31.8% | 299.7 40.4% | 307.1 31.1% | 333.4 30.7% | 392.3 31.2% | 495.1 32.0% | 462.5 29.0% | (285.6) (18.7%) | 250.9 18.5% | 440.5 22.2% | 488.8 19.4% | 384.2 17.1% | 553.0 21.5% | 721.1 23.2% | 770.4 22.3% |
% margin | 463.3 6.4% | 576.1 7.4% | 615.6 7.7% | 476.9 6.0% | 435.8 6.1% | 462.5 5.9% | 441.9 5.0% | 680.2 7.1% | 752.6 7.4% | 865.9 7.8% | 1,053.8 9.3% | 1,132.7 9.6% | 1,772.3 11.8% | 1,108.7 6.3% | 1,541.3 8.6% | 2,030.4 11.1% | 1,864.4 9.3% | 2,020.1 9.1% | 2,388.8 10.4% | 2,681.4 11.6% |
EPS | 1.13 | 1.44 | 1.61 | 1.36 | 1.28 | 1.43 | 1.41 | 2.21 | 2.47 | 2.98 | 3.79 | 4.11 | 6.36 | 3.97 | 5.60 | 7.48 | 7.10 | 7.83 | 9.35 | 10.68 |
Diluted EPS | 1.09 | 1.40 | 1.57 | 1.33 | 1.26 | 1.40 | 1.38 | 2.16 | 2.42 | 2.93 | 3.72 | 4.00 | 6.22 | 3.89 | 5.50 | 7.36 | 6.98 | 7.72 | 9.25 | 10.55 |
% margin | 959.3 13.3% | 1,072.5 13.7% | 1,148.1 14.3% | 945.7 11.9% | 833.7 11.8% | 923.7 11.9% | 964.9 11.0% | 1,129.3 11.8% | 1,339.4 13.2% | 1,483.0 13.3% | 1,820.4 16.1% | 1,882.9 15.9% | 2,249.8 15.0% | 2,508.6 14.3% | 3,310.5 18.5% | 3,869.8 21.1% | 3,566.9 17.9% | 3,974.1 17.9% | 4,149.9 18.0% | 3,773.0 16.3% |
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Discover the top 20 best undervalued large-cap growth stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Discover the top 20 best undervalued high-yield dividend stock that offers both growth potential and attractive dividend returns for Mar 2025.
As of today, Microsoft Corp's last 12-month EV/Gross Profit LTM is 8.7x, based on the financial report for Dec 30, 2024 (Q4’2024). The average annual EV/Gross Profit LTM for The Sherwin-Williams Company have been 8.8x over the past three years, and 9.0x over the past five years.
As of today, The Sherwin-Williams Company's EV/Gross Profit LTM is 8.7x, which is higher than industry median of 5.1x. It indicates that The Sherwin-Williams Company's EV/Gross Profit LTM is Bad.