please use excel to solve this question

Problems Income Statement Balance Sheet Sales 200,000 Assets Costs Except Depreciation (100,000) Cash and Equivalents 15,000 EBITDA 100,000 Accounts Receivable 2000 Depreciation (6000) Inventories 4000 EBIT 94,000 Total Current Assets 21,000 Interest Expense (net) (400) Property, Plant, and Equipment 10,000 Pre-tax Income 93,600 Total Assets 31,000 Income Tax (32,760) Net Income 60,840 Liabilities and Equity Accounts Payable 1500 Problems Depreciation (6000) Inventories 4000 EBIT 94,000 Total Current Assets 21,000 Interest Expense (net) (400) Property, Plant, and Equipment 10,000 Pre-tax Income 93,600 Total Assets 31,000 Income Tax (32,760) Net Income 60,840 Liabilities and Equity Accounts Payable 1500 Debt 4000 Total Liabilities 5500 Stockholders' Equity 25,500 Total Liabilities and Equity 31,000 | 4. Jim's Espresso expects sales to grow by 10% next year. Using the percent of sales method, forecast the following: a. Costs b. Depreciation c. Net income d. Cash e. Accounts receivable f. Inventory g. Property, plant, and equipment Problems Income Statement Balance Sheet Sales 200,000 Assets Costs Except Depreciation (100,000) Cash and Equivalents 15,000 EBITDA 100,000 Accounts Receivable 2000 Depreciation (6000) Inventories 4000 EBIT 94,000 Total Current Assets 21,000 Interest Expense (net) (400) Property, Plant, and Equipment 10,000 Pre-tax Income 93,600 Total Assets 31,000 Income Tax (32,760) Net Income 60,840 Liabilities and Equity Accounts Payable 1500 Problems Depreciation (6000) Inventories 4000 EBIT 94,000 Total Current Assets 21,000 Interest Expense (net) (400) Property, Plant, and Equipment 10,000 Pre-tax Income 93,600 Total Assets 31,000 Income Tax (32,760) Net Income 60,840 Liabilities and Equity Accounts Payable 1500 Debt 4000 Total Liabilities 5500 Stockholders' Equity 25,500 Total Liabilities and Equity 31,000 | 4. Jim's Espresso expects sales to grow by 10% next year. Using the percent of sales method, forecast the following: a. Costs b. Depreciation c. Net income d. Cash e. Accounts receivable f. Inventory g. Property, plant, and equipment