All I need is a balance sheet for this data. The template we are using is below the problem. Let me know if i need to post any more information

John Marshal Company
Balance Sheet
as of 12/31/2019
Assets
Current Assets:
Non-current assets:
Total Assets
Liabilities and Equity
Current Liabilities:
Non-current liabilities
Total Liabilities
Stockholders' Equity
Total Liabilities and Stockholders' Equity

AutoSave CHO Accounting cyuka problemu Word A Hikal Benjamins van 10 File Home nsert Design Layout References Mailing Rover View Hop Share Comments Times New Rom-2 - AA AAA SS 2. I hind Replace X Cut come Paste Format Pite Cipboard AaBbce: ABCDE AaBbc Aabbcc AaB A:Bbcc 4oBbce AgebCO ABCD AaBBCCD AcebCO ABECED T Normal No Spac.. Heading 1 Heading 2 Suite Subtle Em. Emphasis Emphasis intense Intense O.. Quote Dictate Sensit Editor Tont Paragraph Eding Senty Editor ACCT 215(CT) Accounting Cycle Problem The Jom Marshall Company, Inc., which provides congresos lo mejor utility companies was formed on January 2 of this year. Transactions completed during the first year of operation Acre as follows: Sockholders liquity 301 Common stock 310 Retained earnings 320 Dividendo Revemos 401 Senice revenue Expenses: 501 Wage expense 502 Lrtility expensie sna Selling experte 50-1 Administrative expense SOS Rexpense 506 Insidance expense 502 Supplies expense 510 Depreciation expense 520 Interest expense Other 601 Thcome tu January 2 - Issaed 600.000 shares of stock for $10,000,000. Terwy 10 - Acquired equipment in exchange for $7.000000 ched a 56.000 no more payable The note is due in ten years. Felmuay! - Paid $24,000 for a buenas incurce policy cucing the two-year period beginning on February February 22 - Purchased $900.000 of supplies on account Mach 1 - Paid wages of $185.000 March 23 - Billed S2,730,000 for services condeced on account April 1 - Pad 100,000 of the amount due on the supplies purchased February 22. Amil 17 - Collected $210,000 of the most receivable May 1-Paid wages of $200.000 May-Received and paid bill for $99,200 for utilities May 24 - Pasd 342,500 for sales commissions June 1 - Made the first payment on the norteamed Jams 10 The payment consisted of $20.000 interested 5200 ng applied against the principal of the nate June 16 Billed customers for $560,000 of zacvices rendered. June 30 - Collected $100,000 ou accounts receivable. July 10 - Purchase $155,000 of supplies on account August 25 - Paid $100.000 for administrative expenses September 23 - Paid $30,000 for warehouse repairs October 1-Pad general wages of $90,000. November 20-Turchased suplice for 560,000 cash. December 15 - Colleted $125.600 in advance for services to be provided in December and Janusny December 30 - Declared and paid a $50.000 dividend to shareholders. REQUIRED. Uusing the information provided above, complete the followmg steps m an Excel workbook (Template provided): 1. Journalize the transactions for the year. 2. Post the journal entries to a T account. 3. Pregunean utsalgusled trial bal as December 31 4. Journalize and post adjusting entries to the accounts based on the following additional information a. Eleven months of the insurance policy expired by the end of the year 6. Depreciation for equipment is $400,000. c. The company provided $70,000 of services related to the advance collection of December 15, d There are $500,000 of supplies on hand the end of the year. 4. An additional $170,000 of interest has acceved on the note by the end of the year. f. Wilson accrued wages of $200,000 at the end of the car. 5. Prepare an add tris halcex of December 11 6. Prepare a single step income statement and statement of retained earnings for the year ended December 31 and a classified balance she is of December 31 7. Journal and post the closing entre 5. Prepare a post-closing trial balance as of December 31. Submit your completed Excel workbook in Black Board under assignments by the due date. The chart of accounts that Mansell Company, Inc. uses is as follows: 101 Cach 102 Accounts receivable 103 Supplies 104 Prepaid insurance 110 Equipment 112 Accumulated depreciation Listilities 201 Accounts payable 202 Uneanted service reverse 203 Wages payable 210 Interest payable 220 Neten ayahle new 731 wants I tru