Info for Performa Forecast is in the images below. PLEASE FILL OUT THE PROFORMA FORECAST...
60.1K
Verified Solution
Link Copied!
Question
Accounting
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}
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!