please solve the questions in MS EXCEL sheet, with the required tables!!

dont use papers or handwriting please.

Case Study (to be submitted in an excel sheet. Attached] Accenture PLC is a multinational professional services company that specialises in information technology services and consulting. Following are the transactions for the year 2014 2014 Details of Transactions Jan- Accenture Co acquired S385.000 from the issue of common stock. 01 Feb-021 Collected S60,000 as an advance for technical services yet to be provided over one year starting May 1. Feb-25 Provided $26,460 of Technical Assistance Services on account. Mar- 31 Paid S120,000 cash for the extension of the Office Building. Apr- Purchased $24,000 cash for a one-year insurance policy with coverage initiating 11 15 of July, Jun-10 Collected $18,400 from accounts receivable. Jul-25 Purchased $3,000 of Stationary for office use on the account. Aug. Paid $32,000 Cash for Wages to employees. 15 Nov- Paid a dividend of 3% of Total Equity. Dec-01 Paid $3,000 to settle accounts payable related to stationery Dec-2053,500 is recognized as Utility Bill expenses on account. 10 Adjustments As of 31" December 2014, 1 Stationery of value $1,000 was found left in store that could be used next year. 2 Earned $40,000 of the $60,000 of revenue deferred on Feb 2. 3 Recognized S1,200 Rent revenue which is not received until 31" December 2014. 4 58000 was found accrued of Wages. 5 Had used half of the S24,000 of insurance coverage that it had paid for on 15th April. Accenture PLC had the following Balances at the beginning of 14 January 2014 a. Cash: $15,000. b. Common Stock S15,000 c. There was no Retained Earnings opening balance. 6 Required: Prepare (In the attached excel sheet] a) Journal b) T Account (Ledger Account) c) Trial Balance d) Statement of Changes in Equity e) Balance Sheet