Create balance sheets

Visit the website below

https://www.causeiq.com/organizations/bon-secours-st-francis-medical-center,311716973/

1.            Create balance sheets

2.            On an excel worksheet (show formula), calculate the Liquidity Ratios which include Current Ratio, Acid Test Ratio, and Net Working Capital for the 5-year period from fiscal year ending August 2014 to 2018 for the non-for-profit organization.

3.            In a memo give the interpretation of the various ratios. Is the organization able to pay off its short-term debt obligations? Is the company financially healthy? What can the organization do differently in order to be successful?

Description

Please use the financial data for Bon Secours St. Francis Medical Center only as provided by the link. FYI, Do not use any other financial information apart from the one provided through the link for Bon Secours St. Francis Medical Center. Provide financial statements, calculate Current Ratio, Acid Test Ratio, and Net Working Capita. Write memo on a separate word document with the following

give the interpretation of the various ratios. Is the organization able to pay off its short-term debt obligations? Is the company financially healthy? What can the organization do differently in order to be successful?

Include graphs, charts where need be.