answer in excel with formula thanks

REQUIRED: PREPARE UNADJUSTED TRIAL BALANCE. ADJUSTING ENTRIES, AND ADJUSTED TRIAL BALANCE McGuire Corporation began operations in 2024. The company purchases computer equipment from manufacturers and then sells to retail stores. During 2024, the bookkeeper used a check register to record all cash receipts and cash disbursements. No other journals were used. The following is a recap of the cash receipts and disbursements made during the year. Cash receipts: Issue of common stock $ 50,000 Collections from customers 320,000 Borrowed from local bank on April 1. note signed requiring principal and interest at 12% to be paid on March 40,000 31, 2025 Total cash receipts $410,000 Cash disbursements: Purchase of inventory $220,000 Payment of salaries 80.000 Purchase of office equipment 30.000 Payment of rent on building 14,000\f