All answers must be entered as excel formulas, i.e. =SUM(D7:D12)

AB D E F G H I J Jetson Spacecraft Corp. shows the following information on its income statement: sales = $235,000; costs = $141,000; other expenses = $7,900; depreciation expense = $17,300; interest expense = $12,900; taxes = $19,565; dividends = $12,300. In addition, you're told that the firm issued $6,100 in new equity during the year and redeemed $4,500 in outstanding long-term debt. a. What is the operating cash flow? b. What is the cash flow to creditors? c. What is the cash flow to stockholders? d. If net fixed assets increased by $25,000 during the year, what was the addition to NWC? Sales Costs Other expenses Depreciation expense Interest expense Taxes Dividends 235,000 141,000 7,900 17,300 12,900 19,565 12,300 New equity Net new long-term debt Change in fixed assets 6,100 (4,500) 25,000 Complete the following analysis. Do not hard code values in your calculations. Income Statement Sales Costs Other expenses Depreciation expense EBIT Interest expense EBT Taxes Net income Dividends Addition to retained earnings a. Operating cash flow b. Cash flow to creditors C. Cash flow to stockholders d. Cash flow from assets Net capital spending Change in NWC AB D E F G H I J Jetson Spacecraft Corp. shows the following information on its income statement: sales = $235,000; costs = $141,000; other expenses = $7,900; depreciation expense = $17,300; interest expense = $12,900; taxes = $19,565; dividends = $12,300. In addition, you're told that the firm issued $6,100 in new equity during the year and redeemed $4,500 in outstanding long-term debt. a. What is the operating cash flow? b. What is the cash flow to creditors? c. What is the cash flow to stockholders? d. If net fixed assets increased by $25,000 during the year, what was the addition to NWC? Sales Costs Other expenses Depreciation expense Interest expense Taxes Dividends 235,000 141,000 7,900 17,300 12,900 19,565 12,300 New equity Net new long-term debt Change in fixed assets 6,100 (4,500) 25,000 Complete the following analysis. Do not hard code values in your calculations. Income Statement Sales Costs Other expenses Depreciation expense EBIT Interest expense EBT Taxes Net income Dividends Addition to retained earnings a. Operating cash flow b. Cash flow to creditors C. Cash flow to stockholders d. Cash flow from assets Net capital spending Change in NWC