Complete a spreadsheet, journalize transactions, and prepare an unadjusted trial balance.

The following ledger accounts appear below, in this order: Caeh, Accounts Rocoivable, Supplies, Prepald hasurance. Ofice Equipmert, Accumulated Depreciation - Oflice Equipmert: Accourts Paynble, Wages Payable, Unaarned Revenwe, Peyton Smith Capitt, Peyton Smith, Drawing and incame Summary - Beginning balances from the textbook have already been entered. - The remaining accounts are found on the next page. An asterisk (") will appear in the column to the right of an incorrect amount. LEDGERS - Balance Sheet accounts \begin{tabular}{|lllllll|} \hline Office Equipment & & & & 17 \\ \hline Date & Post & & & & Balance \\ \hline & & Def. & Dr. & & & \\ \hline \end{tabular} CONTINUING PROBLEM The following ledger accounts appear below, in this order Feos Earned, Waoss Experse, Ofice Rent Experse, Equipment Rert Expense, Unilites Experso, Mianic Expense, Aoverting Experse, Supples Experte, Insurance Expense. Depreclafon Experse, and Miscellanoon Exponse. - Beginning balances from the textbook have already been entered. - The remaining accounts are found on the next page: An asterisk (") will appear in the column to the right of an incorrect amount. LEDGERS - Income Statement accounts \begin{tabular}{|l|llllll|} \hline \multicolumn{1}{|l|}{ Insurance Expense } & & & & & & \\ \hline 13 & & Post & & & & Balance \\ \hline 14 & Date & Hef & Dr. & Cr. & Dr. & Cr. \\ \hline 15 & & & & & & \\ 116 & & & & & & \\ 117 & & & & & & \\ \hline \end{tabular} \begin{tabular}{l|lllll|} \hline 112 & Insurance Expense & & & \\ \hline 113 & & Post & Balance \\ \hline 114 & Date & Ref. & Dr. & Cr. & Dr. \\ 115 & & & & Cr. \\ 116 \\ 117 & & & & \\ 118 \\ 119 & & & & \\ 120 & & & & \\ 121 & & & & \\ 122 & & & & \\ \hline \end{tabular} Save a copy of the spreadsheet by clicking on the "5preadsheet" here. You will need this completed spreadsheet for the remaining parts of this Continuing Problem. Be sure to save she spreadsheet in a safe place for future use. Ps Masic's chart of zccounts and the balance of accounts as of July 1,20 Ys (all normal balances), are as follows: Continuing Problem Chapter 2 Instruction 2 The transactions completed by PS Music during hune 20y5. The following transactions were completed during July, the second month of the business's operations: Analyze and journalize each transaction in the two-column jouroal below. Tnelude Posting References, using the account numbers in your spreadstieet. If an amaunt box does not require an entry, leave is blank. July 1t Peyton Smikh made an additional investment in P5 Music in exchange for common stock by depositing $5,000 in ps Music's ehecking account. July 1 instesd of contimuing to share office space with a local real estate sgency, Peyton decided to rent office space near a local music store. Paid rent for 3 uly, 51,750 July 1t Paid s premivm of t2,700 for a comprehencwe insurance pobcy covering wability, theft, and fire. The polley covers a one-year period. July 2: Received $1,000 on sccount. accoedance aith the contract, Peyton received 37,200 frem kouk as an advance payment for the first two months. July 3i Paid $250 on account. July 4: Paid an attoener $900 for Feviewing the July 3 contract with kocMD. (Record as Miscelianeous Expense.) July 5: Purchares office eguibinent on eccount frem offece Mart, 37,500 July B: Pad for a nimsaper adrentsement, 1200 . July 8: Paid for a newspaper advertisement, $200. Juty 11 : Peceived $1,000 for serving as a disc jockey for a party. July 13: Paig 5700 to a local audio electronics store for rental of digital recording equigment. July 14t pad wapes of s1,200 to recepbognist and part-time awistant. July 14: Paid wages of $1,200 to receptionist and part.time assistant. July 16: Received \$2,000 for serving as a disc jockey for a wedding reception. July 18: Purchased supplies on account, 5850. Jufy 217 Fid 3620 to upload Music for use of tes current musk demos in making vaneus musie sets. July 21: Pald s620 to Uplosd Musk for use of its cument music demos in making various music sets, July 22t Pald $1000 to a local radio mation 1.0 advertse the servioes of PS Musle twice daly for the remalnder ef luly. July 23: Served as ese jockey for a party for 52,500 . Received $750, with the remainder due August 4, 20rs. July 27 f raid eiectic bir, 5015 : July 27: Paid electric bill, $915. July 28: Paid wages of $1,200 to receptionist and part-time assistant. July 29: Paid miscellaneous expenses, $540. July 30 : Served as a disc jockey for a charity ball for $1,500. Received $500, with the remainder due on August 9,20Y5. July 31: Received $3,000 for serving as a disc jockey for a party, July 31: Paid $1,400 royakies (music expense) to National Music Clearing for use of various artists' music during July. July 31: Paid $1,400 royaltles (music expense) to National Music Clearing for use of various artists' music during July. July 31: Paid dividends, ol $1,250. Chapter 2 - Instruction $3 Post the journal entries completed in Chapter 2 Part 2 to the fedgers in the spreadsheet you soved in Chapter 2 Part 1 . When entering the Posting References, use fournal page 1 for transactions from July 1-14, and use joumal page 2 for transactions from July 16-31, Extend the account balance to the appropriate balance column atter each posting. Be sure to save your work in the spreadsheet. Continuing Problem Chapter 2 - Instruction #4 Refer to your answers from Chapter 2, Part 3 to complete this part. Prepare an unadjusted trial balance as of July 31,20Y5. If an amount box does not require an entry, leave it blank. 2 more Check My Work uses remaining