use excel only do the 1 and 2 which is journal entries and trial balance

o boulties,THl Balnce, and Financial Statements LO3 5 6.7 or Inc. was organized on June 2 by a group of accountants to provide accounting and tax services to small businesses. The following transactions occurred during the first month of business: June 2: June 5: Purchased a computer system for $12,000. The agrement with the vendor requires June 8: Received contributions of $10,000 from each of the three owners of the business in exchange for shares of stock. a down payment of $2,500 with the balance due in 60 days Signed a two-year promissory note at the bank and received cash of $20,000. Billed $12,350 to clients for the first half of June. Clients are billed twice a month for services performed during the month, and the bills are payable within ten days. June 15: June 17: Paid a $900 bill from the local newspaper for advertising for the month of June June 23: Received the amounts billed to clients for services performed during the first half of the month. Received and paid gas, electric, and water bills. The total amount is $2,700. Received the landlord's bill for $2,200 for rent on the office space that Neveranerror leases. The bill is payable by the 10th of the following month. June 28: June 29: June 30: Paid salaries and wages for June. The total amount is $5,670. June 30: Billed $18,400 to clients for the second half of June. June 30: Declared and paid dividends in the amount of $6,000. Required 1. Prepare journal entries on the books of Neveranerror Inc. to record the transactions entered into during the month. Ignore depreciation expense and interest expense. 2. Prepare a trial balance at June 30