Microsoft Corporation (MSFT) Financial Ratios Annual - Discounting Cash Flows
MSFT
Microsoft Corporation
MSFT (NASDAQ)
Period Ending: LTM
(Last Twelve Months)
2024
06-30
2023
06-30
2022
06-30
2021
06-30
2020
06-30
2019
06-30
2018
06-30
2017
06-30
2016
06-30
2015
06-30
2014
06-30
2013
06-30
2012
06-30
2011
06-30
2010
06-30
2009
06-30
2008
06-30
2007
06-30
2006
06-30
2005
06-30
2004
06-30
2003
06-30
2002
06-30
2001
06-30
2000
06-30
1999
06-30
1998
06-30
1997
06-30
1996
06-30
1995
06-30
1994
06-30
1993
06-30
1992
06-30
1991
06-30
1990
06-30
1989
06-30
1988
06-30
1987
06-30
1986
06-30
Price Ratios
Price to Earnings Ratio 38.72 38.51 35.04 26.47 33.37 34.97 26.53 45.82 20.95 19.74 29.61 15.68 13.16 15.13 9.54 10.81 14.59 14.51 20.41 19.3 21.97 37.77 36.51 36.36 53.08 43.88 58.24 58.69 43.7 32.51 39.01 27.51 27.5 27.38 27.09 30.29 14.72 23.26 35.42 19.95
Price to Sales Ratio 13.85 13.85 11.97 9.71 12.16 10.83 8.27 6.88 5.53 4.45 3.86 3.99 3.7 3.48 3.16 3.25 3.64 4.25 5.62 5.49 6.77 8.38 8.54 10.04 15.41 18.01 22.96 17.27 12.65 8.23 9.55 6.78 6.98 7.03 6.8 7.15 3.12 4.88 7.36 3.97
Price to Book Ratio 11.62 12.64 12.3 11.56 14.4 13.09 10.17 9.18 6.09 5.63 4.51 3.85 3.65 3.87 3.87 4.39 5.37 7.07 9.23 6.06 5.6 4.12 4.51 5.46 8.24 9.99 15.94 15.85 14.01 10.33 10.63 7.08 8.08 8.84 9.28 9.21 4.47 7.68 10.65 5.63
Price to Free Cash Flow Ratio 53.93 45.82 42.63 29.55 36.43 34.24 27.21 23.54 17.02 16.23 15.22 12.81 11.71 8.76 8.96 9.18 13.36 13.92 18.48 18.96 17.05 22.83 18.44 20.72 31.65 39.19 36.12 34.73 36.02 22.13 37.91 23.97 31.27 32.83 42.71 70.35 18.86 0 0 0
Price to Operating Cash Flow Ratio 28.63 28.63 28.95 21.62 26.64 25.52 19.95 17.3 13.51 12.17 12.17 10.65 9.98 8.12 8.18 8.42 11.17 11.87 16.13 16.88 16.21 21.09 17.4 19.62 29.05 36.18 34.52 31.25 32.19 19.19 28.48 19.79 24.4 21.37 22.47 30.38 11.28 0 0 0
Price Earnings to Growth Ratio 9.29 1.75 170 1.36 0.844 2.52 0.193 -2.13 0.716 0.467 -0.673 8.18 0.451 -0.582 0.338 0.352 -1.03 0.454 1.07 2.73 0.451 4.41 -13.14 8.36 -2.36 2.82 0.864 2.11 0.874 0.455 2.34 1.38 1.1 0.602 0.474 0.757 0.589 0.233 0 0
EV to EBITDA 22.53 25.7 24.27 19.23 24.29 22.56 18.04 15.61 13.03 10.57 12.43 8.58 7.42 8.32 6.01 6.42 8.15 16.78 16.73 18.69 8.8
Liquidity Ratios
Current Ratio 1.37 1.27 1.77 1.78 2.08 2.52 2.53 2.9 2.92 2.35 2.47 2.5 2.71 2.6 2.6 2.13 1.82 1.45 1.69 2.18 2.89 4.71 4.22 3.81 4.24 3.11 2.47 2.77 2.87 3.23 4.17 4.72 5.06 3.96 3.51 3.85 2.95 2.94 4.57 5.02
Quick Ratio 1.36 1.27 1.75 1.75 2.05 2.49 2.5 2.86 2.88 2.31 2.41 2.45 2.66 2.57 2.56 2.1 1.8 1.41 1.64 2.12 2.86 4.69 4.17 3.76 4.23 3.11 2.47 2.77 2.87 3.23 4.11 4.61 4.84 3.77 3.34 3.56 2.71 2.48 4.21 4.75
Cash Ratio 0.252 0.146 0.333 0.147 0.16 0.188 0.164 0.204 0.137 0.11 0.113 0.19 0.102 0.212 0.334 0.211 0.225 0.346 0.257 0.299 0.287 0.956 0.461 0.237 0.424 0.497 0.565 0.67 1.03 1.07 1.46 1.62 1.8 1.77 1.42 1.32 1.21 1.56 2.84 3.48
Debt Ratio 0.108 0.131 0.146 0.168 0.203 0.236 0.273 0.316 0.366 0.276 0.202 0.131 0.11 0.098 0.11 0.069 0.074 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.003 0.012 0.006 0.035 0.041 0.025 0.011
Debt to Equity Ratio 0.188 0.25 0.291 0.368 0.477 0.6 0.766 0.989 1.04 0.743 0.441 0.252 0.198 0.18 0.209 0.129 0.145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.004 0.014 0.007 0.045 0.054 0.03 0.014
Long Term Debt to Capitalization 0.11 0.137 0.169 0.22 0.261 0.335 0.394 0.466 0.464 0.36 0.258 0.187 0.138 0.139 0.173 0.097 0.087 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.008 0.013
Total Debt to Capitalization 0.158 0.2 0.225 0.269 0.323 0.375 0.434 0.497 0.511 0.426 0.306 0.201 0.165 0.153 0.173 0.114 0.127 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.004 0.014 0.007 0.043 0.051 0.029 0.013
Interest Coverage Ratio 49.43 37.29 44.98 40.42 29.8 20.44 15.99 12.83 13.06 20.98 23.25 46.5 62.39 57.27 92.07 159.6 535.9 210.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Cash Flow to Debt Ratio 2.16 1.77 1.46 1.45 1.13 0.855 0.666 0.536 0.431 0.623 0.841 1.44 1.85 2.65 2.26 4.05 3.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109.3 28.61 42.82 8.76 None None None
Margins
Gross Profit Margin 69.07% 69.76% 68.92% 68.4% 68.93% 67.78% 65.9% 65.25% 64.52% 64.04% 64.7% 68.82% 73.81% 76.22% 77.73% 80.16% 79.2% 80.8% 79.08% 82.72% 84.84% 81.77% 81.18% 81.7% 86.34% 86.92% 90.86% 90.59% 86.49% 91.83% 89.76% 88.69% 87.16% 87.16% 84.44% 82.56% 77.6% 77.66% 80.83% 82.23%
Operating Profit Margin 45.23% 44.64% 41.77% 42.06% 41.59% 37.03% 34.14% 31.77% 30.06% 28.61% 19.41% 31.97% 34.38% 29.52% 38.83% 38.57% 34.85% 36.86% 36.07% 37.2% 36.6% 24.53% 29.65% 41.99% 46.33% 47.94% 50.86% 43.97% 40.81% 35.5% 34.33% 37.13% 35.33% 36.1% 35.25% 33.23% 30.14% 31.72% 36.69% 30.84%
Pretax Profit Margin 43.8% 43.97% 42.14% 42.22% 42.3% 37.08% 34.72% 33.05% 30.96% 28.13% 19.78% 32.04% 34.75% 30.2% 40.13% 40.03% 33.92% 39.41% 39.32% 41.24% 41.79% 33.11% 34.34% 40.59% 45.56% 62.18% 60.22% 46.63% 44.52% 38.97% 36.5% 37.04% 37.33% 37.75% 36.38% 34.7% 31.21% 31.09% 35.1% 33.42%
Net Profit Margin 35.79% 35.96% 34.15% 36.69% 36.45% 30.96% 31.18% 15.02% 26.39% 22.53% 13.03% 25.42% 28.08% 23.03% 33.1% 30.02% 24.93% 29.26% 27.51% 28.45% 30.8% 22.17% 23.4% 27.6% 29.04% 41.04% 39.42% 29.42% 28.94% 25.31% 24.47% 24.65% 25.39% 25.67% 25.1% 23.59% 21.22% 20.97% 20.79% 19.9%
Operating Cash Flow Margin 48.41% 48.36% 41.33% 44.91% 45.65% 42.43% 41.47% 39.76% 40.91% 36.56% 31.7% 37.43% 37.04% 42.9% 38.59% 38.53% 32.58% 35.77% 34.81% 32.53% 41.73% 39.71% 49.08% 51.15% 53.06% 49.77% 66.53% 55.25% 39.28% 42.89% 33.52% 34.27% 28.62% 32.88% 30.26% 23.52% 27.69% None None None
Free Cash Flow Margin 25.69% 30.22% 28.07% 32.86% 33.39% 31.63% 30.4% 29.22% 32.49% 27.41% 25.35% 31.11% 31.57% 39.77% 35.23% 35.36% 27.24% 30.5% 30.38% 28.96% 39.69% 36.7% 46.31% 48.44% 48.7% 45.94% 63.57% 49.71% 35.1% 37.19% 25.18% 28.29% 22.33% 21.4% 15.92% 10.16% 16.57% 0% 0% 0%
Return
Return on Assets 17.18% 17.21% 17.56% 19.94% 18.36% 14.7% 13.69% 6.4% 10.18% 10.62% 6.99% 12.81% 15.35% 14% 21.3% 21.79% 18.71% 24.29% 22.26% 18.1% 17.3% 8.66% 9.21% 11.57% 12.49% 18.07% 20.16% 20.08% 24.01% 21.75% 20.15% 21.37% 25.05% 26.82% 28.14% 25.26% 23.66% 25.13% 24.98% 23.02%
Return on Equity 32.74% 32.83% 35.09% 43.68% 43.15% 37.43% 38.35% 20.03% 29.06% 28.53% 15.23% 24.59% 27.69% 25.58% 40.55% 40.63% 36.83% 48.73% 45.23% 31.42% 25.47% 10.92% 12.34% 15% 15.53% 22.77% 27.38% 27% 32.05% 31.77% 27.25% 25.75% 29.4% 32.29% 34.25% 30.39% 30.35% 33% 30.07% 28.21%
Return on Capital Employed 27.24% 28.29% 28.76% 30.91% 28.52% 23.13% 19.78% 17.5% 14.92% 19.45% 14.55% 21.9% 25.49% 24.57% 33.98% 40.19% 40.04% 51.91% 46.78% 34.93% 27% 11.38% 14.09% 21.69% 23.64% 25.96% 33.68% 40.36% 45.2% 40.14% 34.76% 38.79% 40.9% 45.42% 48.1% 42.81% 43.11% 49.92% 52.61% 43.13%
Return on Invested Capital 23.78% 24.28% 26.26% 28.32% 26.09% 20.53% 18.75% 8.45% 13.24% 16.37% 10.04% 18.65% 21.37% 20.32% 31.85% 33.19% 33.43% 50.77% 38.74% 28.1% 21.86% 9.29% 10.6% 15.61% 17.2% 19.34% 26.46% 33.1% 44.78% 39.46% 35.03% 38.64% 40.47% 48.32% 48.02% 39.78% 44.57% 65.76% 69.14% 94.19%
Turnover Ratios
Receivables Turnover Ratio 5.22 4.31 4.35 4.48 4.42 4.47 4.26 4.17 4.31 4.99 5.23 4.44 4.45 4.67 4.67 4.8 5.22 4.45 4.51 4.75 5.54 6.25 6.19 5.53 6.89 7.06 8.8 10.45 12.18 13.57 10.22 9.79 11.1 3.35 7.58 6.54 7.23 6.31 6.28 5.72
Payables Turnover Ratio 3.18 3.37 3.64 3.3 3.44 3.68 4.57 4.45 4.64 4.75 5.01 3.64 4.22 4.2 3.71 3.08 3.66 2.88 3.29 2.63 2.89 3.91 3.85 4.3 2.91 2.77 2.06 1.89 2.24 0.876 1.08 1.62 2.02 1.89 3.34 4.05 4.29 0 0 0
Inventory Turnover Ratio 98.47 59.48 26.35 16.74 19.81 24.32 20.8 14.41 15.71 14.56 11.38 10.18 10.52 15.42 11.35 16.75 16.95 11.77 9.49 5.18 12.28 15.95 9.47 7.71 41.63 0 0 0 0 0 6.91 5.16 3.8 4.12 6.09 3.71 4.76 2.47 3.99 4.39
Fixed Asset Turnover Ratio 1.3 1.59 1.93 2.26 2.37 2.7 2.87 3.05 3.19 4.97 6.35 6.67 7.79 8.92 8.57 8.19 7.76 9.68 11.75 14.55 16.96 15.84 14.48 12.51 10.96 12.06 12.26 10.14 8.15 6.54 4.98 5 4.33 3.6 3.48 3.64 4.04 4.54 4.94 10.13
Asset Turnover Ratio 0.48 0.479 0.514 0.543 0.504 0.475 0.439 0.426 0.386 0.471 0.536 0.504 0.547 0.608 0.643 0.726 0.75 0.83 0.809 0.636 0.562 0.39 0.394 0.419 0.43 0.44 0.511 0.683 0.83 0.859 0.823 0.867 0.986 1.05 1.12 1.07 1.12 1.2 1.2 1.16
Per Share Items ()
Revenue Per Share 36.32 32.99 28.46 26.45 22.27 18.79 16.4 14.33 12.47 11.5 11.44 10.46 9.3 8.78 8.24 7.09 6.53 6.48 5.25 4.24 3.67 3.41 3 2.62 2.37 2.22 1.96 1.57 1.25 0.928 0.592 0.476 0.394 0.312 0.219 0.148 0.118 0 0 0
Operating Cash Flow Per Share 17.58 15.95 11.76 11.88 10.17 7.97 6.8 5.7 5.1 4.21 3.63 3.92 3.44 3.77 3.18 2.73 2.13 2.32 1.83 1.38 1.53 1.35 1.47 1.34 1.26 1.11 1.31 0.867 0.491 0.398 0.198 0.163 0.113 0.102 0.066 0.035 0.033 None None None
Free Cash Flow Per Share 9.33 9.97 7.99 8.69 7.44 5.94 4.99 4.19 4.05 3.15 2.9 3.26 2.93 3.49 2.9 2.51 1.78 1.98 1.59 1.23 1.46 1.25 1.39 1.27 1.15 1.02 1.25 0.78 0.439 0.345 0.149 0.135 0.088 0.067 0.035 0.015 0.02 None None None
Cash & Short Term Investments 10.71 10.16 14.94 13.97 17.26 17.94 17.44 17.37 17.17 14.29 11.8 10.33 9.2 7.51 6.22 4.17 3.52 2.54 2.4 3.27 3.48 5.61 4.57 3.58 2.96 2.3 1.71 0.395 0.388 0.278 0.196 0.151 0.106 0.089 0.05 0.031 0.028 0.03 0.018 0.014
Earnings Per Share 13 11.86 9.72 9.7 8.12 5.82 5.11 2.15 3.29 2.59 1.49 2.66 2.61 2.02 2.73 2.13 1.63 1.9 1.44 1.21 1.13 0.756 0.702 0.724 0.688 0.912 0.774 0.462 0.362 0.235 0.145 0.117 0.1 0.08 0.055 0.035 0.025 0 0 0
EBITDA Per Share 20.37 17.73 13.75 13.05 10.81 8.64 7.12 5.89 4.88 4.13 2.95 3.97 3.64 2.95 3.52 3.04 2.56 2.61 2.04 1.66 1.42 0.946 1.02 1.2 1.24 1.19 1.09 0.795 0.568 0.381 0.23 0.201 0.155 0.125 0.086 0.055 0.039 0.033 0.019 0.009
Dividend Per Share 2.97 2.93 2.66 2.42 2.19 1.99 1.8 1.65 1.53 1.39 1.21 1.07 0.89 0.76 0.61 0.519 0.499 0.43 0.391 0.34 3.33 0.16 0.08 0 0 0.001 0.003 0.003 0.002 0 0 0 0 0 0 0 0 0 0 0
Enterprise Value Per Share 459 455.6 333.7 251 262.6 194.9 128.5 91.86 63.58 43.63 36.66 34.1 27.03 24.5 21.19 19.51 20.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.1 1.44 1.03 0.344 0 0 0
Book Value Per Share 39.71 36.13 27.7 22.22 18.81 15.55 13.34 10.74 11.32 9.08 9.79 10.82 9.43 7.9 6.72 5.24 4.42 3.89 3.19 3.84 4.44 6.93 5.69 4.83 4.43 4 2.83 1.71 1.13 0.74 0.532 0.456 0.34 0.248 0.161 0.115 0.082 0 0 0
Price Per Share 461.6 456.7 340.5 256.8 270.9 203.5 135.7 98.61 68.93 51.17 44.15 41.7 34.36 30.59 26 23.01 23.77 27.51 29.47 23.3 24.84 28.56 25.64 26.33 36.5 40 45.09 27.09 15.8 7.64 5.65 3.23 2.75 2.19 1.49 1.06 0.368 0 0 0
Dividend Ratios
Dividend Payout Ratio 24.3% 24.7% 27.36% 24.93% 26.96% 34.18% 35.2% 76.63% 46.47% 53.59% 81.05% 40.22% 34.1% 37.61% 22.38% 24.4% 30.67% 22.71% 27.05% 28.14% 294.7% 21.17% 11.38% 0% 0% 0.138% 0.36% 0.624% 0.434% 0% 0% 0% 0% 0% 0% 0% 0% None None None
Annual Dividend Yield 0.644% 0.641% 0.781% 0.942% 0.808% 0.977% 1.33% 1.67% 2.22% 2.71% 2.74% 2.57% 2.59% 2.49% 2.35% 2.26% 2.1% 1.56% 1.33% 1.46% 13.41% 0.56% 0.312% 0% 0% 0.003% 0.006% 0.011% 0.01% 0% 0% 0% 0% 0% 0% 0% 0% None None None
Effective Tax Rate 18.29% 18.23% 18.98% 13.11% 13.83% 16.51% 10.18% 54.57% 14.76% 19.89% 34.12% 20.65% 19.18% 23.75% 17.53% 25% 26.5% 25.75% 30.03% 31.01% 26.31% 33.03% 31.87% 32% 33.01% 34% 34.53% 36.91% 35% 35.04% 32.95% 33.45% 31.98% 32% 31% 32% 32.02% 32.55% 40.77% 40.45%
Short Term Coverage Ratio 43.58 13.26 16.69 32.39 9.51 16.18 9.46 10.98 3.9 2.58 3.96 16.25 9.61 25.69 0 24.07 9.52 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109.3 28.61 42.82 8.76 None None 0
Capital Expenditure Coverage Ratio 2.13 2.67 3.12 3.73 3.72 3.93 3.75 3.77 4.86 3.99 4.99 5.93 6.77 13.72 11.46 12.18 6.1 6.79 7.86 9.13 20.45 13.19 17.73 18.84 12.17 13 22.53 12.86 9.4 7.53 4.02 5.73 4.55 2.86 2.11 1.76 2.49 0 0 0
EBIT Per Revenue 0.452 0.446 0.418 0.421 0.416 0.37 0.341 0.318 0.301 0.286 0.194 0.32 0.344 0.295 0.388 0.386 0.348 0.369 0.361 0.372 0.366 0.245 0.297 0.42 0.463 0.479 0.509 0.44 0.408 0.355 0.343 0.371 0.353 0.361 0.353 0.332 0.301 0.317 0.367 0.308
EBITDA Per Revenue 0.561 0.537 0.483 0.493 0.485 0.46 0.434 0.411 0.391 0.359 0.258 0.38 0.392 0.335 0.428 0.428 0.392 0.403 0.389 0.392 0.387 0.277 0.34 0.458 0.524 0.534 0.555 0.507 0.455 0.41 0.389 0.422 0.394 0.402 0.394 0.371 0.332 0.344 0.389 0.338
Days of Sales Outstanding 69.89 84.76 83.86 81.48 82.61 81.7 85.63 87.58 84.78 73.18 69.85 82.15 81.98 78.13 78.21 76.02 69.91 82.09 80.95 76.79 65.87 58.36 58.92 66 52.97 51.67 41.5 34.92 29.97 26.9 35.72 37.29 32.87 109 48.17 55.83 50.51 57.83 58.14 63.76
Days of Inventory Outstanding 3.71 6.14 13.85 21.8 18.42 15.01 17.55 25.33 23.24 25.06 32.06 35.86 34.7 23.67 32.15 21.79 21.53 31 38.47 70.52 29.72 22.88 38.55 47.32 8.77 0 0 0 0 0 52.83 70.78 96.17 88.54 59.94 98.32 76.65 147.9 91.39 83.19
Days of Payables Outstanding 114.7 108.3 100.3 110.7 106 99.25 79.8 82.01 78.73 76.81 72.82 100.2 86.45 86.93 98.34 118.5 99.82 127 110.8 138.8 126.2 93.32 94.76 84.94 125.5 131.7 176.8 192.9 163.2 416.6 338 224.8 181 193.3 109.3 90.19 85.17 0 0 0
Cash Conversion Cycle -41.15 -17.43 -2.56 -7.41 -4.93 -2.55 23.38 30.91 29.29 21.44 29.09 17.83 30.24 14.87 12.01 -20.71 -8.38 -13.86 8.59 8.51 -30.66 -12.07 2.72 28.38 -63.77 -80 -135.3 -158 -133.2 -389.7 -249.4 -116.8 -51.94 4.26 -1.21 63.96 42 205.8 149.5 147
Cash Conversion Ratio 1.35 1.35 1.21 1.22 1.25 1.37 1.33 2.65 1.55 1.62 2.43 1.47 1.32 1.86 1.17 1.28 1.31 1.22 1.27 1.14 1.36 1.79 2.1 1.85 1.83 1.21 1.69 1.88 1.36 1.69 1.37 1.39 1.13 1.28 1.21 0.997 1.3 0 0 0
Free Cash Flow to Earnings 0.718 0.84 0.822 0.896 0.916 1.02 0.975 1.95 1.23 1.22 1.95 1.22 1.12 1.73 1.06 1.18 1.09 1.04 1.1 1.02 1.29 1.65 1.98 1.75 1.68 1.12 1.61 1.69 1.21 1.47 1.03 1.15 0.879 0.834 0.634 0.431 0.781 0 0 0
discounting cash flows home logo

Discounting Cash Flows

Are you finding our services helpful? Review us on trustpilot logo Trustpilot
Have a question? Contact us