Please send your answer excel format and explain how can you did t-account. Thank you

Bradford Auto Repair had the following account balances after adjustments. Assume all accounts had normal balances. B Click the icon to view the account balances.) 14. Prepare the closing entries for Bradford at December 31. 15. What is the balance of Bradford, Capital after closing entries have been recorded? (Use a T-account to determine the balance.) - X Data table Cash $ 4,540 S Bradford, Capital Bradford, Withdrawals 37,140 2,300 Accounts Receivable 3,000 2,200 1,100 3,600 100 Service Revenue Depreciation Expense-Equipment Salaries Expense Rent Expense 35,200 Prepaid Rent Office Supplies Equipment Accumulated Depreciation Equipment Accounts Payable Notes Payable (long-term) 300 1,000 900 5.800 400 Utilities Expense Supplies Expense 8.000 500 Print Done