Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please I need help with: BM155 Financial Services: Capstone Project Part 4 Statement of Cash Flows Project Description: Statement of cash flows is the component
please I need help with:
BM155 Financial Services: Capstone Project Part 4 Statement of Cash Flows Project Description: Statement of cash flows is the component of a financial statement that summarizes the inward and outward movement of cash in a business. This section captures the inflows and outflows of money generated from operations, investments and tinancing activities. Cash tlow's from operations focus on the day to day activities such as sales and inventory purchases. Investment cash flows relate to income and expenses generated by long-term projects ar programs. The financing cash flows segment tracks changes in the capital composition of the business as occasioned by the sale of shares and distribution of dividends, as well as borrowing and repayment of deht. To complete this section, answer the following questions using information taken from the 2018 statement of cash flows. 1) What was the ending balance at cash To complete this section, answer the following questions using information taken from the 2018 statement of cash flows. 1) What was the ending balance of cash and cash equivalents in 2018 as presented on the Statement of Cash Flows? Does this agree with the encing balance of cash and cash equivalents reported on the 2018 Balance Sheet? Explain any discrepancy. 21 What was the net cash flow from operating activities? How much of this was the result of a net income or not loss? What portion of the cash flows came from depreciation, amortization and ather non-cash charges? 3) What was the net cash flow fram investing activities? Was it an inflaw ar an outflow of cash? what percentage of this amount came from the purchases ot tixed assets? 4) What was the net cash tlow from tinancing activities? Was it an intlow ar an cutflow of cash? 5) What activity accounted for the largest cash flow tram financing activities? Was it an inflow or outflow of cash? G! What was the cash paid for taxes ? 71 What was the cash paid for interest? Submit your Statement of Cash Flows to Capstone Project 4 Dropbox folder on D2L. Sellu de pagina AaBbCcDc AabbCcDc AaBbcc AaBbcc 1 Normal 1 No Spac... Heading 1 Heading Styles AL 498 3.056 (436) (169) 156 Paragraph L :1 2 3 VARTERIELLS ELRONC COTTON Adjustments to reconcile net income including noncontrolling interests to net cash provided by operations Net cash provided by operations Capital expenditures Sale of property and non-core product lines Purchases of marketable securities and investments Proceeds from sale of marketable securities and investments Proceeds from sale of land in Mexico Proceeds from sale of South Pacific laundry detergent business Payment for acquisitions, net of cash acquired Reduction in cash due to Venezuela accounting change Other Net cash used in investing activities Principal payments on debt Proceeds from issuance of debt Dividends paid Purchases of treasury shares Proceeds from exercise of stock options Net cash used in financing activities (728) 16 (4.808) (1.170) (7.355) 7,176 (1.591) (1.238) 329 (2.679) (1.529) (1.399) 507 (2.450) .A. E E UCLU AMBOLCD 1 Normal 1 No Spac... Heading 1 Heading 2 Tit Paragrap Styles 1 . 1 . 1 . 2 Consolidated Cash Flow Statement Dec 31, 2018 2.558 511 (7) Dec 31, 2017 2.174 475 91 127 US$ in millions 12 months ended Net income including noncontrolling interests: Depreciation and amortization Restructuring and termination benefit s Venezuela remeasurement changes Charge for a foreign tax matter Stock-based compensation expense Gain on sale of land in Mexico Gain on sale of South Pacific laundry detergent business Charge for Venezuela accounting change Charge for U.S. tax reform Deferred income taxes Voluntary benefit plan contributions Receivables Inventories Accounts payable and other accruals Other non-current assets and liabilities Cash effects of changes in assets and liabilities Adjustments to reconcile net income including noncontrolling interests to net cash provided by operations Net cash provided by operations Capital expenditures III 3 27 275 108 (81) (15) (67) (79) (58) (8) 18 (96) (36) (155) (115) 498 3.056 (436) 880 3.054 (553) D'Focus B DELL Balance Sheet All numbers in thousands Get access to 15+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 12/30/2018 12/30/2017 12/30/2016 Assets Current Assets Cash Cash And Cash Equivalents 726,000 1,535,000 1,315,000 Short Term Investments Total Cash 726,000 1,535,000 1,315.000 Net Receivables hs 1.400,000 1.480,000 1,411.000 1,42 Inventory 1.250,000 1,221,000 1,171,000 1.18 Other Current Assets 417.000 403,000 441,000 807 Total Current Assets 3.793.000 4.639.000 4.338.000 4,384 Tine her finance is, MNDUS of companies Inventory 1,250,000 1,221,000 1,171,000 Other Current Assets 417,000 403,000 441,000 Total Current Assets 3,793,000 4,639,000 4,338,000 Non-current assets Property, plant and equip.. Gross property, plant and... 8,336,000 8,460,000 7,942,000 Accumulated Depreciation -4,455,000 -4,388,000 -4,102,000 Net property, plant and e 3,881,000 4,072,000 3,840,000 Equity and other investments Goodwill 2,530,000 2.218.000 2.107.000 Intangible Assets 1.637.000 3,965.000 1,313,000 Other long-term assets 4.487,000 218,000 Total non-current assets 8,368,000 224.000 7,785,000 8.037.000 Total Assets 12.161.000 12.676.000 12.123,000 11 Liabilities and stockholders' equity Liabilities Current Liabilities Total non-current assets 8,368,000 8,037,000 7,785,000 Total Assets 12,161,000 12,676,000 12,123,000 Liabilities and stockholders' equity Liabilities Current Liabilities Total Revenue 12,000 11,000 13,000 Accounts Payable 1,222,000 1,212,000 1,124,000 Taxes payable 411,000 354,000 441,000 Accrued liabilities 1,476,000 1,607,000 1,531,000 Deferred revenues Other Current Liabilities 3,329,000 3,397,000 4,000 Total Current Liabilities 3.329,000 3,397.000 3,305,000 Non-current liabilities Long Term Debt 16.366,000 6,577,000 6,520,000 Deferred taxes liabilities 235.000 204,000 246,000 Deferred revenues Other long-term liabilities 2.269,000 2.459.000 172.000 2.15 I VI Companies Total Current Liabilities 3,329,000 3,397,000 3,305,000 Non-current liabilities 3,232 Long Term Debt 6,366,000 6,577,000 6,520,000 Deferred taxes liabilities 6,571, 235,000 204,000 246,000 Deferred revenues 233.0 Other long-term liabilities 2,269,000 2,459,000 172,000 2.199,00 Total non-current liabilities 8,635,000 9,036,000 8,801,000 8,770,00 Total Liabilities 11,964,000 12,433,000 12,106,000 12.002,000 Stockholders' Equity Common Stock 1.466,000 1,466,000 1,466,000 Retained Earnings 1,466,000 20,531,000 21,615,000 19.922,000 18,861,000 Accumulated other comprehe. -4.191,000 -3,860,000 -4,187,000 -3,962,000 Total stockholders' equity -102,000 Total liabilities and stockhold... -60,000 12.676,000 12.161.000 -243,000 12,123,000 -299.000 11.958,000 BM155 Financial Services: Capstone Project Part 4 Statement of Cash Flows Project Description: Statement of cash flows is the component of a financial statement that summarizes the inward and outward movement of cash in a business. This section captures the inflows and outflows of money generated from operations, investments and tinancing activities. Cash tlow's from operations focus on the day to day activities such as sales and inventory purchases. Investment cash flows relate to income and expenses generated by long-term projects ar programs. The financing cash flows segment tracks changes in the capital composition of the business as occasioned by the sale of shares and distribution of dividends, as well as borrowing and repayment of deht. To complete this section, answer the following questions using information taken from the 2018 statement of cash flows. 1) What was the ending balance at cash To complete this section, answer the following questions using information taken from the 2018 statement of cash flows. 1) What was the ending balance of cash and cash equivalents in 2018 as presented on the Statement of Cash Flows? Does this agree with the encing balance of cash and cash equivalents reported on the 2018 Balance Sheet? Explain any discrepancy. 21 What was the net cash flow from operating activities? How much of this was the result of a net income or not loss? What portion of the cash flows came from depreciation, amortization and ather non-cash charges? 3) What was the net cash flow fram investing activities? Was it an inflaw ar an outflow of cash? what percentage of this amount came from the purchases ot tixed assets? 4) What was the net cash tlow from tinancing activities? Was it an intlow ar an cutflow of cash? 5) What activity accounted for the largest cash flow tram financing activities? Was it an inflow or outflow of cash? G! What was the cash paid for taxes ? 71 What was the cash paid for interest? Submit your Statement of Cash Flows to Capstone Project 4 Dropbox folder on D2L. Sellu de pagina AaBbCcDc AabbCcDc AaBbcc AaBbcc 1 Normal 1 No Spac... Heading 1 Heading Styles AL 498 3.056 (436) (169) 156 Paragraph L :1 2 3 VARTERIELLS ELRONC COTTON Adjustments to reconcile net income including noncontrolling interests to net cash provided by operations Net cash provided by operations Capital expenditures Sale of property and non-core product lines Purchases of marketable securities and investments Proceeds from sale of marketable securities and investments Proceeds from sale of land in Mexico Proceeds from sale of South Pacific laundry detergent business Payment for acquisitions, net of cash acquired Reduction in cash due to Venezuela accounting change Other Net cash used in investing activities Principal payments on debt Proceeds from issuance of debt Dividends paid Purchases of treasury shares Proceeds from exercise of stock options Net cash used in financing activities (728) 16 (4.808) (1.170) (7.355) 7,176 (1.591) (1.238) 329 (2.679) (1.529) (1.399) 507 (2.450) .A. E E UCLU AMBOLCD 1 Normal 1 No Spac... Heading 1 Heading 2 Tit Paragrap Styles 1 . 1 . 1 . 2 Consolidated Cash Flow Statement Dec 31, 2018 2.558 511 (7) Dec 31, 2017 2.174 475 91 127 US$ in millions 12 months ended Net income including noncontrolling interests: Depreciation and amortization Restructuring and termination benefit s Venezuela remeasurement changes Charge for a foreign tax matter Stock-based compensation expense Gain on sale of land in Mexico Gain on sale of South Pacific laundry detergent business Charge for Venezuela accounting change Charge for U.S. tax reform Deferred income taxes Voluntary benefit plan contributions Receivables Inventories Accounts payable and other accruals Other non-current assets and liabilities Cash effects of changes in assets and liabilities Adjustments to reconcile net income including noncontrolling interests to net cash provided by operations Net cash provided by operations Capital expenditures III 3 27 275 108 (81) (15) (67) (79) (58) (8) 18 (96) (36) (155) (115) 498 3.056 (436) 880 3.054 (553) D'Focus B DELL Balance Sheet All numbers in thousands Get access to 15+ years of historical data with Yahoo Finance Premium. Learn more Breakdown 12/30/2018 12/30/2017 12/30/2016 Assets Current Assets Cash Cash And Cash Equivalents 726,000 1,535,000 1,315,000 Short Term Investments Total Cash 726,000 1,535,000 1,315.000 Net Receivables hs 1.400,000 1.480,000 1,411.000 1,42 Inventory 1.250,000 1,221,000 1,171,000 1.18 Other Current Assets 417.000 403,000 441,000 807 Total Current Assets 3.793.000 4.639.000 4.338.000 4,384 Tine her finance is, MNDUS of companies Inventory 1,250,000 1,221,000 1,171,000 Other Current Assets 417,000 403,000 441,000 Total Current Assets 3,793,000 4,639,000 4,338,000 Non-current assets Property, plant and equip.. Gross property, plant and... 8,336,000 8,460,000 7,942,000 Accumulated Depreciation -4,455,000 -4,388,000 -4,102,000 Net property, plant and e 3,881,000 4,072,000 3,840,000 Equity and other investments Goodwill 2,530,000 2.218.000 2.107.000 Intangible Assets 1.637.000 3,965.000 1,313,000 Other long-term assets 4.487,000 218,000 Total non-current assets 8,368,000 224.000 7,785,000 8.037.000 Total Assets 12.161.000 12.676.000 12.123,000 11 Liabilities and stockholders' equity Liabilities Current Liabilities Total non-current assets 8,368,000 8,037,000 7,785,000 Total Assets 12,161,000 12,676,000 12,123,000 Liabilities and stockholders' equity Liabilities Current Liabilities Total Revenue 12,000 11,000 13,000 Accounts Payable 1,222,000 1,212,000 1,124,000 Taxes payable 411,000 354,000 441,000 Accrued liabilities 1,476,000 1,607,000 1,531,000 Deferred revenues Other Current Liabilities 3,329,000 3,397,000 4,000 Total Current Liabilities 3.329,000 3,397.000 3,305,000 Non-current liabilities Long Term Debt 16.366,000 6,577,000 6,520,000 Deferred taxes liabilities 235.000 204,000 246,000 Deferred revenues Other long-term liabilities 2.269,000 2.459.000 172.000 2.15 I VI Companies Total Current Liabilities 3,329,000 3,397,000 3,305,000 Non-current liabilities 3,232 Long Term Debt 6,366,000 6,577,000 6,520,000 Deferred taxes liabilities 6,571, 235,000 204,000 246,000 Deferred revenues 233.0 Other long-term liabilities 2,269,000 2,459,000 172,000 2.199,00 Total non-current liabilities 8,635,000 9,036,000 8,801,000 8,770,00 Total Liabilities 11,964,000 12,433,000 12,106,000 12.002,000 Stockholders' Equity Common Stock 1.466,000 1,466,000 1,466,000 Retained Earnings 1,466,000 20,531,000 21,615,000 19.922,000 18,861,000 Accumulated other comprehe. -4.191,000 -3,860,000 -4,187,000 -3,962,000 Total stockholders' equity -102,000 Total liabilities and stockhold... -60,000 12.676,000 12.161.000 -243,000 12,123,000 -299.000 11.958,000
Step 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