Question

Please show what to write on Excel. For example (=D7+D8)

The D B 1 u. B-?»_a. Alignment Number Conditional Format asvell. Cells Editing Paste Formatting Table Styles Styles Clipboard A1 A B Font Jetson Spacecraft Corp. shows the following information on its 2011 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 2011 and redeemed $4,500 in outstanding long-term debt. a. What is the 2011 operating cash flow? b. What is the 2011 cash flow to creditors? c. What is the 2011 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 10 12 13 $ 6,100 15 16 17 18 2011 New equity Net new long-term debt Change in net fixed assets (4,500) 25,000

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

I HAVE WRITTEN ALL EXCEL FORMULAS DO YOU CAN PUT IN YOUR EXCEL SHEET, YOU WILL GET ANSWER. WE ARE NOT ALLOWED TO SUBMIT EXCEL SHEET AS YOU KNOW. THANK YOU