Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To begin your financial statement ratio analysis, use data to complete Financial Statement Ratios Additional notes below are required reading: Current Ratio and Acid Test

To begin your financial statement ratio analysis, use data to complete Financial Statement Ratios
Additional notes below are required reading:
Current Ratio and Acid Test answers are rounded to two decimals.
Use percentages (with two decimal places) for Debt Ratio, Equity Ratio, Debt to Equity Ratio and Profit Margin
Lowe's Companies, Inc does not have Accounts Receivables or Trade Receivables therefore use zero in calculation that includes receivables.
Net income is called Net earnings on Consolidated Statement of Earnings report.
Use Basic earnings per common share for Earnings per share.
You will need to do an online search for market price per common share. The market price is the price the stock was selling for on report year end dates. Stock symbol is LOW
Submit completed Financial Statement Ratios for Lowe's Companies, Inc. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
\begin{tabular}{|c|c|c|} \hline Consolidated Balance Sheets - USO (\$) \$ in Millions & tan28,2022 & Jan.29,2021 \\ \hline \multicolumn{3}{|l|}{ Current assets } \\ \hline Cash and cash equivalents & $1,133 & $4.690 \\ \hline Short-term investments & 271 & 506 \\ \hline Merchandise irwentory - nat: & 17,605 & 16,193 \\ \hline Qther current assets & 1.051 & 937 \\ \hline Total current assets & 20,060 & 22,326 \\ \hline Property, less ascumulated depreciation & 19,071 & 19,155 \\ \hline Operasng lease rightoof-use assets & 4108 & 3,832 \\ \hline Long-term investments & 199 & 200 \\ \hline Deferredincome taxes-net & 164 & 340 \\ \hline Other assets & 1,038 & 882 \\ \hline Total assets & 44,640 & 46,735 \\ \hline \multicolumn{3}{|l|}{ Current liabilities } \\ \hline Qurrentmauritles of long-term debt & 868 & 1,112 \\ \hline Current operating lease liablittes & 636 & 541 \\ \hline Acoounts payable & 11,354 & 10,884 \\ \hline Accrued compensation and employea benefits & 1,561 & 1,350 \\ \hline Deferred revenue & 1,914 & 1,608 \\ \hline Cther cutrent liabilltes & 3,335 & 3.235 \\ \hline Total currentilabifties & 19,668 & 18,730 \\ \hline Lorg-term debt axduding currentmaturltes & 23,859 & 20,668 \\ \hline Noncurrent operating lease liabilites & 4,021 & 3,890 \\ \hline Deferred revenue - Lowe's protection plans & 1.127 & 1,019 \\ \hline Other liablites & 781 & 991 \\ \hline Total lisblittes & 49,456 & 45,298 \\ \hline \multirow{2}{*}{\multicolumn{3}{|c|}{\begin{tabular}{l} Commitments and contngensies \\ Shareholders (defidt)/equity? \end{tabular}}} \\ \hline & & \\ \hline Preferred too k$5 por value: Au thorized 5.0m ilion shares; issued & 0 & 0 \\ \hline & 335 & 366 \\ \hline Capital in excess of par value & 0 & 90 \\ \hline (Acoumul ated deffoly/retained earrings & (5,115) & 1,117 \\ \hline Accumulated other comprebensivelost & (36) & (136) \\ \hline Total sharefiders' (deflct)/equity & (4.816) & 1,437 \\ \hline Totw ifdoritses and sharehalders' (deffet)/fequity. & $44640 & $46,735 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|l|}{ Lowes Companies Inc } \\ \hline \begin{tabular}{l} Consolidated Statements of Cash Fows - USD ($)$ in \\ Millions \end{tabular} & \multicolumn{3}{|c|}{12 Months Ended } \\ \hline \multicolumn{4}{|l|}{ Cash flows from operating activities } \\ \hline Net earnings & $8,442 & $5,835 & $4,281 \\ \hline \multicolumn{4}{|l|}{ Adjustments to reconcile net earnings to net cash } \\ \hline Depreciation and amortization & 1,882 & 1,594 & 1,410 \\ \hline Noncash lease expense & 517 & 479 & 468 \\ \hline Deferredincome taxes & 135 & (108) & 177 \\ \hline Loss on property and other assets - net & 34 & 139 & 117 \\ \hline Loss on extinguishment of debt & 0 & 1,060 & \\ \hline Share-based payment expense & 230 & 155 & 98 \\ \hline \multicolumn{4}{|l|}{ Changes in operating assets and liabilities } \\ \hline Merchandise inventory - net & (1,413) & (2,967) & (600) \\ \hline Other operating assets & (23) & 326 & (354) \\ \hline Accounts payable. & 466 & 3,211 & (637) \\ \hline Deferred revenue & 413 & 512 & (15) \\ \hline Other operating liabilities & (570) & 813 & (639) \\ \hline Net cash provided by operating activities & 10,113 & 11,049 & 4,296 \\ \hline \multicolumn{4}{|l|}{ Cash flows from investing activities: } \\ \hline Purchases of investments & (3,065) & (3,094) & (743) \\ \hline Proceeds from sale/maturity of investments & 3,293 & 2,926 & 695 \\ \hline Capital expenditures & (1,853) & (1,791) & (1,484) \\ \hline Proceeds from sale of property and other long-term & 113 & 90 & 163 \\ \hline Other-net & (134) & (25) & 0 \\ \hline Netcash usedin investing activities & (1,646) & (1,894) & (1,369) \\ \hline \multicolumn{4}{|l|}{ Cash flows from financing activities: } \\ \hline Net change in commer cial paper & 0 & (941) & 220 \\ \hline Net proceeds from issuance of debt & 4,972 & 7.929 & 3,972 \\ \hline Repayment of debt & (2,118) & (5,618) & (1,113) \\ \hline Proceeds from issuance of common stock under share- & 132 & 152 & 118 \\ \hline Cash dividend payments & (1,984) & (1,704) & (1,618) \\ \hline Repurchases of common stock & (13,012) & (4,971) & (4,313) \\ \hline Other-net & (6) & (38) & (1) \\ \hline Net cash used in financing activities & (12,016) & (5,191) & (2,735) \\ \hline Effect of exchange rate charges on cash & (8) & 10 & 1 \\ \hline \begin{tabular}{l} Net (decrease)/increase in cash and cashequivalents, \\ induding cash dassiffed within current assets held for \end{tabular} & (3,557) & 3,974 & 193 \\ \hline Less: Net decrease in cash dassified within curr & 0 & 0 & 12 \\ \hline \end{tabular} Changes in operating assets and liabilities Merchandise inventory - net Other operating assets Accounts payable Deferred revenue Other operating liabilities Net cash provided by operating activities Cash flows from investing activities: Purchases of investments Proceeds from sale/maturity of investrnents Capital expenditures Proceeds from sale of property and other long-term Other-net Netcash used in investing activities Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt Repayment of debt Proceeds from issuance of common stock under share- Cash dividend payments Repurchases of common stock Other-net Net cash used in financing activities Effect of exchange rate charges on cash Net (decrease)/increase in cash and cash equivalents, including cash classified within current assets held for Less: Net decrease in cash dassified within current Net (decrease)/increase in cash and cash equivalents Cash and cash equivalents, begirning of year Cash and cash equivalents, end of year (1,413) (2,967) (600) (23) 326 (364) 3,211 (637) (15) (639) (570)10,11381311,049 4,296 (3,065) (3,094) (743) 3,293 2,926 695 (1,853) (1,791) (1,484) 113 163 (1,646) 0 (1,369) (25) (1,894) 220 \begin{tabular}{cc} (941) & 220 \\ 7,929 & 3,972 \\ (5,618) & (1,113) \\ 152 & 118 \\ (1,704) & (1,618) \\ (4,971) & (4,313) \end{tabular} \begin{tabular}{rrr} 0 & (941) & 220 \\ 4,972 & 7,929 & 3,972 \\ (2,118) & (5,618) & (1,113) \\ 132 & 152 & 118 \\ (1,984) & (1,704) & (1,618) \\ (13,012) & (4,971) & (4,313) \\ (6) & (38) & (1) \\ (12,016) & (5,191) & (2,735) \\ (8) & 10 & 1 \\ (3,557) & 3,974 & 193 \\ 0 & 0 & 12 \\ 0 & 0 & \\ (3,557) & 3,974 & 511 \\ 4,690 & 716 & $716 \end{tabular} Wotks heet Financialstatement Ratios towe's cormenies, inc

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing Uncover Fraud And Protect Your Portfolio

Authors: Kate Mooney

1st Edition

0071481826, 9780071481823

More Books

Students also viewed these Accounting questions