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

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