need help determining how to fill out the ratio analysis section of this, anthing helps!

|instructions: 1) Only enter answers in yellow cells 2) Calculate each ratio for both the current year and the prior year. 3) Aeference the raw financial mumbers tab and use excel equations to complete this section. NO answers should be directly typed in. 4) Most companies do not separate out credit yersus cash sales on their financial statements, For the accounts receivable turnover ratio use net sales in place of net credit sales Home / Micuosoft 365 onedrivelive.com/editaspox?resid=80F54B1CB8E 6A00042448 dthint = fite %2 cxlsx Bect 16801545672708 wdOrigin= OFFICECOM-WEB.M Easicinformation Raw Financial Numbers Horizontal Analysis Vertical Analysis Ratio Analysis Ratio Equations Helpful Fints |instructions: 1) Only enter answers in yellow cells 2) Calculate each ratio for both the current year and the prior year. 3) Aeference the raw financial mumbers tab and use excel equations to complete this section. NO answers should be directly typed in. 4) Most companies do not separate out credit yersus cash sales on their financial statements, For the accounts receivable turnover ratio use net sales in place of net credit sales Home / Micuosoft 365 onedrivelive.com/editaspox?resid=80F54B1CB8E 6A00042448 dthint = fite %2 cxlsx Bect 16801545672708 wdOrigin= OFFICECOM-WEB.M Easicinformation Raw Financial Numbers Horizontal Analysis Vertical Analysis Ratio Analysis Ratio Equations Helpful Fints