I need help with the problem in the attacehd spreadsheet. All work needs to be shown under the answers section in the spreadsheet. Additional info pertaining to the question can be found in the PDF.
Problem 3
UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT | |||
Chapter 13 — Financial Condition Analysis | |||
PROBLEM 3 | |||
Bayside Memorial Hospital’s financial statements are presented in Tables 13.1, 13.2, and 13.3. | |||
a. Calculate Bayside’s financial ratios for 2009. Assume that Bayside had $1 million in lease | |||
payments and $1.4 million in debt principal repayments in 2009. (Hint: use the book discussion to | |||
identify the applicable ratios.) | |||
b. Interpret the ratios. Use both trend and comparative analysis. For the comparative analysis, assume | |||
that the industry average data presented in the book is valid for both 2009 and 2010. | |||
ANSWER |