Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Info for Performa Forecast is in the images below. PLEASE FILL OUT THE PROFORMA FORECAST WITH THE FORMULAS IN THE CELLS. The Horne Depat, Inc.
Info for Performa Forecast is in the images below. PLEASE FILL OUT THE PROFORMA FORECAST WITH THE FORMULAS IN THE CELLS.
The Horne Depat, Inc. Consollidated Ealance Sheets fs in milfions, except per share data) As of: 27 Masets 28 Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets 33. Property and equipment, cost 34 Land 35 Buildings and Other 36 Furniture, Fixtures and Equipment Less accumulated depreciation Property and equipment, net 39 Intangibles and other assets Total assets Current liabilities: Consolidated Statements of Earnings - USD (\$) shares in Millions, \$ in Millions Income Statement [Abstract] Net sales cost of sales Gross profit Jan. 30, 2022 Jan. 31, 2021 Feb. 02, 2020 Operating expenses: Selling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense: Interest and investment income Interest expense Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings Basic weighted average common shares Basic earnings per share Diluted weighted average common shares Diluted earnings per share \begin{tabular}{|rrr|} \hline 25,406 & 24,447 & 19,740 \\ \hline 2,386 & 2,128 & 1,989 \\ \hline 27,792 & 26,575 & 21,729 \\ \hline 23,040 & 18,278 & 15,843 \\ \hline \end{tabular} \begin{tabular}{rrrr} (44) & (47) & (73) \\ \hline 1,347 & 1,347 & 1,201 \\ 1,303 & 1,300 & 1,128 \\ \hline 21,737 & 16,978 & 14,715 \\ \hline 5,304 & 4,112 & 3,473 \\ \hline$16,433 & $12,866 & $11,242 \\ \hline 1,054 & 1,074 & 1,093 \\ \hline 15.59 & $11.98 & $10.29 \\ 1,058 & 1,078 & 1,097 \\ $15.53 & $11,94 & $10.25 \\ \hline \end{tabular} The Horne Depat, Inc. Consollidated Ealance Sheets fs in milfions, except per share data) As of: 27 Masets 28 Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets 33. Property and equipment, cost 34 Land 35 Buildings and Other 36 Furniture, Fixtures and Equipment Less accumulated depreciation Property and equipment, net 39 Intangibles and other assets Total assets Current liabilities: Consolidated Statements of Earnings - USD (\$) shares in Millions, \$ in Millions Income Statement [Abstract] Net sales cost of sales Gross profit Jan. 30, 2022 Jan. 31, 2021 Feb. 02, 2020 Operating expenses: Selling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense: Interest and investment income Interest expense Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings Basic weighted average common shares Basic earnings per share Diluted weighted average common shares Diluted earnings per share \begin{tabular}{|rrr|} \hline 25,406 & 24,447 & 19,740 \\ \hline 2,386 & 2,128 & 1,989 \\ \hline 27,792 & 26,575 & 21,729 \\ \hline 23,040 & 18,278 & 15,843 \\ \hline \end{tabular} \begin{tabular}{rrrr} (44) & (47) & (73) \\ \hline 1,347 & 1,347 & 1,201 \\ 1,303 & 1,300 & 1,128 \\ \hline 21,737 & 16,978 & 14,715 \\ \hline 5,304 & 4,112 & 3,473 \\ \hline$16,433 & $12,866 & $11,242 \\ \hline 1,054 & 1,074 & 1,093 \\ \hline 15.59 & $11.98 & $10.29 \\ 1,058 & 1,078 & 1,097 \\ $15.53 & $11,94 & $10.25 \\ \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