3. Complete the “FR & Comparisons” worksheet in the “Comparison with Industry &
Peers” file based on the financial statements of your company – you can find these
statements approximately in the middle of your company’s 10K reports (right after or
before the independent auditor’s report). In the Modules 10K reports area, I have posted
the three latest 10K reports for each company which you will need for this assignment.
Specifically, you need to submit the following:
a) The financial summary and ratio calculations using the formula sheet (all the areas that
are highlighted in yellow).
b) Perform trend analysis. Using the ratios that you calculated, identify the areas that
show improvement and the areas of potential concern. You can describe the trends in
simple terms such as improving, stable, fluctuating, etc.
c) Under the RMA Norm column, list the industry median values for the subject ratios
(the ones highlighted in yellow). Then compare your ratios to the industry ones and
indicate whether they are better/favorable, worse/unfavorable or the same.
d) Compare your company’s ratios to the ratios of the other company in your group; what
you need to do here is to rank the ratios for your companies for the most recent year i.e. 1
or 2 with 1 being the best. You can use the last column in this worksheet to present your
comparisons.