Question: Each Student will analyze their corporate selection for 2 0 2 1 and perform the calculations for each ratio in table [ [ ,

 Each Student will analyze their corporate selection for 2021 and perform

Each Student will analyze their corporate selection for 2021 and perform the calculations for each ratio in\table[[,Dec 2021,Dec 2020,Dec 2019,Dec 2018],[Revenue,127,004.00,122,485.00,137,237.00,147,049.00],[Cost of Goods Sold,109,126.00,108,813.00,123,265.00,132,954.00],[Gross Profit,17,878.00,13,672.00,13,972.00,14,095.00],[Gross Profit Margin,14.08%,11.16%,10.18%,9.59%],[SG&A Expense,--,7,038.00,8,491.00,9,650.00],[Depreciation and Amortization,--,--,--,--445.00],[Operating Income,9,324.00,6,634.00,5,481.00,4,445%],[Operating Margin,7.34%,5.42%,3.99%,3.02%],[Nonoperating Income,--,0.00,0.00,(70.00)],[Nonoperating Expenses,--,--,--,--],[Income Before Taxes,12,716.00,8,095.00,7,436.00,8,549.00],[Income Taxes,2,771.00,1,774.00,769.00,474.00],[Net Income After Taxes,10,019.00,6,427.00,6,732.00,8,014.00],[,,,,],[Continuing Operations,9,945.00,6,321.00,6,667.00,8,075.00],[Discontinued Operations,--,--,--,--],[Total Operations,--,--,--,--084.00],[Total Net Income,10,019.00,6,427.00,6,732.00,8,08%],[Net Profit Margin,7.89%,5.25%,4.91%,5.50%],[,,,--,--],[Diluted EPS from Continuing Operations,--,--,--,--],[Diluted EPS from Total Operations,--,--,4.57,5.53],[Diluted EPS from Total Net Income,6.70,4.33,1.52,1.52]]\table[[,50c2021,sec2020,,],[Cash,20,067.00,19,992.00,19,069.00,20,844.00],[Net Receivables,34,043.00,34,244.00,33,398.00,33,399.00],[Inventories,12,988.00,10,235.00,10,398.00,9,816.00],[Other Current Assets,--,--,--,--],[Total Current Assets,82,103.00,80,924.00,74,992.00,75,293.00],[Net Fixed Assets,79,044.00,77,451.00,80,805.00,82,317.00],[Other Noncurrent,--,--,--,--],[Total Assets,244,718.00,235,194.00,228,037.00,227,339.00],[Shareholder's Equity],[,Dec 2021,Dec 2020,Dec 2019,Dec 2018],[Preferred Stock Equity,--,--,--,--],[Common Stock Equity,15.00,14.00,14.00,14.00],[Total Equity,59,744.00,45,030.00,41,792.00,38,860.00],[Shares Outstanding (M),1,500.00,1,400.00,1,400.00,1,400.00],[Liabilities],[,Dec 2021,Dec 2020,Dec 2019,Dec 2018],[Accounts Payable,20,391.00,19,928.00,21,018.00,22,297.00],[Short-Term Debt,33,720.00,36,913.00,37,400.00,31,891.00],[Other Current Liabilities,--,--,--,2],[Total Current Liabilities,74,408.00,79,910.00,84,905.00,82,237.00],[Long-Term Debt,75,659.00,72,981.00,65,924.00,73,060.00],[Other Noncurrent,3,661.00,3,009.00,3,026.00,3,063.00],[Total Liabilities,178,903.00,185,517.00,182,080.00,184,562.00]]
the above table. Please show all of your calculations when creating the ratios. In addition, each student will
then summarize their analytical conclusions for each ratio category in the following analytical worksheet to. Find the Liquidity
Management
Debt Management
Profitability
Market Performance
Working Capital
AR Turnover
Times Interest Earned
Gross Margin %
Earnings Per Share
Current Ratio
Inventory Turnover
Debt-Equity
Net Profit Margin %
Price Earnings
Acid Test
Asset Turnover
Equity Multiplier
ROE
Dividend Yield
the calculations for each ratio in\table[[,Dec 2021,Dec 2020,Dec 2019,Dec 2018],[Revenue,127,004.00,122,485.00,137,237.00,147,049.00],[Cost of Goods

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!