Question
Good morning :) You have helped me with previous assignments and did a great job. I have an additional request. I have created a table
Good morning :) You have helped me with previous assignments and did a great job. I have an additional request. I have created a table outline that needs to be calculated using the Cash Flow data I have attached. The first spreadsheet is the table that needs to be completed. The second spreadsheet has IBM (my company) statements. The third tab is the Cash Flow Statement that can be used. The last two attachments are two examples of what my teacher wanted the table to sort of look like. I will handle the formatting at the end. But he said the top part should resemble Company A Top part and the bottom part should resemble the bottom part attached. If there are any questions, please let me know. I think I've attached all resources needed.
qattachments_9777093f7e1e7405bc69e9af48468c207e7c688a Year 5 Year 4 Year 3 Year 2 Year 1 Operating Activities Investing Activities Financing Activities Net Change in Cash Operating Activities Capital Expenditures Free Cash Flow Page 1 qattachments_f6b2b44196729cf9cb0d6180c36654cb4425d353 INTERNATIONAL BUSINESS MACHINES CORP STATEMENTS OF CASH FLOWS Fiscal year ends in December. USD in millions except per share data. Cash Flows From Operating Activities Net income Depreciation & amortization Deferred income taxes Stock based compensation Inventory Accounts payable Accrued liabilities Other working capital Other non-cash items Net cash provided by operating activities Cash Flows From Investing Activities Investments in property, plant, and equipment Property, plant, and equipment reductions Acquisitions, net Purchases of investments Sales/Maturities of investments Purchases of intangibles Other investing activities Net cash used for investing activities Cash Flows From Financing Activities Debt issued Debt repayment Common stock issued Common stock repurchased Dividend paid Other financing activities Net cash provided by (used for) financing activities Effect of exchange rate changes Net change in cash Cash at beginning of period Cash at end of period Free Cash Flow Operating cash flow Capital expenditure Free cash flow Page 1 2012-12 2013-12 2014-12 $16,604 4676 797 688 280 (224) (1,008) (1,497) (730) 19586 $16,483 4678 (1,610) 614 (57) (529) $12,022 4492 (237) 512 (39) (456) (4,082) 410 (3,123) (4,109) 3142 (635) (607) (9,004) (3,623) 372 (2,759) (4,608) 4873 (517) (1,064) (7,326) (3,740) 404 1701 (2,338) 2493 (443) (1,078) (3,001) 12242 (9,549) 1540 (11,995) (3,773) (441) (11,976) (116) (1,510) 11922 10412 16353 (10,013) 1074 (13,859) (4,058) 620 (9,883) 28 304 10412 10716 8180 (4,644) 709 (13,679) (4,265) (1,753) (15,452) (655) (2,240) 10716 8476 (1,860) (1,271) (234) 1845 17485 16868 19586 17485 16868 (4,717) (4,140) (4,183) 14869 13345 12685 qattachments_f6b2b44196729cf9cb0d6180c36654cb4425d353 2015-12 2016-12 $13,190 $11,872 3855 4381 1387 (1,132) 468 544 133 (14) 81 197 (2,658) 552 17008 1048 62 16958 (3,579) 370 (3,750) (3,073) 2842 (572) (397) (8,159) (3,567) 424 (6,133) (5,917) 5692 (583) (892) (10,976) 5540 (5,622) 322 (4,609) (4,897) 100 (9,166) 9132 (6,395) 204 (3,502) (5,256) 26 (5,791) (317) 8476 8159 191 7686 7877 17008 16958 (4,151) (4,150) 12857 12808 Page 2Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started