Using the information and Excel, provided for Jacks Maintenance Services to: 1. Record the journal entries for June transactions. Include narrations. 2. Record adjusting entries for the end of June. Include narrations. 3. Construct the "T" formatted ledger accounts. 4. Prepare the profit and loss statement for the year ended 30 June 2020. 5. Prepare the classified narrative formatted balance sheet as at 30 June 2020. You must use excel formula to construct the leger accounts, profit and loss statement, and balance sheet. Use excel to answer the assignment requirements. The excel sheets must be linked to each other. You CANNOT just enter the data into the financial statements. You MUST enter the data once and link the excel sheets to produce the financial reports. Cr Jacks Maintenance Services Unadjusted Trial Balance as at 31st May 2020 Account Dr Cash at bank 65,100 Accounts receivable 56,300 GST receivable 3,600 Prepaid rent 12,000 Prepaid insurance 9,000 Office supplies 6,660 Office equipment 121,500 Accumulated depreciation - Office equipment Accounts payable Unearned fees Loan payable - due 31 December 2020 GST payable Capital (H. Jacks) Drawings (H. Jacks) 21,600 Fees revenue Electricity expense 4,500 Fuel expense 8,600 Rent expense 22,000 Salaries expense 73,000 Telephone expense 6,100 Totals 409,960 53,700 29,300 17,600 22,000 3,860 115,000 168,500 409,960 June transactions: Amount Date 1/06/2020 2/06/2020 $22,000 $88,000 $1,045 5/06/2020 9/06/2020 $1,540 $13,800 12/06/2020 15/06/2020 22/06/2020 24/06/2020 26/06/2020 28/06/2020 29/06/2020 30/06/2020 30/06/2020 Transaction Cash receipts from customers for moneys owed Purchased a truck paying a 40% cash deposit and taking out a 3- year 7% loan to cover the balance. Purchased office supplies on credit, due 15 July 2020 Received a cash deposit upfront from a customer for maintenance work to be completed by the end of July 2020 Cash receipts from customers for moneys owed Paid all outstanding accounts payable from previous month Received electricity bill Paid June salaries up to this date Received and paid telephone bill for month of June Settled previous month GST with ATO Cash receipts from customers for moneys owed Record all June Sales made on credit Received bank interest $682 $5,260 $363 $11,400 $79,200 $423 . . Additional Information: All sales are credit sales (21 days). Unless stated all amounts are GST inclusive or GST exempt. A physical count of office supplies on 30th June shows $2940 of unused supplies on hand. Depreciation of the office equipment for the year is estimated to be $16,200. Depreciation of the truck will be determined using the straight line method. Jacks maintenance estimates the useful life of the truck to be 5 years, and the residual value to be $7,000. Prepaid Rent was paid on the 1st of May and covered a period of four months. This account was not adjusted at the end of May. 25% of prepaid insurance expired during June. A fuel bill for June of $1,100 has not been recorded or paid. Salaries expense accrued for the last week in June amounts to $2,150. Interest expense of $275 has accrued in June on the loans payable. Of the unearned fees recorded in May, 20% were refunded to a customer as Jack's Maintenance Services was unable to complete the work prior to 30 June as previously agreed. The remainder of the unearned fees were earned during June. O