Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management A Strategic Emphasis

Authors: Edward Blocher, David E. Stout, Gary Cokins, Kung Chen

4th Edition

0073128155, 978-0073128153

More Books

Students also viewed these Accounting questions

Question

In your own words, summarize the primary objectives of unions.

Answered: 1 week ago