please help!!!

ACCT 215 (CT) Accounting Cycle Problem The John Marsha1 Company, Inc., which provides consulting services to major utility companies, was formed on January 2 of this year. Transactions completed during the first year of operation were as follows: January 2 - Issued 600,000 shares of stock for S10,600,000 January 10 - Acquired equipment in exchange for $2,500,000 cash and a $5,500,000 note puyable. The note is due in ten years. February 1 - Paid $10,800 for a business insurance policy covering the two-year period beginning on February 1 February 22 - Purchased $950,000 of supplies on account March 1 - Paid wages of $185,600 March 23 - Billed $2,820,000 for services rendered on account April 1 - Paid $110,000 of the amount due on the supplies purchased February 22. April 17 - Collected S240,000 of the accounts receivable May 1-Paid wages of $200,400. May 8 - Received and paid bill for $96,200 for utilities May 24 - Paid 542,500 for sales commissions June 1 - Made the first payment on the note issued January 10. The payment consisted of $60,000 interest and $200,000 applied against the principal of the note. June 16 - Billed customers for $550,000 of services rendered June 30 - Collected $310,000 on accounts receivable. July 10 - Purchased $155,000 of supplies on account. August 25 - Paid S160,000 for administrative expenses. September 23 - Paid $30,000 for warehouse repairs. October 1-Paid general wages of $90,000 November 20 - Purchased supplies for $60,000 cash. December 15 - Collected $135,000 in advance for services to be provided in December and January December 30 - Declared and paid a $50,000 dividend to shareholders. The chart of accounts that Marshall Company, Inc. uses is as follows: Assets: 101 Cash 102 Accounts receivable 103 Supplies 104 Prepaid game 110 Equipment 112 Accumulated depreciation Liabilities Accounts payable Uneared service revenue 203 Wages payable 210 Interest payable 220 Notes payable 201 202 320 Stockholders' Equity 301 Common stock 310 Retained earnings Dividends Revenues 401 Service revenue Expenses 501 Wage expense 502 Utility expense 503 Selling expense 504 Administrative expense 505 Repairs expense 506 Insurance expense 507 Supplies expense 510 Depreciation expense 520 Interest expense Other: 601 Income summary REQUIRED: Utilizing the information provided above, complete the following steps in an Excel workbook (Template provided): 1. Journalize the transactions for the year. 2. Post the journal entries to a T account 3. Prepare an unadjusted trial balance as of December 31. 4. Journalize and post adjusting entries to the accounts based on the following additionat information: Eleven months of the insurance policy expired by the end of the year. b. Depreciation for equipment is $410,000. c. The company provided 585,000 of services related to the advance collection of December 15 d There are $530,000 of supplies on hand at the end of the year. An additional $180,000 of interest has accrued on the note by the end of the year. f Wilson accrued wages of S210,000 at the end of the car 5. Prepare an adjusted trial balance as of December 31. 6. Prepare a single-step income statement and statement of retained camings for the year ended December 31 and a classified balance sheet as of December 31. 7. Journalize and post the closing entries 8. Prepare a post-closing trial balance as of December 31. Submit your completed Excel workbook in Black Board under assignments by the duc date A. % Conditional Formatting Format as Table 2 Cell Styles Clipboard Font Alignment Number Calls Editin EZ x fx 10600000 1 Act and Nan 10.000.000 Cormonte Eupen 10, SO.000 1 L000.000 120 LOL 720 104 2.500.000 5.500.000 1feb 23 10.800 Netes Payable Prepaid Dash Supplies Amount Payable Wage Line Cash Aus Medevate Service leven Amounts Payable 950.000 108 201 501 100 102 12 200,400 23 Mar 200,400 14 220.000 1 AD 2.000.000 110.000 17 Apr 110,000 140.000 17 TE 19 20 21 201 101 101 102 501 301 Ch Accounts Recevable Wapente Cash y Espen 1 May 240.000 200.000 BMW 200.400 200 100 24 May M. 200 10 Wu 0,500 0.000 27 Gish Interest Expen Notes Payable Cash Account Revale Service Menu 101 520 220 101 109 41 DOS 16 Jun 250,000 29 101 Cash 350.00 330.000 11 22 12 10 310.000 155.000 Account Redevable Supplies Acourts Payable Anitrative Cash Repairs Cash Wie lige 000 35 16 17 23-Sep 150.000 00 1.Od 10,000 101 201 504 101 SOS 100 501 101 103 101 101 200 320 201 19 40 11 90.000 30 New 0.000 50.000 15-0e 50,000 Supplies Cash Gash Uneared Service Revenue Dividende Chh I.300 20 Dec 135,000 50,000 50,000 0 51 Journal entries Trial Balances Income Statement Statement of Retained ean Ready Home Insert Draw Page Layout Formulas >> Tell me Share C o A. % Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Anal Da 029 7,616, 20.000 LIS DOO .000 DO 12 W 1.100.000 10.600.00 TI 000 w 200 11 160.000 + 11 Journal entries Trial Balances Income Statement Statement of Retained earning Ready Clipboard Font Cells Edit 10 Format as Table Alignment Number ZCell Styles fx John Marshal Company A1 x B D E 1 2 3 John Marshal Company Income Statement for the Year ended 12/31/2019 5 6 7 Expenses 8 9 10 11 12 13 14 15 16 17 NNNNNN 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Journal entries Trial Balances Income Statement Statement of Retained Conditional Formatting A- . % Format as Table Clipboard Font Alignment Number Cells Cell Styles A8 fx A B D m 1 2 Nm John Marshal Company Statement of Retained Earnings for the Year ended 12/31/2019 3 4 $ 5 Balance January 1, 2019 6 7 8 9 10 11 12 13 14 15 un 16 17 18 19 20 er 21 22 23 WN N Home Insert Draw Page Layout Share Comments to A - % Formulas >> Tell me 3 Conditional Formatting E Format as Table 52 Cell Styles Clipboard Font Alignment Number Cells Editing Analyze Data A2 x D une 104 searl Notes Puyate 220 3.500 DOO 200.000 Di 110 DDD Depreconcesos Amur Res 102 23.10.000 240.000 10.000 110.000 2.500.000 20.00 300,000 110.000 240.000 70,000 $350.000.00 5200,000 00 ed Depron 12 Warto 300,000 200400 0,000 Repuis presos 10,000 200.450 42.500 250.000 10000 Suplies 100 950.000 195.000 0.000 100.000 20.000 0.00 0.000 15 11 1,165,000 15 15.000 Selin 50,000 96,300 Servavene 2.000.000 SCO 10 La 110 000.000 21 23 210 Attrave Lips tre 320 45.000 115.100 11.00 155.000 201 incorrer 501 110.000 5.000 Wersyte200 + Trial Balances Income Statement Statement of Retained earnings Taccounts + Read 75%