Question: Professor Office. (n.d.). Excel: Horizontal analysis and vertical analysis. Retrieved from https://youtu.be/MwMZATCDas4?feature=shared (horizontal) https://youtu.be/U7lWb2n3N50?feature=shared (vertical) Use the consolidated balance sheets downloaded from St. Joseph to
Professor Office. (n.d.). Excel: Horizontal analysis and vertical analysis. Retrieved from https://youtu.be/MwMZATCDas4?feature=shared (horizontal) https://youtu.be/U7lWb2n3N50?feature=shared (vertical)
Use the consolidated balance sheets downloaded from St. Joseph to perform a vertical analysis of the company and a horizontal analysis of the company in an Excel document. (https://www.providence.org/-/media/project/psjh/providence/socal/files/about/financial-statements/2023-continuing-disclosure-annual-report.pdf)
Discuss your findings by answering the following:
Is St. Joseph growing? How do you know? What line items reflected the largest-percentage increases and/or decreases? What is the financial impact these changes have on the company's financial viability currently and in the future?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
