Please write answer in Excel

Exercise 4-06 a-b Selected worksheet data for Pharoah Company are presented below. Trial Balance Adjusted Trial Balance Account Titles Debit Credit Debit Credit Accounts Receivable 2 33,500 Prepaid Insurance 25,900 20,200 Supplies 6,900 ? Accumulated Depreciation-Equipment 11,200 ? Salaries and Wages Payable 2 5,800 Service Revenue 88,900 98,000 Insurance Expense 2 Depreciation Expense 9,200 Supplies Expense 4,100 Salaries and Wages Expense ? 48,900 Fill in the missing amounts. Trial Balance Debit Credit Account Titles Adjusted Trial Balance Debit Credit Accounts Receivable 33,500 25,900 20,200 Prepaid Insurance Supplies 6,900 Accumulated Depreciation Equipment 11,200 Salaries and Wages Payable 5,800 Service Revenue 88,900 98,000 Insurance Expense Depreciation Expense Supplies Expense 9,200 4.100 Supplies Expense Salaries and Wages Expense 4,100 48,900 LINK TO TEXT Prepare the adjusting entries that were made. (Credit account titles are automatically indented when a Account Titles and Explanation Debit Credit (To record service revenue on account) (To record expired insurance) (To record supplies used) (To record depreciation)