X AutoSave O off ) H horizontal_analysis_balance_sheet_ba271(1) (2) - Compatibility M... v Search Victoria Tkachenko VT X File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share Verdana 10 A A ab Wrap Text General TIX O Paste BIU FLAV Merge & Center $ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Formatting Table Styles v Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A11 VIX fx B C D E F G H M N O P Q R S Horizontal Analysis: Balance Sheet N N Team Members 4 Industry Company 6 Year: Year: Year: 9 $$$ Change Percent $$$ Change Percent $$$ 10 11 12 13 14 Page Sheet + Calculating Descriptive Statistics .X AutoSave Off)[ vertical_analysis_balance_sheet_ba271(1) (1) - Compatibility M... v Search Victoria Tkachenko VT X File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share Verdana 10 A A ab Wrap Text General TIX O Paste BIUZAY E Merge & Center $ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Formatting Table v Styles v Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity M18 VIX fx B C E F H K M N O P Q R S Vertical Analysis: Balance Sheet Team Members Industry Company Year: Year: Year: 9 $ $$ Percent $$ $ Percent $$$ Percent 10 11 12 13 14 15 Page 1 Sheet + Calculating Descriptive Statistics .X AutoSave ( off ) H Horizantal Viertical balance sheet... . Saved to this PC v Search Victoria Tkachenko VT X File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share Calibri AA ab Wrap Text General TIX O Paste E Merge & Center ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Formatting v Table v Styles Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity H9 v I X fx B C G Balance sheet - Horizontal Annual Data 2022 2021 2020 SS Total Assets $ 364,840,000.0 $ 333,779,000.0 $ 301,311,000.0 Current assets $ 169,684,000.0 $ 184,406,000.0 $ 181,915,000.0 Total non-current assets $ 195, 156,000.0 $ 149,373,000.0 $ 119,396,000.0 Total Liabilities Net Minority Interes $ 198,298,000.0 $ 191,791,000.0 $ 183,007,000. Total Equity Gross Minority Interest $ 166,542,000.0 141,988,000.0 $ 118,304,000.0 10 Stockholders' Equity $ 166.542,000.0 $ 141,988,000.0 |$ 118,304,000.0 Total Capitalization 5 213,574,000.0 $ 192,062,000.0 $ 177,882,000.0 Common Stock Equity $ 166,542,000.0 $ 141,988,000.0 $ 118,304,000.0 Capital Lease Obligations $ 11,489,000.0 9,629,000.0 $ 7.671,000.0 4 Net Tangible Assets $ 87,720,000.0 $ 84,477,000.0 $ 67,915,000.0 Working Capital $ 74,602,000.0 $ 95,749,000.0 $ 109,605,000.0 Invested Capital $ 216,323,000.0 200, 134,000.0 $ 181,631,000.0 Tangible Book Value $ 87,720,000.0 $ 84,477,000.0 $ 67,915,000.0 Total Debt $ 61,270,000.0 $ 67,775,000.0 $ 70,998,000.0 Net Debt $ 35,850,000.0 $ 43,922,000.0 $ 49,751,000.0 Share issed $ 7,464,000.0 7,519,000.0 $ 7.571,000.0 1 Orfinary shares number $ 7,464,000.0 $ 7,519,000.0 $ 7.571,000.0 Microsoft Corporation (MSFT) Balance Sheet - Yahoo Finance Balance sheet virtical Annual Data | Millions of US $ except per share data 6/30/2022 6/30/2021 6/30/2020 Cash On Hand (/stocks/charts/MSFT/microsoft/cash- $104, 757 $130,334 $136,527 eceivables (/stocks/charts/MSFT/microsoft/receivable $44,261 $38,043 $32,011 Inventory (/stocks/charts/MSFT/microsoft entory) $3,742 $2,636 $1,895 Other Current Assets (/stocks/charts/MSFT/microsoft $16,924 $13,393 $11,482 Total Current Assets (/ stocks/charts/MSFT/microsoft/total $169,684 184,406 $181,915 Property, Plant, And Equipment (/stocks/charts/MSFT/ $74,398 $59,715 $44,151 Long-Term Investments (/stocks/charts/MSFT/microsoft $6,891 $5,984 $2,965 goodwill And Intangible Assets (/stocks/charts/MSFT/ 78,822 $57,511 $50,389 Other Long-Term Assets (/stocks/charts/MSFT/microso 21,89 $15,075 $13,138 Other Long-Term Assets (/stocks/charts/MSFT/microso $21,897 $15,075 $13,138 Total Long-Term Assets (/stocks/charts/MSFT/microsoft/to $195,156 $149,373 $119,396 Total Assets (/stocks/charts/MSFT/microsoft/total-assets $364,840 $333,779 $301,311 Total Current Liabilities (/stocks/charts/MSFT/microsoft/tot $95,082 $88,657 $72,310 Long Term Debt (/stocks/charts/MSFT/microsoft/long-t $47,032 $50,074 $59,578 Other Non-Current Liabilities (/stocks/charts/MSFT/mic $41,595 $40,617 $40,064 Total Long Term Liabilities (/stocks/charts/MSFT/microsoft $103,216 $103,134 $110,697 Total Liabilities (/stocks/charts/MSFT/microsoft/total-liab $198,298 $191,791 $183,007 Common Stock Net (/stocks/charts/MSFT/microsofit $86,939 $83,111 $80,552 etained Earnings (Accumulated Deficit) (/stocks/chat $84,281 $57,055 $34,566 Comprehensive Income (/stocks/charts/MSFT/microso $4, 678 $1.822 $3 , 186 Other Share Holders Equity Share Holder Equity (/stocks/charts/MSFT/microsoft/totat $166,542 $141,988 $118,304 Total Liabilities And Share Holders Equity (/stocks/charts $364,840 $333,779 $301,311 Microsoft Balance Sheet 2009-2023 | MSFT | MacroTrends Sheet1 Calculating Descriptive Statistics