% 9 Jim's Espresso expects sales to grow by 9.8% next year Using the following statements and the percent of sales method File Hom insert Draw Page Form Data Rev a. Costs b. Depreciation A 96 Conde c. Net Income Clipboard d. Cash Font rom Alignment Number e. Accounts receivable Cells f. Inventory g. Property, plant, and equipment (Note: Make sure to round all intermediate calculations to at least five decimal places X Balances The Tax Cuts and Jobs Act of 2017 temporarily allows 100% bonus depre these problems in anticipation of the return of standard depreciation pract data 11.10.2021-72 E 2 A 1 Balance Sheet A1 2 Assets a. Costs 3 Cash and Equivalents $14.990 B The forecasted costs will be $ (Round to the nearest dollar and enter 4 Accounts Receivable 1960 1 Income Statement 5 Inventories 4050 2 Sales $195,910 6 Total Current Assets $20,990 3 Costs Except Depreciation (99,950) 7. Property. Plant and Equipment 9950 4 EBITDA $95,960 8 Total Assets $30,910 5 Depreciation (15,910) 6 EBIT $90,050 10 Liabilities and Equity 7 Interest Expense (net) (410) 11 Accounts Payable S1.580 8 Pretax income $89,640 12 Debt 3900 9 Income Tax (22,410) 13 Total liabilities $5,480 10 Net Income $67,230 25460 14 Stockholders' Equity 11 15 Total abilities and Equity $30.940 data-11_10_2021-xx dita 11.10_2021 12 16 9 B