Answered step by step
Verified Expert Solution
Link Copied!

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)
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Challenges And Impacts Of Religious Endowments On Global Economics And Finance

Authors: Buerhan Saiti , Adel Sarea

1st Edition

1799812456,1799812480

More Books

Students also viewed these Finance questions