your task is to complete the yellow-shaded columns to complete the close process. All other cells...

  

Transcribed Image Text:

your task is to complete the yellow-shaded columns to complete the close process. All other cells are locked within the spreadsheet. This practice problem continues the understanding of the placement of specific account types on the appropriate financial statements. For each of the financial statements, the column headers are labeled for debits (DR) and credits (CR). The excess of revenue over expenses is closed out to Net Assets (NA), which appears on both the Statement of Net Assets and Balance Sheet. Fort Collins General Hospital Financial Worksheet For the Fiscal Year Ended December 31, 20X3 Acet No. 101 Cash 102 Temporary Investments 105 104 105 100 107 108 109 名条班民日菜菜或游戏开 150 160 101 170 171 201 204 205 206 Account Name Accrued Interest Receivable 301 302 401 402 405 Accounts Receivable (A/R) Allowance for Uncollectible Accounts (AUCAs) Inventory (Supply 202 Notes Payable (N/P) 404 405 406 407 Prepaid Insurance Expense Prepaid Rent Expense Prepaid Interest Expense Land 205 Accrued interest Payable Buildings(s) Accumulated Depreciation-Building(s) Equipment Accumulated Accounts Payable (A/P) Depreciation Equipment 220 Bonds Payable Accrued Salaries and Wages (5/W) Payable Deferred Rental Revenue (Income) Deferred Tuition Revenue (Income) Hospital Net Assets (NA) Revenue and Expense Summary Routine Services Revenue Ancillary Services Revenue Premium Revenue Other Operating Revenue Rental Revenue Tuition Revenue Interest Revenue 400 Non-Operating Revenue 501 Contractual Adjustments 502 Charity Care Adjustments 601 Salary and Wages (5/W) Expense 602 Inventory (Supply) Expense 603 Utilities Expense 604 605 606 Insurance Expense Repairs Expense Rent Expense Depreciation Expense 607 608 Interest Expense 609 Bad Debt Expense 610 Other (Miscellaneous) Expenses ADI Trial Balance 12/31/20X5 Profit/Loss end-of-year NA update: does it belence OR 616,100 353.000 44,700 1.013,100 167,100 13.500 4.900 400 450.000 407 400 148.200 144.200 181,900 684,400 280,200 148.200 110,500 54,800 17,800 156.500 67,400 75,400 CR 13.500 121.500 40.400 21.400 14.800 5.000 4.700 10.000 5,400 299.100 1,482,000 2.254,400 687,100 134,700 125.900 37,700 19,700 33.400 13,700 24.300 Totals: 3,325,800 5.325.800 Statement of Operations 2005 OR CA Statement of NA 20x5 DR CA Selence Sheet 12/31/2015 DR CR your task is to complete the yellow-shaded columns to complete the close process. All other cells are locked within the spreadsheet. This practice problem continues the understanding of the placement of specific account types on the appropriate financial statements. For each of the financial statements, the column headers are labeled for debits (DR) and credits (CR). The excess of revenue over expenses is closed out to Net Assets (NA), which appears on both the Statement of Net Assets and Balance Sheet. Fort Collins General Hospital Financial Worksheet For the Fiscal Year Ended December 31, 20X3 Acet No. 101 Cash 102 Temporary Investments 105 104 105 100 107 108 109 名条班民日菜菜或游戏开 150 160 101 170 171 201 204 205 206 Account Name Accrued Interest Receivable 301 302 401 402 405 Accounts Receivable (A/R) Allowance for Uncollectible Accounts (AUCAs) Inventory (Supply 202 Notes Payable (N/P) 404 405 406 407 Prepaid Insurance Expense Prepaid Rent Expense Prepaid Interest Expense Land 205 Accrued interest Payable Buildings(s) Accumulated Depreciation-Building(s) Equipment Accumulated Accounts Payable (A/P) Depreciation Equipment 220 Bonds Payable Accrued Salaries and Wages (5/W) Payable Deferred Rental Revenue (Income) Deferred Tuition Revenue (Income) Hospital Net Assets (NA) Revenue and Expense Summary Routine Services Revenue Ancillary Services Revenue Premium Revenue Other Operating Revenue Rental Revenue Tuition Revenue Interest Revenue 400 Non-Operating Revenue 501 Contractual Adjustments 502 Charity Care Adjustments 601 Salary and Wages (5/W) Expense 602 Inventory (Supply) Expense 603 Utilities Expense 604 605 606 Insurance Expense Repairs Expense Rent Expense Depreciation Expense 607 608 Interest Expense 609 Bad Debt Expense 610 Other (Miscellaneous) Expenses ADI Trial Balance 12/31/20X5 Profit/Loss end-of-year NA update: does it belence OR 616,100 353.000 44,700 1.013,100 167,100 13.500 4.900 400 450.000 407 400 148.200 144.200 181,900 684,400 280,200 148.200 110,500 54,800 17,800 156.500 67,400 75,400 CR 13.500 121.500 40.400 21.400 14.800 5.000 4.700 10.000 5,400 299.100 1,482,000 2.254,400 687,100 134,700 125.900 37,700 19,700 33.400 13,700 24.300 Totals: 3,325,800 5.325.800 Statement of Operations 2005 OR CA Statement of NA 20x5 DR CA Selence Sheet 12/31/2015 DR CR

Answer rating: 100% (QA)

Financial Worksheet For the Fiscal year ended December 31 20x5 Cash Temporary Investment Accrued Int... View the full answer