Please help with the entire question answered in excel format. Each part answered separately (5 parts)

P3.3 Cocktail Hospital's trial balance at January 1, 20x1, includes the following accounts: Cash Accounts receivable $10.500 24,800 5.700 19.000 73.000 27,000 Buildings 6,600 Accounts payable Short-term notes and loans payable-banks Bonds payable Hospital net assets 60,000 160.000160.000 The hospital completed the following transactions during the month ended January 31 1. Purchases of supplies on account were S4,900. 2. Supplies that had cost $5,200 were issued from inventory for , 20X1 use in hospital activities 3. Services billed to patients were as follows: $ 40,800 31,600 72.400 Routine services Ancillary services 4. Cash collections on patients' accounts were S59,100 5. Payments on accounts payable totaled $5,070 6. Other revenues received in cash amounted to $7,300. 7. Operating expenses included these payments: Salaries and wages 53.200 1.900 1,200 1,100 Other expenses Total $ 58,000 8. Payment of interest on bonds and bank loan totaled $870 Reguired: Using the chart of accounts provided in Figure 3.1, (1) enter the January 1, 20X1, balances in ledger accounts, (2) jour- nalize the January 20XI transactions, (3) post the transaction entries to the ledger accounts, (4) prepare a trial balance at January 31, 20x1, (5) prepare a statement of operations for January 20X1 and (6) prepare a balance sheet at January 31, 20x1