could you please write the formula specific 5o the column, the chart pattern is already on Chegg if it helps.

Excel SIM: Merchandising operations and the multi-step income statement 1. Prepare and analyze a merchandiser's multi-step Income statement. KH 7 Merchandising operations and the multi-step income statement - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME INSERT Callbri 111 A A 196 Paste B T2 A Alignment Number dells conditional Format as Cell Formatting - Table - Styles Styles Clipboard Font B52 M ces C E 1 Noodles Unlimited, Inc. sells swimming pool toys. The following adjusted trial balance 2 is for the year ended December 31, 20X1. 3 4 Account Titles Debits Credits S Cash $37,500 6 Accounts Receivable 28,600 Inventory 43,300 8 Prepaid Rent 2,000 9 Equipment 69,000 10 Accumulated Depreciation $20,700 11 Accounts Payable 8,800 12 Unearned Fees 20,000 13 Long-term Notes Payable 75,000 14 J. Noodle, Capital 31,800 15 Sales Revenue 175,500 16 Sales Returns and Allowances 4,700 17 Sales Discounts 6,000 18 Cost of Goods Sold 671700 19 Salaries and Wages Expense 25.900 20 Depreciation Expense 13,800 21 Rent Expense 24,000 22 Interest Expense 1,600 Praw Calibri 11 Paste BIU- Alignment Number Clipboard F Conditional Format Formatting Table Styles Font 852 V A B 4 Account Titles Debits Credits 5 Cash $37,500 6 Accounts Receivable 28,600 7 Inventory 43,300 8 Prepaid Rent 2,000 9 Equipment 69,000 10 Accumulated Depreciation $20,700 11 Accounts Payable 8,800 12 Unearned Fees 20,000 13 Long-term Notes Payable 75,000 14 J. Noodle, Capital 31,800 15 Sales Revenue 175,500 16 Sales Returns and Allowances 4,700 17 Sales Discounts 6,000 18 Cost of Goods Sold 67,700 19 Salaries and Wages Expense 25,900 20 Depreciation Expense 13,800 21 Rent Expense 24,000 22 Interest Expense 1,600 23 Loss on Sale of Equipment 7,700 24 Totals $331,800 $331,800 25 25 Required: 27 1. Prenare a multisten income statement that would be used for intemal renortine du Sheet1 READY Attempt(s) 373 M D 21. Prepare a multistep income statement that would be used for internal reporting purposes. 0 Note: Wher more than one correct account could uppeor in ocell Nar terms in order or largest la 29 smallest dlar omounts. Use cel referencng to select account titles and values 20 AN numbers should appeur os positive numbers. 3. 2. After entering the formula a cell 852. use the Excel TF function to label cell AS2 as either 22 "Net Income" or "Net Lossas appropriate based on the volue calculated in cell B92. NOODLES UNLIMITED Income Statement CBG TOT CHU V omdouDECUTIEDOT 2 sole Revenue LCES 9. 00 40 NO SAVICH 42 4 GroPro 44 Expenses ue 4B Income from Operations 49 Other Expenses and losses 64 3. Compute the gross profit percentage. 55 Note Make sure to nelude 100 or the end of your formula Ge in order to cover the decimal tuo percentage 57 Cross Pralu PercentLUL den