Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help creating the indirect statement of cash flows. Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard), prepare

image text in transcribed

Need help creating the indirect statement of cash flows.

Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard), prepare a complete Statement of Cash Flows that shows both the direct method and the indirect method for summarizing cash flow from operating activities. Note to complete the assignment you will need to calculate items such as dividends paid (Retained Earnings & AOC 2019 - Net income2019 - Retained Earnings & AOC1201) and capital expenditures (Net PP&E 2018 - Book Value of PP&E Sold2019 Depreciation Expense2019 - Net PP&E2010). Please submit your work via the assignment submission feature in Blackboard. Balance Sheets Income Statement (millions) 2019 2018 (millions) Cash & equivalents $2,577.0 $1,556.0 Sales Accounts receivable, net 1.262.0 1,100.0 Less: Cost of goods sold Inventories 8,992.0 9,497.0 Gross profit Other current assets 371.0 366.0 Less: Selling, gen. & admin, expenses Total current assets 13.202.0 12.5190 Less: Depr.& amort, expenses Property, plant, & equipment gross 45,547.0 44,220.0 Operating profit (EBIT) Less: Accumulated depreciation 19.6640 18.6870 Less: Interest expense Property, plant, & equipment, net 25,883.0 25,533.0 Other income expense) Right-of-use leased assets 2.536.0 2.215.0 Gain/(loss) on sale of assets Other long-term investments 137.0 10.0 Earnings before tax Goodwill 633.0 633.0 Less: Income tax expense Other intangible assets 53.0 66.0 Net income Other noncurrent assets 635.0 564.0 Total assets $43.079.0 $41.540.0 2019 $78,112.0 54,864.0 23,248.0 16,163.0 2.357.0 4,728.0 467.0 (18.0) (410) 4,202.0 921.0 $3,281.0 Current portion of long-term debt $94.0 $1.002.0 Short-term debt (notes payable) 41.0 63.0 Current operating lease liabilities 261.0 2110 Accounts payable 9,920.0 9,761.0 Other accrued expenses 1.983.0 2.034.0 Deferred revenue 1,135.0 840.0 Other current liabilities 1.053.0 1.103.0 Total current liabilities 14.487.0 15,0140 Long-term debt 10,035.0 9.255.0 Long-term operating lease liabilities 2,275.0 2004.0 Deferred taxes 1,1220 972.0 Other long-term liabilities 3.0270 2.7480 Total liabilities 30,946.0 29,993.0 Common stock and add. paid-in capital 6,268.0 6,085.0 Retained earnings 11.6770 9.845.0 Accum. other comp. income (loss) (868,0) (805.0) Less: Treasury stock 4,944.0 3,578.0 Total equity 12.133.0 11.5470 Total liabilities and equity $43.079,0 $41.540.0 Footnotes During the year, the company received cash of $338.4 when it sold PP&E with a net book value of $379.4, which gave rise to the $41.0 loss that appears on the income statement. Total depreciation and amortization expenses of $2,357.0 is made up of depreciation expense of $2.344.0 and amortization expense of $13.0. Check figures: cash flow from operations = $6,728.0; cash flow from investments = $(3,183.0); and cash flow from financing = $(2,524.0)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Edp Auditing A Primer

Authors: Joseph L. Sardinas

1st Edition

0471123056, 978-0471123057

More Books

Students also viewed these Accounting questions

Question

What is the subnet mask of 1 3 5 . 4 4 . 3 3 . 2 2 / 2 0

Answered: 1 week ago

Question

How do you add two harmonic motions having different frequencies?

Answered: 1 week ago

Question

b. Why were these values considered important?

Answered: 1 week ago