I need the Review of preparing a worksheet and journaling entries

GROUP B PROBLEMS (Excel templates for all questions are available in My Accountinglab.) eet P4-1B. To: Matt Kamimsk From: Abbey Ellen RE: Accounting Needs Please prepare ASAP from the following info along with (b) journalized adjusting entries. ASAP from the following information (attached) a) a worksheet DEBBIE'S DANCE STUDIO TRIAL BALANCE JUNE 30, 2020 Dr. 10 1 5 000 500 000 17 00 00 3 00 00 12 9 5 000 Cash Accounts Receivable Prepaid Insurance Dance Supplies Dance Equipment Accumulated Depreciation, Dance Equipment Accounts Payable D. Dee, Capital D. Dee, Withdrawals Dance Fees Earned Salaries Expense Telephone Expense Advertising Expense 400 000 575 000 15 1 50 00 40 000 520000 45 000 7 000 80.00 30 1 0 0 0 30 1 0 0 0 0 Adjustment Data a. Insurance expired, $100 b. Dance supplies on hand, $20 c. Depreciation on dance equipment, $200 d. Salaries earned by employees but not due to be paid until July, $490