Answered step by step
Verified Expert Solution
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 Analysis
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started