Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

all answers must be in entered as a formula. thanks. Calculating total cash flows - Excel FORMULAS DATA REVIEW VIEW Sign In FILE HOME INSERT

image text in transcribed
image text in transcribed
all answers must be in entered as a formula. thanks.
Calculating total cash flows - Excel FORMULAS DATA REVIEW VIEW Sign In FILE HOME INSERT PAGE LAYOUT Arial Cells Editing Paste BIU 12 % 3.A - Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles Clipboard X D32 D E G F H B 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? 4 S 6 $ 7 B 9 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 11 12 13 14 $ 15 New equity Net new long-term debt Change in fixed assets 6,100 (4,500) 25,000 16 1 MacBook Air 80 000 F2 000 F4 " MacBook Air 11 FB

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions