IndividualExcel ProjectSelect anapproved company and obtain

IndividualExcel ProjectSelect anapproved company and obtain the financials for the most recent two yearperiod. Based on the company financials:1.  Prepare a Horizontal Analysis forall 3 financial statements.2.  Prepare a Vertical Analysis for theBalance Sheet and Income Statement.3.  Prepare a Ratio Analysis for each ofthe following:a.  Current ratiob.  Acid-test ratioc.  Receivable turnoverd.  Inventory turnovere.  Profit marginf.  Asset turnoverg.  Return on Assetsh.  Return on Common Stockholder’sEquityi.  EPS (Earnings Per Share)j.  Debt to total Assets ratiok.  Times Interest EarnedYouranalysis should include a comparative analysis that is Intracompany(Horizontal & Vertical analysis for 2 years). No intercompany analysis isrequired. The project should be donevia Excel