File X Calibri Paste Undo Clipboard 95 D5 BIU EB Font 16 5 > A A A G || Merge & Alignment VXfx C D. Of the balance of unearned revenue, $1,260 has been earned The property, plant and equipment was purchased at the beginning of 2019 and is expected to last 10 years with no residual value The amount in prepaid insurance is for an annual policy that was paid on September 1, 2021 A Dec 31 Dec 31 10 Dec 31 12 13 14 15 % 17 " " 20 Bill's Bistro Worksheet December 31, 2021 Adjusted Trial Ba Adjustments 21 22 Account Titles 2 Cash Unadjusted Trial Balance DR CR DR CR DR $12,000 24 Credit Card Receivables. 2,300 2 Inventory 16,200 Prepaid Insurance 8,100 27 Equipment 15,000 Accumulated Depreciation $5,500 2 Accounts Payable 2,700 30 Unearned Revenue 2,100 3 Bank Loan 18,500 32 Bill, Capital 6,650 Bill, Drawings 700 Sales Revenue 28,000 Food & Beverage Expense 0 xDepreciation Expense 0 37 Rent Expense 2,800 Salaries Expense 6,200 Insurance Expense 0 40 Telephone Expense 150 41 Total $63,450 $63,450 42 43 Question 1 Question 2 Question 3 Ready Accessibility: Investigate AutoSave off Mid Term 1 O Search (Alt+Q) File Home Insert Page Layout Formulas Data Review View Help Calibri 16 A A Wrap Text General Paste B I U v M A Merge & Center % " Undo Clipboard Ex Font Alignment Ex Number B9 A 1 Part II vXfx =CONCATENATE("The property, plant and equipment was purchased at the beginning of 2019 and in Worksheet-Adjustments 20 Marks Below, is Bill's Bistro's unadjusted trial balance at the end of December 2021. Adjusting entries have not yet been made, Required: Use the trial balance and the information below to complete the worksheet. F Dec 31 . Dec 31 A physical count showed that $3,240 of inventory is on hand at the end of the year Of the balance of unearned revenue, $1,260 has been earned Dec 31 The property, plant and equipment was purchased at the beginning of 2019 and is expected to last 10 years with no residual value M " Dec 31 12 The amount in prepaid insurance is for an annual policy that was paid on September 1, 2021 17 Bill's Bistro Worksheet " 20 21 December 31, 2021 Unadjusted Trial Balance - Adjustments Adjusted Trial Balance 22 Account Titles Cash DR CR DR CR DR CR $12,000 Credit Card Receivables 2,300 25 Inventory 16,200 Prepaid insurance 8,100 27 Equipment 15,000 Accumulated Depreciation $5,500 2 Accounts Payable 2,700 Unearned Revenue 2,100 Bank Loan 18,500 Bill, Capital 6,650 Bill, Drawings 200 Sales Revenue 28,000 Food & Beverage Expense xDepreciation Expense ol Question 1 Question 2 Question 3 + Ready Accessibility investigate OL a File AutoSave off Midlerm 1- Home Insert Page Layout Formulas Data Review Search (Alt+Q) View Help X Calibr -16 -A A = Wrap Text Ge Paste BIU - 161 A- Merge & Center K Undo Clipboard Font Alignment 89 Xfx CONCATENATE("The property, plant and equipment was purchased at the beginning o " December 11, 2621 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Titles Cash DR CR DR CR DR CR Credit Card Receivables $12,000 2,300 Inventory 16,200 Prepaid Insurance Equipment a Accumulated Depreciation i Accounts Payable 100 15,000 55.500 2,700 Unearned Revenue Bank Loan 2,300 18.500 Bill, Capital 450 Bill Drawings 700 Sales Revenue 21,000 Food & Beverage Expense O Depreciation Expense Ment Expense 2,000 Salaries Expense 6,200 Insurance Expense 0 Telephone Expense 156 Total 583450 561,450 42 43 Ready Question 1 Question 2 Question 3 OL 0