help understanding filling in blank spaces uses the four different statements between: earnings, balance sheets, shareholders equity, and cash flows

Lowe's Companies, Inc. Consolidated Balance Sheets (In millsons, execpt par value) Jaauary 28,2022 January 29,2021 Assets Cerreat assets: Liabilities and shareholders' (defieit)/equity Curreat liabilities: Commitments and contingencies Shareholders' (deficit)/equity: Preferred stock -55 par valuer Authorized - 5.0 million shares: Issucd and outstanding - none Common stock - $0.50 par value: Authorized -5.6 billion shares; Issued and outstanding -670 million and 731 million, respectively Capital in excess of par value (Accumulated deficit)retained earnings Accumulated other comprehensive loss Total shareholders' (deficit)/equity Total liabilities and shareholders' (deficit)/equity. See accompanying notes to consolidated financial statementr. Lowe's Companies, Inc. Consolidated Statemeats of Earnings (tn millions, execpt per share and percentage data Lowe's Companies, Inc. Consolidated Statements of Comprehensive Income (In millions, except percentage data) Dowe's Companies, Inc. Consolidated Statemeats of Shareholderst (Deficit) Fquiry Lowe's - Fiscal 2021 Pg2 Vertical Analysis of the Income Statement (Common-Size Statements) Use the data from Lowe's Consolidated Statements of Earnings to fill in Fiscal 2021 below. Enter the amounts exactly as they are shown on the financial statement, which are in millions. Basic Earnings per Common Share % columns may not add-up due to rounding Vertical Analysis of the Balance Sheet (Common-Size Statements) Use the data from Lowe's Consobdated Balance Sheets to fill in Fiscal 2021 below. Enter the amounts exactly as they are shown on the financial statement, which are in milions. Lone's - Fiscal 20R1 DuPont Analysis . Return on Assets Apply DuPont Analysis and the Return on Assete \% to evaluase towe's coveral finaneial berfonmance Use the information in Lowe's inesme Statement and falacise Sheets for Facal 2021 and Fiacal 2060 is of the thancial suatement itema bat wit be tased in the numerator and the denominatoe of the tatios Enter the financial statement doltar amounts just as they are shown on the financiai ntminments. Round at averages to 0 decimal placet -1 whole number 5x, 00x Found the persentages bo 2 decimal pleset xx,x4 Round the decimal results to 2 decimel placet. cx.,ox Note Since each ratio is being rounded, it is poss ble that Return on Equty, %. wit nof exactly equal (Profitabuley x Eticiency x Leverage). Calculate each ratio separately. Do not calculate Return on Equaty K by multiolvina iProd rabiliv x Efficianev x l avarane Lowe's - Fiscal 2021 Pg,7 Profitability Indicators Apply the three Profitability Indicators to evaluate Lowe's profitability. Use the information in Lowe's Fiscal 2021 Income Statement to calculate the three Profitability Indicators. In the left-hand column enter the names of the items that will be used in the numerator and the denominator of the ratios Enter the financial statement dollar amounts just as they are shown on the financial statements. Round the percentages to 2 decimal places. xx.xx% Gross Profit Margin \% 2021 sicoxsocx $x, $00,00 Net Profit Margin \% 500,000 Efficiency Indicators Round it be desinal ineils bo 2 atecimal places an wa NietFiniesAccowitsRecelrableRumoverRatio Average Avecunts Rech wiplen thel Des to are Gine in 19 fars,ein Anemex and 2028 Number of ouys" Simles we Recelvabiea Dary in a Year (3ese) Aacourts fecevable Tumover Ratio. Invmatany Turnover Racio Number of Darys" Sales in irrventory Fired Asset Tumover Ratio 2021 2020 twe00 Deg. Wr Ant. End pt: Ant Areage trmen 4.73 Lowe's - Fiscal 2021 Pg. 10 Liquidity Indicators Use the information in Lowe's 2021 Balance Sheet to calculate the three Liquidity Indicators. In the left-hand column enter the names of the items that will be used in the calculation. Enter the financial statement dollar amounts just as they are shown on the Balance Sheet. Round the decimal results to 2 decimal places. xx.xx Working Capital Working Capital Current Ratio (Acid Test Ratio) Quick Ratio Cash and Near-Cash Assets Lowe's - Fiscal 2021 Pg11 Statement of Cash Flows Indicators Use the information in Lowe's 2021 Consolidated Statement of Cash Flows to calculate the three Statement of Cash Flows Indicators. In the left-hand column enter the names of the items that will be used in the calculation. Enter the financial statement dollar amounts in millions of dollars as shown on the Consolidated Statement of Cash Flows. Round the decimal results to 2 decimal places. xx.xx (Quality of income Ratio) 2021 2020 Cash Flow to Net Income Ratio 500000 (Cash Flow Adequacy Ratio) Cash Flow to Capital Expenditures Ratio $000,00x Net Cash Paid to Purchase PP\&E to 1 6.50 Free Cash Flow $0000 to 1 1.89 Year-End Closing Market Price of 1 Common Share The Year-End Closing Market Price of 1 share of Lowe's Common Stock is not given in Lowe's annual report. The Year-End Closing Market Price is used in the two calculations below. The last day in Lowe's 2021 fiscal year was Friday, Jan 28, 2022. Lowe's common stock trades on the New York Stock Exchange (NYSE). On the NYSE, Lowe's year-end closing market price on Friday, Jan, 28,2022 was $234,99. Enter that price in the box below. 2021 Year-End Closing Market Price of 1 Common Share 2. Morizontal Analysss or the income statement (PG. 3) 1> Rank the following items in terms of which had the largest % increase from Fiscal 2019 to Fiscal 2020. Place a " 1 " in the box of the largest, a "2" in the box of the second largest, etc. 2. Rank the following items in terms of which had the largest \% increase from Fiscal 2020 to Fiscal 2021. Place a"1"intheboxofthelargest,a"2"intheboxofthesecondlargest,etc. Net Sales Cost of Sales Pre-Tax Earnings Net Earnings 3. True or False? In terms of \% Change, Selling, General and Admin, increased more than Net Sales from Fiscal 2019 to Fiscal 2020. [ x only one answer] True False 4> True or False? In terms of \% Change, from Fiscal 2020 to Fiscal 2021 Cost of Sales increased more than Net Sales. ["xonlyoneanswer]TrueFalse. Lowe's - Fiscili2021 Analytical Observations 2. Vertical Analysis of the Balance Stheet (Pg4) 1> For fiscal year 2021, rank the following assets in terms of which was the largest as a No of fotal Assets, Plase a "1" in the box of the largest, a "2" in the box of the second largent, ete Gash and Caat Equtralents Merchandace inventogy + net Froperty, Letz Actum Depr. Leng-1enos investenents 27 For fiscal year 2021 , rank the folowing Hems in berms of which was the largest as a \% of Total Liabilities and Shareholders' Equity. Place a " 1 " in the bex of the latgest, a +2 in the box of the second laraest. etc. 4. Horizontal Analysis of the Balance Sheet (Pg,5) 1> Rank the following items in terms of which had the largest % decrease from Fiscal 2020 to Fiscal 2021. Place a " 1 " in the bax of the largest, a 22 in the box of the second largest, etc. 5. DuPont Analysis - Return on Assets Ratio (Pg,6) 1> True or False? Profitablity increased from Fiscal 2020 to Fiscal 2021 ? ["x"onlyonearswer]True False 2. True or False? Efficiency increased from Fiscal 2020 to Fiscal 2021? [xonlyoneanswer]True False 3> Which fiscal year has the highest Return on Assets \%? [" x " only one answer] 2021 2020 Lowe's - Fiscal 2021 Pg15 Analytical Observations 7. Efficiency Indicators (Pg.8) 12 Based on the Inventory Turnover Ratio, in which fiscal year, 2021 or 2020, did Lowe's more efficiently manage the invontory asset? ["xonlyoneanswer]2021 2> Basod on Number of Days' Sales in Inventory, in which fiscal year, 2021 or 2020. did Lowe's have an item in inventory for the shortest amount of time? [xonlyoneanswer]2021 3> Based on the Number of Days' Purchases in Accounts Payable, in which fiscal year, 2021 or 2020, did Lowe's hold on to its cash longer before paying the cash to vendors? [x"onlyoneanswer]2021 4> Which fiscal year, 2021 or 2020 , had the better Cash-to-Cash Cycle? [xonlyoneanswer]2021 5 . In which fiscal year, 2021 or 2020, did Lowe's have the better Flood Asset Turnover Ratio? [xonlyoneantwor]2021 8. Leverage Indicators (at year-end) - Interest Coverage (Pg.9) 1. Based on the Debt \%, who had the greatest claim to Lowe's assets in Fiscal 2021? [xonlyoneanswer]CreditorsShareholders Creditors Shareholders 2> True or False? In Fiscal 2021 more than half of Lowe's Total Assets were financed with debt? ["x"onlyoneanswer]TrueFalse 3> Based on the Times Interest Earned Ratio, were the creditors' interest payments more secure in Fiscal 2021 or Fiscal 2020 ? [xonlyoneanswer]2021 9. Liquidity Indicators ( Pg.10) 1> Based on all three of the Liquidity Indicators did Liquidity increase or decrease from Fiscal 2020 to Fiscal 2021 ? [" x only one answer] Liquidity Increased Liquidity Decreased Pg. 16 Analytical Observations 10. Statement of Cash Flows Indicators (Pg. 11) 1> True or False? By looking at the Cash Flow to Capital Expenditure Ratio it can be seen that Lowe's was able to internally fund the purchases of Fixed Assets in Fiscal 2021 and in Fiscal 2020. ["x"onlyoneanswer]TrueFalse 2> In which fiscal year, 2021 or 2020 , did Lowe's have more Free Cash Flow? ["x"onlyoneanswer]2021 2020 11. Equity Investor Indicators ( Pg.12) 1> True or False? Based on the Dividend Payout \% it can be seen that Lowe's paid out a larger percent of Net Income, in the form of Cash Dividends, in Fiscal 2021 than in Fiscal 2020. ["x"onlyoneanswer]TrueFalse 2> Based on the Price-Earnings Ratio, in which fiscal year, 2021 or 2020, did investors place a higher value on Lowe's earnings? ["x"onlyoneanswer]2021 3> Based on the Dividend Yield \%, in which fiscal year, 2021 or 2020, did an investor in Lowe's Common Stock earn a higher return from the cash dividends she received on her Lowe's Common Stock? [" x " only one answer] 2021 2020