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.)
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.