AutoSave Oom A H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Home Insert Page Layout Formulas Data Review View Help Share Comments y X [ Calibri === ab General 28 0 4 - 11 A A BIU A Insert Delete Format Paste $ % 82% Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cdis Editing Ideas Sensitivity G9 . fx B C D E F G . 1 J L M N 51 52 53 54 Peaceful Pastures Bed & Breakfast Preliminary Trial Balance 55 Account Name Debit Credit 56 Cash 39,500 57 Accounts Recievable 21,000 58 Prepaid Supplies 3,000 59 Prepaid Insurance 2,200 60 Office Equipment 6,500 61 Accounts Payable 1,500 62 Unearned Revenue 6,000 63 Common Stock 45,000 22.000 64 Service Ravnice Problems 1 and 2 Ready Problem 3 Problems 4-5 and 6 + (a) 100% H Type here to search BI J' e g A la 8:30 AM 10/6/2020 AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Review View Help Share Comments Home Insert Page Layout Formulas Data X Calibri - 11 A A === [ BIUD OA y ab General 28 O Insert Delete Format Paste $ % 82% Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cels Editing Ideas Sensitivity G9 - fx B C D E F F G H. 1 J K L M N 60 Office Equipment 6,500 61 Accounts Payable 1,500 62 Unearned Revenue 6,000 63 Common Stock 45,000 64 Service Revnue 22,000 65 Salaries & Wages Expense 1,500 66 Utilities Expense 800 67 TOTALS 74,500 74,500 68 69 70 71 72 73 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + Ready (a) 100% H Type here to search O BI e 3 O 8:30 AM 10/6/2020 AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Review View Help Share Comments Home Insert Page Layout Formulas Data X Calibri - 11 A A === [ BIU, IA y ab Custom Insert Delete Format 28 o Paste $% % 58,8 Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cdis Editing Ideas Sensitivity L39 - j L M N AA B D E F F H 1 6 7 3) In the gray boxes, enter your balances from your Preliminary Trial Balance from Problem 2 8 5 points Post the appropriate adjusting entry for the transactions below for the month 9 Calcualte your new ending account balance. 10 11 1. Depreciation on equipment is $800 for the month 12 2. Prepaid insurance had a beginning balance of $2,200. The policy covers a one year period. Round to the whole dollar. 13 3. Sent out invoices to customers (on account) in the amount of $6,000 for services performed in the month and earned. 14 4. Accrued for an oustanding utility bill not yet received for month end in the amount of $400. 15 5. Supplies had a beginning balance of $3,000. At month end, it was determined there is only $2,100 on hand. 16 17 18 Cash Accounts Receivable Prepaid Supplies 19 Prepaid Insurance Office Equil 20 21 22 23 Problems 1 and 2 Problem 3 Problems 4-5 and 6 Ready (a) 100% H Type here to search O BI 8:31 AM 10/6/2020 A la 3 22 AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Home Insert Page Layout Formulas Data Review View Help Share Comments y X [ Calibri 11 AA === ab Custom Insert Delete Format 28 0 4 Paste $%8-28 Ideas OA Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity L39 - f B D E F G H 1 j K M N 17 18 19 Cash Accounts Receivable Prepaid Supplies Prepaid Insurance Office Equip 20 21 22 23 24 25 26 27 Office Equipment - Accumulated Depreciation 28 Accounts Payable Unearned Revenue Common Stock 29 30 31 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + Ready (a) 100% H Type here to search O BI A fax 8:31 AM 10/6/2020 22 AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Home Insert Page Layout Formulas Data Review View Help Share Comments y X [ Calibri 11 AA === ale Custom Insert Delete Format 28 O Paste BIU Ideas OA $ % 82% Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Sensitivity Clipboard Font E Alignment Number Cells Editing Ideas Sensitivity L39 fx D E F G H 1 M N O P Q 17 18 19 Accounts Receivable Prepaid Supplies Prepaid Insurance Office Equipment 20 21 22 23 24 25 26 27 28 Accounts Payable Unearned Revenue Common Stock 29 30 31 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + Ready (a) + 100% 1 8:31 AM 10/6/2020 H Type here to search O BI 3 22 And l x AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Home Insert Page Layout Formulas Data Review View Help Share Comments y X [ Calibri 11 AA === ab Custom Insert Delete Format 27 O 5 Paste BIUD A $ % 82% Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity L39 fx A E F G H 1 K M N B Office Equipment - Accumulated Depreciation 28 Accounts Payable Unearned Revenue Common Stock 29 30 31 32 33 34 35 36 Sales Revenue Salaries & Wages Expense Utilities Expenses Depreciation Expense Insurance E: 37 38 39 40 41 42 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + Ready 100% H Type here to search BI 8:31 AM 10/6/2020 22 AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Home Insert Page Layout Formulas Data Review View Help Share Comments y X [ Calibri AA === ab Custom 28 0 4 Insert Delete Format Paste $ % 82% Ideas BIU, CA Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cdis Editing Ideas Sensitivity L39 fx F H M N O P o R S s 28 : Payable Unearned Revenue Common Stock 29 30 31 32 33 34 35 36 ages Expense Utilities Expenses Depreciation Expense Insurance Expense Supplies Expense 37 38 39 40 41 42 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + Ready 100% H Type here to search O BI 8:31 AM 10/6/2020 22 AutoSave Oom H2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Review View Help Share Comments Home Insert Page Layout Formulas Data X Calibri - 11 A A === [ BIU, IOA y ab Custom Insert Delete Format 28 O Paste $ % 588 Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity L39 fx L M N AA B D D E F G H 1 44 45 2) Using your ending balances, create an Adjusted Trial Balance as of December 31, 2021 for Peaceful Pastures Bed & Breakfast: 46 5 points 48 49 50 Peaceful Pastures Bed & Breakfast Adjusted Trial Balance 51 Account Name Debit Credit 52 53 54 55 56 57 58 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + Ready (a) 100% H Type here to search e BP a 3 A fax 8:31 AM 10/6/2020 22 AutoSave On H 2 Chapters 1-4 Extra Credit Excel Search Alissa Butcher AB Ga X File Home Insert Page Layout Formulas Data Review View Help Share Comments y X [ Calibri AA === ab Custom 27 0 % Insert Delete Format Paste Ideas $ % 82% BIU, CA Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cdis Editing Ideas Sensitivity L39 - fx A A B E F G . H 1 j K L M N 58 59 60 61 62 63 64 65 66 67 TOTALS 68 69 70 71 Problems 1 and 2 Problem 3 Problems 4-5 and 6 Ready (a) 100% H Type here to search BI e 8:31 AM 10/6/2020 3