PAGE LAPUUI FUNMULLS DATA REVIEW VIEW X Calibri AA % Paste BIU- A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 X ok A B D E F G H K at 1 2 nces 3 Billy's Exterminators, Inc., has sales of $817,000, costs of $343,000, depreciation expense of $51,000, interest expense of $38,000, and a tax rate of 21 percent. The firm just paid out $95,000 in cash dividends. What is the addition to retained earings? 4 5 6 7 Sales Costs Depreciation expense Interest expense $ 817,000 343,000 51,000 38,000 8 9 10 11 12 Tax rate 21% 13 Cash dividends $ 95,000 14 15 16 17 Complete the following analysis. Do not hard code values in your calculations. 18 Income Statement 19 Sales A1 F G H 1 7 8 9 B c Costs Depreciation expense Interest expense D 343,000 51,000 38,000 10 Tax rate 21% 11 12 13 Cash dividends $ 95,000 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 18 19 20 21 22 23 Income Statement Sales Costs Depreciation expense EBIT Interest expense EBT Taxes (21%) Net income 24 25 26 27 28 29 Addition to retained earnings Sheet1