Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using a spreadsheet, prepare the following for the most recent two years: Comparative Income Statement - Vertical Analysis Consolidated Statements of Earnings - USD ($$)

Using a spreadsheet, prepare the following for the most recent two years:

Comparative Income Statement - Vertical Analysisimage text in transcribedimage text in transcribed

Consolidated Statements of Earnings - USD (\$\$) shares in Millions, \$ 12 Months Ended Jan. 30, 2021 Feb. 01, 2020 Feb. 02, 2019 Consolidated Statements of Earnings [Abstract] Revenue Cost of sales Gross profit Selling, general and administrative expenses Restructuring charges Operating income Other income (expense): Gain on sale of investments Investment income and other Interest expense Earnings before income tax expense Income tax expense Net earnings Basic earnings per share Diluted earnings per share \begin{tabular}{|r|r|r|} \hline 47262 & 43638 & 42879 \\ \hline 36689 & 33590 & 32918 \\ \hline 10573 & 10048 & 9961 \\ \hline 7928 & 7998 & 8015 \\ \hline 254 & 41 & 46 \\ \hline 2391 & 2009 & 1900 \\ \hline \end{tabular} Weighted-average common shares outstanding Basic Diluted \begin{tabular}{|r|r|r|} 259.6 & 264.9 & 276.4 \\ \hline 263 & 268.1 & 281.4 \\ \hline \end{tabular} Consolidated Statements of Earnings - USD (\$\$) shares in Millions, \$ 12 Months Ended Jan. 30, 2021 Feb. 01, 2020 Feb. 02, 2019 Consolidated Statements of Earnings [Abstract] Revenue Cost of sales Gross profit Selling, general and administrative expenses Restructuring charges Operating income Other income (expense): Gain on sale of investments Investment income and other Interest expense Earnings before income tax expense Income tax expense Net earnings Basic earnings per share Diluted earnings per share \begin{tabular}{|r|r|r|} \hline 47262 & 43638 & 42879 \\ \hline 36689 & 33590 & 32918 \\ \hline 10573 & 10048 & 9961 \\ \hline 7928 & 7998 & 8015 \\ \hline 254 & 41 & 46 \\ \hline 2391 & 2009 & 1900 \\ \hline \end{tabular} Weighted-average common shares outstanding Basic Diluted \begin{tabular}{|r|r|r|} 259.6 & 264.9 & 276.4 \\ \hline 263 & 268.1 & 281.4 \\ \hline \end{tabular}

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

Step: 3

blur-text-image

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

Im A Auditor If You Dont Want A Sarcastic Answer Dont Ask A Stupid Question

Authors: Tim Hansen

1st Edition

B088Y3ZP2D, 979-8618443227

More Books

Students also viewed these Accounting questions