T'Challa Panther owns Wakanda Enterprise. A trial balance for T'Challa Panther for his yearly fiscal period and additional information follow directly. Additional information1. Office supplies on hand on October 31 are valued at $13, 100.2. Prepaid Insurance balance of $24 000 was the original cost of the insurance on Jan 1, 2021.3. Late invoices pertaining the October 31 fiscal period were:General Expense? - $730.00Repair Expense - $2 235.00Total??$ 2 965.004. The Office equipment cost $45,000 and was expected to last for 7 years. It was estimated that it would be worth $1, 500 at the end of that time.5. The Store Equipment cost $65 0000 and was expected to last for 9 years. It was estimated that it would be worth $5, 500 at the end of that time.(All values should be rounded to two decimal places.)Complete the template below and create a journal statement. This should be done on excel.Thank you!

Using the additional information above: a) Complete the eight-column work sheet. b) Journalize adjusting and closing entries Income Balance Accounts Trial Balance Adjustment Statement Sheet Cash 30,350.00 Accounts Receivable 4,000.00 Office Supplies 17,640.00 Prepaid Insurance 24,000.00 Office Equipment 45,000.00 Accumulated Depreciation-Office 22,500.00 Equipment Store Equipment 65,000.00 Accumulated Depreciation-Store Equipment 26,000.00 Account Payable 37,500.00 T'Challa Panther, Capital 82,090.00 T'Challa Panther, Drawings 21,100.00 Fees Earned 251,000.00 Rent Expense 10,000.00 General Expense 500.00 Repair Expense 1500.00 Salaries Expense 200.000,00 419,090.00 419,090.00