I am trying to learn how to do cash conversion cycle analysis.

I am practicing by using the wal-mart 2016 financial statements.

Reviewthe selected company's most recent financial statements- 2016.

Calculatethe following cash conversion cycle ratios based on the financial statements usingMicrosoftExcel:

• Average inventory
• Inventory turnover rate
• Average account receivable
• Account receivable turnover
• Average collection cycle

Also, I am trying to do the formulas in microsoft excel.

I really need help bad.

Anyone that can help, it would be greatly appreciated.

I just want to become better at this so I can move forward and not become stagnated by this one concept.

Thanks