Prepare an Excel Workbook.
Tab 1 – Horizontal Analysis of the Balance Sheet
Tab 2 – Vertical Analysis of the Income Statement
Tab 3 – Financial Ratios – Select 2 profitability and 2 liquidity ratios (Use formate covered in class, I want to see details of the calculations.)
Review analysis work and select 4 of the more critical observations made in the analysis.
Write a paper of no more that 1250 words in which you conduct a comparative and ratio analysis to measure profitability and liquidity.