Hello Class:Hope you all had a good weekend.Here is the assignment for this week. You will do this in Excel.
This assignment, due by midnight of 11/4, is worth15% points.The usual late submission policy will apply. Use the separate Forum ("Questions on Mini Project: Financial Statements Analysis") for any queries.
Note - THIS IS AN EXTREMELY IMPORTANT ASSIGNMENT BECAUSE YOU WILL BE DOING A SIMILAR EXERCISE IN YOUR FINAL PAPER. IF THE ASSIGNMENT IS COMPLETE (THERE ARE NO MISSING PIECES) - YOU WILL GET A MINIMUM OF 5% POINTS FOR ATTEMPT (EVEN IF SOME OF YOUR CALCULATIONS ARE INCORRECT). The rest of the grade will depend on how well you do on the assignment.
ASSIGNMENT
1. Input into an Excel spreadsheet the FY 2015 and 2016 numbers for the company Sturm, Ruger& Co, as posted here on Blackboard.
2. Next, go to page 111 (in Chapter 4) of the text. Here you have a list of several financial ratios. Using the numbers that you have put in, CALCULATE AS MANY FINANCIAL RATIOS AS YOU CAN for the company foryear 2016. The only exception is "Growth Ratios", for which you will need both 2015 and 2016 numbers.
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 financialsbecause 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 posted, to do extra research to find the missing number(s). We shall stick to what is available.
5. Finally, once you post your assignment, check to make sure that it is visible (ie has posted correctly). If not, submit it to me via emailimmediately- at
Post the spreadsheet,as an Excel attachment showing all of your work, on this Forum.