fx Sha Mart ROR 5-%9 E Conditional Format Formatting as Table Styk Cel Fie Seth THES Sect A Date A c D 3 1 in Millions of USD except Per FY 2012 232 Months Ending Total Assets 4-Cash, Cash Equivalents & S Cash&Cash Equivalents " G 2013 6/30/12 6/30/13 FY 2014 6/30/14 FY2015 L FY2016 4/30/15 6/10/16 FY 2017 6/30/17 M FY 2018 6/10/18 N BY 2020 6/30/19 6/10/20 0 FY2021 1/10/21 61,040.00 6,938.00 B ST Investments Accounts & Notes Receiv B Accounts Receivable, Net 15,780.00 Notes Receivable, Net 0 0 0 77022.00 85,709.00 9.526.00 113,240.00 132,981 00 133,768.00 133,819.00 136,527.00 130,334.00 380400 8669.00 56102.00 71218.00 77040.00 5,595.00 651000 7,663.00 11946.00 11,156.00 15,780.00 17,486.00 19.544.00 90,931.00 106,710.00 125,318.00 121,822.00 122,463.00 122951.00 116,130.00 11.576.00 14.224.00 17,308.00 20.63.00 22,431.00 17,486 00 19.544.00 17.508.00 20,436.00 22.431.00 26,481.00 26,481.00 25.524.00 3201100 38,043.00 29.524.00 12.011.00 38.043.00 10 Inventories 11 Raw Materials 113700 210 1,938.00 2,66000 328 Work In Process 96 201 544 266 290200 1,100.00 202 0 13 Finished Goods 24 Other Inventory 0 1,400.00 1,450.00 0 1,600.00 2.251.00 612 158 148100 2,181.00 737 145 2,662.00 54 2,063.00 399 53 189500 700 2.61600 1190.00 79 0 0 1,219.00 0 1,951.00 1,611.00 1,167.00 15 Other ST Assets 5.127.00 16 Derivative & Hedging Asse 262 5,020.00 254 17 +Deferred Tax Assets 2,035.00 1,63200 6,333.00 109 1,941.00- 5,461.00 719 4,06100 548 5,10100 136 6,751.00 395 30,146.00 113 11,48200 234 11.993.00 215 +Misc ST Assets 2,830.00 3,134.00 4283.00 4,74200 5.523.00 19 Total Current Assets 20 Property, Plant & Equip, Ne 23 Property, Plant & Equip 22 Accumulated Depreciation 23 LT investments & Receivabl 24 +LT Investments 10,844.00 14,597.00 12,053.00 25 Other 17 Assets 20,130.00 30,530.00 2491.00 85,084.00 101,466.00 114,246.00 122,797.00 142,188.00 162,604.00 140,662.00 175,552.00 181,911.00 184406.00 826900 9,991.00 13,011.00 14,731.00 21,554.00 30.289.00 34.146.00 41854.00 12.504.00 19,231.00 22.504.00 2780400 3233700 43,354.00 10,962.00 54,46800 12,513.00 65,365.00 79.186.00 96,101.00 14,793.00 17606.00 190000 9,776.00 24.179.00 10,844.00 23,223.00 35.330.00 41197.00 51,351.00 14,597.00 12.053.00 10,431.00 9.775.00 6,023,00 10,431 00 18.142.00 6,023,00 476700 6.356.00 10013.00 11,348.00 11.178.00 8000 122,154.00 26 Total Intangible Assets 27 Goodwill 16,622.00 11,452.00 28 Product/Brand Segments 13,452 00 29 Productivity and Business Pr 30 intelligent Cloud 31 More Personal Computing 32 Commercial 23 Other 34 Licensing 249.00 26,724.00 $1,304.00 $1.178.00 64,499.00 17,738.00 27,108.00 21.774.00 21,60500 45.228.00 41,736.00 41.776.00 14,655.00 20.127.00 16,933.00 17,872.00 15,122.00 35.683.00 42,026 00 14.655.00 20.127.00 16,939.00 1787200 35,122.00 35683.00 42,076.00 41,151.00 4,711.00 6,309.00 6,678.00 23,73900 23,823.00 24,277.00 24,190.00 24,317.00 12.697.00 13,256.00 136200 1862.00 2,540.00 2.965.00 598400 3,965.00 584.00 63,52700 72.586.00 $7,500 4335100 471100 5,713.00 5.727.00 5.826.00 4917.00 5,467.00 5.555.00 5,701.00 11,351.00 6157.00 800 6464.00 12.138.00 10,203.00 149 1005400 11,36200 1,311.00 1001100 11,469.00- 1,411.00- Q fx Dete % 9 Condition Cel Formating as Table Styles 34 Licensing A Devices and Consumer Other D t " 10,054.00 10.051.00 3,245.00 10,054.00- 129300 865.00 742 37 Hardware 1,641.00 718 1489.00 738- 38 Phone Hardware 705200 39 Computing and Gaming 0 1,689.00 14.00 1641.00 40 Licensing 5,35400 04 41 Other Intangible Assets 1,170.00 101.00 42 Deferred Tax Asses 4 44 Derivative & Hedging Asse Misc LTAssets 45 Total Noncament Assets 0- 6.M1.00 131 4.815.00 1735.00 10.104.00 228 0 219 248 05300 1,300 1,530.00 Total Assets 47 2,992.00 3,291.00 36,187.00 40,965.00 58.138.00 121.371.00 142,431.00 172.384.00 25 7,75000 7.53600 4 7,000 6405.00 7.181.00 4,500.00 1,889.00 582200 $1,475.00 60,709007614.0000111004.00 115,306.00 14373.00 174,472.00 30297 00 250,312.00 254800 2500 3100 331779.00 604800 7,1800 12 672100 41 78500 48 Liabilities&Shareholder Equity 4Payables & Accruals 30 Accounts Payable 19.00 9537.00 13,011.00 4.175.00 743200 51 Aceved Taxes SE Interest & Dudends Payat + Other Payables & Accnaals 54 ST 709 3,875.00 123100 592 D 783 0 12.793.00 591.00 606 0 13,742.00 11527.00 16,841.00 21.877.00 22.534.00 3739400 180 0- 7,990.00 718 17.00 2,12100 334700 12.53000 15,14300 $445.00 2.13000 213400 4.117.00 2.999.00 0 0 4,797.00 2,000.00 2,000.00 500.00 5,364.00 5.815.00 7,484.00 12,304.00 4,98500 1300400 11,657.00 5072.00 6.303.00 5,573.00 000 7,348.00 7,400,000 5,000 10,825.00 0 0 14 ST Lease Uabilities 153600 1,575.00 ST Finance Leases 0 0 176 ST Operating Leases 142300 13900 317 1515.00 Current Portion of LT Deb 1.23100 2,999.00 2,499.00 0 60 Other ST 22.618.00 24.881.00 30,414.00 29,870.00 275.00 61 Deferred Bevor 1865300 20,639.00 23,150.00 23.223.00 20.177.00 62 1551 135 63 Mit ST 45 Total Deferred Tax Liabilities bie 284 125 630 310.00 4,107.00 33,600 7,055.00 37417.00 45.625.00 LTD 10,713.00 ST 30,713.00 258 211- 21800 4,647.00 58488.00 42000 12,001.00 20,645.00 27.00 44.814.00 1,470.00 1,995.00 79,107.00 12,601.00 10,645.00 27308.00 40,55700 16471.00 11342.00 66663.00 3578.00 24,013.00 137 2830500 201 32.676.00 6,549 00 581100 53,10200 5,745.00 69600 46 LT Lease all 0 4,257.00 7,797.00 50300 12,445.00 1,043.00 1998.00 5,516.00 30,161.00 36,004.00 40.195.00 41871.00 50,4300 6.000.00 41.525.00 14 182 751700 72,300.00 7.00 105007400 300400 16627.00 21.379.00 2.156.00 540 1,61600 3,749.00 807200 2,753.00 791 100 221 7100 LT Finance Leases 241500 Seist M N O " Smalets Ca D S Analysis for Balance sheet of the two most recent Calendar or Fiscal Years and determine Dollar Change and Percentage Change 344 LT Finance Leases 4 M * 70 LT Operating Leases 0- 1,425.00 4.125.00 71 Other LT Liabilities 11,107.00 72 13,465.00 Accrued Liabilities Pension Liabilities 16.33000 0 4,257.00 16.934.00 21,91.00 55600 5,372.00 22.00 35,707.00 35,609.00 14452.00 11.81.00 635700 1800 7.471.00 8954.00 11,750.00 9.425.00 0 0 0 74 Pensions 0 0- 75 Other Post-Ret Benefits 0 0- 0 0 76 Deferred Revenue 0 - 1,406.00 Deferred Tax Liablities 1,995.00 1,760.00 170900 0 78 Deratives & Hedging 2008.00 2,095.00 2,728.00 1,295.00 0 0 79 Misc LT Liabilities 80 Total Noncurrent Liabilities Total Liabilities 82 Prefered Equity and Hybrid 2014.00 6,315.00 0 2.64300 574.00 541 4,530.00 213 1180.00 204 1 2,436.00 118 8.208.00 22,220.00 54,908.00 10,000.00 26,070.00 63,487.00 11,504.00 13.544.00 13.62.00 34.601.00 14.375.004434200 64.705.00 106,856.00 11744200 114,806.00 13060700013400 30921000470028854.30 82.600.00 $430.00 1150700162601.00 176,130.00 184,224.00 181.007.00 1,00 31,34700 0 0 0 0 83 Share Capital & APIC 65,797.00 67306.00 68,346008465.00 M4 +Common Stock 0.05 85 +Additional Paid in Capital 65,796.95 0.05 67,305.95 005 6436595 64G 68.178.00 0.05 4315.00 71221.00 52000 552.00 12.00 0.05 0.05 005 48.177.95 3314.95 7L395 78529 9555 86 Treasury Stock 87 Retained Earnings 0 856 0 0 0 0 88 Other Equity 1,43200 2.522.00 80 Equity Before Minority Interes 66,363.00 5,895.00 17,710.00 1096.00 11.118.00 17,749.00 1182.00 24250004566.07.05.00 1,743.00 3,70800 1,794.00 78,944.00 3.784.00 0.083.00 81.000.00 3,100 1200 87,711.00 2,71800002330001104.0040 30 Minority/Non Controlling in 0 91 Total Equity 66,363.00 92 Total Liabilities & Equity 78.944.00 9,784.00 0.083.00 1,090.00 87711.00 271800 1000 110430 4,00 121,271.00 142,431.00 172.384.00 174,472.00 20297 00 250,313 00 254348.00 286354.00 3100 7700 1) Perform Vertical Analysis and Hortontal Analysis for Balance sheet of the two most recent Calendar oral Years and Change and Pegs Change De a third worksheet is this same Excel in perform Ratio Analysis for each of the flowing important A) Gross Profit Margin (Percentage) 9 0 0 0 ) Net Profit Margin 99 100 D) Current Ratin 101 Return Assets Debt to Equity and 302 F) Total Asset Tur 104 + M