** SEE FILE ATTACHED
Create your complete analysis report as a Word document by copying the relevant sections
of the Excel spreadsheet into the document. This report will include your ratio computations,
a financial trend comparison and an industry-performance comparative financial analysis.
Include a synopsis of the major ratios computed in Part Two A as well as the following
sections:
Financial Trend Comparison
For each of the five ratio categories: Liquidity, Asset Utilization, Profitability, Debt
Utilization, and Market Values, write a paragraph regarding the trend and implications about
the future financial health of the company. You do not have to address every single category,
just enough to determine the overall trend.
Comparative Financial Analysis of the company compared to the industry performance
Write a paragraph regarding your company’s comparative performance to the industry average
(or its closest competition for the most recent year. Many times, it is not possible to find the
industry averages for several of the categories. Supplement this analysis by evaluating the results of
the company’s closest competitor. You do not have to address every single category, just enough to
determine the overall situation.
4
Graphical Analysis
Describe the financial trend and comparative financial analysis graphically. Be creative here, a
picture is worth a thousand words! Under each chart write one sentence summarizing the
financial trend and comparative analysis from above