Question
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
Guidelines:
Create an excel workbook with two tabs:
Statement of Operations (1st tab)
Balance Sheet (2nd 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started