Based on your financial statements (from Part 1), calculate the following ratios for the two years. Show all your calculations in good form. Show your formulas. If you use excel, each calculation need to show the excel formula

 Part 2: Financial Statement Analysis 

A. Based on your financial statements (from Part 1), calculate the following ratios for  the two years. Show all your calculations in good form. Show your formulas. If  you use excel, each calculation need to show the excel formula 

Current ratio 

Quick ratio 

Inventory turnover (times) 

Average collection period (days) 

Total asset turnover (times) 

Debt ratio 

Times interest earned 

Gross profit margin 

Net profit margin 

Return on total assets 

Return on equity 

P/E ratio 

Return on equity using DuPont Analysis 

I have attached Part 1 excel and original data document

My duty is to complete Part 2 (A) in the data document