1 Gmail YouTube Maps: The best bridal sh... wtime clock My Best Buy Cre... el Project 2 Instructions.pdf 1 / 1 100% Excel Project 2 Downtown Cabinet Company Instructions: Client uses Accrual Method of Accounting. 1. Enter the trial balance into an Excel Spreadsheet. 2. Record adjustments through a General ledger. Create adjusting entry journals and T-Bar accounts. 3. Make an adjusting trial balance worksheet including the changes affecting the Balance Sheet and Income Statement. 4. Create a final Income Statement, Balance Sheet, and Statement of Retained Earnings for the month ended. 5. Extra Credit (5 points)- Create and Administration Page to organize all sheets of the Excel File. Administration page should link to sheet in Excel File. In addition, sheet should link back to Administration page. 6. Upload the Excel File on Blackboard Note: Adjusted amounts should be linked to their corresponding financial statement. The idea is to make all your changes and adjustments on the trial balance worksheet so that the financial statement will automatically change accordingly. Adjustments to the Trial Balance at 11/30/20XX 1. Estimated bad debts is one-half of 1 percent of sales 2. Insurance expired for the month of November-$480 3. Interest accrued on notes receivable for the month of November-$725 4. Downtown Cabinet Company purchased 10 computers for $15,000 on a no interest 5 year loan. Record this purchase and one loan payment was paid in the month of November. 5. The accounting department discovered an overpayment of rent in the amount of $1,000 6. Property taxes accrued for the month of November should be at $5,000 7. Income taxes are estimated to be 22% of net income.