Task:
Please resort to the case study listed above and read it first from the required book: Cases in Healthcare Finance. Please follow with the Case Highlights ppts presenting Key Learning Points in each case. Please follow with the Focus Questions leading your critical thinking though the concepts in each case. Next, please analyze thoroughly the complete Excel Spreadsheet-based models supporting each case, with all formulas and data provided. Both, the addressed cases and your own experience, you are strongly encouraged to share, will constitute the real life issues and problems to be resorted to, and discussed while presenting Practical Application of Financial Analysis, Cash Budgeting and Forecasting (Ratios and DuPont analysis). Please support your assignment with presentations of financial models, interpretations, explanations of theoretical concepts referred to. Please provide supporting data, and references for your arguments. Please be detailed, precise and clear in your critical analysis. Your write-up should be comprehensive, well-organized and concluded with suggested solutions and recommendations.
Prepare a managerial report with narrative (analysis, explanations, conclusions, and recommendations) with supporting data (with tables transferred from excel spreadsheet) pasted throughout the text when you are referring to them. It needs to be a thorough and in-depth financial analysis (applied not theoretical) providing comprehensive assessment of financial performance. You do not have to answer questions included in the cases, but they are to help you with assessing the financial performance and presenting Ratios (KPIs and ratios covering all areas of financial assessment) and DuPont analysis, according to the objectives of the assignment. You could start with a trend analysis and general explanation of the basic financial performance analysis with application of Balance Sheet and Income Statement, and with the interpretation of the key financial ratios.
