Exel Sheet Analyze

 https://www.sec.gov/Archives/edgar/data/1037038/000103703817000004/rl-20170401x10k.htm 

. 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