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.

3 = 5 A Fort Collins General Hospital Financial Worksheet For the Fiscal Year Ended December 31, 20X5 Acct No. 101 Cash 102 Temporary Investments 103 104 Accrued Interest Receivable Accounts Receivable (A/R) 105 Allowance for Uncollectible Accounts (AUCAS) 106 107 108 109 150 160 161 170 171 201 202 203 204 205 206 220 301 302 401 402 403 404 B 405 406 407 408 Account Name 601 602 603 604 605 Inventory (Supply) Prepaid Insurance Expense Prepaid Rent Expense Prepaid Interest Expense Land Buildings(s) Accumulated Depreciation - Building(s) Equipment Accumulated Depreciation - Equipment Accounts Payable (A/P) Notes Payable (N/P) Accrued Interest Payable Accrued Salaries and Wages (S/W) Payable Deferred Rental Revenue (Income) Deferred Tuition Revenue (Income) Bonds Payable 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 Non-Operating Revenue 501 Contractual Adjustments 502 Charity Care Adjustments Salary and Wages (S/W) Expense Inventory (Supply) Expense Utilities Expense Insurance Expense Repairs Expense Rent Expense 606 607 608 609 610 Other (Miscellaneous) Expenses Depreciation Expense Interest Expense Bad Debt Expense D Profit/Loss: end-of-year NA update: does it balance?: ADJ Trial Balance 12/31/20X5 DR 818,100 333,000 44,700 1,013,100 167,100 13,500 4,900 400 450,000 407,400 148,200 E 144,200 181,900 684,400 280,200 148,200 110,500 34,800 17,800 156,300 CR 13,500 121,300 40,400 21,400 14,800 5,800 6,700 10,800 5,400 299,100 1,482,000 2,254,400 687,100 134,700 123,900 37,700 19,700 33,400 13,700 67,400 75,400 24,300 Totals: 5,325,800 5,325,800 F G Statement of Operations 20X5 DR H 0 0 CR 0 J K Statement of NA 20X5 DR CR 0 L M Balance Sheet 12/31/20X5 DR N CR 0 O P