I just need question 4- info used from 1 & 3

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 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 C24 fi A B C D E F G . 1 1 2 Chapters 1-4 Extra Credit Assignment 3 4 5 6 7 4) Using proper format, prepare an income statement, including appropriate totals, for the year ended December 31, 2021 5 points 9 10 11 12 13 14 15 $ 16 $ Problems 1 and 2 Problem 3 Problems 4-5 and 6 lal + 100% H Type here to search O BI J' w AUX 12:17 PM 10/2/2020 22 AutoSave On Aww = 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 C24 fi C D E F G . 1 17 18 19 20 21 22 23 24 $ 25 $ 26 27 28 5) Using proper format, prepare the statement of retained earnings, for the year ended December 31, 2021. 5 points 29 30 Problems 1 and 2 Problem 3 Problems 4-5 and 6 a 100% H Type here to search 0 BI w AUX 12:17 PM 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 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 C24 fx C D E F G . 1 27 28 5) Using proper format, prepare the statement of retained earnings, for the year ended December 31, 2021. 5 points 29 30 31 32 33 34 35 $ 36 37 38 39 40 41 6) Using proper format, prepare the classified balance sheet, for the year ended December 31, 2021. 5 points 42 43 Problems 1 and 2 Problem 3 Problems 4-5 and 6 + 100% H Type here to search O BI c 3 AUX 12:17 PM 10/2/2020 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 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 C24 f C D E F G . 1 j 39 40 41 6) Using proper format, prepare the classified balance sheet, for the year ended December 31, 2021. 5 points 42 43 44 45 46 47 48 49 $ $ 50 51 $ 52 53 54 $ 55 56 $ $ Problems 1 and 2 Problem 3 Problems 4-5 and 6 a 100% H Type here to search O BI w AUX 12:18 PM 10/2/2020 AutoSave On 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 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 C24 f AB C D E F G . 1 46 47 48 49 $ $ 50 51 $ 52 53 $ 54 $ 55 56 $ 57 58 $ 59 $ $ 60 61 62 Problems 1 and 2 Problem 3 Problems 4-5 and 6 100% H Type here to search BI 3 w AUX 12:18 PM 10/2/2020