Assignment:
Organize your company's and its closest competitor's financial information in an Excel Workbook
1. 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.
2. 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
https://www.sec.gov/Archives/edgar/data/1037038/000103703817000004/rl-20170401x10k.htm