detailed excel version input/answers please !

The following unadjusted trial baiance was extracted from the general ledger of Rouge Corporation at the end of its fiscal year on June 30,2023 . At fiscail year ond the following adjusting informaticn was echer not recorded or wrong entries made to the general kedger: 1 a. Insurance oxpiced during the yoar, $2,500 b. Bad debts expense for the year $1,400 c. At the of every year, equipment is depreciated at 10% on original cont d. Interest on Notes Payable is 1\$ (APR). The Notes were issued on June 1, 2023 and mature in 90 days 13 monthst. e. Rent paid in advance at June 30,2023 amounled bo $10,000 (ariginally charged to rent expensej. f. Salaries and wages unpeid at June 30,2023 wore $5,500. g. Ot the unearned service revenue, $1,600 was earned on June 30,2023 . h. Service for $8,000 was offered to clients but clients were nce invoiced by dure 30 , 2023. i. On June 30, 2023, supples on hand were valued at $500 (\$1,500 was used) 1. An amount of $7,000 received from clients for work not yet done by June 30, 2023 was recorded as service revonue. Instructions 0. From the unadjusted trial balance and inlorenation given below it, prepave arnual adjusting entries on June 30, 2023 i) Prepare an adjusted trial balance on June 30, 2023