Download the Excel workbook. Using the Metropolis Health System (MHS) Supplemental Information in the Examples and Exerc
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Download the Excel workbook. Using the Metropolis Health System (MHS) Supplemental Information in the Examples and Exerc
Download the Excel workbook.Using the Metropolis Health System (MHS) SupplementalInformation in the Examples and Exercises of your textbook, locatethe data components listed below that you will need to enter onyour spreadsheet. The data will be located in one of the MHSreports in this section. The reports you will need to refer to forthis assignment include the comparative Balance Sheet, Statement ofRevenue and Expenses, and Statement of Fund Balance.On your Excel spreadsheet, you will see a list of componentsdown the left side of the spreadsheet, horizontally.Across the top, vertically, enter both years as shown in thecomparative data supplemental information (see the example). Enterthe comparative data for both available years for eachcomponent.Enter the data that is provided for each component.Once you have entered the data for all eight components forboth years, your spreadsheet is complete and ready to submit.Save your file as a .xlsx file using your last name as the filename, e.g. Smith.xlsx, and follow the instructions below to submityour assignment.