Vertical Analysis
Perform vertical analysis on the balance sheets and income statements for the three years presented. The vertical analysis should be performed on the same worksheet that the financial data appears on.
Ratio Analysis
Calculate the required ratios on the Ratios worksheet for the two years 2010 and 2009 only. The ratios should be calculated on that sheet. Hint: You may want to capture the needed information from the other worksheets onto the Ratios page first; think about what amounts are required from each statement and then capture those in an organized manner.
Attachment:- Balance Sheets and Income Statement.xls