please answer a, b, c and d!!!!!!!

please answer!!

Maddie Chxz manages True Grit Enterprises. As of July 1, 2022 True Grit has account balances of 19,800 4,200 2,450 750 6,000 5,000 7,800 Cash A/R Supplies A/P N/P Stock 51 par Retained Earnings July 1: True Grit purchases Equipment for SXXXX (use the last 4 digits of your student ID) and pays cash. July 2: True Grit provides services for business customers and bills them for $XXXXX(Use the last 5 digits of your student ID). July 6: Mattie receives a bill for $615 from Appalachian Power. July 7: True Grit Enterprises is sued by an irate customer and pays a legal firm $1000 as a retainer (a down payment for future services). July 8: The bookkeeper pays $750 of the Accounts Payable July 11: True Grit Enterprises receives $10,000 from accounts receivable. July 11: The bookkeeper opens the mail and records receipt of the phone bill for $350. July 12: The bookkeeper pays the electric bill. July 16: The Board of Directors meets and decides to pay a dividend of $0.XX (last two digits of your student ID) per share. July 30: The lawyer sends a statement showing $900 worth of legal charges. July 31: The dividend checks are mailed. July 31: Maddie counts the supplies and realizes there are only $250 of supplies on hand. July 31: The bookkeeper takes one month's depreciation on the equipment. It has a salvage value of $300 and a life of 3 years Required: a. Using Excel, enter all transactions in the General Journal using proper journal entries. b. Create a chart of accounts. c. Use formulas to post the journal entries to the General Ledger d. Using named cells, prepare all four financial statements: Income, Statement of Retained Earnings, Balance Sheet and Statement of Cash Flows so that if I change a number in the journal, the financial statements change as well. last 5 digits : 86547 last 4 digits : 6547