Question: Please help me with the 3Q21 in Model sheet. 3021 139,207 1,318 i Wallmart (WMT) 2 $142.00 3 INCOME STATEMENT 4 Sales Revenues 5 Other

3021 139,207 1,318 i Wallmart (WMT) 2 $142.00 3 INCOME STATEMENT 4 Sales Revenues 5 Other Revenues 6 Total revenue 7 Cost of Sales 8 Other Costs 9 Cost of Goods Sold 10 Gross Profit 11 Selling General and Administrative 12 Provision for Doubtful Accounts 13** OPEN ROW ** 14 EBITDA 15 Depreciation 16 Amortization 17 Operating income 18 Equity in Investment in Affiliates 19 Interest Income 20 Pension Expense 21 Other Income/Expense 22 OPEN ROW 23 EBIT 24 Interest Expense 25 Non Operating / Unusual items 26 Pretax Net Income 27 Non Operating After Tax Items 28 Income Taxes 29 Net income before minority 30 Non-Controlling Income 31 Preferred Dividend 32 GAAP Net Income 33 Check 34 Adjusted Core Income 35 Shares Outstanding 36 Avg Dilluted Shares Model Input Sheet 13103 BA A 2 TARGET CORPORATION (TGT) 3Q21 4 INCOME STATEMENT 5 Net Sales 6 Membership and Other Income 7 Total Revenue 8 Cost of Sales 9 Gross profit 10 Selling General and Administrative 11 Total Operating Expenses 12 Operating income 13 Interests Debts 14 Interest - Capital Lease and Financingo 15 Interest Income 16 Other Gain/loss 17 Interest and Other (Net) 18 Earnings before Taxes 19 Provision for Income Tax 20 Minority Interest (After Tax) 21 Ne Earnings 22 23 Weighted Avg. Shares Basic 24 Weighted Avg. Shares Diluted 25 26 Dividends Per Share 27 28 Depreciation and Amortization 29 Depreciation Expense 30 Amortization Expense 31 Intangible Amortization (Est.) 32 Depreciation Expense 33 139, 207 1,318 140, 525 -105, 023 35, 502 -29, 710 -29.710 5, 792 -408 -78 44 -1, 203 -1, 645 4, 147 -1, 015 -27 3, 105 2. 785 2,797 $ 0.55 -2, 609 Model Input Sheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
