I am struggling with finding short term liquidity analysis for 4 ratios. Could someone help me with showing how to calculate using excel? Most important, please show me where the numbers are coming from. Feel free to double check the work! This is my first time!
Balance Sheet
Income Statement
Statement of Cash Flow
Short Term Liqidity Analysis Units 1 Ratio 2 Ratio 3 Times 4 Times 5 Days 6 Days 7 Days 8 Percent 9 Percent 10 $ mil 11 Days 12 Days 13 Percent Measure Current Ratio Acid Test Ratio Accounts Rec Turnover Inventory Turnover Days Sales in Receivable Days Sales in Inventory Approximate conversion period Cash to Current Assets Cash to Current liabilities Working Capital Days purchase in accounts payable Average Net Trade Cycle Cash provided by operations to average current liabilities 2021 1.19 0.33 81.45 4.18 4.5 87.3 91.7 23.27 27.74 3,596 2020 1.01 0.14 65.56 3.92 5.6 93.1 98.6 5.72 5.77 136 2019 0.98 0.11 87.66 4.16 4.2 87.6 91.8 5.12 5.03 -269 2018 1.06 0.11 87.25 4.36 4.2 83.8 88.0 5.40 5.70 676 2017 1.00 0.13 101.99 4.42 3.6 82.5 86.1 5.48 5.50 26 2016 1.01 0.11 302.17 8.14 1.2. 44.8 46.0 6.74 6.79 69 A B D E F G Lowe's Company, Inc. Common-Size Consolidated Balance Sheet Assets Cash and Short Term Investments Merchandise inventory-net Total current assets Property, less accumulated depreciation Total Assets Liabilities and Shareholders Equity Accounts payable 1 Total Current liabilities 2 Total Debt 3 Total Liabilities 1 Shareholders Equity 5 Shares Outstanding, year end 5 29/2021 5196 16,193 22,326 19,155 46,735 1/31/2020 876 13,179 15,318 18,669 39,471 2/1/2019 729 12,561 14,228 18,432 34,508 2/2/2018 690 11,393 12,772 19,721 35,291 2/3/2017 658 10,458 12,000 19,949 34,408 1/29/2016 712 9,458 10,561 19,577 31,266 10,884 18,730 21,780 45,298 1,437 731 7,659 15,182 19,306 37,499 1,972 763 8,279 14,497 16,223 30,864 3,644 801 6,590 12,096 16,995 29,418 5,873 830 6,651 11,974 15,699 27,974 6,434 866 5,633 10,492 12,649 23,612 7,654 910 Lowe's Company, Inc. Income Statement 2021-2016 Net sales (in millions) Gross Margin Serlling, General, Administrative (% to sales) Depreciation and Amortization to sales) Operating Margin Interest-Net (% to sales) Net Earnings (% to sales) Weighted Average shares, assuming dilution (in millions) 1 Diluted earnings per common share 2 Adjusted diluted earnings per common share 3 Cash dividends per share 1 1/29/2021 1/31/2020 2/1/2019 2/2/2018 89,597 72,148 71,309 68,619 33.01% 31.80% 32.12% 32.69% 20.68% 21.30% 24.41% 21.04% 1.56% 1.75% 2.07% 2.05% 10.77% 8.75% 5.64% 9.60% 0.95% 0.96% 0.88% 0.92% 6.51% 5.93% 3.24% 5.02% 750 778 812 7.75 5.49 2.84 4.09 8.86 5.74 5.11 4.39 2.3 2.13 1.85 1.58 2/3/2017 1/29/2016 65,017 59,074 33.34% 34.82% 22.12% 23.88% 2.23% 2.53% 8.99% 8.41% 0.99% 0.93% 4.76% 4.31% 881 929 3.47 2.73 3.99 3.29 1.33 1.07 840 5 7 8 Reference From Wall Street Journal Cost of Goods Sold 1 Operating income 2 61424 9,647 50467 6,314 49878 4,018 47589 6,586 44042 5,846 38504 4,971 Lowe's Company, Inc. Statement of Cash Flows 2021 2020 2019 2018 2016 2017 5617 4296 6193 5065 4784 11049 1791 1484 1174 1123 1123 Net Cash provided by operating activities Capital Expenditures Cash divided payments Repurchase of common stock 1197 957 1288 1704 4971 1618 4313 1455 3037 1288 3192 3192 3925
