A review of the ledger of Smallville Company at April 30, 2020, produces the following data pertaining to the preparation of monthly adjusting entries.

(a) Notes Payable $25400. This balance consists of a note for 6 months at an annual interest rate of 15%, dated January 1, 2020.

(b) There are five workers in Smallville Company who are paid wages weekly. The five workers are paid $800 each for a 5-day work week (Monday to Friday). April 30 is a Tuesday and workers are paid on Fridays.

(c) Annual depreciation is $12100 on equipment.

(d) Physical check reveals inventory actually on hand on April 30, 2020 is $57069.4.

(5) Prepare an adjusted trial balance.

There is a picture format template is given,please follow that.I have given you only one question not too many works. Kindly Do your work in excel and give me the work of that,If you do it correctly,you will get 3 upvotes,Thanks!

Smallville Company Adjusted Trial Balance Serial No. Account Titles Dr 191 Total Smallville Company Adjusted Trial Balance Serial No. Account Titles Dr 191 Total