Please use Excel to analyze the statement of cash flows for the table below. 1) What is...

80.2K

Verified Solution

Question

Accounting

Please use Excel to analyze the statement of cash flows for thetable below.

1) What is the correlation between net income and operating cashflow?

2) Explain the trends of cash flow from the table below.

3) What is the free cash flow from the table below?

Cash Flow
All numbers in thousands
Period Ending1/31/20181/31/20171/31/20161/31/2015
Net Income9,862,00013,643,00014,694,00016,363,000
OperatingActivities, Cash Flows Provided By or Used In
Depreciation10,529,00010,080,0009,454,0009,173,000
Adjustments To Net Income4,703,0001,617,0001,124,000733,000
Changes In AccountsReceivables-1,074,000-402,000-19,000-569,000
Changes In Liabilities4,086,0003,942,0002,008,0002,678,000
Changes In Inventories-140,0001,021,000-703,000-1,229,000
Changes In Other OperatingActivities928,0001,280,0001,466,0001,249,000
Total Cash Flow From OperatingActivities28,337,00031,673,00027,552,00028,564,000
InvestingActivities, Cash Flows Provided By or Used In
Capital Expenditures-10,051,000-10,619,000-11,477,000-12,174,000
Investments--1,901,000-1,901,000-1,901,000
Other Cash flows from InvestingActivities-58,000-122,000-79,000479,000
Total Cash Flows From InvestingActivities-9,060,000-13,987,000-10,675,000-11,125,000
FinancingActivities, Cash Flows Provided By or Used In
Dividends Paid-6,124,000-6,216,000-6,294,000-6,185,000
Sale Purchase of Stock----
Net Borrowings-1,437,000-3,591,000-3,158,000-5,018,000
Other Cash Flows from FinancingActivities-4,018,000-967,000-2,721,000-2,853,000
Total Cash Flows From FinancingActivities-19,875,000-19,072,000-16,285,000-15,071,000
Effect Of Exchange RateChanges487,000-452,000-1,022,000-514,000
Change In Cash and CashEquivalents-111,000-1,838,000-430,0001,854,000

Answer & Explanation Solved by verified expert
4.1 Ratings (756 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students