Please HELP 
Congratulations! You are almost finished with your internship and your hard work has been noticed! For the third part of your project, you have been promoted to Senior Intern. The hospital Chief Financial Officer wants to know how Pima Medical Center is doing compared to its primary competitor, Tuscon Regional. You have been asked to prepare a Ratio Analysis and Common Size Financial Statement for the CFO to present at the next Board of Trustees meeting. The presentation needs to cover both quantitative measures and qualitative analysis. You have been provided with a list of ratios that the CFO wants you to compute and the necessary financial statements for both facilities. You are to calculate the ratios for Pima Medical Center for the last three fiscal years and for Tucson Regional for the last year. In addition, you need to write a description of what each ratio means, as this will help the CFO answer any questions the Board may have. The ratio analysis and common size financial statements will serve as the quantitative portion of the presentation. For the qualitative portion, you have been asked to analyze the numbers and make assessments based on those numbers. For example, because you have three years of data for Pima Medical Center, you should be able to comment on trends over those three years and because you have the last fiscal year for both Pima Medical Center and Tuscon Regional, you can comment on which is doing better and why. The name and description of each worksheet you will use for this project are below. Please be sure to complete data entry on each of the A1 :fx Hospital Financial Statements Calculate the given 15 Ratios for BOTH hospitals. A1 :Xfx Question 3: Provide a summary and analysis for each ratio Question 4: Prepare a Common Sizo Analysis - Enter the relevant dala for for each category. Categories shaded in yellow have been entered for you. - Complete the Anaysis column Column Jj based on your calculations. - Areas in which you are required to input data are shaded in blue. - It is a good idea to use Excel cell references and fomulas to reduce errors in calculations. Congratulations! You are almost finished with your internship and your hard work has been noticed! For the third part of your project, you have been promoted to Senior Intern. The hospital Chief Financial Officer wants to know how Pima Medical Center is doing compared to its primary competitor, Tuscon Regional. You have been asked to prepare a Ratio Analysis and Common Size Financial Statement for the CFO to present at the next Board of Trustees meeting. The presentation needs to cover both quantitative measures and qualitative analysis. You have been provided with a list of ratios that the CFO wants you to compute and the necessary financial statements for both facilities. You are to calculate the ratios for Pima Medical Center for the last three fiscal years and for Tucson Regional for the last year. In addition, you need to write a description of what each ratio means, as this will help the CFO answer any questions the Board may have. The ratio analysis and common size financial statements will serve as the quantitative portion of the presentation. For the qualitative portion, you have been asked to analyze the numbers and make assessments based on those numbers. For example, because you have three years of data for Pima Medical Center, you should be able to comment on trends over those three years and because you have the last fiscal year for both Pima Medical Center and Tuscon Regional, you can comment on which is doing better and why. The name and description of each worksheet you will use for this project are below. Please be sure to complete data entry on each of the A1 :fx Hospital Financial Statements Calculate the given 15 Ratios for BOTH hospitals. A1 :Xfx Question 3: Provide a summary and analysis for each ratio Question 4: Prepare a Common Sizo Analysis - Enter the relevant dala for for each category. Categories shaded in yellow have been entered for you. - Complete the Anaysis column Column Jj based on your calculations. - Areas in which you are required to input data are shaded in blue. - It is a good idea to use Excel cell references and fomulas to reduce errors in calculations
