AutoSave On Chapters 1-4 Extra Credit - Protected View - Excel O Search Alissa Butcher AB X Share Comments File Home Insert Page Layout Formulas Data Review View Help O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X B11 f 1. Owner invested $45,000 in exchange for common stock of the corporation A B D E F H 1 j K L M N 2 2 3 NAME Chapters 1-4 Extra Credit Assignment 4 5 6 7 1) For the following transactions, post the entry to the following T-accounts for the month of December: Once you enter all your Debits and Credits, in the yellow cell, enter in your ending balance, This will be used for Problem #2 below to create a preliminary trial balance. 5 points 9 10 12 13 11 1. Owner invested $45,000 in exchange for common stock of the corporation 2. Paid $6,500 for office equipment (computer, desk, chair and printer) 3. Received $6,000 from a customer in advance of providing the services. Services will be performed in February of next year. 14 4. Purchased office supplies, on account, in the amount of $3,000. Those supplies are estimated to cover 3 months. 15 5. Paid $2,200 for insurance. The policy covers a one year period. 6. For the office supplies purchased in 4., paid the vendor (account) $1,500. 7. Paid employees $1,500 for the month. 8. Performed services and billed the customer for $22,000 19 9. Collected $1,000 from the customer in 8. 20 10. Paid the utility company for the electric bill received in the amount of $800. 21 22 23 Cash Accounts Receivable Prepaid Supplies 24 16 16 17 17 18 Prepaid Insurance Office E Problems 1 and 2 Problem 3 Problems 4-5 and 6 lal 100% 11:59 AM H Type here to search O BI w AGU 10/2/2020 AutoSave On H 2 - Chapters 1-4 Extra Credit Protected View - Excel Search Alissa Butcher AB X Share Comments File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing G33 A B D E F G H 1 L L M N 1 2 3 NAME Chapters 1-4 Extra Credit Assignment 4 5 6 6 7 7 3) 5 points 8 8 9 In the gray boxes, enter your balances from your Preliminary Trial Balance from Problem 2 Post the appropriate adjusting entry for the transactions below for the month Calcualte your new ending account balance. 10 11 12 13 1. Depreciation on equipment is $800 for the month 2. Prepaid insurance had a beginning balance of $2,200. The policy covers a one year period. Round to the whole dollar. 3. Sent out invoices to customers (on account) in the amount of $6,000 for services performed in the month and earned. 4. Accrued for an oustanding utility bill not yet received for month end in the amount of $400. 5. Supplies had a beginning balance of $3,000. At month end, it was determined there is only $2,100 on hand. 14 15 16 17 18 Cash Accounts Receivable Prepaid Supplies Prepaid Insurance Office Equit 19 20 21 22 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + + 100% H Type here to search O BI 3 w 12:11 PM 10/2/2020 AutoSave On H 2 - Chapters 1-4 Extra Credit Protected View - Excel Search Alissa Butcher AB X File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing X G33 B D E F G H 1 K L M N CA 17 18 19 Cash Accounts Recelvable 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 32 33 34 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + + 100% H Type here to search O BI c 3 w 12:11 PM 10/2/2020 AutoSave On Chapters 1-4 Extra Credit Protected View - Excel Search Alissa Butcher AB X File Home Insert Page Layout Formulas Data Review View Help Share Comments O PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X G33 E F G H 1 K M N O P O R 17 Accounts Receivable Prepaid Supplies Prepaid Insurance 18 19 Office Equipment 20 21 22 23 24 25 26 27 28 Accounts Payable Unearned Revenue Common Stock 29 30 31 32 33 34 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + lal 1 100% H Type here to search O CH 3 w AUX 12:11 PM 10/2/2020