https://docs.google.com/spreadsheets/d/1pSOBAaq4bThW9dJ9bVflrSJiMLUrYQxMbbpRgCLHGj8/edit?usp=sharing

the spreadsheets are in the link above

1. Calculate the cash conversion cycle and all of its components for Walmart and Target for the fiscal year of 2014. Note that the column heading of January 2015 in the spreadsheet data below really means fiscal year 2014, which includes February 2014 through January 2015. Most likely, they have changed their fiscal year to end in the month of January after a calendar year so that sales during the Christmas season (including returns) would be completed. You will need to calculate the Accounts Receivable turnover and period (assume all sales are credit sales), the Inventory turnover and period, the Accounts Payable turnover and period, the Operating Cycle, and the Cash Conversion Cycle. The formulas for calculating each of these items are illustrated in the first lecture, Financial Statements #1.

2. What did you find out that relates to the operating strategies of these two firms? You will need to write a short paragraph after you have looked over the results of your calculations.