3 Deleulate the missing values in the table (highlighted in yellow). 4 Cisco Corporation Balance Sheet (5 millions) Dec-16 Dec 15 Dec-14 Dec-13 Dec-12 g $ $ S S S S S $ 19.098.00 $ 24,313.00 $ 5,079.00 $ 5,530.00 $ 5.006.00 $ 5.167.00 $ 7.789.00 $ 4,346.00 S 36,972.00 $ 39 356.00 S 77,819.00 S 62.709.00 $ 114,791.00 $ 102,065.00 S 14.055.00 S 20,087,00 $ 18,162.00 4.427.00 $ 3,647.00 $ 4,699.00 4,273.00 $ 4,172.00 S 4,734,00 4,976.00 $ 4,178.00 $ 3,763.00 27,731.00 S 32.084.00 $ 31,358,00 64.226.00 $ 60,274.00 S 52.993.00 91.957.00 $92,358.00 $ 84,351.00 Score = 13 7 Assets 8 Cash & Short Term Investments Short-Term Reccivables 10 Inventories 11 Other Current Assels 12 Total Current Assets Net Fixed Assets 14 Total Assets 15 Liabilities & Shareholders' Equity 16 Accounts Payable 17 Income Tax Payable 18 Other Current Liabilities 19 Total Current Liabilities Long-Term Debt 21 Deferred Tax Liabilities 22 Other Linbilities 21 Total Liabilities 24 Preferred Stock (Carrying Value) 25 Common Equity 26 Total Shareholders' Equity 27 Total Liabilities & Shareholders' Equity S S $ $ S S 2,475.00 S 329.00 $ 12.864.00 $ 15,668.00 S 20.649.00 S 1,750.00 S 3,538.00 S S 41,585.00 S 882.00 $ 20 2,063.00 S 272.00 S 10.698.00 $ 13.033.00 S 20.036.00 $ 2.539.00 $ 2,841.00 S 38,449.00 $ 89700 S 2,748.00 S 2.968.00 $ 443.00 S 542.00 S 11.224.00 $ 9.776.00 S 14.415.00 $ 13,286.00 $ 12.107.00 S 13.165.00 $ 3,775 00 5 4.397.00 $ 3.27800 S 2.972.00 S S 33,575.00 S 33,820.00 S 912.00 $ 3,023.00 711.00 8,852.00 12,586.00 13,136.00 3.412.00 3,702.00 32,836.00 S S $ S F G H H Dec-12 Trend Analysis 29 30 b) Use a formula to calculate Liquidity Ratios (Current and Quick), Leverage Ratios (Total Debt and Debt to Equity) for all years. 31 c) Provide analysis and conditional formatting on the 2015 and 2016 ratios calculated in part B 32 using appropriate formula. Compare 2016 performance to 2015 performance, report "Good" 33 in green color, otherwise report "Bad" in red color. 34 Dec-16 Dec-15 Dec-14 Dec-13 35 Liquidity Ratios 36 Current Ratio 37 Quick Ratio 38 Leverage Ratios 39 Debt 40 Equity 41 42 d) Convert the above balance sheet to common size balance sheet. 43 Intel Corporation 44 Balance Sheet (Common-size) 45 Dec-16 Dec-15 Dec-14 Dec-13 46 Assets 47 Cash & Short-Term Investments Short-Term Receivables Inventories SO Other Current Assets 51 Total Current Assets 52 Net Fixed Assets 53 Total Assets 54 Liabilities & Shareholders' Equity 55 Accounts Payable 56 Income Tax Payable Other Current Liabilities Dec-12 48 49 57 44 Intel Corporation Balance Sheet (Common-size) Dec-16 Dec-15 Dec-14 Dec-13 Dec-12 45 46 Assets 47 Cash & Short-Term Investments 48 Short-Term Receivables 49 Inventories 50 Other Current Assets 51 Total Current Assets 52 Net Fixed Assets 53 Total Assets 54 Liabilities & Shareholders' Equity 55 Accounts Payable 56 Income Tax Payable 57 Other Current Liabilities 58 Total Current Liabilities 59 Long-Term Debt 60 Deferred Tax Liabilities 61 Other Liabilities 62 Total Liabilities 63 Preferred Stock (Carrying Value) 64 Common Equity 65 Total Shareholders' Equity 66 Total Liabilities & Shareholders' Equity 67 68