Could you please help fill this out? Especially the T accounts and Adjusted Trial Balance. Thank you

17Dec Paid the employees the amount due to them from the November 30 payroll, taxes will be paid in January. 1Dec The company borrowed $60000 from Bank of America by signing a 10year, 4% note. The note requires annual payments of $7397 beginning December 1, 2024. 1Dec Purchased a new delivery truck to save customers on shipping. The total cost of the Delivery Truck was $70000. 47Dec Paid the amount due from the November 15 purchase. 5Dec Declared and paid $4000 in cash dividends to the stockholders of the company. 6Dec Purchased $1700 of supplies on account, term n/30. 7Dec Purchased 20 ice cream machines at a cost of $1210 each on account, terms n/30, FOB Destination. 157Dec Sold 22 ice cream machines for $3300 each on account, terms 2/10, nf30, the company uses FIFO to find the cost of goods sold. Record the sales revenue first. 18Dec Paid for an ad in the local newspaper, $1700. 24Dec Received $33000 payment for 10 ice cream machines to be shipped on January 8, 2024. 314366 Prepared payroll for the month of December, the first payroll for the company. Record the Salaries Expense entry first. The tax rates are as follows: Federal Income Tax Rate 15%. NC State Income Tax Rate 10%. FICA Tax Rate 7.65%. Unemployment Tax Rate 6% on the first $7000 of each employees earnings per year. Company Information 8: Summary of Significant Account Policies Cups 3: Cones Company began operations on November 1, 2023. The main operating goal ofthe company is to sell high end ice cream machines. Customers may pay using cash or ifappropriate, a credit is extended to customers with terms 3/15, n/30. The company uses the perpetual inventory method and a FIFO cost system. The company follows a calendar year, with all adjusting entries made at the end ofthe accounting period, December 31. The company uses the straight-line depreciation for all depreciable assets. The company has decided to use the Allowance method to account for uncollectible accounts. At the end ofthe period, based on industry standards, the company believes 1% ofthe balance in accounts recievable will be uncollectible. The company purchases ice cream machines for resale only as such they carry them as inventory. The company has two employees, one is a sales technician, salary of $4000 per month and the other employee is the office manager with a salary of $6000 per month. Payroll is processed on the last day ofthe month, and paid on the first day ofthe following month. This means the November 30 payroll with accrue into Salaries Payable and then be paid on Decemember 1. General Ledger (T-Account) Cash Accounts Receivable Allowance for Uncollectible Inventory Accounts Supplies Prepaid Rent Prepaid Insurance Accumulated Depreciation - Accumulated Depreciation - Computer Equipment Computer Delivery Truck Delivery Truck Egg; \fUnemployment Tax Payable Common Stock Retained Earnings Cash Dividends Egg; Sales Revenue Service Revenue Sales Discounts Cost of Goods Sold Advertising Expense Utilities Expense Salaries Expense Depreciation Expense Egg; Rent Expense Interest Expense Supplies Expense Bad Debt Expense Egg; Payroll Tax Expense Insurance Expense NOTE: Three accounts have check figures. After posting the Daily Transactions, your Cash, Accounts Receivable, and Cost of Goods Sold ' balance will show GREEN if it is correct. Adjusted Trial Balance December 31, 2022 Account Name Debit Credit Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Supplies Prepaid Rent Prepaid Insurance Computer Equipment Accumulated Depreciation Computer Delivery Truck Accumulated Depreciation Delivery Truck Accounts Payable Interest Payable Deferred Revenue Salaries Payable Notes Payable Federal Income Tax Payable NC State Income Tax Payable FICA Tax Payable Unemployment Tax Payable Common Stock Retained Earnings Dividends Sales Revenue Service Revenue Sales Discounts Cost of Goods Sold Advertising Expense Utilities Expense Salaries Expense Depreciation Expense Rent Expense Interest Expense Supplies Expense Bad Debt Expense Pavroll Tax Expense Insurance Expense Totals Required: 1) Cups 8: Cones Company engaged in the following transactions for November and December. Record the following transactions on the Daily Transactions tab. Note: Place debits first, credits second but do NOT indent credits. If more than one debit or credit, please list in alphabetical order to receive full credit. 1|'\\ov The owner invested $150000 into the company in exchange for 5,000 shares of common stock. 17M\"! The company purchased a computer system for $15000 and signed a oneyear note for the entire balance. The note is due on November 1, 2024 and has an annual rate of interest of 3%. Zrhov Paid for two years rent on the office space, $24000. 3hov Purchased 8 ice cream machines at a total cost of $1000 each for cash, FOB Destination. 4hov Purchased $1700 of supplies on account, term n/30. 15-h0V Purchased 15 ice cream machines at a total cost of $1100 each on account, terms n/30, FOB Destination. Shipping of $150 was paid to the shipping company by the appropriate party. 17|\\ov Paid for the supplies purchased on November 4. 18l'\\0v Paid for a twoyear insurance policy for the store, $12000. The policy was effective beginning December 1, 2023. 20-h0V Sold 15 ice cream machines for $3000 each on account, terms 3/15, n/30, the company uses FIFO to find the cost of goods sold. The printers were shipped FOB Shipping Point. Record the sales revenue first. 287|\\ov Received payment in full on account from the November 20 sale. 297lxov Paid for November's utilities bill $1700. Prepared payroll for the month of November, the first payroll for the company. Record the Salares Expense entry first. The tax 307|\\ov rates are as follows: Federal Income Tax Rate 15%. NC State Income Tax Rate 10%. FICA Tax Rate 7.65%. Unemployment Tax Rate 6% on the first $7000 of each employees earnings per year. For each ratio, in the answer cell, use FORMULAS to calculate the ratio, do not type in the answer. Ratio Formula Answer Current Ratio Current Assets/Current Liabilities Debt to Equity Total Liabilities/Stockholders Equity Gross profit ratio GP/Net Sales Profit margin Net income/Net sales Return on Assets Net income/Average total assets I _lUse A Formula Use A Formula Use A Formula Use A Formula Use A Formula 2) Post all the Daily Transactions to the Ledger on the Ledger tab. 3} As of December 31, a search revealed the following information. Record any necessary adjusting entries for the year on the Adjusting Entries tab. H The computer equipment purchased on November 1 has a 5year life and an expected residual {salvage} value of $1500. Record any interest that has accrued on the note signed on November 1 for the computer system. The rent paid on November 2 is for two years beginning on November 1. The insurance policy purchased on November 18 is effective beginning December 1. Supplies on hand as of December 31 totaled $510. The delivery truck purchased on December 1 has a 10year life and an expected residual {salvage} value of $7000. Accrue the interest, if needed, on the note signed on December 1. Record any bad debt expense for the year ended December 31. If needed, round to the nearest dollar. leMGELn-bU-IN Utilites accrued but not yet paid as of December 31 totaled $1500. 4} Post all the Adjusting Entires to the Ledger on the Ledger tab. 5) Based on the account balances in the ledger, create an adjusted trial balance on the Adjusted Trial Balance tab. 6) Based on the adjusted trial balance, prepare a multi-step income statement on the Income Statement tab. 7} Based on the adjusted trial balance, prepare the statement of stockholders' equity on the Equity Statement tab. 8) Based on the adjusted trial balance, prepare the balance sheet on the Balance Sheet tab. 9} Prepare the closing entries {DO NOT POST them to the ledger, just produce the entries}. When journaling, close the accounts in the order they appear on the Trial Balance. Do one entry for revenue accounts, one for expense accounts and one for dividend accounts. 10) Calculate the ratios on the Ratios tab.