Rat1-Regular Trensactions The followint transaction occurred for Zeta-2 Video Game Supplies during the perlod ended 12/31/x1. They provide services to customers and sell products. March 1 The company was formed with 3,500,000 shares authorized - no par value. March 20 The company issued 250,000 shares of (no-par value) stock at $1.50 a share stock. April 7 Created a unique came chalr - applied for a patent - legal costs were $3,000. April 28 Found a close out deal and purchased two years of office supplles for $5,200 on account. Mar 1 Purchase a cash reglster, counter, and some shelving for the store with a Note Papable of $90,000 due in 5 vears. The company used the straicht-line method for depredation. The note requires annual princlpal payment of $18,000 and has an interest rate of 3% May 10 Purchased video eame for Inventory for $105,000 on account. The company uses the FIFO method under a perpetual system to account for inventory May 31 Purchase two parcels of land for $95,000 - Parcel A was $30,000 and Parcel B was \$15,000. Parcel A was used to bulld a stornge faclilty. Parcel B is next door to the store. The intention is to have extra land to bulld a parking lot one day, but the owner does not have any immedlate plans to start bulldine. June 1 Purchased two years of Insurance for $18,000. June 25 Sold some video e ames to a customer for $15,000. Inventory had a cost of $7,600. The customer pald $9,000 cash and the rest on account. July 7 Sold vintage video eame systems to a customer for $5,000 to a customer for cash. Imentory had a cost of $36,400. July 26 Pald emplovee wazes of $9,200. Auzust9 Acustomer cave the store a deposit of $12,000 for to have several retro video cames systems repalred. It was uncertain if all the needed parts could be located 30no promises were made but the store sald they would try and took the mone\%. August 17 Customer purchased $18,000 of video games on account. Inventory had a cost of $9,700. Sept 10 Invested $23,000 of excess cash in securities - Intend to hold them for several years. Sept 21 Collected $12,000 from a customer that owed you money for goods previously purchased. Sept 29 Sold one of the shelving units purchased on Moy 1 st. The shelf cost $5,200 and was sold for $3,200. Oat 1 Landlord offered a big discount so pald one year of store rent for $14,400. Rate-Instruction You will prepare the following in excel: 1. General Journel a. Journal entries - full proper journal enty with descriptions b. Post entries to ledzer 2. Ledger - Taccounts 2. Show beginning bolance b. Post all acthity - make sure to include reference to journal entrx c. Show endins balences 3. Trial Balance a. Unadjusted Trial Balance MOTE-only record the transaction that have occurred - DO NOT DO any adjusting entries. The description will include extra information that you will need to do Adj usting entries