Financial Statement Analysis: Compute the ratios for Juniper Networks fiscal 2018 and 2019 inclouding

Price/Earnings Ratio

Current Ratio

Receivable Turnover Ratio

Working Capital

Return on asset

Financial Leverage Ratio

Quick Ratio

Total Assets Turnover Ratio

Net Profit Margin

Inventory Turnover Ratio

Primary (Basic) earnings per share

Return on equity

note please can you submit it in a form similar to the one down below ...

December 31, 2018 December 31, 2017 $ $ 2,489 1,070.1 2,006.5 1,026.1 754.6 268.1 4.581.8 951.7 852 299.9 4,184.5 1,021.1 199.0 118.5 3,108,8 403.5 9.363.3 988.4 128.1 3,096.2 415.5 9.833.8 $ $ Juniper Networks, Inc. Consolidated Balance Sheets (In millions, except par values) December 31, 2019 ASSETS Current assets Cash and cash equivalents $ 1,215.8 Short-term investments 738 Accounts receivable, net of allowance for doubtful accounts of $4.9 and $5.7 as of December 31, 2018 and 2017, respectively 879.7 Prepaid expenses and other current assets 376.3 Total current assets 3,209.8 Property and equipment, net 830.9 Operating lease assets 169.7 Long-term investments 589.8 Purchased intangible assets, net 185.8 Goodwill 3,337.1 Other long-term assets 514.6 Total assets $ 8,837.7 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable $ 219.5 Accrued compensation 229 Deferred revenue 812.9 Short-term portion of long-term debt Other accrued liabilities 282.5 Total current liabilities 1,543.9 Long-term debt 1,683.9 Long-term deferred revenue 410.5 Long-term income taxes payable 372.6 Long-term operating lease liabilities 158.1 Other long-term liabilities 58.1 Total liabilities 4.227.1 Stockholders' equity: Convertible preferred stock, $0.00001 par value; 10.0 shares authorized; none issued and outstanding $ $ 217.6 186 1,030.3 208.8 221 829.3 349.9 233.5 1,842.5 1,789.1 384.3 404.4 304.3 1,738.2 2.136.3 509 650.6 119.8 4.540.1 118.8 5,152.9 Common stock, $0.00001 par value; 1,000.0 shares authorized; 335.9 shares and 346.4 shares issued and outstanding as of December 31, 2019 and 2018, respectively Additional paid-in capital Accumulated other comprehensive loss Accumulated deficit Total stockholders' equity Total liabilities and stockholders' equity 7,370.5 (18.5) (2,741.4) 4,610.6 8,837.7 7,672.8 (182) (2,831.4) 4,823.2 9,363.3 8,042.1 (5.4) (3,355.8) 4,680.9 9,833.8 $ $ $ Juniper works, Inc. Consolidated Statements of Operations (In millions, except per share amounts) Years Ended December 31, 2018 2019 2017 $ $ $ 2,867.7 1,577.7 4,445.4 3.107.1 1,540.4 4,647.5 3,446.2 1,581 5,027.2 1,277.2 1,227 601.6 1,828.6 2,616.8 629.1 1,906.3 2,741.2 1.360.9 594.2 1,955.1 3,072.1 Net revenues Product Service Total net revenues Cost of revenues: Product Service Total cost of revenues Gross margin Operating expenses: Research and development Sales and marketing General and administrative Restructuring charges Total operating expenses Operating income Other expense, net Income before income taxes Income tax provision (benefit) Net income 955.7 939.3 244.3 35.3 2,174.6 442.2 (27.8) 414.4 69.4 345 1,0032 927.4 231.1 7.3 2,169 572.2 (39.5) 532.7 (34.2) 566.9 980.7 950.2 227.5 65.6 2.224 848.1 (36.3) 811.8 505.6 306.2 $ $ $ $ $ $ 1.01 0.99 $ $ 1.62 1.60 $ $ 0.81 0.80 Net income per share Basic Diluted Shares used in computing net income per share: Basic Diluted 343.2 348.2 349.0 354.4 377.7 3842 Juniper Networks, Inc. Consolidated Statements of Cash Flows (In millions) Years Ended December 31, 2018 2019 2017 $ 566.9 $ 306.2 187.5 202.2 210.3 217.1 210.5 225.6 42 15.3 2.9 3.5 42.6 9.6 (139.6) (14.5) 203.8 (118.1) (100.7) 6.4 6.5 (40.5) (46.8) 0.9 528.9 96.3 (70.9) 3.5 41.4 (269.2) (11.4) 24.7 861.1 43 (10.1) (42.8) 447.3 (2.1) 55 1,259.3 Cash flows from operating activities: Net income Adjustments to reconcile net income to net cash provided by operating activities: Share-based compensation expense Depreciation, amortization, and accretion Operating lease assets expense Loss on extinguishment of debt Deferred income taxes Other Changes in operating assets and liabilities, net of acquisitions: Accounts receivable, net Prepaid expenses and other assets Accounts payable Accrued compensation Income taxes payable Other accrued liabilities Deferred revenue Net cash provided by operating activities Cash flows from investing activities: Purchases of property and equipment Purchases of available-for-sale debt securities Proceeds from sales of available-for-sale debt securities Proceeds from maturities and redemptions of available-for-sale debt securities Purchases of equity securities Proceeds from sales of equity securities Proceeds from Pulse note receivable Payments for business acquisitions, net of cash and cash equivalents acquired Subsequent payments related to acquisitions in prior years Net cash (used in) provided by investing activities Cash flows from financing activities: Repurchase and retirement of common stock Proceeds from issuance of common stock Payment of dividends Payment of debt Issuance of debt, net Payment for debt extinguishment costs Change in customer financing arrangement Other Net cash used in financing activities Effect of foreign currency exchange rates on cash, cash equivalents, and restricted cash Net increase in cash, cash equivalents, and restricted cash Cash, cash equivalents, and restricted cash at beginning of period Cash, cash equivalents, and restricted cash at end of period (109.6) (3,209.8) 1,520 1,642.3 (107.1) 14.2 (147.4) (1,228.5) 1,070.2 910.2 (17.5) 36.9 (151.2) (1,882.9) 944 741.6 (14.9) 12.4 75 (27) (270.9) (73) (528.2) (16.4) (42.7) 564.8 (303) (756.6) 56.9 (249.3) (725.8) 64.5 (150.4) (554.9) 55.6 (260.1) (950) 495.2 (14.6) 16.9 (16:9) (2.7) (968.6) (1,228.8) (794.8) (1.2) (1,229.3) 2,505.8 1,276.5 (10.6) 446.7 2,059.1 2,505.8 17 178.5 1,880.6 2,059.1 $ $ $ Supplemental disclosures of cash flow information: Cash paid for interest, net of amounts capitalized Cash paid for income taxes, net $ $ 90.60 98.80 $ $ 94.00 181.00 $ $ 93.90 193.50 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