10/1 Update - Added in reference information to help calculate the ratios. Please let me know if anything additional is needed. Thank you!
I need help calculating the following Stock Market Ratios for the Lowe's Company.
Market Price per Share as of 6/21/2022 for Lowe's is $172.38 - this should be used for 2021 and 2020.
Information from the 2021 Annual Report for Reference - Lowe-2021-Annual-Report.pdf (lowes.com):
Information from the Lowe's 2020 Annual Report for Reference - lowes-2020ar.pdf
Lowe's Companies, Inc. Consolidated Statements of Shareholders'(Deficit)/Equity (In millions, except per share data) \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Lowe's 2020} \\ \hline Input & AnnualReportreferencepage#and/orcalculationcomment & Ratio Output \\ \hline 5,835.00 & & 7.811 \\ \hline 747.00 & Calculation: =(731+763)/2 & \\ \hline & & 0.000 \\ \hline 7.81 & & \\ \hline & & \#DIV/0! \\ \hline & & \\ \hline & & #DIV/0! \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Assets & & & & \\ \hline Current assets: & & & & \\ \hline Cash and cash equivalents & $ & 4,690 & S & 716 \\ \hline Short-term investments & & 506 & & 160 \\ \hline Merchandise inventory - net & & 16,193 & & 13,179 \\ \hline Other current assets & & 937 & & 1,263 \\ \hline Total current assets & & 22,326 & & 15,318 \\ \hline Property, less accumulated depreciation & & 19,155 & & 18,769 \\ \hline Operating lease right-of-use assets & & 3,832 & & 3,891 \\ \hline Long-term investments & & 200 & & 372 \\ \hline Deferred income taxes - net & & 340 & & 216 \\ \hline Other assets & & 882 & & 905 \\ \hline Total assets & s & 46,735 & S & 39,471 \\ \hline Liabilities and shareholders' equity & & & & \\ \hline Current liabilities: & & & & \\ \hline Short-term borrowings & $ & - & S & 1,941 \\ \hline Current maturities of long-term debt & & 1,112 & & 597 \\ \hline Current operating lease liabilities & & 541 & & 501 \\ \hline Accounts payable & & 10,884 & & 7,659 \\ \hline Accrued compensation and employee benefits & & 1,350 & & 684 \\ \hline Deferred revenue & & 1,608 & & 1,219 \\ \hline Other current liabilities & & 3,235 & & 2,581 \\ \hline Total current liabilities & & 18,730 & & 15,182 \\ \hline Long-term debt, excluding current maturities & & 20,668 & & 16,768 \\ \hline Noncurrent operating lease liabilities & & 3,890 & & 3,943 \\ \hline Deferred revenue - extended protection plans & & 1,019 & & 894 \\ \hline Other liabilities & & 991 & & 712 \\ \hline Total liabilities & & 45,298 & & 37,499 \\ \hline Commitments and contingencies & & & & \\ \hline Shareholders' equity: & & & & \\ \hline Preferredstock-$5parvalue:Authorized-5.0millionshares;Issuedandoutstanding-none & & - & & - \\ \hline Commonstock$0.50parvalue:Authorized5.6billionshares;Issuedandoutstanding731millionand763million,respectively & & 366 & & 381 \\ \hline Capital in excess of par value & & 90 & & - \\ \hline Retained earnings & & 1,117 & & 1,727 \\ \hline Accumulated other comprehensive loss & & (136) & & (136) \\ \hline Total shareholders' equity & & 1,437 & & 1,972 \\ \hline Total liabilities and shareholders' equity & S & 46,735 & S & 39,471 \\ \hline \end{tabular} Lowe's Companies, Inc. Consolidated Statements of Shareholders' Equity (In millions, except per share data) Lowe's Companies, Inc. Lowe's Companies, Inc. Consolidated Statements of Shareholders'(Deficit)/Equity (In millions, except per share data) \begin{tabular}{|c|c|c|} \hline \multicolumn{3}{|c|}{ Lowe's 2020} \\ \hline Input & AnnualReportreferencepage#and/orcalculationcomment & Ratio Output \\ \hline 5,835.00 & & 7.811 \\ \hline 747.00 & Calculation: =(731+763)/2 & \\ \hline & & 0.000 \\ \hline 7.81 & & \\ \hline & & \#DIV/0! \\ \hline & & \\ \hline & & #DIV/0! \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Assets & & & & \\ \hline Current assets: & & & & \\ \hline Cash and cash equivalents & $ & 4,690 & S & 716 \\ \hline Short-term investments & & 506 & & 160 \\ \hline Merchandise inventory - net & & 16,193 & & 13,179 \\ \hline Other current assets & & 937 & & 1,263 \\ \hline Total current assets & & 22,326 & & 15,318 \\ \hline Property, less accumulated depreciation & & 19,155 & & 18,769 \\ \hline Operating lease right-of-use assets & & 3,832 & & 3,891 \\ \hline Long-term investments & & 200 & & 372 \\ \hline Deferred income taxes - net & & 340 & & 216 \\ \hline Other assets & & 882 & & 905 \\ \hline Total assets & s & 46,735 & S & 39,471 \\ \hline Liabilities and shareholders' equity & & & & \\ \hline Current liabilities: & & & & \\ \hline Short-term borrowings & $ & - & S & 1,941 \\ \hline Current maturities of long-term debt & & 1,112 & & 597 \\ \hline Current operating lease liabilities & & 541 & & 501 \\ \hline Accounts payable & & 10,884 & & 7,659 \\ \hline Accrued compensation and employee benefits & & 1,350 & & 684 \\ \hline Deferred revenue & & 1,608 & & 1,219 \\ \hline Other current liabilities & & 3,235 & & 2,581 \\ \hline Total current liabilities & & 18,730 & & 15,182 \\ \hline Long-term debt, excluding current maturities & & 20,668 & & 16,768 \\ \hline Noncurrent operating lease liabilities & & 3,890 & & 3,943 \\ \hline Deferred revenue - extended protection plans & & 1,019 & & 894 \\ \hline Other liabilities & & 991 & & 712 \\ \hline Total liabilities & & 45,298 & & 37,499 \\ \hline Commitments and contingencies & & & & \\ \hline Shareholders' equity: & & & & \\ \hline Preferredstock-$5parvalue:Authorized-5.0millionshares;Issuedandoutstanding-none & & - & & - \\ \hline Commonstock$0.50parvalue:Authorized5.6billionshares;Issuedandoutstanding731millionand763million,respectively & & 366 & & 381 \\ \hline Capital in excess of par value & & 90 & & - \\ \hline Retained earnings & & 1,117 & & 1,727 \\ \hline Accumulated other comprehensive loss & & (136) & & (136) \\ \hline Total shareholders' equity & & 1,437 & & 1,972 \\ \hline Total liabilities and shareholders' equity & S & 46,735 & S & 39,471 \\ \hline \end{tabular} Lowe's Companies, Inc. Consolidated Statements of Shareholders' Equity (In millions, except per share data) Lowe's Companies, Inc
