cash flow statements, business and finance assignment help

Anonymous
timer Asked: Nov 21st, 2016
account_balance_wallet $20

Question Description

I only need help with part 4 of the attached excel sheet.

Please include formulas.


Thank you!

Unformatted Attachment Preview

USE THE DATA ON THE TAB LABELED "GIVEN (ROWS 2 THROUGH 48) AND: 1 On the tab labeled "PT 1" use the indirect method and compute the net cash provided by operating activities for t 2 On the tab labeled "PT 2" prepare a statement of cash flows for the year 2014. 3 On the tab labeled "PT 3" compute the the free cash flow for the year 2014. 4 On the tab labeled "PT 4" explain why cas declined so sharply during the year 2014. ND: operating activities for the year 2014. Foxboro Company Income Statement For the Period January 1, 2014 through December 31, 2014 Sales Cost of Goods Sold $ 700.000 400.000 Gross Margin Selling and Administrative Expenses 300.000 216.000 Net Operating Income Gain on Sale of Equipment 84.000 6.000 Income Before Taxes Income Taxes 90.000 27.000 Net Income $ 63.000 Foxboro Company Comparative Balance Sheets December 31, 2014 Assets Cash Accounts Receivable Inventory Prepaid Expenses 11.000 $ 250.000 318.000 7.000 19.000 180.000 270.000 16.000 Total Current Assets 586.000 485.000 Plant and Equipment Accumulated Depreciation 620.000 165.000 500.000 130.000 Net Plant and Equipment 455.000 370.000 Loan to Harker Company 40.000 Total Assets $ December 31, 2013 - $ 1.081.000 $ 855.000 $ 310.000 $ 42.000 84.000 260.000 50.000 80.000 Total Current Liabilities Bonds Payable 436.000 190.000 390.000 100.000 Total Liabilities 626.000 490.000 Common Stock Retained Earnings 335.000 120.000 275.000 90.000 Total Stockholders' Equity 455.000 365.000 Liabilities and Stockholders' Equity Accounts Payable Accrued Liabilities Income Taxes Payable Total Liabilities and Stockholders' Equity ADDITIONAL INFORMATION $ 1.081.000 $ 855.000 Equipment that had cost $30,000 and on which there was accumulated depreciation of $10,000 was sold during 2014 for $26,000. The company declared and paid a cash dividend during 2014. It did not retire any bonds or repurchase any of its own stock. ...
Purchase answer to see full attachment

Tutor Answer

psaikrishna
School: New York University

Hi, please check the attachment. I hope this is helpful to you, If you need any further assistance from me please feel free to ask me. Thank you.

USE THE DATA ON THE TAB LABELED "GIVEN (ROWS 2 THROUGH 48) AND:
1

On the tab labeled "PT 1" use the indirect method and compute the net cash provided by operating activities for t

2

On the tab labeled "PT 2" prepare a statement of cash flows for the year 2014.

3

On the tab labeled "PT 3" compute the the free cash flow for the year 2014.

4

On the tab labeled "PT 4" explain why cas declined so sharply during the year 2014.

ND:

operating activities for the year 2014.

Foxboro Company
Income Statement
For the Period January 1, 2014 through December 31, 2014
Sales
Cost of Goods Sold

$

700...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors