Please use the information in the pictures to create an adjusted trial balance.

aste X Delete BI U a A HTH > $ %. OOO Conditional Format as Cell Formatting Table Styles Format Sort Filter Clipboard Font Alignment Number Styles Cells Editi 86 Diego's bank told him that he will receive $500 in interest income for the month of December 2019, B E F G H T J M N O P 0 Diego's Dinners, Inc. ADJUSTING JOURNAL ENTRIES: NOTE: Assume that all prior regular journal entries were recorded correctly prior to December unless otherwise noted Only the below AJE's discovered by the Bentley students in December still need to be recorded Journal Entries Calculations Show all calculations in Excel (on side or in formulas) to receive partial credit If no transaction exists, write "NO TRANSACTION" for the journal entry Transaction 1 Diego borrowed all of the loan proceeds (Notes Payable) listed on the Unadjusted Trial balance on July 1 201 Transaction 1 No interest was recorded for 2019. Interest rate is 10% and is not payable until the loans are due Transaction 2 Transaction 2 Diego had received a deposit of $10,000 for the full price of an order to Falcon Corporation received in September 2019 for a December 2019 delivery date, Diego delivered the meals in December but did not reflect the transaction Transaction 3 Transaction 3 Diego's office rent is $5,100/month. He had paid his rent ahead of time, but has not yet recorded the December rent use Transaction 4 Transaction 4 In December Diero ordered $10,000 of inventory for a St. Patrick's Day promotion in March The inventory was not anticipated to be delivered until the end of January, Diego forgot to record a delivery he completed in December on account for $20.000, Transaction 5 3 Transaction 5 4 5 Diego was notified that he won a bid for $20,000 to provide meals for a major hospital workers 6 Transaction 6 Transaction 6 Transaction 7 28 29 Transaction 7 30 31 32 33 Transaction 8 34 Diego didn't update its bad debt estimate. Diego uses the Credit sales method for estimating its bad debt expense and estimates 1% of their unadjusted trial balance sales is estimated to be uncollectible Transaction 8 Diego pays employees weekly on Friday for a five day work week. Payroll for the last week of December is $10,000. Diego notices that December 31st is on a Tuesday, Diego's bank told him that he will receive $500 in interest income for the mor_h of December 2019, but it won't be paid to his bank account until January 2020 Transaction 9 Transaction 10 Transaction 9 37 38 39 Transaction 10 40 41 42 43 Diego estimates the income tax expense for 2019 to be $15,000 and had not recorded this yet INSTRUCTIONS Unadjusted Trial Balance AJE's TAccounts Formatting Table Styles Format Clipboard Font Alignment Number Styles Cells H7 F G H M N P R S T use this information to create an adjusted trial balance A B D E 1 Diego's Dinners, Inc. 2 Unadjusted Trial Balance 3. For the year ended 12/31/19 4 Unadjusted Trial Balance 5 Debit Credit 6 Cash 5 425,000 7 Accounts receivable 235,000 8 Allowance for doubtful accounts 25,000 9 Interest receivable 10 Inventory 40,000 11 Prepaid insurance 7,000 12 Prepaid rent 10,000 13 Equipment -cost 150,000 14 Accumulated depreciation - equipment 15,000 15 Accounts payable 40,500 16 Salary payable 17 Interest payable 18 Income tax payable 19 Unearned revenue 120,000 20 Notes payable - Due June 1, 2020 100,000 21 Notes payable - Due December 1, 2021 150,000 22 Common stock 23 Retained earnings - beginning of year 24 Sales revenue 500,000 25 Sales returns and allowances 7,000 26 Cost of goods sold 250,000 27 Advertising expense 5,000 28 Bad debt expense 29 Depreciation expense 15,000 30 Insurance expense 11,000 31 Income tax expense 32 Interest expense 33 Interest income 1,000 34 Rent expense 55,000 35 Salaries expense 120,000 36 Utilities expense 5,500 37 Total S 1.335,500 1,335,500 38 39 check INSTRUCTIONS Inadiusted Trial Balance 100,000 284,000 AJE'ST Accounts aste X Delete BI U a A HTH > $ %. OOO Conditional Format as Cell Formatting Table Styles Format Sort Filter Clipboard Font Alignment Number Styles Cells Editi 86 Diego's bank told him that he will receive $500 in interest income for the month of December 2019, B E F G H T J M N O P 0 Diego's Dinners, Inc. ADJUSTING JOURNAL ENTRIES: NOTE: Assume that all prior regular journal entries were recorded correctly prior to December unless otherwise noted Only the below AJE's discovered by the Bentley students in December still need to be recorded Journal Entries Calculations Show all calculations in Excel (on side or in formulas) to receive partial credit If no transaction exists, write "NO TRANSACTION" for the journal entry Transaction 1 Diego borrowed all of the loan proceeds (Notes Payable) listed on the Unadjusted Trial balance on July 1 201 Transaction 1 No interest was recorded for 2019. Interest rate is 10% and is not payable until the loans are due Transaction 2 Transaction 2 Diego had received a deposit of $10,000 for the full price of an order to Falcon Corporation received in September 2019 for a December 2019 delivery date, Diego delivered the meals in December but did not reflect the transaction Transaction 3 Transaction 3 Diego's office rent is $5,100/month. He had paid his rent ahead of time, but has not yet recorded the December rent use Transaction 4 Transaction 4 In December Diero ordered $10,000 of inventory for a St. Patrick's Day promotion in March The inventory was not anticipated to be delivered until the end of January, Diego forgot to record a delivery he completed in December on account for $20.000, Transaction 5 3 Transaction 5 4 5 Diego was notified that he won a bid for $20,000 to provide meals for a major hospital workers 6 Transaction 6 Transaction 6 Transaction 7 28 29 Transaction 7 30 31 32 33 Transaction 8 34 Diego didn't update its bad debt estimate. Diego uses the Credit sales method for estimating its bad debt expense and estimates 1% of their unadjusted trial balance sales is estimated to be uncollectible Transaction 8 Diego pays employees weekly on Friday for a five day work week. Payroll for the last week of December is $10,000. Diego notices that December 31st is on a Tuesday, Diego's bank told him that he will receive $500 in interest income for the mor_h of December 2019, but it won't be paid to his bank account until January 2020 Transaction 9 Transaction 10 Transaction 9 37 38 39 Transaction 10 40 41 42 43 Diego estimates the income tax expense for 2019 to be $15,000 and had not recorded this yet INSTRUCTIONS Unadjusted Trial Balance AJE's TAccounts Formatting Table Styles Format Clipboard Font Alignment Number Styles Cells H7 F G H M N P R S T use this information to create an adjusted trial balance A B D E 1 Diego's Dinners, Inc. 2 Unadjusted Trial Balance 3. For the year ended 12/31/19 4 Unadjusted Trial Balance 5 Debit Credit 6 Cash 5 425,000 7 Accounts receivable 235,000 8 Allowance for doubtful accounts 25,000 9 Interest receivable 10 Inventory 40,000 11 Prepaid insurance 7,000 12 Prepaid rent 10,000 13 Equipment -cost 150,000 14 Accumulated depreciation - equipment 15,000 15 Accounts payable 40,500 16 Salary payable 17 Interest payable 18 Income tax payable 19 Unearned revenue 120,000 20 Notes payable - Due June 1, 2020 100,000 21 Notes payable - Due December 1, 2021 150,000 22 Common stock 23 Retained earnings - beginning of year 24 Sales revenue 500,000 25 Sales returns and allowances 7,000 26 Cost of goods sold 250,000 27 Advertising expense 5,000 28 Bad debt expense 29 Depreciation expense 15,000 30 Insurance expense 11,000 31 Income tax expense 32 Interest expense 33 Interest income 1,000 34 Rent expense 55,000 35 Salaries expense 120,000 36 Utilities expense 5,500 37 Total S 1.335,500 1,335,500 38 39 check INSTRUCTIONS Inadiusted Trial Balance 100,000 284,000 AJE'ST Accounts