Review: Professor Office. (n.d.). Excel: Horizontal analysis and vertical analysis. Retrieved from http://professoroffice.com/VerticalHorizontalRatioAnalysis.aspx Use the consolidated balance sheets downloaded from Ascension Health to perform a vertical analysis of the company and a horizontal analysis of the company in an Excel document.