Comprehensive Problem The Accounting Cycle using journals and T-accounts The trial balance of DeCore Design Service as of Jamuary 1, 2018 had the following normal balances $ 12000 Supplies Prepaid Insurance Accumulated Dep Accounts Payable Salaries Payable Interest Payable Urned Revenue Note paysbe a 10,000 2.450 tained arnines Design rvenue Fuel Expene Depreciation Expenee Ren Expense Salary Expense Supplies Exp DeCore Design Service completed the following transactions during 2038 Issued stock $5.0co . Pais the salaries payoble from the prior war . Paid $600 cach for supples 4, Collected $60 in advance for desgn service to be performed later. 5. Paid the amount due on account 6, prepaid insurance of S600 for a six month period 7. Performed design services for a customer and receted $2,800 cash. Paid office rent for the period, $2,000 . Completed a large design job and billed the customer $6,500 10. The company purchased a truck far $30,000 making a down payment of $6.000 and taking a loan on the remainder of $24,000 sts 5% annual interest rate. 11. Collected $1,500 cash from customer on accoum 12. Purchased fuel for the truck, paying 5400 on account 13. Receved $3,000 cash for pe-forming desgn services 14. Paid employees, 5700 15. Paid $200 in diwidends to the stockhoiders. Adus tments. 16. Prepaid insurance used during the year was 5100 per month 17, Unearned services earned during the year $1.000 18. Accrue interest on the note payable far one full year 19. Accrue salaries for year end, $300. 20. Depreciation for the year was $3,000 21. There was $500 supplias on hand at year end Requred: Record the above transactions (#145) and the adjustments (F16-21) inthe general Oral (You are to create a general jounal pege in Excel and number each transaction you recerd ie 1,2,3 etc) a. b. Pest the entries to T Accounts Use anea 1AB n EXCEL to create the T-Accou i Line up the T-Accounts in organized columns, under each of the folowing catepories ts. (Hint: the CASH wil have the most postings! lAssets, Liabilties, Equity, Revenues, Expenses) ii. After posting, subtotal each T-Account to show the balance in the account. c. Prepare a Trial balance. Please use a separate tab in Excel for this step d Prepare the financial statements for 2015 and include complete and proper headines on each lIncome Statement, Statement of Changes in Stockholders Equity, Balance Sheet and the Statement of Cash Flows)