Smith & Wesson Holding Comapny

Please attach and submit your excel spreadsheets here. This should include both the vertical and horizontal analysis for a minimum of a 2 year period of both the income statement and balance sheet of the company you have chosen. The horizontal techniques you Will need to do for 2 years are the amount and percentage of change and a trend analysis for 3 years for the balance sheet. In order to do your ratios for the second year you Will need to have the balances also for the third year back. If you can download your company's financial statements great. otherwise you must build them in excel (remember to use excel for such things as subtotals and totals). For the ratio part of the assignment calculate the liquidity. solvency. profitability and market prospects ratios. Do not merely type in the answers. You must use the calculation abilities of excel in other words set up formulas where possible. The financial ratios are summarized on page 603 of your text- To get full credit you must use the excel capabilities everywhere you can to add. subtract. and diVide. This is not a typing exercise.