Company Altice USA and Cable One

Data analytics: using technology and tools to measure, analyze, andinterpret. Note: all cells that include calculated numbers must have an embedded formula that begins with "=" and references cells on the same or another sheet. I. Preparean Excel spreadsheet that includes the following: a. Sheet 1: paste the SEC 10-K Income Statement and Balance Sheet for Company A. You will be referencing cells on this spreadsheet so do not paste a screen capture. Cite all sources b. Sheet 2: paste the SEC 10-K Income Statement and Balance Sheet for Company B. You will be referencing cells on this spreadsheet so do not paste a screen capture. Cite all sources c. Sheet 3: paste the Industry Averages. You will be referring to cells on this spreadsheet so do not paste a screen capture. Cite all sources d. Sheet 4: Perform a horizontal analysis and vertical analysis of Corporation A, for the most current year, using the most current 2 years of financial statements, of the i. Balance Sheet and ii. Income Statement 1. Embed formulas in all cells requiring computations. Reference cell on different sheets in your formulas when necessary. a. If you do not know how to reference cells on other worksheets, post questions in the discussion Post Questions about Project 1, located in the week it is due e. Sheet 5: Perform a horizontal analysis and vertical analysis of Corporation B, for the most current year, using the most current 2 years of financial statements, of the i. Balance Sheet and ii. Income Statement 1. Embed formulas in all cells requiring computations. Reference cell on different sheets in your formulas when necessary. a. If you do not know how to referencing cells on other worksheets, post questions in the discussion Post Questions about Project 1, located in the week it is due f. Sheet 6: Perform ratio analyses i. Identify 20 ratios relevant to the industry and available online. If a ratio cannot be computed for one corporation, use a different ratio for both. ii. Compute the same ratios for Corporation A and Corporation B iii. Create a comparison of the Industry Averages to Corporation A to Corporation B using 5 columns: 1) Ratio name, 2) Ratio formula 3) Corp. A result, 4) Corp. B result, and the 5) Industry Average 1. Embed formulas in all cells requiring computations. Reference different sheets in your formulas wherever possible. g. Sheet 7: Report findings and recommendations i. Compare the industry averages to your horizontal analyses, vertical analyses, and financial ratio analyses. Your results should be similar to the industry averages. If substantially different, explain why. ii. Review your results to detect data trends and or data outliers, if any. Make note of metrics you found unusual, interesting, or that may potentially impact corporate profitability. iii. Cite all sources. iv. Note how each company performed in response to the global pandemic. v. Make recommendations to enhance profitability