PLEASE DO THIS ON EXCEL AND SHOW HOW TO USE APPROPRIATE FORMULA AND CELL REFERENCING.

Required Information C4-2 From Recording Transactions (Including Adjusting Journal Entries) to Preparing Financial Statements and Closing Journal Entries (Chapters 2, 3, and 4) [LO 2-3, LO 3-3, LO 4-1, LO 4-2, LO 4-3, LO 4.4, LO 4-5, LO 4-6] [The following information applies to the questions displayed below.) Brothers Harry and Herman Hausyerday began operations of their machine shop (H & H Tool, Inc.) on January 1, 2016. The annual reporting period ends December 31. The trial balance on January 1, 2018, follows the amounts are rounded to thousands of dollars to simplify): Debit Credit $ 4 4 11 a 53 20 6 Account Titles Cash Accounts Receivable Supplies Land Equipment Accumulated Depreciation Software Accumulated Amortization Accounts Payable Notes Payable short-term) Salaries and Wages Payable Interest Payable Income Tax Payable Common Stock Retained Earnings Service Revenue Salaries and Wages Expense Depreciation Expense Amortization Expense Income Tax Expense Interest Expense Supplies Expense Totals e e 65 7 a a $92 $92 Transactions and events during 2018 (summarized in thousands of dollars) follow: a. Borrowed $13 cash on March 1 using a short-term note. b. Purchased land on March 2 for future building site; paid cash, $7. C. Issued additional shares of common stock on April 3 for $31. d. Purchased software on July 4, $12 cash. e Purchased supplies on account on October 5 for future use, $17. f. Pald accounts payable on November 6, S14. 9. Signed a $30 service contract on November 7 to start February 1, 2019. h. Recorded revenues of $146 on December 8, including $33 on credit and $113 collected in cash. 1. Recognized salaries and wages expense on December 9, $78 pald in cash. J. Collected accounts receivable on December 10, $17. Data for adjusting Journal entries as of December 31 k. Unrecorded amortization for the year on software, $7. 1. Supplies counted on December 31, 2018. $11. m. Depreciation for the year on the equipment, $7. n. Interest of $2 to accrue on notes payable. o. Salaries and wages earned but not yet paid or recorded, $13. p. Income tax for the year was $9. It will be paid in 2019. Instructions: Copy the Beginning TB from page 2. Label this Trial Balance (TB) at 12.31.17. Prepare the T Accounts with the balances in the above Beginning Trial Balance Analyze Transactions (A-J) for effect on the Accounting Equation Prepare the JEs in A-J (See pic below) Post the JEs to the T-Accounts (Sum your T-Accounts, see pic) Prepare the Unadjusted Trial Balance Prepare the Adjusting Journal Entries (AJES) (transactions K-P, record in GJ) Post the AJEs to the T-Accounts (Sum your T-Accounts, see pic) Prepare the Adjusted Trial Balance (Check that DR & CRs still balance) Preparing Financial Statements Prepare the Closing Journal Entries (Record in GJ)(Roll R/E/NID to RE) Post CJEs to the T-Accounts (CJEs will have an entry to RE) Prepare a Post-Closing Trial Balance