50.1K

Verified Solution

Link Copied!

Question #1 Please compute CAT's Operating Cash Flow amounts for EACH of those past 4 quarters individually. Based on your calculated amounts, is there a trend for CAT's most recent OCFs to improve, stabilize, or deteriorate quarter-by-quarter during the past 4 quarters?

Annual Quarterly Income Statement All numbers in thousands 9/30/2018 Revenue 3/31/2019 12/31/2018 6/30/2018 Total Revenue 13,466,000 14,342,000 13,510,000 14,011,000 10,770,000 10,126,000 Cost of Revenue 9,657,000 9,690,000 3,572,000 Gross Profit 3,809,000 3,885,000 3,820,000 Operating Expenses Research Development 466,000 435,000 479,000 462,000 Selling General and Administrative 1,101,000 1,372,000 1,130,000 1,217,000 Non Recurring -23,000 Others 2,000 -5,000 -43,000 Total Operating Expenses 11,170,000 12,610,000 11,294,000 11,762,000 Operating Income or Loss 2,296,000 1,732,000 2,216,000 2,249,000 Income from Continuing Operations Total Other Income/Expenses Net -25,000 -362,000 -74,000 -54,000 2,296,000 2,249,000 Earnings Before Interest and Taxes 1,732,000 2,216,000 Interest Expense -103,000 99,000 -102,000 -102,000 1,370,000 2,195,000 Income Before Tax 2,271,000 2,142,000 Income Tax Expense 387,000 321,000 415,000 490,000 Minority Interest 41,000 41,000 40,000 63,000 Net Income From Continuing Ops 1,884,000 1,049,000 1,727,000 1,705,000 Income from Continuing Operations Total Other Income/Expenses Net -25,000 -362,000 -74,000 -54,000 Earnings Before Interest and Taxes 2,296,000 1,732,000 2,216,000 2,249,000 Interest Expense -103,000 99,000 -102,000 -102,000 Income Before Tax 2,271,000 1,370,000 2,142,000 2,195,000 Income Tax Expense 321,000 387,000 415,000 490,000 Minority Interes 41,000 41,000 40,000 63,000 1,884,000 Net Income From Continuing Ops 1,049,000 1,727,000 1,705,000 Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income 1,727,000 Net Income 1,881,000 1,048,000 1,707,000 Preferred Stock And Other Adjustments 1,727,000 Net Income Applicable To Common Shares 1,881,000 1,048,000 1,707,000 Quarterly Annual Cash Flow All numbers in thousands Period Ending 3/31/2019 12/31/2018 9/30/2018 6/30/2018 1,881,000 1,048,000 Net Income 1,727,000 1,707,000 Operating Activities, Cash Flows Provided By or Used In 641,000 701,000 686,000 Depreciation 698,000 296,000 Adjustments To Net Income 91,000 1,092,000 184,000 22,000 Changes In Accounts Receivables -150,000 -894,000 -377,000 Changes In Liabilities 355,000 213,000 -49,000 59,000 243,000 -614,000 -405,000 Changes In Inventories -813,000 Changes In Other Operating Activities -532,000 -884,000 -320,000 182,000 2,148,000 Total Cash Flow From Operating Activities 1,121,000 2,083,000 1,392,000 Investing Activities, Cash Flows Provided By or Used In -547,000 787,000 -601,000 771,000 Capital Expenditures Investments -52,000 -64,000 435,000 -374,000 -38,000 3,000 5,000 Other Cash flows from Investing Activities -11,000 -346,000 -1,268,000 Total Cash Flows From Investing Activities -181,000 -798,000 Financing Activities, Cash Flows Provided By or Used In -494,000 -511,000 Dividends Paid 507,000 -466,000 Sale Purchase of Stock Net Borrowings -424,000 874,000 -392,000 1,075,000 22,000 Other Cash Flows from Financing Activities -6,000 -28,000 -1,000 Total Cash Flows From Financing Activities -1,675,000 1,432,000 -1,645,000 -35,000 Effect Of Exchange Rate Changes 9,000 3,000 -49,000 -78,000 732,000 Change In Cash and Cash Equivalents -156,000 -648,000 767,000 Annual Quarterly Income Statement All numbers in thousands 9/30/2018 Revenue 3/31/2019 12/31/2018 6/30/2018 Total Revenue 13,466,000 14,342,000 13,510,000 14,011,000 10,770,000 10,126,000 Cost of Revenue 9,657,000 9,690,000 3,572,000 Gross Profit 3,809,000 3,885,000 3,820,000 Operating Expenses Research Development 466,000 435,000 479,000 462,000 Selling General and Administrative 1,101,000 1,372,000 1,130,000 1,217,000 Non Recurring -23,000 Others 2,000 -5,000 -43,000 Total Operating Expenses 11,170,000 12,610,000 11,294,000 11,762,000 Operating Income or Loss 2,296,000 1,732,000 2,216,000 2,249,000 Income from Continuing Operations Total Other Income/Expenses Net -25,000 -362,000 -74,000 -54,000 2,296,000 2,249,000 Earnings Before Interest and Taxes 1,732,000 2,216,000 Interest Expense -103,000 99,000 -102,000 -102,000 1,370,000 2,195,000 Income Before Tax 2,271,000 2,142,000 Income Tax Expense 387,000 321,000 415,000 490,000 Minority Interest 41,000 41,000 40,000 63,000 Net Income From Continuing Ops 1,884,000 1,049,000 1,727,000 1,705,000 Income from Continuing Operations Total Other Income/Expenses Net -25,000 -362,000 -74,000 -54,000 Earnings Before Interest and Taxes 2,296,000 1,732,000 2,216,000 2,249,000 Interest Expense -103,000 99,000 -102,000 -102,000 Income Before Tax 2,271,000 1,370,000 2,142,000 2,195,000 Income Tax Expense 321,000 387,000 415,000 490,000 Minority Interes 41,000 41,000 40,000 63,000 1,884,000 Net Income From Continuing Ops 1,049,000 1,727,000 1,705,000 Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income 1,727,000 Net Income 1,881,000 1,048,000 1,707,000 Preferred Stock And Other Adjustments 1,727,000 Net Income Applicable To Common Shares 1,881,000 1,048,000 1,707,000 Quarterly Annual Cash Flow All numbers in thousands Period Ending 3/31/2019 12/31/2018 9/30/2018 6/30/2018 1,881,000 1,048,000 Net Income 1,727,000 1,707,000 Operating Activities, Cash Flows Provided By or Used In 641,000 701,000 686,000 Depreciation 698,000 296,000 Adjustments To Net Income 91,000 1,092,000 184,000 22,000 Changes In Accounts Receivables -150,000 -894,000 -377,000 Changes In Liabilities 355,000 213,000 -49,000 59,000 243,000 -614,000 -405,000 Changes In Inventories -813,000 Changes In Other Operating Activities -532,000 -884,000 -320,000 182,000 2,148,000 Total Cash Flow From Operating Activities 1,121,000 2,083,000 1,392,000 Investing Activities, Cash Flows Provided By or Used In -547,000 787,000 -601,000 771,000 Capital Expenditures Investments -52,000 -64,000 435,000 -374,000 -38,000 3,000 5,000 Other Cash flows from Investing Activities -11,000 -346,000 -1,268,000 Total Cash Flows From Investing Activities -181,000 -798,000 Financing Activities, Cash Flows Provided By or Used In -494,000 -511,000 Dividends Paid 507,000 -466,000 Sale Purchase of Stock Net Borrowings -424,000 874,000 -392,000 1,075,000 22,000 Other Cash Flows from Financing Activities -6,000 -28,000 -1,000 Total Cash Flows From Financing Activities -1,675,000 1,432,000 -1,645,000 -35,000 Effect Of Exchange Rate Changes 9,000 3,000 -49,000 -78,000 732,000 Change In Cash and Cash Equivalents -156,000 -648,000 767,000

Answer & Explanation Solved by verified expert

See Answer