Problem: The following account balances appeared in the general ledger of Dr. Robin Rubio at the end of December 2012, the second year of his private medical practice: Cash 350,403 Accounts Receivable 205, 000 Allowance for Bad Debts 7, 550 Prepaid Supplies 11,500 Library 155,000 Accumulated Depreciation-Library 15, 500 Medical Equipment 96,000 Accumulated depreciation-Medical Equipment Loans Payable 2, 000 200, 000 Accounts Payable 18,000 SS and CC Premium Payable 200 HDMF Premium Payable 100 PhilHealth Premium Payable Withholding Taxes Payable 75 427 Rubio, Capital 180, 650 Rubio, Personal 42, 000 Medical Fees Earned 729, 000 HDMF Premium Expense 1,100 PhilHealth Premium Expense 825 Salaries Expense Rent Expense 72, 000 110, 000 SS And EC Premium Expense 4,974 Taxes and Licenses 9, 000 Utilities Expense 75, 700 Interest Expense 20, 000 DATA FIR ADJUSTMENTS AS FOLLOWS 1. Rent expense represents payment for rent from January to November. 2. The estimated annual depreciation of the property and equipment is 10% per year of its acquisition cost. The library is part of the doctor's investment at the start of his practice on January 1, 2011 while the medical equipment were acquired in two groups: P48, 000 was acquired August 1, 2011 and the balance was acquired six months after the first acquisition. 3. Included in the medical fees is P12, 500 received in advance for surgical services to be rendered early next year 4. Only P2,750 of the supplies has not been used up. 5. Taxes accrued at the end of the year amounted to 2, 500. 6. Interest expense includes the 18% interest on a200-day loan discounted when the loan was taken 60 days ago. 7. Received bill from Meralco for electric consumption for the month of December, 3,500. 8. A provision for uncollectible accounts equal to 5% of the outstanding receivables is deemed reasonable. REQUIRED: A. Prepare a 10-column worksheet as at December 31. B. Journalize your adjustments. C. Prepare an adjusted trial balance.