This question is through McGraw, and makes it more difficult by only accepting answers with excel equations (i.e. Q.1 would be =D6, or the taxes would be =D22*D11) But if you don't want to write it that way, I'll figure that part out... I just need to know the answers and how you got them!! Thank you, I've been trying to solve this for over an hour and I'm brain dead.

$ - x Calculating depreciation - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Arial 12 A A % Paste Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles 2 Clipboard Font D26 X fi =D9 B D E F G H J K 4 5 6 7 8 9 Sales $ Costs $ Addition to retained earnings $ Dividends paid $ Interest expense $ Tax rate 61,000 29,600 5,600 1,950 4,300 21% 10 11 12 13 14 15 16 17 18 19 Complete the following analysis. Do not hard code values in your calculations. NOTE: You must enter your calculations in the order numbered in Column B. Income Statement 1) Sales $ 61,000 2) Costs 29,600 10) Depreciation expense 9) EBIT 8) Interest expense 4,300 6) EBT 7) Taxes 5) Net income $ 7,550 20 21 22 23 24 25 26 3) Dividends $ 4) Addition to retained earnings $ 1,950 5,600 27 28 - Sheet1 READY + 60% Attempt(s) 0/10 Hint