Presented below is a trial balance prepared before adjustments for the year ended Dec. 31, 2014

Self-Check: (Adapted: Encabo) Preparation of Worksheet Presented below is a trial balance prepared before adjustments for the year ended Dec. 31, 2014 MY RENT-A-CAR Trial Balance December 31, 2014 Account Title Debit Credit Cash 120,000 Shop Supplies 25,300 Prepaid Insurance 19,200 Mitsubishi Cars 1,500,000 My, Capital P 950,000 Rent Revenues 840,000 Salaries Expense 98,000 Utilities Expense 18,000 Repairs and Maintenance 9,500 Total P 1,790,000 P 1,790,000 Data for year-end adjustments: a. Car insurance covers the period from June 1, 2014 to June 1, 2015. b. The Mitsubishi cars acquired on Jan. 1, 2014 have an estimated life of 10 years without scrap value. C. Advance car rental of P25,000 was received for a 10-day servicing starting from Dec. 26, 2014 to Jan. 4, 2015. d. Unpaid service driver's salary, P2,000. e. Cost of shop supplies on hand, P9,500. 50 Required: Prepare a 10-column worksheet