ASSIGNMENT

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 111of 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 cannot find a number from the financials because it is missing, CLEARLY STATE what number is missing and therefore which is the ratio you cannot 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.