I need guidance with how to setup a ratio table (ratios listed below) based on information from the attached financial statements

All ratios should use year-end totals and not averages and be compared to its industry average as well as time trend analysis. Calculate the ratios mentioned in the table below. For the turnover in days assume 365 days. Hint: for Cash flow statement, you have to add back amortization to the Land, Plant, and Equipment item.

Ratio table

Current Ratio Fixed Assets Turnover Operating Profit Margin Parts Inventory Turnover in Days Total Assets Turnover

Net Profit Margin WIP Inventory Turnover in Days Debt Ratio Return on Assets FG Inventory Turnover in Days

Times Interest Earned Return on Equity A/R Turnover in Days Gross Profit Margin Liability to Asset ratio