Problem:
Calculate the following 14 ratios: current ratio, quick ratio, inventory turnover, average collection period, average payment period (use cost of goods in place of purchases), total assets turnover, debt ratio, times interest earned ratio, gross profit margin, operating profit margin, net profit margin, return on total assets, return on common equity, and price/earnings ratio.
Prepare a common size income statement for the latest two years at Target. This needs to be done using an Excel spreadsheet and show ALL calculations for the ratios (do not just show the answer, show what numbers were used to calculate the ratio). Here is the link for the two years of annual reports that need to be used.
https://investors.target.com/phoenix.zhtml?c=65828&p=irol-reportsAnnual