This is a new project, based upon the previous order #453689942. Please use 3594 as the requested writer, as they previously worked this topic.Instructions:You will see that this as similar to the previous project you completed for me, albeit with a few twists — in particular the hospital in this case is for-profit. As with the previous project please enter your calculations in the supplied Word (*.docx) answer sheet. And, as with the previous project* Attached here is an Excel Sheet with the income statement and balance sheet for you to do calculations.* Look at the Answer Sheet (Word) for the questions, and then enter your calculations there in response to the questions. Upload the Word file to facilitate the grading process. (You can also upload your completed Excel Sheet, but that is optional.)* Pick the most relevant benchmark from the Zelman table (page 185). Remember that Regional Medical Center is a for-profit 450-bed hospital. Since the Zelman ratios and benchmarks are described in not-for-profit terminology, you will need to substitute the not-for-profit terminology to find the correct formula and benchmark. Remember that a for-profit’s “equity” is equivalent to a not-for-profit’s “net assets.” (See the footnotes on Zelman, p. 186, which discuss for-profit vs. not-for-profit terminology and ratio calculations.)* Attached is a for-profit vs not-for-profit terminology refresher — comparing the for-profit “income statement” to a not-for-profit “statement of operations.”* Note: Assume debt principal payments are $5.5 million in each year, 2015 and 2016.* When asked for your “assessment” — of liquidity, profitability, activity, and capital structure — (1) provide an overall assessment, (2) make clear whether the ratios are favorable or unfavorable relative to the benchmarks, and (3) whether the trend is favorable or unfavorable. (Use the answers to the previous assignment and my comments on your assignment as a guide.)
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|