Based on the income and balance sheet, what is the liquidity for 2017 and 2018?

1 Annual Financials for Microsoft Corp. 2 Fiscal year is July-June. All values USD millions. Income Statement 2017 Sales Revenue 96.02 6 Cost of Goods Sold (COGS) incl. D&A 34.62 7 COGS excluding D&A 26.77 8 Depreciation & Amortization Expense 7.86 Depreciation 6.1 10 Amortization of Intangibles 1.76 Gross Income 61.4 2018 110.18 38.97 29.02 9.95 7.7 2.25 71.21 Fiscal year is October September. All values USD millions. Balance Sheet Assets Fiscal year is July-June. All values USD millions. 2017 2018 Cash & Short Term Investments 132.98B 133.77B Cash Only 7.66B 11.95B Short-Term Investments 125.32B 121.82B 11 Total Accounts Receivable Accounts Receivables, Net Accounts Receivables, Gross Bad Debt Doubtful Accounts Other Receivables 22.43B 22.43B 22.78B (345M) 26.48B 26.48B 26.86B (377M) 2017 32.62 13.04 19.58 2018 36.33 14.73 21.61 14 SG&A Expense 15 Research & Development 16 Other SG&A 17 Other Operating Expense 18 Unusual Expense 19 EBIT after Unusual Expense 20 Non Operating Income/Expense 21 Non-Operating Interest Income Equity in Affiliates (Pretax) 2.18B 1.24B 145M 797M 2.66B 1.95B 54M 655M 871M 234M (871M) 34.64B 2.83B 2.35B 1.39B 2.21B Inventories Finished Goods Work in Progress Raw Materials Progress Payments & Other Other Current Assets Miscellaneous Current Assets Total Current Assets 5.13 5.1B 162.7B 6.75B 6.75B 169.66B 24 Interest Expense 25 Gross Interest Expense 26 Interest Capitalized 2.22B 2.3B 81M 2.73B 2.79B 59M Net Property, Plant & Equipment Property, Plant & Equipment - Gross 30.29B 54.47B 36.15B 65.37B 28 Pretax Income 29 Income Tax 30 Income Tax - Current Domestic 31 Income Tax - Current Foreign 32 Income Tax - Deferred Domestic 33 Income Tax - Deferred Foreigr. 34 Income Tax Credits 29.9B 36.47B 4.41B 19.9B 2.77B 20.7B 2.47B 4.35B (285M) (4.75B) (544M) (393M Buildings Land & Improvements Computer Software and Equipment Other Property, Plant & Equipment Accumulated Depreciation 16.28B 1.11B 21.41B 9.11B 24.18B 20.6B 1.250 27.63B 9.19B 29.22B Total Investments and Advances Other Long-Term Investments 6.02B 6.02B 1.86B 1.86B Long-Term Note Receivable 1.7B 1.8B 36 Equity in Affiliates 37 Other After Tax Income (Expense) 38 Consolidated Net Income 39 Minority Interest Expense 25.49B 16.57B Intangible Assets Net Goodwill Net Other Intangibles 45.23B 35.12B 10.11B 43.74B 35.68B 8.05B Other Assets Tangible Other Assets Total Assets 4.13B 4.27B 4.13B 4.27B 250.31B 258.85B 41 Net Income 42 Extraordinaries & Discontinued Operatio- 43 Extra Items & Gain Loss Sale Of Assets 44 Cumulative Effect - Accounting Chg 45 Discontinued Operations 46 Net Income After Extraordinaries 25.49B 47 Preferred Dividends 48 Net Income Available to Common 25.49B 16.57B Liabilities & Shareholders' Equity 2017 2018 16.57B 49 ST Debt & Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt 11.66B 10.5B 1.16B 5.57B 1.4B 4.17B 2.15 50 EPS (Basic) 51 Basic Shares Outstanding 3.29 7.75B 7.7B EPS (Diluted) Diluted Shares Outstanding 3.25 2.13 7.83B 7.79B Accounts Payable Income Tax Payable Other Current Liabilities Dividends Payable Accrued Payroll Miscellaneous Current Liabilities 7.39B 718M 35.98B 3B 5.82B 27.16B 8.62B 2.12B 42.18B 3.22B 6.1B 32.85B EBITDA 36.63B 44.83B Total Current Liabilities 55.75B 58.49B 60 Liquidity for 2017 and 2018? Profit for 2017 and 2018? 62 Asset utilization for 2017 and 2018? 63 Current ration for 2017 and 2018? Quick ratio for 2017 and 2018? Long-Term Debt Long-Term Debt excl. Capitalized Leases Non-Convertible Debt Convertible Debt 83.87B 76.07B 76.07B 81.94B 72.24B 72.24B Capitalized Lease Obligations 2.43B 4.13B Provision for Risks & Charges Deferred Taxes Deferred Taxes - Credit Deferred Taxes - Debit 13.49B 5.49B 5.73B 248M 30.27B (828M) 541M 1.37B Other Liabilities Other Liabilities (excl. Deferred Income) Deferred Income Total Liabilities 3.77B 1.12B 2.64B 162.6B 4.9B 1.09B 3.82B 176.13B Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock Non-Redeemable Preferred Stock 82.72B 71.22B 13.68B Common Equity (Total) 87.713 Common Stock Par/Carry Value 69.32B Retained Earnings 17.77B ESOP Debt Guarantee Cumulative Translation Adjustment Unrealized For. - Unrealized Gain Loss Marketable Securities 1.83B Revaluation Reserves Treasury Stock Total Shareholders' Equity 87.71B (892M) 82.72B Accumulated Minority Interest Total Equity Liabilities & Shareholders' Equity 87.71B 82.72B 250.31B 258.85B 1 Annual Financials for Microsoft Corp. 2 Fiscal year is July-June. All values USD millions. Income Statement 2017 Sales Revenue 96.02 6 Cost of Goods Sold (COGS) incl. D&A 34.62 7 COGS excluding D&A 26.77 8 Depreciation & Amortization Expense 7.86 Depreciation 6.1 10 Amortization of Intangibles 1.76 Gross Income 61.4 2018 110.18 38.97 29.02 9.95 7.7 2.25 71.21 Fiscal year is October September. All values USD millions. Balance Sheet Assets Fiscal year is July-June. All values USD millions. 2017 2018 Cash & Short Term Investments 132.98B 133.77B Cash Only 7.66B 11.95B Short-Term Investments 125.32B 121.82B 11 Total Accounts Receivable Accounts Receivables, Net Accounts Receivables, Gross Bad Debt Doubtful Accounts Other Receivables 22.43B 22.43B 22.78B (345M) 26.48B 26.48B 26.86B (377M) 2017 32.62 13.04 19.58 2018 36.33 14.73 21.61 14 SG&A Expense 15 Research & Development 16 Other SG&A 17 Other Operating Expense 18 Unusual Expense 19 EBIT after Unusual Expense 20 Non Operating Income/Expense 21 Non-Operating Interest Income Equity in Affiliates (Pretax) 2.18B 1.24B 145M 797M 2.66B 1.95B 54M 655M 871M 234M (871M) 34.64B 2.83B 2.35B 1.39B 2.21B Inventories Finished Goods Work in Progress Raw Materials Progress Payments & Other Other Current Assets Miscellaneous Current Assets Total Current Assets 5.13 5.1B 162.7B 6.75B 6.75B 169.66B 24 Interest Expense 25 Gross Interest Expense 26 Interest Capitalized 2.22B 2.3B 81M 2.73B 2.79B 59M Net Property, Plant & Equipment Property, Plant & Equipment - Gross 30.29B 54.47B 36.15B 65.37B 28 Pretax Income 29 Income Tax 30 Income Tax - Current Domestic 31 Income Tax - Current Foreign 32 Income Tax - Deferred Domestic 33 Income Tax - Deferred Foreigr. 34 Income Tax Credits 29.9B 36.47B 4.41B 19.9B 2.77B 20.7B 2.47B 4.35B (285M) (4.75B) (544M) (393M Buildings Land & Improvements Computer Software and Equipment Other Property, Plant & Equipment Accumulated Depreciation 16.28B 1.11B 21.41B 9.11B 24.18B 20.6B 1.250 27.63B 9.19B 29.22B Total Investments and Advances Other Long-Term Investments 6.02B 6.02B 1.86B 1.86B Long-Term Note Receivable 1.7B 1.8B 36 Equity in Affiliates 37 Other After Tax Income (Expense) 38 Consolidated Net Income 39 Minority Interest Expense 25.49B 16.57B Intangible Assets Net Goodwill Net Other Intangibles 45.23B 35.12B 10.11B 43.74B 35.68B 8.05B Other Assets Tangible Other Assets Total Assets 4.13B 4.27B 4.13B 4.27B 250.31B 258.85B 41 Net Income 42 Extraordinaries & Discontinued Operatio- 43 Extra Items & Gain Loss Sale Of Assets 44 Cumulative Effect - Accounting Chg 45 Discontinued Operations 46 Net Income After Extraordinaries 25.49B 47 Preferred Dividends 48 Net Income Available to Common 25.49B 16.57B Liabilities & Shareholders' Equity 2017 2018 16.57B 49 ST Debt & Current Portion LT Debt Short Term Debt Current Portion of Long Term Debt 11.66B 10.5B 1.16B 5.57B 1.4B 4.17B 2.15 50 EPS (Basic) 51 Basic Shares Outstanding 3.29 7.75B 7.7B EPS (Diluted) Diluted Shares Outstanding 3.25 2.13 7.83B 7.79B Accounts Payable Income Tax Payable Other Current Liabilities Dividends Payable Accrued Payroll Miscellaneous Current Liabilities 7.39B 718M 35.98B 3B 5.82B 27.16B 8.62B 2.12B 42.18B 3.22B 6.1B 32.85B EBITDA 36.63B 44.83B Total Current Liabilities 55.75B 58.49B 60 Liquidity for 2017 and 2018? Profit for 2017 and 2018? 62 Asset utilization for 2017 and 2018? 63 Current ration for 2017 and 2018? Quick ratio for 2017 and 2018? Long-Term Debt Long-Term Debt excl. Capitalized Leases Non-Convertible Debt Convertible Debt 83.87B 76.07B 76.07B 81.94B 72.24B 72.24B Capitalized Lease Obligations 2.43B 4.13B Provision for Risks & Charges Deferred Taxes Deferred Taxes - Credit Deferred Taxes - Debit 13.49B 5.49B 5.73B 248M 30.27B (828M) 541M 1.37B Other Liabilities Other Liabilities (excl. Deferred Income) Deferred Income Total Liabilities 3.77B 1.12B 2.64B 162.6B 4.9B 1.09B 3.82B 176.13B Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock Non-Redeemable Preferred Stock 82.72B 71.22B 13.68B Common Equity (Total) 87.713 Common Stock Par/Carry Value 69.32B Retained Earnings 17.77B ESOP Debt Guarantee Cumulative Translation Adjustment Unrealized For. - Unrealized Gain Loss Marketable Securities 1.83B Revaluation Reserves Treasury Stock Total Shareholders' Equity 87.71B (892M) 82.72B Accumulated Minority Interest Total Equity Liabilities & Shareholders' Equity 87.71B 82.72B 250.31B 258.85B