Assignment
Organize your company's and its closest competitor's financial information in an Excel Workbook
Create Vertical and Horizontal Analysis excel spreadsheets - Using your company's Income Statement reported in their Form 10-k, prepare a Vertical Analysis and a Horizontal Analysis of three years of your company's income statement data. Embed your excel charts within your word document.
Create a comparative Ratio Analysis chart - Include the following information in a management report that is easy to read and comprehend.
Company ratios - Show a 3 year trend of your company's key ratios (obtain ratios from Calcbench - do not calculate them), separated into the categories of profitability, liquidity, and solvency. You must choose at least 3 ratios that tell us something different about profitability, at least 3 ratios that tell us something different about liquidity, and at least 2 ratios that tell us something different about solvency. (For example, inventory turnover is a liquidity ratio but days sales in inventory, also a liquidity ratio, tells us the same thing in different ways....therefore, these are not considered 2 different liquidity ratios).
· Competitor ratios - Do the same for your company's closest competitor (obtain ratios from Calcbench - do not calculate them).
· Industry ratios - Show the industry average for each ratio you reported for your company and competitor.