Question

Use the data from the following financial statements in the popup​ window,

The company paid interest expense of $17,700 and had an overall tax rate of 40% for 2017 Find the cash flow for 2017 and break it into 3 parts:
operating cash​ flow, capital​ spending, and change in net working capital.

What is the cash flow from assets?

Partial Income Statement Year Ending 2017 Sales revenue $349,800 Cost of goods sold $141,900 Fixed costs $43,200 Selling, gen

ASSETS Cash Accounts receivable Inventories Partial Balance Sheet 12/31/2017 LIABILITIES $26,200 Notes payable $18,800 Accoun

0 1
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

EBIT = Sales Revenue - Costs of Goods Sold - Fixed Costs - Selling, General and Administrative Expenses - Depreciation
EBIT = $349,800 - $141,900 - $43,200 - $27,800 - $46,000
EBIT = $90,900

EBT = EBIT - Interest Expense
EBT = $90,900 - $17,700
EBT = $73,200

Taxes = EBT * Tax Rate
Taxes = $73,200 * 40%
Taxes = $29,280

Operating Cash Flow = EBIT + Depreciation - Taxes
Operating Cash Flow = $90,900 + $46,000 - $29,280
Operating Cash Flow = $107,620

Ending Current Assets = Cash + Accounts Receivable + Inventories
Ending Current Assets = $26,200 + $18,800 + $52,800
Ending Current Assets = $97,800

Ending Current Liabilities = Notes Payable + Accounts Payable
Ending Current Liabilities = $12,200 + $24,200
Ending Current Liabilities = $36,400

Ending Working Capital = Ending Current Assets – Ending Current Liabilities
Ending Working Capital = $97,800 - $36,400
Ending Working Capital = $61,400

Beginning Current Assets = Cash + Accounts Receivable + Inventories
Beginning Current Assets = $15,800 + $28,200 + $47,900
Beginning Current Assets = $91,900

Beginning Current Liabilities = Notes Payable + Accounts Payable
Beginning Current Liabilities = $13,900 + $19,000
Beginning Current Liabilities = $32,900

Beginning Working Capital = Ending Current Assets – Ending Current Liabilities
Beginning Working Capital = $91,900 - $32,900
Beginning Working Capital = $59,000

Change in Net Working Capital = Ending Working Capital – Beginning Working Capital
Change in Net Working Capital = $61,400 - $59,000
Change in Net Working Capital = $2,400

Net Capital Spending = Ending Fixed Assets - Beginning Fixed Assets
Net Capital Spending = $448,000 - $368,100
Net Capital Spending = $79,900

Cash Flow from Assets = Operating Cash Flow - Net Capital Spending - Change in Net Working Capital
Cash Flow from Assets = $107,620 - $79,900 - $2,400
Cash Flow from Assets = -$25,320

Add a comment
Know the answer?
Add Answer to:
Use the data from the following financial statements in the popup​ window, The company paid interest...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the data from the following financial statements in the popup​ window. The company paid interest...

    Use the data from the following financial statements in the popup​ window. The company paid interest expense of $17,700 and had an overall tax rate of 40 % for 2017. Complete the statement of retained earnings for 2017​, and determine the dividends paid last year. (Click on the following icon in order to copy its contents into a spreadsheet.) Partial Income Statement Year Ending 2017 Sales revenue $350,000 Cost of goods sold $141,900 Fixed costs $43,100 Selling, general, and administrative...

  • Statement of retained earnings. Use the data from the following financial statements in the popup window,...

    Statement of retained earnings. Use the data from the following financial statements in the popup window, BB. The company paid interest expense of $18,800 for 2017 and had an overall tax rate of 40% for 2017. Complete the statement of retained earnings for 2017, and determine the dividends paid last year. The distributed earnings is $ . (Round to the nearest dollar.) Partial Income Statement Year Ending 2017 Sales revenue $350,200 Cost of goods sold $141,900 Fixed costs $42,900 Selling,...

  • Cash flow from assets. Use the data from the following financial statements in the popup window....

    Cash flow from assets. Use the data from the following financial statements in the popup window. The company paid interest expense of $17,200 for 2014 and had an overall tax rate of 40% for 2014. Find the cash flow from assets for 2014, and break it into its three parts: operating cash flow, capital spending, and change in net working capital The operating cash flow is $(Round to the nearest dollar.) The capital spending is $(Round to the nearest dollar.)...

  • Cash flow to owners. Use the data from the following financial statements in the popup​ window,...

    Cash flow to owners. Use the data from the following financial statements in the popup​ window, LOADING... . The company paid interest expense of $ 18 comma 700$18,700 for 20172017 and had an overall tax rate of 40 %40% for 20172017. Find the cash flow to owners for 20172017 by parts and​ total, with the parts being dividends paid and increases in borrowing from owners​ (change in common stock and​ paid-in-surplus). 1Data Table Partial Income Statement Year Ending 2017 Sales...

  • Cash flow to owners. Use the data from the following financial statements in the popup window,...

    Cash flow to owners. Use the data from the following financial statements in the popup window, The company paid interest expense of $18,000 for 2017 and had an overall tax rate of 40% for 2017. Find the cash flow to owners for 2017 by parts and total, with the parts being dividends paid and increases in borrowing from owners (change in common stock and paid-in-surplus). The distributed earnings is $ . (Round to the nearest dollar.) rarua come Jalement Tea...

  • Cash flow identity.  The company paid interest expense of $17,700 for 2017 and had an overall tax...

    Cash flow identity.  The company paid interest expense of $17,700 for 2017 and had an overall tax rate of 40% for 2017. Verify the cash flow​ identity: cash flow from assets = cash flow to creditors + cash flow to owners A. The cash flow from assets is $______ B. The cash flow to creditors is $______ C. The cash flow to owners is $_______ Partial Income Statement Year Ending 2017 Sales revenue $350,000 Cost of goods sold $141,900 Fixed costs...

  • Cash flow to owners. Use the data from the following financial statements in the popup​ window,...

    Cash flow to owners. Use the data from the following financial statements in the popup​ window, LOADING.... The company paid interest expense of $ 18 comma 100 for 2017 and had an overall tax rate of 40 % for 2017. Find the cash flow to owners for 2017 by parts and​ total, with the parts being dividends paid and increases in borrowing from owners​ (change in common stock and​ paid-in-surplus). The distributed earning is aspx?homeworkId=550UJO Financial Statements 15 of 16...

  • Sales revenue   350,200 Cost of goods sold   141,900 Fixed costs   43,000 Selling, general, and administrative expenses  ...

    Sales revenue   350,200 Cost of goods sold   141,900 Fixed costs   43,000 Selling, general, and administrative expenses   27,800 Depreciation   46,200 ASSETS       LIABILITIES   Cash   16,200   Notes payable   14,000 Accounts receivable   28,000   Accounts payable   18,900 Inventories   48,100   Long-term debt   190,100 Fixed assets   367,900   OWNERS' EQUITY   Accumulated depreciation   140,300   Retained earnings   Intangible assets   81,900   Common stock   131,900 ASSETS       LIABILITIES   Cash   25,900   Notes payable   12,100 Accounts receivable   19,200   Accounts payable   23,900 Inventories   53,100   Long-term debt   161,800 Fixed assets   447,800   OWNERS' EQUITY   Accumulated depreciation  ...

  • TH Data Table Partial Income Statement Year Ending 2017 Sales revenue $349,800 Cost of goods sold...

    TH Data Table Partial Income Statement Year Ending 2017 Sales revenue $349,800 Cost of goods sold $141,800 Fixed costs $43,200 Selling, general, and administrative expenses $28,100 Depreciation $46,200 (Click on the following icon in order to copy its contents into a spreadsheet.) Partial Balance Sheet 12/31/2016 ASSETS LIABILITIES Cash $14,000 $19,100 $190,000 Accounts receivable Inventories $15,800 Notes payable $28,200 Accounts payable $47,800 Long-term debt $368,000 OWNERS' EQUITY $142,600 Retained earnings $82,000 Common stock Fixed assets Accumulated depreciation Intangible assets $132,000...

  • Data Table 1. depi ed all (Click on the following icon in order to copy its...

    Data Table 1. depi ed all (Click on the following icon in order to copy its contents into a spreadsheet.) Partial Income Statement Year Ending 2017 Sales revenue $350,200 Cost of goods sold R$ 142,000 Fixed costs $43,000 Selling, general, and administrative expenses $27,800 Depreciation $45,800 (Click on the following icon in order to copy its contents into a spreadsheet.) Partial Balance Sheet 12/31/2016 ASSETS LIABILITIES Cash $16,100 Notes payable Accounts receivable $28,000 Accounts payable Inventories $48,000 Long-term debt Fixed...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT