pleaseee help

there is no missing info read the question i attached everything needed

1. Input into an Excel spreadsheet the FY 2016 numbers for the company Sturm, Ruger \& Co, as posted on Blackboard (see under "Financials - Sturm Ruger" in the column on the left). 2. Next, go to page 111 of the text. There you will find TABLE 4-9: A SUMMARY OF KEY FINANCIAL RATIOS. Using the numbers that you have put into the spreadsheet, CALCULATE AS MANY FINANCIAL RATIOS AS YOU CAN for the company for year 2016. 3. In your spreadsheet, I want to see the following: (a) the name of the ratio that you are calculating (b) number or numbers that go into the numerator (c) number or numbers that go into the denominator and (d) the calculation of the ratio. 4. You should be able to calculate most if not all of the ratios. However, if you are unable to find a number from the financials because it is missing, CLEARLY STATE what number is missing and therefore which is the ratio that you are unable to calculate. DO NOT go outside of the numbers provided, or do any extra research to find the missing number. We shall stick to what has been provided. POST YOUR ASSIGNMENT AS AN EXCEL ATTACHMENT. 5. AlSO, COMMENT ON ANY THREE RATIOS, OR ANY ISSUES WITH THE NUMBERS. YOU MAY ALSO COMMENT ON ANY RATIOS THAT YOU BELIEVE NEED TO BE MONITORED OR OR CONCERN YOU. Basically I am looking for your interpretation of some key numbers. \begin{tabular}{|c|c|c|c|c|c|} \hline 2 & \begin{tabular}{l} Defined \\ benefit \\ pension plans \\ settlement \\ charge \end{tabular} & - & - & 40,999 & Deferred income \\ \hline 13 & \begin{tabular}{l} Other \\ operating \\ income, net \end{tabular} & -5 & -113 & 1,612 & Prepaid expenses \\ \hline 14 & \begin{tabular}{l} Total \\ operating \\ expenses \end{tabular} & 85,145 & 77,615 & 112,836 & Total Current Asse \\ \hline 15 & \begin{tabular}{l} Operating \\ income \end{tabular} & 134,409 & 94,545 & 56,338 & Property, Plant, anc \\ \hline 16 & Other income: & & & & \begin{tabular}{l} Le: \\ de! \end{tabular} \\ \hline 17 & \begin{tabular}{l} Royalty \\ income \end{tabular} & 1,142 & 1,084 & 468 & \begin{tabular}{l} Ne \\ equ \end{tabular} \\ \hline 18 & \begin{tabular}{l} Interest \\ income \end{tabular} & 14 & 5 & 2 & Other assets \\ \hline 19 & \begin{tabular}{l} Interest \\ expense \end{tabular} & -186 & -156 & -152 & Total Assets \\ \hline 20 & \begin{tabular}{l} Other income \\ (expense), net \end{tabular} & 542 & 622 & 584 & Liabilities and Stoch \\ \hline 21 & \begin{tabular}{l} Total other \\ income, net \end{tabular} & 1,512 & 1,555 & 902 & Current Liabilities \\ \hline 22 & \begin{tabular}{l} Income before \\ income taxes \end{tabular} & 135,921 & 96.100 & 57.240 & Trade accounts paya \\ \hline 23 & Income taxes & 48,449 & 33,974 & 18,612 & Product liability \\ \hline 24 & \begin{tabular}{l} Net income \\ and \\ comprehensiv \\ e income \end{tabular} & $87,472 & $62,126 & $38,628 & Employee compensat \\ \hline 25 & \begin{tabular}{l} Basic Earnings \\ Per Share \\ Diluted \end{tabular} & $4.62 & $3.32 & $1.99 & Workers' compensatic \\ \hline 26 & \begin{tabular}{l} Diluted \\ Earnings Per \\ Share \end{tabular} & $4.59 & $3.21 & $1.95 & Income taxes payable \\ \hline 27 & \begin{tabular}{l} Cash \\ Dividends Per \\ Share \end{tabular} & $1.73 & $1.10 & $1.62 & Total Current Liabilitie \\ \hline \end{tabular} Table 4-9 A Summary of Essential Financial Ratios Ratio How Calculated What it Measures 1. Liquidity Ratios Current Ratio The extent to which a firm can meet its short-term obligations Current assets Current liabilities Quick Ratio The extent to which a firm can meet its Current assets minus inventory short-term obligations without relying on the Current liabilities sale of its invertories II. Leverage Ratios Debt-to-Total The percentage of total funds provided by Assets Ratio creditors TotalassetsTotaldebt Debt-to-Equity The percentage of total funds provided by Ratio creditors versus by owners Lono-Term Debt-to- Total debt Total stockholders' equity Equity Ratio The balance between debt and equity in a firm's long-term capital structurn Long-Term Debt-to- Equity Ratio The balance between debt and equity in a firm's long-term capital structure TotalstockholdersequityLong-termdebt Times-interest- Earned Ratio Profits before interest and taxes Total interest charges The extent to which eamings can decline without the firm becoming unable to meet its annual interest costs 1II. Activity Ratios Inventory Tumover COGS/Inventory Whether a firm holds excessive stocks of inventories and whether a firm is slowly selling its inventorles compared to the industry average Fixed Assets Sales productivity and plant and equipment Turnover utilization FixedassetsSales Total Assets Whether a firm is generating a sufficient Turnover volume of business for the size of its asset TotalassetsSales investment Accounts Sales/Accounts receivable The average length of time it takes a firm to Recelvable collect credit sales (in percentage terms) Turnover Accounts Receivable Turnover Average Collection Period Sales/Accounts receivable The average length of time it takes a firm to collect credit sales (in percentage terms) Accounts receivable Total credit sales 365 days The average length of time it takes a firm to collect on credit sales (in days) IV. Profitability Ratios Gross Profit Margin Gross profit/Sales The total margin available to cover operating expenses and yield a profit Operating Profit Profitability without concern for taxes and Margin interest SalesEBIT Net Profit Margin After-tax profits per dollar of sales Net income Return on Total Assets (ROA) Net income Total assets After-tax profits per dollar of assets, this ratio is also called retum on investment (fol) Return on After-tax profits per dollar of stockholders Stockholders investment in the firm Return on Stockholders' Equity (ROE) After-tax profits per dollar of stockholders investment in the firm Earnings per Share Earnings available to the owners of Total stockholders' equity (EPS) Net income common stock Price-Eamings Attractiveness of firm on equity markets Ratio Market price per share Earnings per share V. Growth Ratios Sales Firm's annual growth rate in sales Sales2022(Sales2023Sales2022) Net Income Firm's annual growth rate in profits (Net Income 2023 - Net Income 2022) Net Income 2022 Earnings per Share Firm's annual growth rate in EPS (EPS 2023 - EPS 2022) EPS 2022 Eamings per share Growth Ratios Firm's annual growth rate in sales (Sales 2023 - Sales 2022) Sales 2022 Firm's annual growth rate in profits (Net Income 2023 - Net Income 2022) Net Income 2022 Earnings per Share Firm's annual growth rate in EPS EPS2022(EPS2023EPS2022) Dividends per Share Firm's annual growth rate in dividends pe share (Div, per Share 2023 - Div. per Share 2022) Dividends Per Share 2022 COGS - cost of goods sold: EBIT = eamings before intenest and taxes ; Div. = dividends 1. Input into an Excel spreadsheet the FY 2016 numbers for the company Sturm, Ruger \& Co, as posted on Blackboard (see under "Financials - Sturm Ruger" in the column on the left). 2. Next, go to page 111 of the text. There you will find TABLE 4-9: A SUMMARY OF KEY FINANCIAL RATIOS. Using the numbers that you have put into the spreadsheet, CALCULATE AS MANY FINANCIAL RATIOS AS YOU CAN for the company for year 2016. 3. In your spreadsheet, I want to see the following: (a) the name of the ratio that you are calculating (b) number or numbers that go into the numerator (c) number or numbers that go into the denominator and (d) the calculation of the ratio. 4. You should be able to calculate most if not all of the ratios. However, if you are unable to find a number from the financials because it is missing, CLEARLY STATE what number is missing and therefore which is the ratio that you are unable to calculate. DO NOT go outside of the numbers provided, or do any extra research to find the missing number. We shall stick to what has been provided. POST YOUR ASSIGNMENT AS AN EXCEL ATTACHMENT. 5. AlSO, COMMENT ON ANY THREE RATIOS, OR ANY ISSUES WITH THE NUMBERS. YOU MAY ALSO COMMENT ON ANY RATIOS THAT YOU BELIEVE NEED TO BE MONITORED OR OR CONCERN YOU. Basically I am looking for your interpretation of some key numbers. \begin{tabular}{|c|c|c|c|c|c|} \hline 2 & \begin{tabular}{l} Defined \\ benefit \\ pension plans \\ settlement \\ charge \end{tabular} & - & - & 40,999 & Deferred income \\ \hline 13 & \begin{tabular}{l} Other \\ operating \\ income, net \end{tabular} & -5 & -113 & 1,612 & Prepaid expenses \\ \hline 14 & \begin{tabular}{l} Total \\ operating \\ expenses \end{tabular} & 85,145 & 77,615 & 112,836 & Total Current Asse \\ \hline 15 & \begin{tabular}{l} Operating \\ income \end{tabular} & 134,409 & 94,545 & 56,338 & Property, Plant, anc \\ \hline 16 & Other income: & & & & \begin{tabular}{l} Le: \\ de! \end{tabular} \\ \hline 17 & \begin{tabular}{l} Royalty \\ income \end{tabular} & 1,142 & 1,084 & 468 & \begin{tabular}{l} Ne \\ equ \end{tabular} \\ \hline 18 & \begin{tabular}{l} Interest \\ income \end{tabular} & 14 & 5 & 2 & Other assets \\ \hline 19 & \begin{tabular}{l} Interest \\ expense \end{tabular} & -186 & -156 & -152 & Total Assets \\ \hline 20 & \begin{tabular}{l} Other income \\ (expense), net \end{tabular} & 542 & 622 & 584 & Liabilities and Stoch \\ \hline 21 & \begin{tabular}{l} Total other \\ income, net \end{tabular} & 1,512 & 1,555 & 902 & Current Liabilities \\ \hline 22 & \begin{tabular}{l} Income before \\ income taxes \end{tabular} & 135,921 & 96.100 & 57.240 & Trade accounts paya \\ \hline 23 & Income taxes & 48,449 & 33,974 & 18,612 & Product liability \\ \hline 24 & \begin{tabular}{l} Net income \\ and \\ comprehensiv \\ e income \end{tabular} & $87,472 & $62,126 & $38,628 & Employee compensat \\ \hline 25 & \begin{tabular}{l} Basic Earnings \\ Per Share \\ Diluted \end{tabular} & $4.62 & $3.32 & $1.99 & Workers' compensatic \\ \hline 26 & \begin{tabular}{l} Diluted \\ Earnings Per \\ Share \end{tabular} & $4.59 & $3.21 & $1.95 & Income taxes payable \\ \hline 27 & \begin{tabular}{l} Cash \\ Dividends Per \\ Share \end{tabular} & $1.73 & $1.10 & $1.62 & Total Current Liabilitie \\ \hline \end{tabular} Table 4-9 A Summary of Essential Financial Ratios Ratio How Calculated What it Measures 1. Liquidity Ratios Current Ratio The extent to which a firm can meet its short-term obligations Current assets Current liabilities Quick Ratio The extent to which a firm can meet its Current assets minus inventory short-term obligations without relying on the Current liabilities sale of its invertories II. Leverage Ratios Debt-to-Total The percentage of total funds provided by Assets Ratio creditors TotalassetsTotaldebt Debt-to-Equity The percentage of total funds provided by Ratio creditors versus by owners Lono-Term Debt-to- Total debt Total stockholders' equity Equity Ratio The balance between debt and equity in a firm's long-term capital structurn Long-Term Debt-to- Equity Ratio The balance between debt and equity in a firm's long-term capital structure TotalstockholdersequityLong-termdebt Times-interest- Earned Ratio Profits before interest and taxes Total interest charges The extent to which eamings can decline without the firm becoming unable to meet its annual interest costs 1II. Activity Ratios Inventory Tumover COGS/Inventory Whether a firm holds excessive stocks of inventories and whether a firm is slowly selling its inventorles compared to the industry average Fixed Assets Sales productivity and plant and equipment Turnover utilization FixedassetsSales Total Assets Whether a firm is generating a sufficient Turnover volume of business for the size of its asset TotalassetsSales investment Accounts Sales/Accounts receivable The average length of time it takes a firm to Recelvable collect credit sales (in percentage terms) Turnover Accounts Receivable Turnover Average Collection Period Sales/Accounts receivable The average length of time it takes a firm to collect credit sales (in percentage terms) Accounts receivable Total credit sales 365 days The average length of time it takes a firm to collect on credit sales (in days) IV. Profitability Ratios Gross Profit Margin Gross profit/Sales The total margin available to cover operating expenses and yield a profit Operating Profit Profitability without concern for taxes and Margin interest SalesEBIT Net Profit Margin After-tax profits per dollar of sales Net income Return on Total Assets (ROA) Net income Total assets After-tax profits per dollar of assets, this ratio is also called retum on investment (fol) Return on After-tax profits per dollar of stockholders Stockholders investment in the firm Return on Stockholders' Equity (ROE) After-tax profits per dollar of stockholders investment in the firm Earnings per Share Earnings available to the owners of Total stockholders' equity (EPS) Net income common stock Price-Eamings Attractiveness of firm on equity markets Ratio Market price per share Earnings per share V. Growth Ratios Sales Firm's annual growth rate in sales Sales2022(Sales2023Sales2022) Net Income Firm's annual growth rate in profits (Net Income 2023 - Net Income 2022) Net Income 2022 Earnings per Share Firm's annual growth rate in EPS (EPS 2023 - EPS 2022) EPS 2022 Eamings per share Growth Ratios Firm's annual growth rate in sales (Sales 2023 - Sales 2022) Sales 2022 Firm's annual growth rate in profits (Net Income 2023 - Net Income 2022) Net Income 2022 Earnings per Share Firm's annual growth rate in EPS EPS2022(EPS2023EPS2022) Dividends per Share Firm's annual growth rate in dividends pe share (Div, per Share 2023 - Div. per Share 2022) Dividends Per Share 2022 COGS - cost of goods sold: EBIT = eamings before intenest and taxes ; Div. = dividends