I need help with Excel and the math.

/in /by

I need help with Excel and the math.

Assignment Steps – PART 1 (Calculation)

Review and Retrieve CCC formulas from Page 384 Cash Conversation Cycle of the Textbook

Review and Analyze Walmart Financials in Yahoo!Finance – https://finance.yahoo.com/quote/WMT/financials?p=WMT

Calculate and Submit the following cash conversion cycle ratios for Walmart 2018 based on the financial statements in Microsoft® Excel®

Production Cycle

  • Average inventory
  • Inventory turnover rate
  • Production Cycle

Collection Cycle

  • Average accounts receivable
  • Accounts receivable turnover
  • Collection Cycle

Payment Cycle

  • Average accounts payable
  • Accounts payable turnover
  • Payment Cycle

Cash Conversation Cycle = Production Cycle + Collection Cycle + Payment Cycle

What is the company’s 2018 Cash Conversation Cycle (in number of days)? 2 decimal space max.

(Note: Credit will not be awarded when detailed steps of calculations are not presented in your Excel worksheet i.e. even if you provide a number for each required ratio.)

Assignment Steps – PART 2 (Two (2) Short-Answer Questions)

Explain and Submit in 100 to 250 words for EACH of the two following tasks in a Microsoft Word document, including:

  • Analyze the results of your calculations for your study company.
  • Propose strategies to improve the cash flows of your study company.

(Note: This short-answer question is not an official paper so do not submit an official paper format. Point deduction will take place when your total submitted word-count is not between 200 ~ 500 words.)