Guidelines:

Create an excel workbook with two tabs:

Statement of Operations (1^st tab)

Balance Sheet (2^nd tab)

Use the word bank provided to create the rows of your statements. For the statement of operations, create columns for 2017 (current year) -2020. The ASC is projected to open in January 2018. Use the financial statement exhibits from your textbook reading as a guideline.

Once you have sorted out the word list into financial statements in Excel, insert formulas to show how you would calculate various items (such as Current Assets or Total Personnel Expense). You do not need to plug in values, but show how you would calculate them in Excel.

Submit your assignment as an excel (.xlsx) file.

Grading:

100 points based on the correctness of your answer.

Due Date: This part of the Course Project is due on the last night of week 2.

Word Bank: Section headings are in Mixed Case Italics Bold, totals are in UPPERCASE BOLD.

Contractual Adjustment	Gross Patient Services Revenue
Admin Salaries Expense	Admin Benefits Expense
NET PROPERTY PLANT & EQUIPMENT	Long Term Investment
TOTAL LONGTERM ASSETS	Charity Care Adjustment
Bad Debt Adjustment	TOTAL OPERATING EXPENSES
General & Administrative Expense	Other Accounts Payable
Salaries Payable	Interest Expense
Property Plant & Equipment	Less: Accumulated Depreciation
TOTAL OPERATING INCOME	EXCESS OF REVENUES OVER EXPENSES
NET PATIENT REVENUE	Other Revenue
TOTAL CURRENT LIABILITIES	Long Term Liabilities
Clinical Benefits Expense	Revenues
Allocated Overhead Salaries And Benefits Expense	TOTAL PERSONNEL EXPENSE
TOTAL LIABILITIES	Net Assets
Drugs & Supply Expense	TOTAL ASSETS
TOTAL CURRENT ASSETS	Current Liabilities
TOTAL OPERATING REVENUES	TOTAL LIABILITIES AND NET ASSETS
Clinical Salaries Expense	Expenses
Facilities & Equipment Expense	Net Patient Accounts Receivable
Inventory	Depreciation Expense
Current Assets	Cash