5

Using the financial statements that you have prepared for Smith Manufacturing; prepare the following analyses in Excel:

Horizontal analysis

Vertical analysis

Ratio analysis - calculate a minimum of five ratios

In addition to the numerical calculations, prepare a Word document that contains a brief written analysis of your findings. For example, is this company struggling, doing well, etc.