Please Prepare and Unadjusted Trial balance, prepare adjusting entries and prepare an Adjusted trial balance.

TRANSACTIONS: Date January I January I January I January 3 January 5 January 7 January I O January 12 January 1 5 January 1 8 January 19 January 20 January 24 January 25 January 30 January 31 January 31 January 31 January 31 Transaction Owner, Tom Ford, invested S260,OOO cash along with office equipment that had a S90,OOO market value in exchange for 35,000 shares of S 10 par value common stock in Celebrity Consultants, Inc. Purchased land and an office building for S 140,000, of which S20,OOO was attributable to thc fair market value of thc land. A S50,OOO cash down payment was made and a five-year note was signed for the balance Interest and of the principal will be paid annually on tlus date. (Assume a 360-day year for interest umputation purposes.) Purchased a one-year insurance policy, effective January I , for S2,400. Purchased office supplies of S3 ,600 on account from Office Depot Established a petty ea.sh fund of S400. Placed an order with thc LA Times newspaper for advertising, which will run during January, February, and March. The advertising, which cost SI ,800, was paid for on this date in order to obtain a lower price. Completed comsulting job for Brad Pitt_ and billed him total of S 12,000, due in 30 days. Completed consulting job totaling SI 8,500 for Beyonce' Knowles, and eolleeted S 10,000 cash with the balance due in 30 days. Paid the semi-monthly payroll, which totaled S8,OOO, to the firm's workers, all of which are classified as independent eon tractors. Received SI 5,000 from Tiger Woods for 6 montWs consulting services to begin February I _ Paid Office Depot S2,500 on the account balance. Received S8,OOO from Brad Pitt for services billed January 10th. Completed S5,OOO consulting job for Taylor Swift and received full cash payment. Received S4,OOO from Beyonce' Knowles for comsulting services completed January 12. Received the January telephone hill from AT&T for S375, due Feb 15. Paid the paymll to firm's workers for the second half of January _ Received utility bills for January due Feb 16, from SWEPCO for S360 & L.A. Water Utilities for S280_ An audit of the petty cash fund determined the following: Receipts: Postage Office supplies Misc. Exm Currency and Coin s 24 Reimburse Petty Cash and record the entry from thc information above. Declared & paid cash dividend of S. 10 per share to the shareholders ofrccord on January 31 _ SUPPLEMENTAL ADJUSTING ENTRY INFORMATION: . An inventory or supplies was taken On January g I found that S2,IOO or supplies remained on hand. d. An invoice Of S280 ror repair or OIT1ce equipment dated January 26 had not yzt been recorded. The building will be depreciated on a straight-line basis over 30 years with no salvage value. The equipment will be depreciated on a straight-line basis over 10 yzars with no salvage value. Review accounts ror other adiustments necessary at January 31 in addition to those indicated in items a d.