Midterm Financial Project Requires (15 point total):
Completion of Budget and Actual Income Statement. 5 points Detail in Cols A&B Rows 70-75
Variance Analysis by visits, patient days and revenues 5 points. Detail in Cols A&B Rows 76-80
A narrative summary and analysis of 1 to 2 pages double spaced (no more than 12 pt font with 1” margins) will accompany the Excel spreadsheet identifying key operational issues and corrective solutions. 5 points
There are some statistics (benchmarks) you can use in your narrative (analysis) to compare your expense calculations against California Hospital data for 2017/2018. Detail in Cols A 7 B Rows 88-99.
2 pages analysis and 1 page for excel sheet