AutoSave OFF " A F Y C ... Financial_Statements_from_Trial_Balance.8.10.21 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A A 207 ab Wrap Text v I V Paste BI UVV M Av Merge & Center v $ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Q v Filter Select Data C72 X V fx 3500 D G H CK CL CM CN co CP ca CR CS CT CU CV CW Fatimah Abdulrahman NH Name: Your score 40%% The trial balance of the Fatimah Abdulrahman Company as of December 31, 2021 is presented below. Prepare an ncome statement, statement of retained earnings and a balance sheet for the year ended (date of), December 31, 2021. Every yellow cell requires either an account title or a formula. ALL FORMULAS FOR TOTALS MUST INCLUDE THE =SUM FUNCTION. Use the dropdown list to select the proper account titles. Fatimah Abdulrahman Company al Balance December 31, 2021 Debit Credit Cast $4,800 Accounts receivable 70 Inventory 10,200 Prepaid rent 2,900 Equipment 26,500 Accounts payable $6,700 Unearned consulting revenue 3,500 Common stock 32,700 Dividends 700 Consulting revenue 6.300 Rental revenue 800 Salaries expense 1,900 Rent expense .500 Insurance expense 800 Totals 1) Prepare the income statement for Fatimah Abdulrahman Company for the Tell me what you want to do year ended December 31, 2021. Fatimah Abdulrahman Company Income Statemen For Year Ended December 31, 2021 Revenues Consulting revenue $6,300 This is not a formula Rental revenue $800 This is not a formula Total revenues $7,100 This is not a formula Expenses Salaries expense 1,900 This is not a formula Rent expense 1,500 This is not a formula nsurance expense 800 This is not a formula Total expenses 4,200 This is not a formula Net income $2.900 This is not a formula 43 44 2) The Fatimah Abdulrahman Company began operations on January 1, 2021 Instructions Prepare Fin Sts 100% Ready - +AutoSave OFF " A F Y C ... Financial_Statements_from_Trial_Balance.8.10.21 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A A 207 ab Wrap Text v I V Sort & Find & Analyze Paste BIUV MY Av KE Merge & Center v $ % 9 Conditional Format Cell Insert Delete Format Formatting as Table Styles Q v Filter Select Data C72 X V fx 3500 D E G H CK CL CM CN co CP ca CR CS CT CU CV CW Name: Fatimah Abdulrahman Your score: 40% 2) The Fatimah Abdulrahman Company began operations on January 1, 2021. Prepare its statement of retained earnings for the year ended December 31, 46 2021 Fatimah Abdulrahman Company 48 Statement of Retained Earnings 49 For Year Ended December 31, 2021 50 Retained earnings, January 1, 2021 $0 Net income 2.900 This is not a formula Subtotal 700 This is not a formula Dividends 2,200 This is not a formula Retained earnings, December 31, 2021 3) Prepare a balance sheet for Fatimah Abdulrahman Company at December 31, 2021. Fatimah Abdulrahman Company Balance Sheet December 31, 2021 Assets Cash $4,800 This is not a formula Accounts receivable 700 This is not a formula 65 nventory 10,200 This is not a formula Prepaid rent 2,900 This is not a formula Equipment 26,500 This is not a formula Total assets $45,100 This is not a formula Tell me what you want to do Liabilities and Equity Liabilities Accounts payable $6.700 This is not a formula Unearned consulting revenue 3.500 This is not a formula Total liabilities $10,200 This is not a formula Equity Common stock 32,700 This is not a formula Retained earnings 2,200 This is not a formula Total liabilities and equity $45,100 This is not a formula 79 80 81 82 83 84 Instructions Prepare Fin Sts + Ready - + 100%