find two formulas both years 2018 and 2019 for microsoft corporation:

time interest earned

price to earnings

... first chart is income statemnt. Remember to find both years 2018/2019

21 $ in milions : Year ended June 30 22 2019 2018 % variance 23 24 25 66.069 64,497 59,774 45,863 125,843 110,360 26 27 28 29 30 Revenues Product Service and other Total Revenue Cost of Revenue Product Service and other Total cost of Revenue Gross margin Research and Development Sales and Marketing General and Administrative Restructuring Operating Income other income, net Income before income taxes Provision for income taxes Net Income Earnings per share Basic Diluted Weighted Avg. Shares outstanding Basic Diluted 35 16,273 26,637 42.910 82.933 16,876 18.213 4,885 0 42.959 729 43,688 4,448 39,240 15,420 22,933 38,353 72,007 14,726 17,469 4,754 35 -2.38% $1,572.00 -23.27% $13,911.00 -12.30% $15,483.00 $0.00 -5.24% $853.00 -13.91% $3,704.00 -10.62% $4,557,00 -13.17% $10,926.00 -12.74% $2,150.00 -4.08% $744.00 -2.68% $131.00 $0.00 -18.39% $7,901.00 94.24% -$687.00 -16.51% $7.214.00 347.46% $15,455.00 -57.77% $22.669.00 $0.00 -57,93% -57.91% $2.93 $0.00 0.35% $27.00 0.53% -$41.00 37 38 30 35,058 1,416 36,474 19,903 16,571 00 2 $5.11 2.15 $2.96 $5.06 2.13 45 7,673 7,753 7700 7794 INI Microsoft + Data Income SR Balance sheet $ in millions 60 2019 2018 % variance S 61 69 65 60 70 Assets Current Assets Cash and cash equlients Short term investment Total cash, cash equivalents, and she Accounts receivable, net of allowance Inventories Other Total current assets Property and equipment, net of accun Operating lease right-of-use assets Equity Investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current Liabilities Accounts payable Short term debt Current portion of long-term debt Accrued compensation 11,356 11,946 122,463 121,822 133,819 133,768 29,524 26,481 2,063 2,662 10,146 6,751 75,552 169,662 36.477 20-460 7,379 6,686 2,649 1,862 42,026 35,683 7.750 8,053 14.723 7,442 286,556 258,848 71 22 73 #DIV/0! $11,946.00 #DIV/0! $121,822.00 #DIV/0 $133,768.00 #DIV/01 $26.481.00 #DIV/ 0-$2,662.00 -33.46% $3,395.00 -3.36% $5,890.00 -19.24% $7,017.00 #DIV/0! $6,686.00 -29.71% $787.00 -15.09% $6,343.00 3.91% -$303.00 -49.45% $7.281.00 -9.67% $27.708.00 $0.00 $0.00 -8.15% $765.00 $0.00 -27.52% $1,518.00 - 10.64% 5727.00 74 75 70 72 9.382 8,617 0 5,516 6,830 3,998 6,103 Microsoft Data Income Balance she Explore B E F G B1 12 83 84 85 86 87 5,516 3,998 6,830 6,103 5,665 2.121 32,676 28,905 9,351 8,744 69,420 58,488 66,662 72,242 29,612 30,265 4,530 3,815 233 541 6,188 5,568 7,581 5,211 184,226 176,130 38 B9 Current portion of long-term debt Accrued compensation Short-term income taxes Short-term uneamed revenue Other Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Differed Income taxes Operating lease liabilities Other long-term labilities Total Liabilities Commitments and contingencies Stockholders' equity Common stock and paid.in capital - Retained earnings Accumulated other comprehensive lo Total stockholders' equity Total liabilities and stockholders' equit 90 -27.52% $1,518.00 -10.64% $727.00 -62.56% $3,544.00 -11.54% $3,771.00 -6.49% $607.00 - 15.75% $10,932.00 8.37% -$5,580.00 2.21% -$653.00 -15.78% $715.00 132.19% $308.00 -10.02% $620.00 31,26% $2,370.00 -4,39% $8,096.00 $0.00 S0.00 9.29% $7.297.00 -43.35% $10.468.00 543.24% $1,847.00 - 19.17% $19,012.00 -9.67% $27.708.00 90 92 93 54 95 96 92 90 78,520 71,223 24,150 13,682 -340 -2,187 102,330 82,718 286,556 258,848 99 100 101 B E H K 105 Cash flow 105 $ in millions 107 % variance $ 108 109 110 111 112 113 114 115 116 117 118 2019 2018 Operations Net income 39,240 16,571 Adjustments to reconcile net income Depreciation, amortization, and other 11,682 10,261 Stock-based compensation expense 4,652 3,940 Net recognized gains on investments -792 -2,212 Deferred income taxes -6,463 -5,143 Changes in operating assets and liabilities: Accounts receivable -2,812 -3,862 Inventories 597 -465 Other current assets -1,718 -952 Other long-term assets -1,834 -285 Accounts payable 232 1,148 Unearned revenue 4,462 5,922 Income taxes 2,929 18,183 Other current liabilities 1,419 798 Other long-term liabilities 591 -20 Net cash from operations 52,185 43,884 Financing Repayments of short-term debt, matu o -7,324 Proceeds from Issuance of debt 0 7183 Repayments of debt -4,000 -10,060 Common stock issued 1,142 1,002 Common stock repurchased -19,543 -10.721 119 120 121 #DIV/0! $16,571.00 $0.00 #DIV/0$10,261.00 3,939 $712.00 -2,213 $1,420.00 -5,144 -$1,320.00 $0.00 -3,863 $1,050.00 -466 $1,062,00 -953 $766.00 -286 $1,549.00 1.147 -$916.00 5,921 -$1,460.00 18.182 -$15,254.00 $621.00 -21 $611.00 43,883 $8,301.00 $0.00 #DIV/0! $7,324.00 #DIV/0! $7.183.00 -10,061 $6,060.00 1,001 $140.00 -10,722 $8,822.00 122 123 797 124 125 120 127 925 129 130 121 Microsoft Data Income Balance she + Explore B C E 126 127 128 120 130 131 -7.324 7183 -10,060 1,002 - 10.721 - 12,699 -971 -33,590 322 133 154 135 136 137 130 Financing Repayments of short-term debt, matu O Proceeds from issuance of debt 0 Repayments of debt -4,000 Common stock issued 1,142 Common stock repurchased -19,543 Common stock cash dividends paid 10,811 Other, net -675 Net cash from (used in) financing -30,887 Investing Additions to property and equipment -13,925 Acquisition of companies, net of cash-2,388 Purchases of investments -57.697 Maturities of investments 20.043 Sales of investments 38.194 Securities lending payable Net cash used in investing - 15,773 Effect of foreign exchange rates on - 115 Not change in cash and cash equivale-590 Cash and cash equivalents, beginning 11,946 Cash and cash equivalents, and of pe 11,356 $0.00 #DIV/0! $7,324.00 #DIV/ 0.87.183.00 - 10,061 $6,060.00 1,001 $140.00 -10,722 $8,822.00 -12.700 $1,112.00 -972 $296.00 -33,591 $3,297.00 $0.00 -11,633 -$2.293.00 -889 $1,500.00 -137,381 $79,683.00 26,359 $6,317.00 117,676 $79.383.00 WOIVO $98.00 -6,062 $9.712.00 49 -$165.00 4,282 $4,873.00 7,662 $4,283.00 11,945 -$500,00 139 100 - 11,632 -888 -137,380 26,360 117,577 -98 -6,061 50 4,283 7.663 11,946 11 142 143 144 145 146 747 140 21 $ in milions : Year ended June 30 22 2019 2018 % variance 23 24 25 66.069 64,497 59,774 45,863 125,843 110,360 26 27 28 29 30 Revenues Product Service and other Total Revenue Cost of Revenue Product Service and other Total cost of Revenue Gross margin Research and Development Sales and Marketing General and Administrative Restructuring Operating Income other income, net Income before income taxes Provision for income taxes Net Income Earnings per share Basic Diluted Weighted Avg. Shares outstanding Basic Diluted 35 16,273 26,637 42.910 82.933 16,876 18.213 4,885 0 42.959 729 43,688 4,448 39,240 15,420 22,933 38,353 72,007 14,726 17,469 4,754 35 -2.38% $1,572.00 -23.27% $13,911.00 -12.30% $15,483.00 $0.00 -5.24% $853.00 -13.91% $3,704.00 -10.62% $4,557,00 -13.17% $10,926.00 -12.74% $2,150.00 -4.08% $744.00 -2.68% $131.00 $0.00 -18.39% $7,901.00 94.24% -$687.00 -16.51% $7.214.00 347.46% $15,455.00 -57.77% $22.669.00 $0.00 -57,93% -57.91% $2.93 $0.00 0.35% $27.00 0.53% -$41.00 37 38 30 35,058 1,416 36,474 19,903 16,571 00 2 $5.11 2.15 $2.96 $5.06 2.13 45 7,673 7,753 7700 7794 INI Microsoft + Data Income SR Balance sheet $ in millions 60 2019 2018 % variance S 61 69 65 60 70 Assets Current Assets Cash and cash equlients Short term investment Total cash, cash equivalents, and she Accounts receivable, net of allowance Inventories Other Total current assets Property and equipment, net of accun Operating lease right-of-use assets Equity Investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current Liabilities Accounts payable Short term debt Current portion of long-term debt Accrued compensation 11,356 11,946 122,463 121,822 133,819 133,768 29,524 26,481 2,063 2,662 10,146 6,751 75,552 169,662 36.477 20-460 7,379 6,686 2,649 1,862 42,026 35,683 7.750 8,053 14.723 7,442 286,556 258,848 71 22 73 #DIV/0! $11,946.00 #DIV/0! $121,822.00 #DIV/0 $133,768.00 #DIV/01 $26.481.00 #DIV/ 0-$2,662.00 -33.46% $3,395.00 -3.36% $5,890.00 -19.24% $7,017.00 #DIV/0! $6,686.00 -29.71% $787.00 -15.09% $6,343.00 3.91% -$303.00 -49.45% $7.281.00 -9.67% $27.708.00 $0.00 $0.00 -8.15% $765.00 $0.00 -27.52% $1,518.00 - 10.64% 5727.00 74 75 70 72 9.382 8,617 0 5,516 6,830 3,998 6,103 Microsoft Data Income Balance she Explore B E F G B1 12 83 84 85 86 87 5,516 3,998 6,830 6,103 5,665 2.121 32,676 28,905 9,351 8,744 69,420 58,488 66,662 72,242 29,612 30,265 4,530 3,815 233 541 6,188 5,568 7,581 5,211 184,226 176,130 38 B9 Current portion of long-term debt Accrued compensation Short-term income taxes Short-term uneamed revenue Other Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Differed Income taxes Operating lease liabilities Other long-term labilities Total Liabilities Commitments and contingencies Stockholders' equity Common stock and paid.in capital - Retained earnings Accumulated other comprehensive lo Total stockholders' equity Total liabilities and stockholders' equit 90 -27.52% $1,518.00 -10.64% $727.00 -62.56% $3,544.00 -11.54% $3,771.00 -6.49% $607.00 - 15.75% $10,932.00 8.37% -$5,580.00 2.21% -$653.00 -15.78% $715.00 132.19% $308.00 -10.02% $620.00 31,26% $2,370.00 -4,39% $8,096.00 $0.00 S0.00 9.29% $7.297.00 -43.35% $10.468.00 543.24% $1,847.00 - 19.17% $19,012.00 -9.67% $27.708.00 90 92 93 54 95 96 92 90 78,520 71,223 24,150 13,682 -340 -2,187 102,330 82,718 286,556 258,848 99 100 101 B E H K 105 Cash flow 105 $ in millions 107 % variance $ 108 109 110 111 112 113 114 115 116 117 118 2019 2018 Operations Net income 39,240 16,571 Adjustments to reconcile net income Depreciation, amortization, and other 11,682 10,261 Stock-based compensation expense 4,652 3,940 Net recognized gains on investments -792 -2,212 Deferred income taxes -6,463 -5,143 Changes in operating assets and liabilities: Accounts receivable -2,812 -3,862 Inventories 597 -465 Other current assets -1,718 -952 Other long-term assets -1,834 -285 Accounts payable 232 1,148 Unearned revenue 4,462 5,922 Income taxes 2,929 18,183 Other current liabilities 1,419 798 Other long-term liabilities 591 -20 Net cash from operations 52,185 43,884 Financing Repayments of short-term debt, matu o -7,324 Proceeds from Issuance of debt 0 7183 Repayments of debt -4,000 -10,060 Common stock issued 1,142 1,002 Common stock repurchased -19,543 -10.721 119 120 121 #DIV/0! $16,571.00 $0.00 #DIV/0$10,261.00 3,939 $712.00 -2,213 $1,420.00 -5,144 -$1,320.00 $0.00 -3,863 $1,050.00 -466 $1,062,00 -953 $766.00 -286 $1,549.00 1.147 -$916.00 5,921 -$1,460.00 18.182 -$15,254.00 $621.00 -21 $611.00 43,883 $8,301.00 $0.00 #DIV/0! $7,324.00 #DIV/0! $7.183.00 -10,061 $6,060.00 1,001 $140.00 -10,722 $8,822.00 122 123 797 124 125 120 127 925 129 130 121 Microsoft Data Income Balance she + Explore B C E 126 127 128 120 130 131 -7.324 7183 -10,060 1,002 - 10.721 - 12,699 -971 -33,590 322 133 154 135 136 137 130 Financing Repayments of short-term debt, matu O Proceeds from issuance of debt 0 Repayments of debt -4,000 Common stock issued 1,142 Common stock repurchased -19,543 Common stock cash dividends paid 10,811 Other, net -675 Net cash from (used in) financing -30,887 Investing Additions to property and equipment -13,925 Acquisition of companies, net of cash-2,388 Purchases of investments -57.697 Maturities of investments 20.043 Sales of investments 38.194 Securities lending payable Net cash used in investing - 15,773 Effect of foreign exchange rates on - 115 Not change in cash and cash equivale-590 Cash and cash equivalents, beginning 11,946 Cash and cash equivalents, and of pe 11,356 $0.00 #DIV/0! $7,324.00 #DIV/ 0.87.183.00 - 10,061 $6,060.00 1,001 $140.00 -10,722 $8,822.00 -12.700 $1,112.00 -972 $296.00 -33,591 $3,297.00 $0.00 -11,633 -$2.293.00 -889 $1,500.00 -137,381 $79,683.00 26,359 $6,317.00 117,676 $79.383.00 WOIVO $98.00 -6,062 $9.712.00 49 -$165.00 4,282 $4,873.00 7,662 $4,283.00 11,945 -$500,00 139 100 - 11,632 -888 -137,380 26,360 117,577 -98 -6,061 50 4,283 7.663 11,946 11 142 143 144 145 146 747 140