Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Change in net fixed assets ,50u) 25,000 17 18 19 20 21 Complete the following analysis. Do not hard code values in your answers Income Statement 23 24 Sales 27 28 29 30 31 32 Costs Other expenses Depreciation expense EBIT Interest expense EBT Taxes Net income Dividends Addition to retained earnings 35 36 37 38 39 40 a. Operating cash flow 41 42 b. Cash flow to creditors 43 44 C. Cash flow to stockholders 45 46 d. Cash flow from assets 47 48 Net capital spending 49 50 Change in NWC 51 52 53 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started