AutoSave IF ABP Financial_Statements_from_Trial_Balance 8.10.21 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G Wrap Text 3-I Feb Paste B I I u U A = = = Merge & Center v $ Insert Delete Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data V C25 f G | CL CM CN co OP 00 CR CS CT CU CV CW A B E F 1 1 Name: Fatimah Abdulrahman 2 Your score: 09 The trial balance of the Fatimah Abdulrahman Company as of December 31, 2021 is presented below. Prepare an Income statement, statement of retained samnings and a balance sheet for the year andad (data of) December 31, 2021. Every yek cal requires a thar an account site or a formu ALL FORMULAS FOR TOTALS MUST INCLUDE THE SUM FUNCTION. Use the dropdown list to select the proper account thes Credit Fatimah Abdulrahman Company Trial Balance December 31, 2021 Dobit Cash S4,800 Accounts receivable 700 Inventory 10,200 Prepaid rent 2,900 Equipment 28,500 Accounts payable Unearned consulting revenue Corrman slock Dividends 700 Consulting revenue Rental revenue Salarice expense 1,800 Rent expense 1,500 Insurance expense 800 Totale $8,700 3.500 32,700 6,300 800 10 11 12 13 14 15 16 17 12 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 1) Prepare the income statement for Fatimah Abdulrahman Company for the year ended December 31, 2121 Fatimah Abdulrahman Company Income Statement For Year Ended December 31, 2021 Revenues Total revenues Expenses Tolal expenses 22 Tha Fatimah Ahadirahman Company began operations on. Anuary 1 20:21 Instructions Prepare Fin Sts + Ready # - + 100% AutoSave IF ABP Financial Statements_from_Trial_Balance 8.10.21 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X [G Wrap Text 3-I Feb Paste B 1 I U V = = = Merge & Center v $ % Insert Delete Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data V B F G | CL CM CN co OP 00 CR CS CT CU CV CW C25 f A E 1 Name: Fatimah Abdurahman 2 Your score 10% 43 44 2) The Fatimah Abdulrahman Company began operations on January 1, 20121. 45 Praparets statement of retained earnings for the year ended December 31, 46 2021. 47 Fatimah Abdulrahman Company 48 Statement of Retained Earnings 49 For Year Ended December 31, 2021 50 Ratained aarnings, January 1, 2021 $ 51 52 Subtotal 53 54 Retained earnings December 31, 2021 55 56 57 3) Prepare a balance sheet for Fatimah Abdulrahman Company at December 31, 2021, 58 59 Fatimah Abdulrahman Company 60 Balance Sheet G2 December 31, 2021 Assets 62 13 Total assets Llabilities and Equity Liabinos 614 65 67 G2 69 70 71 72 73 74 75 76 77 78 79 Total Tables Equily Total abilities and equily BO A AZ 83 04 Instructions Prepare Fin Sts + Ready - + 100%