Answered step by step
Verified Expert Solution
Question
1 Approved Answer
92% Wed 8:34 PM Q Excel File Edit View Insert Format Tools AutoSave CFF A9 G ... Data Window Help Multiple_Step_Income_Statement_from_Trial_Balance_Corporate SP Calibri (Body) v
92% Wed 8:34 PM Q Excel File Edit View Insert Format Tools AutoSave CFF A9 G ... Data Window Help Multiple_Step_Income_Statement_from_Trial_Balance_Corporate SP Calibri (Body) v 11 Wrap Text X LA General - E2E Paste BI U A = = = Merge & Center $ % of Insert Delete Conditional Format Cell Formatting es Table Styles Format Sort & v Filter Find & Select Analyze Data BT26 fx B D BS BT RU AV BW BY BZ CA CH CC CD CE CF 1 Name: Fatimah Abdulrahman 2 Your score: 05 The trial balance of the Fatimah Abdulrahman Company as of December 31, 2021 is presented below. Frepare a multipla- step income statement for the year ended date of), December 31, 2121. Every yalica cell requires either an account this ar a dolar amount. Use tha dropdown list to select the proper account Has. Enter a formun for alcolar amounts 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Fatimah Abdulrahman Company Trial Balance December 31, 2021 Debit Crecit Cash $9.500 Accounts receivable 18.000 Merchandise Inwertory FZ 500 Store suppies 2.OCO Store Equipment 56,00 Accumulated depreciation $17.000 ) Accounts payabia 14 IUD Salaries payabia 6000 Comman Shack 61.600 Dividende 20,000 Salas 385.000 Sales discounts 8,000 Sales returns and allowances 18,300 Cast of goods sold 128,000 Depreciation experise - Sore equip. 8,500 Salus salaries experise 25,800 Office salaries expense 34,500 Insurance expense 11,500 Rent expense - Store 17.500 Rent expense office 7.5CO Store supplies expense 6.300 Advertising expense 31.800 Totals $463,500 $463.600 li Prepare a multiple-slep income sterrenit for Falimah Abdulraturan Carpany for the year ended December 31, 2021. Remember that seling expenses target the customer, and are expecled to generate audional sales. Administrative expenses are not expected to generate additional salee . 35 36 37 38 39 40 Fatimah Abdulrahman Company Income Statement For Year Ended December 31, 2021 41 42 43 Instructions Multi-Step Ready - + 100% AutoSave IF A. Multiple_Step_Income_Statement_from_Trial_Balance_Corporate Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 VA X G A Wrap Text General 3-I F Paste = = = Merge & Center Insert of % ? Delete Y Conditional Format Cell Formatting es Table Styles Format Sort & Filter Find & Select Analyze Data V BT26 fx B D BS BT RU AV BLU BY BZ CA CH CC CD CE CF 48 1 Name: Fatimah Abdulrahman 2 Your score: 34 Prepare a multiple-slep incurne slatererit for Falimah Abdulraturan Carpany for the year ended December 31, 2021. Reinerter that seling expenses larget the customer, and are expected to generale additional sales. Administrative 35 36 expenses are not expected to generale additional sale. 37 38 Fatimah Abdulrahman Company 39 Income Statement 40 For Year Ended December 31, 2021 41 42 43 44 45 46 47 Operating expenses Scling expenses 49 50 52 52 53 54 Total seing expenses 55 General and administrative expenses 56 57 58 59 Total general and administrative expenses 60 Totalcparating expenses 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 Instructions Multi-Step + Ready - + 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started