Financial Statement Analysis Compute the ratios for Cisco Networks fiscal 2018 and 2019.
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
please put the answer in excel form it will extremely beneficial
similar to the one down below 
July 28, 2018 July 29, 2017 $ $ 8,934 37,614 11,708 58,784 5,554 1,846 4,949 2,940 61,837 3,006 4,882 31,706 2,552 3,219 1,582 108,784 5,146 1,616 4,856 1,593 83,703 3,322 4,738 29,766 2,539 4,239 1,511 129,818 $ $ $ $ CISCO SYSTEMS, INC. Consolidated Balance Sheets (in millions, except par value) Years Ended July 27, 2019 ASSETS Current assets: Cash and cash equivalents 11,750 Investments 21,663 Accounts receivable, net of allowance for doubtful accounts of $211 at July 29, 2017 and $249 at July 30, 2016 5,491 Inventories 1,383 Financing receivables, net 5,095 Other current assets 2,373 Total current assets 47,755 Property and equipment, net 2,789 Financing receivables, net 4,958 Goodwill 33,529 Purchased intangible assets, net 2,201 Deferred tax assets 4,065 Other assets 2,496 TOTAL ASSETS $ 97,793 LIABILITIES AND EQUITY Current liabilities: Short-term debt $ 10, 191 Accounts payable 2,059 Income taxes payable 1,149 Accrued compensation 3,221 Deferred revenue 10,558 Other current liabilities 4,424 Total current liabilities 31,712 Long-term debt 14,475 Income taxes payable 8,927 Deferred revenue 7,799 Other long-term liabilities 1,309 Total liabilities 64,222 Commitments and contingencies (Note 12) Equity Cisco shareholders' equity: Preferred stock, no par value: 5 shares authorized; none issued and outstanding Common stock and additional paid-in capital, $0.001 par value: 20,000 shares authorized; 4,983 and 5,029 shares issued and outstanding at July 29, 2017 and July 30, 2016, respectively 40,266 Retained earnings (5,903) Accumulated other comprehensive income (loss) (792) Total Cisco shareholders' equity 33,571 Noncontrolling interests Total equity 33,571 TOTAL LIABILITIES AND EQUITY $ 97,793 5,238 1,904 1,004 2,986 11,490 4,413 27,035 20,331 8,585 8,195 1.434 65,580 7,992 1,385 98 2,895 10,821 4,392 27,583 25,725 1,250 7,673 1,450 63,681 42,820 1,233 (849) 43,204 45,253 20,838 46 66,137 43,204 108,784 66,137 129,818 $ $ July 28, 2018 July 29, 2017 $ $ 36,709 12,621 49,330 35,705 12,300 48,005 14,427 4,297 18,724 30,606 13,699 4,082 17,781 30,224 CISCO SYSTEMS, INC. Consolidated Statements of Operations (in millions, except per-share amounts) Years Ended July 27, 2019 REVENUE: Product $ 39,005 Service 12,899 Total revenue 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 development 6,577 Sales and marketing 9,571 General and administrative 1,827 Amortization of purchased intangible assets 150 Restructuring and other charges 322 Total operating expenses 18,447 OPERATING INCOME 14,219 Interest income 1,308 Interest expense (859) Other income (loss), net (97) Interest and other income (loss), net 352 INCOME BEFORE PROVISION FOR INCOME TAXES 14,571 Provision for income taxes 2,950 NET INCOME $ 11,621 Net income per share: Basic $ 2.63 Diluted S 2.61 Shares used in per-share calculation: Basic 4,419 Diluted 4,453 6,332 9,242 2,144 221 358 18,297 12,309 1,508 (943) 165 730 13,039 12,929 110 6,059 9,184 1,993 259 756 18,251 11,973 1,338 (861) (163) 314 12,287 2,678 9,609 $ $ $ $ 0.02 0.02 1.92 1.90 $ $ 4,837 4,881 5,010 5,049 July 28, 2018 July 29, 2017 110 $ 9,609 2,192 1,576 (134) 900 2,286 1,526 (8) (124) (153) 154 (322) (269) (244) (219) 66 504 8,118 100 1,205 83 13,666 756 (394) (1,038) 15 311 60 (110) 1,683 (697) 13,876 CISCO SYSTEMS, INC. Consolidated Statements of Cash Flows (in millions) Years Ended July 27, 2019 Cash flows from operating activities: Net income $ 11,621 $ Adjustments to reconcile net income to net cash provided by operating activities: Depreciation, amortization, and other 1,897 Share-based compensation expense 1,570 Provision (benefit) for receivables 40 Deferred income taxes (350) Excess tax benefits from share-based compensation (Gains) losses on divestitures, investments and other, net (24) Change in operating assets and liabilities, net of effects of acquisitions and divestitures: Accounts receivable (84) Inventories 131 Financing receivables (249) Other assets (955) Accounts payable 87 Income taxes, net 312 Accrued compensation 277 Deferred revenue 1,407 Other liabilities 151 Net cash provided by operating activities 15,831 Cash flows from investing activities: Purchases of investments (2,416) Proceeds from sales of investments 7,388 Proceeds from maturities of investments 12,928 Acquisitions and divestitures (2,175) Purchases of investments in privately held companies (148) Return of investments in privately held companies 159 Acquisition of property and equipment (909) Proceeds from sales of property and equipment 22 Other (12) Net cash provided by (used in) investing activities 14,837 Cash flows from financing activities: Issuances of common stock 640 Repurchases of common stock - repurchase program (20,717) Shares repurchased for tax withholdings on vesting of restricted (862) Short-term borrowings, original maturities of 90 days or less, ne 3,446 Issuances of debt 2,250 Repayments of debt (6,780) Excess tax benefits from share-based compensation Dividends paid (5,979) Other 113 Net cash used in financing activities (27,889) Net increase (decrease) in cash, cash equivalents, and restricted c 2,779 Cash, cash equivalents, and restricted cash, beginning of fiscal yea 8,993 Cash, cash equivalents, and restricted cash, end of fiscal year $ 11,772 $ Supplemental cash flow information: Cash paid for interest $ 839 $ Cash paid for income taxes, net $ 2,986 $ (14,285) 17,706 15,769 (2,979) (267) 168 (834) 59 (19) 15,318 (42,702) 28,827 12,143 (3,324) (222) 203 (964) 7 (4) (6,036) 623 (17,547) (703) (2,502) 6,877 (12,375) 708 (3,685) (619) 2,497 6,980 (4,151) 153 (5,511) (178) (3,806) 4,034 7,739 11,773 (5,968) (169) (31,764) (2,780) 11,773 8,993 $ 910 3,911 897 2,742 A B D F G H Numerator 56.68 47,755 51,904 E 2019 Denominator 2.63 31,712 5.523 Numerator 43.26 61,837 49,330 9.22 2 Ratio name Numerator Denominator 3 Price/Earnings Ratio Price per share EPS 4 Current Ratio Current Assets Current Liabilities 5 Receivable Turnover Ratio Net Credit Sales Average Accounts Receivable 6 Working Capital Current Assets - Current liabilities 7 Return on assets Net Income Total Assets 8 Financial Leverage Ratio EBIT EBT 9 Quick Ratio Current Assets - Inventory - Prepaid Expense Current Liabilities 10 Total Assets Turnover Ratio Sales Total Assets 11 Net Profit Margin Net Income Sales 12 Inventory Turnover Ratio Cost of Sales Average Inventory 13 Primary (Basic) earnings per share Net income available to Eq shareholders Weighted average number of shares 14 Return on equity Net Income Shareholder's Equity 11,621 15,440 46,372 51,904 11,621 19,238 11,621 11,621 97,793 14,571 31,712 97,793 51,904 1,615 4,419 33,571 Ratio 21.55 1.51 9.40 16,043 0.12 1.06 1.46 0.53 0.22 11.92 2.63 0.35 110 13,982 59,991 49,330 110 18,724 110 110 2018 Denominator Ratio 0.02 1,902.26 27,035 2.29 5,350 34,802 108,784 0.00 13,039 1.07 27,035 2.22 108,784 0.45 49,330 0.00 1,731 10.82 4,837 0.02 43,204 0.00 Workings :- B 1 51904 2 Ratio name Numerator Denominator 3 Price/Earnings Ratio Price per share EPS 4 Current Ratio Current Assets Current Liabilities 5 Receivable Turnover Ratio Net Credit Sales Average Accounts Receivable 6 Working Capital Current Assets - Current liabilities 7 Return on assets Net Income Total Assets 8 Financial Leverage Ratio EBIT EBT 9 Quick Ratio Current Assets - Inventory - Prepaid Expense Current Liabilities 10 Total Assets Turnover Ratio Sales Total Assets 11 Net Profit Margin Net Income Sales 12 Inventory Turnover Ratio Cost of Sales Average Inventory 13 Primary (Basic) earnings per share Net income available to Eq shareholders Weighted average number of shares 14 Return on equity Net Income Shareholder's Equity D E F G H | 2019 2018 Numerator Denominator Ratio Numerator Denominator Ratio 56.68 =F13 =D3/E3 43.26 =113 =G3/H3 47755 31712 =D4/E4 61837 27035 =G4/H4 =(5491+5554)/2 =D5/E5 49330 =(5554+5146)/2 =G5/H5 =D4-E4 =G4-H4 11621 97793 =D7/E7 110 108784 =G7/17 =14571+869 14571 =D8/E8 =13039+943 13039 =G8/H8 =D4-1383 31712 =D9/E9 =G4-1846 27035 =G9/H9 97793 =D10/E10 49330 108784 =G10/H10 11621 51904 =D11/E11 110 49330 =G11/H11 19238 =(1383-1846)/2 =D12/E12 18724 =(1846+1616)/2 =G12/H12 11621 4419 =D13/E13 110 4837 =G13/H13 11621 33571 =D14/E14 110 |43204 =G14/H14 51904
