Financial Statement Analysis: Compute the ratios for CISCO fiscal 2018 and 2019. inclouding

Price/Earnings Ratio

Current Ratio

Receivable Turnover Ratio

Working Capital

Return on assets

Financial Leverage Ratio

Quick Ratio

Total Assets Turnover Ratio

Net Profit Margin

Inventory Turnover Ratio

Primary (Basic) earnings per share

Return on equity

July 28, 2018 July 29, 2017 S 11,708 53,784 37,514 5,554 1,846 4,949 2,940 61,837 3,006 4,832 31,706 2,552 3,29 1,532 108,734 5,146 1,616 4,856 1,593 83,703 3,322 5,738 29,766 2,539 4,239 1,511 129,810 S $ S CISCO SYSTEMS INC. Consolidate : Balance Sheets (in milions, except par value) Years Erced July 27, 2019 ASSETS Current asses Cash and cash equivalents 11,750 Investmerrs 21,653 Accounts receivable net of a lowance for doubtful accounts of S211 at July 29, 2017 and 5249 al July 30, 2016 5,491 Inventories 1,383 Financing receivables.net 5,095 Other current assets 2,373 Total current assets 47,755 Propers and equ pment net 2,789 Financing receivables, ret 4,958 Goodwil 33,529 Purchased intangible assets, net 2,201 Deferred tax assets 4,055 Other assets 2,496 TOTAL ASSETS E 97,793 LIABILITIES AND EQUITY Current liabillies Short-term debt 5 10,191 Accounts payable 2,059 Income taxes payable 1,149 Accrued compensabon 3,221 Deferred revenue 10,558 Other current liabilities 4,424 Total current labiities 31,712 Longte im deut 14,475 Income taxes payable 8.927 Deferred revenue 7,799 Other long-te liabities 1,309 Totall abilities 64,222 Commiinents and contingencies (Ncte 12) Equity Cis sha eholders' ecuity Pre erred stock, no parva ve 5 shares authorized; rone issued and outstanding Common stock and additional paid-n capital. $0.007 par value 20,000 shares authorized: 4953ad 5.029 shares issued and outstanding at July 29, 2017 and July 30, 2016, respectivel 40,256 Retained earrings 15,903) Accumulated other comprehensive income ilcss) 1792) Total Cisco shareholde s' equity 35,571 Nor controllire interests Total equity 33,571 TOTAL LIABILITIES AND EQUITY 97,793 5,238 1,904 1,004 11,420 4,413 27,035 20,331 8.535 8,195 1.434 65,530 1,992 1,385 98 2,895 10,821 5,392 27,583 25,725 1,250 7,673 1,450 63,681 42,820 1,233 1849) 43,204 45,253 20,838 26 65,137 43,204 108,734 65,137 129,818 S July 28, 2018 July 29, 2017 S 36,709 12,621 49,330 35,705 12,300 43,005 14,427 13,699 5,082 11.781 30,224 18,724 30,506 CISCO SYSTEMS INC. Consolidated Statements of Operations (ir milions, exceplpestre amounts) Years Erded July 27, 2019 REVENUE: Produc $ 39,005 S Service 12,899 Total revenje 51,904 COST OF SALES: Product 14,863 Service 4,375 Total cost of sales 19,238 GROSS MARGIN 32,666 OPERATING EXPENSES: Research and develourrert 8,577 Sales and marketing 9,571 General and administrative 1,827 Amortization purchasedi tangible asszis 150 Restructurng and other charges 322 Total operating expenses 16,447 OPERATING INCOME 14,219 Interest income 1,308 Interest excense (859) Other income (oss), net (97) Interes, and one ncome i lossi, met 352 INCOME BERORE PROVISICN FOR INCOME TAXES 14,571 Provision for income taxes 2,950 NETINCOME $ 11,621 S Net income pa share: Basic E 2.63 S Diluted 9 2.61 S Shares used in per-share calc ation: Basic 4,419 Diluted 4,453 6,332 9,242 2,144 221 358 18,227 12,309 1.508 (243) 165 730 13,039 12,029 110 6,059 9,184 1993 259 758 13.251 11,973 1,338 (861) (1631 19,787 2,678 3,609 0.02 0.02 APA 1.92 1.90 4,837 4,831 5,010 50-9 July 26, 2018 July 29, 2017 110 9009 2,192 1,576 (134) 900 2288 1,528 81 (1241 (322) 154 758 (3941 11 0391 15 CISCO SYSTEMS, INC. Consolidaled Statements of Cash Flows in mil ons) Yea's Erced July 27, 2019 Cash flows from operating acvties. Net income E 11,621 S Adjustmets to reconcileret ncome to net cash prasided by operatirg activities Jepreciation, amorization, and other 1.897 Share-based compensation expense 1,570 Srovisior (benef) for receivables 40 je erned income taxes (350) Excess tax benets from starehase compensation Gainsi losses o-cve atitures. i vestments and ther, net (24) Change in operating assets and iab lities, net of effects of acquisitions and civestitures: Accounts receivable (84) mentories 131 Financing receivables (249) Other assets (955) 4ocounts payable B7 I moome taxes, net 312 A ochued compensation 277 Jeferred revenue 1,407 Other abiities 151 Net cas provided by operating activities 15,831 Cash flows from investing activities: Purchases of mesments (2,416) Proceeds from sales of investments 7,388 Propeeds from maturities of investments 12,928 Acquisics and divestitures (2,175) Purchases of nvestments in privaiely helic oompanies (148) Return of i Tvestments in privately he doompanies 159 ACCUSIO property and equipment (909) Propeeds from sales of property and equipment 22 Other (12) Metcash provided by used in investing achuities 14,837 Cash flows from fnancing act wities: Issuances of common stock 640 Repurchases of common stock - repurchase program 120,717) Shares repurchased fo tax withholdings on vesting of resticted (862) Short-term bo Towings, origiral maturities of days or less, ne 3,446 Issuances of debt 2,250 Repayments of debt (6,780) Exoesste benefits Fom sha e-based compensation Dividends paid (5,979) Other 113 (269) (244) 219 26 504 8,118 100 1,205 33 13,000 60 (110) (6971 13,870 (14,235) 17,706 15,769 12,979) (257) 158 (834) 59 (19) 15,318 (42,7021 23,827 12,743 13,3241 (222) 203 (91641 7 41 10.03 623 (17,547) (703) 2,502) 6,877 (12,375) 708 136851 (6191 2,497 0,980 191511 153 15,5111 (1781 15,968) (169)