1. There are multiple components in a health care financial report. This activity will allow you to create a spreadsheet in Excel and apply your knowledge of the Balance Sheet, Statement of Revenue and Expenses, and Statement of Fund Balance by pulling needed information from the appropriate financial reports to develop your own spreadsheet.
1. You will create a spreadsheet in Excel.
2. Using the Metropolis Health System (MHS) Financial Statements in Appendix 28-A (pg. 409-411) of your Baker and Baker text, locate the data components listed below that you will need to enter on your spreadsheet. The data will be located in one of the MHS reports in this section. The reports you will need to refer to for this assignment include the comparative Balance Sheet, Statement of Revenue and Expenses, and Statement of Fund Balance.
3. On your Excel spreadsheet, list the name of each component (see below) down the left side of the spreadsheet, horizontally.
4. Across the top, vertically, enter both years as shown in the comparative financial statements (see the example).
5. Enter the comparative data for both available years for each component.
6. Once you have entered the data for all eight components for both years, your spreadsheet is complete and ready to submit.
7. Save your file as an xlsx file using your last name as the file name, e.g. Smith.xlsx and follow the instructions below to submit your assignment.
List of Components: (please make sure to indent this list as close to how it looks here) • Current Liabilities • Total Assets • Income from Operations • Accumulated Depreciation • Total Operating Revenue • Current Portion of Long-Term Debt • Interest Income • Inventories Here is an example of how to set up your spreadsheet. You will see it better if you collapse the table of contents and navigation columns of the course.
The “20XX” stands for the year of the data, such as 2012 or 2013. The actual dates are listed in the example in your text
| PLEASE NOTE: You will need Microsoft Excel to complete this activity. If you do not have Excel, which is a part of the Microsoft Office Suite, you can access the Excel software through Excelsior’s website. In order to do so, you must first do two things:
1. Download and install Citrix – which allows you to access software owned by the College. For download and installation instructions, please visit https://myapps.excelsior.edu/vpn/ students.pdf. 2. Once you have installed Citrix, go to https://myapps.excelsior.edu/ to access Excel. If you need additional assistance accessing Excel through Citrix, please contact Technical Support. |
Compose your work using Microsoft Excel and save it frequently to your computer. When you’re ready to submit your work, click Browse My Computer and find your file. Once you’ve located your file click Open and, if successful, the file name will appear under the Attached files heading. Scroll to the bottom of the page, click Submit and you’re done. Be sure to check your work and correct any errors before you post it.
