Question

In: Accounting

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, LOADING.... The company paid interest expense of $ 17 comma 300 for 2017 and had an overall tax rate of 40 % for 2017. Find the cash flow from assets for 2017​, and break it into its three​ parts: operating cash​ flow, capital​ spending, and change in net working capital.

Partial Income Statement Year Ending 2017

Sales revenue

$350,100

Cost of goods sold

$142,000

Fixed costs

$43,000

Selling, general, and administrative expenses

$28,200

Depreciation

$46,200

Partial Balance Sheet 12/31/2016

ASSETS

LIABILITIES

Cash

$15,800

Notes payable

$13,800

Accounts receivable

$28,200

Accounts payable

$19,000

Inventories

$48,100

Long-term debt

$190,100

Fixed assets

$368,100

OWNERS' EQUITY

Accumulated depreciation

$141,300

Retained earnings

Intangible assets

$82,100

Common stock

$131,900

Partial Balance Sheet 12/31/2017

ASSETS

LIABILITIES

Cash

$25,900

Notes payable

$11,900

Accounts receivable

$19,100

Accounts payable

$24,200

Inventories

$52,800

Long-term debt

$162,000

Fixed assets

$448,200

OWNERS' EQUITY

Accumulated depreciation

Retained earnings

Intangible assets

$82,100

Common stock

$181,800

Solutions

Expert Solution

Answer:

First let us calculate the net income from partial income statement and other information given:

As such net income = $44,040

Cash flow from assets for 2017 = Cash flow generated by operations + Changes in working capital + Changes in fixed assets

= $90240 - 80100 + 9600

= $19,740

Cash flow from assets for 2017 = $19,740

Workings and break-up as required:

Operating cash flow = Net Income + Depreciation = 44040 + 46200 = $90,240

Capital Spending = Gross Fixed assets as on 12/31/2017 - Gross Fixed assets as on 12/31/2016 = $448,200 - $368,100 = $80,100

Change in net working capital = Decrease in account receivables - Increase in inventory + Increase in accounts payable

= (28200 - 19100) - (52800 - 48100) + (24200 - 19000)

= $9,600

As such:

Cash flow from assets for 2017 = $19,740

Break-up:

Operating cash flow = $90,240

Capital Spending = $80,100

Change in net working capital =$9,600


Related Solutions

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, LOADING... . The company paid interest expense of $ 17 comma 500$17,500 for 20172017 and had an overall tax rate of 40 %40% for 20172017. Find the cash flow from assets for 20172017​, and break it into its three​ parts: operating cash​ flow, capital​ spending, and change in net working capital. The operating cash flow is ​$nothing. Partial Income Statement Year Ending 2017 Sales...
Use the data from the following financial statements in the popup​ window, LOADING... . The company...
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. Complete the statement of retained earnings for 20172017​, and determine the dividends paid last year. The distributed earnings is ​$nothing Partial Income Statement Year Ending 2017 Sales revenue $350,200 Cost of goods sold $142,000 Fixed costs $43,000 Selling, general, and administrative expenses $28,100...
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, LOADING.... The company paid interest expense of $ 18 comma 400 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. Partial Income Statement Year Ending 2017 Sales revenue $350,000 Cost of goods sold $142,000 Fixed costs $43,200 Selling, general, and administrative expenses $27,800 Depreciation $46,200...
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, LOADING.... The company paid interest expense of $ 17 comma 600 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. Partial Income Statement Year Ending 2017 Sales revenue $350,100 Cost of goods sold $141,800 Fixed costs $42,800 Selling, general, and administrative expenses $27,900 Depreciation $45,900...
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, LOADING...The company paid interest expense of $18,000 for 2017and 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.) Complete the statement of retained​ earnings:  ​(Round to the nearest​ dollar.) Statement of Retained Earnings Year Ending December 31, 2017...
Use the​ end-of-year stock price data in the popup​ window, (data below) to answer the following...
Use the​ end-of-year stock price data in the popup​ window, (data below) to answer the following questions for the Harris and Pinwheel companies. a. Compute the annual rates of return for each time period and for both firms. b. Calculate both the arithmetic and the geometric mean rates of return for the entire​ three-year period using your annual rates of return from part a. ​(Note: you may assume that neither firm pays any​ dividends.) c. Compute a​ three-year rate of...
Calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders DATA    ...
Calculate the cash flow from assets, cash flow to creditors, and cash flow to stockholders DATA     Balance Sheet: 2009 2010 Cash $15,000 $14,000 Marketable Securities 6,000 6,200 Receivables         42,000 33,000 Inventory         51,000 84,000 Prepaid expenses           1,200 1,100 Total current assets       115,200 138,300 Gross plant and equipment       316,000 330,000     Less: accumulated depreciation        (30,000) -60,000 Total assets $401,200 $408,300 2009 2010 Accounts payable $48,000 $57,000 Accruals 6,000 5,000 Notes payable         15,000 13,000 Total current...
Company analysis.  Given the financial data in the popup​ window, LOADING...​, for Disney​ (DIS) and​ McDonald's...
Company analysis.  Given the financial data in the popup​ window, LOADING...​, for Disney​ (DIS) and​ McDonald's (MCD), compare these two companies using the following financial​ ratios: debt​ ratio, current​ ratio, total asset​ turnover, financial​ leverage, profit​ margin, and return on equity. Which company would you invest​ in, either as a bondholder or as a​ stockholder? Disney ​McDonald's Sales ​$48,851 ​$28,149 EBIT ​ $12,119 ​$8,104 Net Income ​ $7,462 ​$5,414 Current Assets ​$15,129 ​$4,919 Total Assets ​$84,112 ​$36,557 Current Liabilities ​$13,164...
Use the information from the balance sheet and income statement in the popup? window, LOADING...?, to...
Use the information from the balance sheet and income statement in the popup? window, LOADING...?, to calculate the following? ratios: a. Current ratio b.? Acid-test ratio c. Times interest earned d. Inventory turnover e. Total asset turnover f. Operating profit margin g. Days in receivables h. Operating return on assets i. Debt ratio j. Fixed asset turnover k. Return on equity Balance Sheet ASSETS Cash $93,000 Accounts receivable 40,000 Inventory 46,000 Prepaid expenses 11,000 Total current assets $190,000 Gross plant...
Adjusted Cash Flow from Assets. You have looked at the current financial statements for Reigle Homes,...
Adjusted Cash Flow from Assets. You have looked at the current financial statements for Reigle Homes, Co. The company has an EBIT of $2.95 million this year. Depreciation, the increase in net working capital, and capital spending were $235,000, $105,000, and $475,000, respectively. You expect that over the next five years, EBIT will grow at 15 percent per year, depreciation and capital spending will grow at 20 percent per year, and NWC will grow at 10 percent per year. The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT