Ps music balance sheet

I’m trying to study for my Accounting course and I need some help to understand this question.

Answer all the Questions on Excel as asked on the document attached. Accounting PrinciplesACC 101 Midterm - Fall 2019 1. Peyton Smith enjoys listening to all types of music and owns countless CDs. Over the years, Peyton has gained a local reputation for knowledge of music from classical to rap and the ability to put together sets of recordings that appeal to all ages. During the last several months, Peyton served as a guest disc jockey on a local radio station. In addition, Peyton has entertained at several friends' parties as the host deejay. On June 1, 2019, Peyton established a proprietorship known as PS Music. Using an extensive collection of music MP3 files, Peyton will serve as a disc jockey on a fee basis for weddings, college parties, and other events. During June, Peyton entered into the following transactions: June 1. Deposited $4,000 in a checking account in the name of PS Music. 2. Received $3,500 from a local radio station for serving as the guest disc jockey for June. 2. Agreed to share office space with a local real estate agency, Pinnacle Realty. PS Music will pay one-fourth of the rent. In addition, PS Music agreed to pay a portion of the wages of the receptionist and to pay one-fourth of the utilities. Paid $800 for the rent of the office. 4. Purchased supplies from City Office Supply Co. for $350. Agreed to pay $100 within 10 days and the remainder by July 5, 2019. 6. Paid $500 to a local radio station to advertise the services of PS Music twice daily for two weeks. 8. Paid $675 to a local electronics store for renting digital recording equipment. 12. Paid $350 (music expense) to Cool Music for the use of its current music demos to make various music sets. 13. Paid City Office Supply Co. $100 on account. 16. Received $300 from a dentist for providing two music sets for the dentist to play for her patients. 22. Served as disc jockey for a wedding party. The father of the bride agreed to pay $1,000 in July. 25. Received $500 for serving as the disc jockey for a cancer charity ball hosted by the local hospital. 29. Paid $240 (music expense) to Galaxy Music for the use of its library of music demos. 30. Received $900 for serving as PS disc jockey for a local club's monthly dance. 30. Paid Pinnacle Realty $400 for PS Music's share of the receptionist's wages for June. 30. Paid Pinnacle Realty $300 for PS Music's share of the utilities for June. 30. Determined that the cost of supplies on hand is $170. Therefore, the cost of supplies used during the month was $180. Page 1 of 19 ACC 101 Midterm - Fall 2019 30. Paid for miscellaneous expenses, $415. 30. Paid $1,000 royalties (music expense) to National Music Clearing for use of various artists' music during the month. 30. Withdrew $500 of cash from PS Music for personal use. Instructions 1. Indicate the effect of each transaction and the balances after each transaction, using the following tabular headings: 2. Prepare an income statement for PS Music for the month ended June 30, 2019. (Hint – Net Income is $1,340.) 3. Prepare a statement of owner's equity for PS Music for the month ended June 30, 2019. 4. Prepare a balance sheet for PS Music as of June 30, 2019. Page 2 of 19 ACC 101 Midterm - Fall 2019 2. The following transactions for PS Music were completed during July, the second month of the business's operations: July 1. Peyton Smith made an additional investment in PS Music by depositing $5,000 in PS Music's checking account. 1. Instead of continuing to share office space with a local real estate agency, Peyton decided to rent office space near a local music store. Paid rent for July, $1,750. 1. Paid a premium of $2,700 for a comprehensive insurance policy covering liability, theft, and fire. The policy covers a one-year period. 2. Received $1,000 cash from customers on account. 3. On behalf of PS Music, Peyton signed a contract with a local radio station, KXMD, to provide guest spots for the next three months. The contract requires PS Music to provide a guest disc jockey for 80 hours per month for a monthly fee of $3,600. Any additional hours beyond 80 will be billed to KXMD at $40 per hour. In accordance with the contract, Peyton received $7,200 from KXMD as an advance payment for the first two months. 3. Paid $250 to creditors on account. 4. Paid an attorney $900 for reviewing the July 3 contract with KXMD. (Record as Miscellaneous Expense.) 5. Purchased office equipment on account from Office Mart, $7,500. 8. Paid for a newspaper advertisement, $200. 11. Received $1,000 for serving as a disc jockey for a party. 13. Paid $700 to a local audio electronics store for rental of digital recording equipment. 14. Paid wages of $1,200 to receptionist and part-time assistant. 16. Received $2,000 for serving as a disc jockey for a wedding reception. 18. Purchased supplies on account, $850. 21. Paid $620 to Upload Music for use of its current music demos in making various music sets. 22. Paid $800 to a local radio station to advertise the services of PS Music twice daily for the remainder of July. 23. Served as disc jockey for a party for $2,500.