Can you help with the Complete cycle (Comprehensive)? See instructions below:

Please, use table excel and no notebook. Thank You.

Financial statements Instructions: Complete cycle (Comprehensive) You must present the answer to the task in full. $3,090 9,900 $100 17,750 1,400 9,000 42,000 Cash Account Receivable Allowance for Doubtful Account Inventory Supplies Land Building and Equipment Accumulated Depreciation Accounts Payable Common Stock (2,000 shares) Retained Earnings (1/1/2016) Dividend Sales Revenue Cost of Goods Sold Salaries Expense Advertising Expense Other Expense 4,200 10.700 20,000 42.400 2,000 69,700 36,860 12,500 8,100 4,500 $147,100 $147,100 Dec. 4 7 14 18 20 21 Transaction Made cash sales of $4,500; the cost of the inventory sold was $1,800. Purchased $2,500 of inventory on credit. Collected $1,400 of accounts receivable. Sold land for $7,100; the land originally cost $6,000. Made credit sales of $5,500; the cost of the inventory sold was $2,700. Returned $400 of defective inventory to supplier for credit to the Davis Company's account 27 28 31 Purchased $1,600 of inventory for cash. Paid $1,300 of accounts payable. Purchased land at a cost of $7,500; made a $1.500 down payment and signed a 12%. 2-year note for the balance. Made cash sales of $3,100; the cost of the inventory sold was $500. 31 Required: 1. Prepare general journal entries to record the preceding transactions. 2. Post to general ledger T-accounts. 3. Prepare a year-end trial balance on a worksheet and complete the worksheet using the following information: (a) accrued salaries at year-end total $1,000. (b) for simplicity, the building and equipment are being depreciated using the straight- line method over an estimated life of 20 years with no residual value. C) supplies on hand at the end of the year total $600. (d) bad debts expense for the year totals $610; and (e) the income tax rate is 30%; income taxes are payable in the first quarter of 2017. 4. Prepare the company's financial statements for 2016. 5. Prepare the 2016 (a) adjusting and (b) closing entries in the general journal