Please complete in Excel

b. Post the entries to T-Accounts. i. Use a new TAB in EXCEL to create the T-Accounts. (Hint: the CASH will have the most postings) ii. Line up the T-Accounts in organized columns, under each of the following categories; (Assets, Liabilities, Equity, Revenues, Expenses) The trial balance of DeCore Design Service as of January 1, 2020 had the following normal balances: $ 12,000 2,500 350 1,200 2,100 500 1,000 Cash Accounts Receivable Supplies Prepaid Insurance Truck Accumulated Depreciation Accounts Payable Salaries Payable Interest Payable Unearned Revenue Note payable Common Stock Retained Earnings Dividends Design Revenue Fuel Expense Depreciation Expense Insurance Expense Interest Expense Rent Expense Salary Expense Supplies Expense 10,000 2.450 DeCore Design Service completed the following transactions during 2020. 1. Issued stock $5,000. 2. Paid the salaries payable from the prior year. 3. Paid $600 cash for supplies. 4. Collected $600 in advance for design service to be performed later. 5. Paid the amount due on account. 6. Prepaid insurance of $600 for a six month period. 7. Performed design services for a customer and received $2,800 cash. 8. Paid office rent for the period, $2,000. 9. Completed a large design job and billed the customer $6,500. 10. The company purchased a truck for $30,000 making a down payment of $6,000 and taking a loan on the remainder of $24,000 at a 6% annual interest rate. 11. Collected $1,500 cash from customer on account. 12. Purchased fuel for the truck, paying $400 on account. 13. Received $3,000 cash for performing design services. 14. Paid employees, $700. 15. Paid $200 in dividends to the stockholders. Adjustments: 16. Prepaid insurance used during the year was $100 per month. 17. Unearned services earned during the year $1,000. 18. Accrue interest on the note payable for one full year. 19. Accrue salaries for year end, $300. 20. Depreciation for the year was $3,000. 21. There was $500 supplies on hand at year end