Excel SIM: Merchandising operations and the multi-step income statement 1. Prepare and analyze a merchandiser's multi-step income statement. Merchandising operations and the multi-step income statement - Excel FILE HOME INSERT PAGE LAYOUT Calibri 11 AA Paste BIU Clipboard G Font C5 fx A FORMULAS DATA % REVIEW VIEW Alignment Number Conditional Format as Cell Formatting Table Styles B C Styles 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 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 Tinearned Raac 20.0001 ? Cells Editing D E