For this problem, I have to update the spreadsheet I have below with the new amounts included in the top two sections of this post.

Continuing Problem Chapter 3 - Instruction #2

Post the adjusting entries completed in Chapter 3 Part 1 to the ledgers in the spreadsheet you saved in Chapter 2 Part 3. Extend the account balance to the appropriate balance column after each posting. Be sure to save your work in the spreadsheet.

Continuing Problem Chapter 3 - Instruction #1 The unadjusted trial balance for PS Music as of July 31, 2019 is as follows: PS Music Unadjusted Trial Balance July 31, 2019 Account No. Debit Balances Credit Balances Cash 119 ,945 2,750 Accounts Receivable Supplies 1,020 Prepaid Insurance 2,700 Office Equipment 7,500 8,350 7,200 9,000 1,750 Accounts Payable Unearned Revenue Peyton Smith, Capital Peyton Smith, Drawing Fees Earned Wages Expense Office Rent Expense Equipment Rent Expense 16,200 2,800 2,550 1,375 Utilities Expense 1,215 Music Expense 3,610 Advertising Expense 1,500 180 Supplies Expense Miscellaneous Expense 59 1,855 40,750 40,750 Based on those balances and the additional data below, prepare adjusting journal entries. Include Posting References, using the account numbers in your spreadsheet. You will need the following additional accounts: Account # Account Name Accumulated Depreciation Office Equipment Wages Payable Insurance Expense Depreciation Expense The data needed to determine adjustments for the two-month period ending July 31, 2019, are as follows: July 31: During July, PS Music provided guest disc jockeys for KXMD for a total of 115 hours. The contract requires PS Music to provide a guest disc jockey for 80 hours per month for a monthly fee of $3,600, which PS Music has already received payment for. Any additional hours beyond 80 will be billed to KXMD at $40 per hour. Credit Account Accounts Receivable V Fees Earned Post. Ref. 12 41 Debit ,400 1 1,400 July 31: Supplies on hand at July 31, $275. Credit Account Supplies Expense v Supplies Post. Ref. 56 14 Debit 745 745 July 31: The balance of the prepaid insurance account relates to the following July 1, 2019 transaction: "Paid a premium of $2,700 for a comprehensive insurance policy covering liability, theft, and fire. The policy covers a one-year period." Credit Account Insurance Expense V Prepaid Insurance Post. Ref. 57 15 Debit 225 225 July 31: Depreciation of the office equipment is $50. Account Credit Depreciation Expense Post. Ref. Debit 5850 18 Accumulated Depreciation Office Equipment 50 July 31: The balance of the unearned revenue account relates to the contract between PS Music and KXMD, described in the July 3, 2019 transaction, which included the following: "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." In accordance with the contract, Peyton received $7,200 from KXMD as an advance payment for the first two months. Credit Account Unearned Revenue Fees Earned Post. Ref. 23 41 Debit ,600 3 3,600 July 31: Accrued wages as of July 31, 2019, were $140. Debit Credit Account Wages Expense v Wages Payable Post. Ref. 50 22 140 140 Continuing Problem Chapter 3 - Instruction #2 Post the adjusting entries completed in Chapter 3 Part 1 to the ledgers in the spreadsheet you saved in Chapter 2 Part 3. Extend the account balance to the appropriate balance column after each posting. Be sure to save your work in the spreadsheet. CONTINUING PROBLEM - The following ledger accounts appear below, in this order: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Office Equipment, Accumulated Depreciation - Office Equipment, Accounts Payable, Wages Payable, Unearned Revenue, Peyton Smith, Capital, Peyton Smith, Drawing, and Income 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 Cash Post Balance Date - Item Ref. Dr. cr. Dr. 5,000 1,750 2,700 3,920 8,920 7,170 4,470 5,470 12,670 1,000 7,200 12,420 200 1,000 700 2019 7/1 Balance 7/1 Peyton Smith, Capital 7/1 Office Rent Expense 7/1 Prepaid Insurance 7/2 Accounts Receivable 7/3 Unearned Revenue 7/3 Accounts Payable 7/4 Miscellaneous Exense 7/8 Advertising Expense 7/11 Fees Earned 7/13 Equipment Rent Expense 7/14 Wages Expense 7/16 Fees Earned 7/21 Music Expense 7/22 Advertising Expense 7/23 Fees Earned 7/25 Utilities Expense 7/28 Wages Expense 7/29 Miscellaneous Exense 7/30 Fees Earned 7/31 Fees Earned 7/31 Music Expense 7/31 Peyton Smith, Drawing 200 2,000 620 800 NNNNNNNNNNN+++ 11,520 11,320 12,320 11,620 10,420 12,420 11,800 11,000 11,750 10,835 9,635 9,095 9,595 12,595 11,195 9,945 750 915 ,200 540 500 3,000 1,400 1.250 Accounts Receivable Post Balance Date Item Rose Dr. Dr. Cr. Dr. Dr. 1,000 1,000 7/1 Balance 7/2 Cash 7/23 Fees Earned 7/30 Fees Earned 1,750 1,000 1,750 2,750 Supplies Post Date Item Rest Dr. Cr. Dr. Sarance 7/1 Balance 7/18 Supplies N2 850 170 1,020 Prepaid Insurance Post Balance Date Item Ref. Dr. Cr. Dr. Palanca Cr. 7/1 Cash 2,700 Office Equipment Post Balance Date Item Ref. Dr. Cr. Dr. Palanca cr 7/5 Cash 7,500 7,500 Accumulated Depreciation - Office Equipment Post Date Item Ref. Dr. Cr. Balance Cr. Dr. Accounts Payable Balance Post Ref. Date Item Dr. Cr. Dr. Cr. 250 250 7/1 Balance 7/3 Cash 7/5 Office Equpment 7/18 Supplies 7,500 850 7,500 8,350 | Wages Payable | Date Item Post Ref. Dr. Cr. Dr. Cr. Unearned Revenue 23 Post | Date Item Ref. Dr. CI. Dr. Balance Co. 7/3 Cash 7,200 7,200 Peyton Smith, Capital Date Item Post Ref. Dr. Cr. Dr. 7/1 Balance 7/1 Cash 5,000 4,000 9,000 Peyton Smith, Drawing Post Ref. Item Date Dr. Balance Dr. Cr. Cr. 7/1 Balance 7/31 Cash 500 1,750 1,250 LEDGERS - Income Statement accounts Fees Earned Date Item Balance Post Ref. Dr. Cr. Dr. Cr. 7/1 Balance 7/11 Cash 7/16 Cash 7/23 Accounts Receivable 7/30 Accounts Receivable 7/31 Cash 1,000 2,000 2,500 1,500 3,000 6,200 7,200 9,200 11,700 13,200 16,200 Wages Expense Post Balance Date Item Ref. Dr. Cr. Dr. * 7/1 Balance 7/14 Cash 7/28 Cash 1,200 1,200 400 1,600 2,800 Office Rent Expense Post Balance Date Item Ref. Dr. Cr. Dr. *** 800 7/1 Balance 7/1 Rent Expense 1,750 2,550 52 Equipment Rent Expense Date Item Ref. Dr. Cr. Dr. Balance Cr. 7/1 Balance 7/13 Equipment Expense 700 675 1,375 Utilities Expense Post Balance Date Item Ref. Dr. Cr. Dr. Balance 7/1 Balance 7/25 Utilities Expense 915 300 1,215 Music Expense Date I tem Post Ref. Dr. Ce Balance 7/1 Balance 7/21 Music Expense 7/31 Music Expense 620 1,590 2,210 3,610 1,400 Advertising Expense Post Date Item Ref. Dr. Cr. DrBalance 7/1 Balance 7/8 Advertising Expense 7/22 Advertising Expense 200 800 500 700 1,500 56 Supplies Expense | Date Item Ref. Dr. Cr. Dr. Balance Co. 7/1 Balance 180 Insurance Expense Post Balance | Date Item Ref. Dr. Cr. Dr. Palanca Cr. Depreciation Expense Balance | Date Post Ref. Date Item Post Item Dr. Dr. cr. Dr. Dr. Balance cr. Miscellaneous Expense Post Date Item Ref. Balance Dr. Cr. Dr. 7/1 Balance 7/4 Miscellaneous Expense 7/29 Miscellaneous Expense 900 540 415 1,315 1,855 2