PLEASE HELP PROVIDE THE TRIAL BALANCES, INCOME STATEMENT AND STATEMENT OF RETAINED EARNINGS

ACCT 215 (CT) Accounting Cycle Problem The John Marshall Company, Ince, which provides consulting services to major utility companies, was formed on Janury 2 of this year. Transactions completed during the fint year of operation were as follows: January 2-Issued 600,000 shares of stock for $10,300,000. Jamany 10 - Acquired equipment in exchange for $2,600,000 cash and a $5,100,000 note payable. The note is dac in ten years. Febrany 1-Pad 512,000 for a business insurance policy covering the two-year period beginning on February 1. Februng 22-Purchased 5900,000 of supplites on scoount March 1-Paid wages of 5185,600 March 23 - Billed 52,810,000 for serviees rendered on necount Aprit 1 - Paid 5120,000 of the amount due on the supplies purchused Fobruary 22. April 17 -Collected $300,000 of the necounts receiviblo Miny 1-Paid wases of 5200,400 . May 8 - Received nnd puid bill for $96,000 for utilities. Mry 24-Paid S44,000 for sales comminstions. June 1 - Mode the fint payment of 250,000 on the note issued January 10. The payment consisted of $50000 intenest and 5200,000 applied egainst the principal of the note. June 16 - Billed cuitomen for $20,000 of servioes rendered. June 30 - Collected 5310,000 en necountr receivible. July 10 - Punchined 5150.000 of supplies on ascount. Augaut 25 - Paid 5155,000 for admialietrative expenses. September 23 - Pald s31, 000 for warehouse repain. Ostober 1 - Pald eeneral waget of $91,000. Novenber 20 - Furchased supplies for 561,000 canh. December is - Collected 5145,000 in advance for Mervises to be provided in Desember and January. Deoenber 30 - Declared mind pald a 555,000 dividend to ahareholders. The chart of gecounts that Manhall Conpany, Ine, uses is as follows REOUTRED: Utilizing the information provided above, complete the following steps in an Excel worlbook (Template provided): 1. Joumalizo the transactions for the year. 2. Post the joumal eatries to a T acoount. 3. Prepare an unadfusted trial balance as of December 31 . 3. Prepare an unatjusted trial balance as of December 31 . information: 2. Eleven months of the insurance policy expired by the end of the year. b. Depreciation for equipment is 510,000 . c. The company provided $92,000 of services related to the advance collection of December 15. A. There are $5.5,000 of eupplies on hand at the end of the year. d. Aneditional 5185,000 of interest has acerued on the note by the end of the year. f. Marhall ecerued whese of $215,000 at the end of the ent. 5. Prepare an adfusted trial balance as of December 31. 5. Prepare an ndjusted trial balance as of Docember 31. December 31 and a clasalfied balance shoet as of Docember 31. 7. Joarnaline and post the closing entries 7. Prepars a post-closing trial balance as of December 31. Submit your completed Bucel workbook in Blnck Bosd under asuignments by the dae dato