Excel SIM: Merchandising operations and the multi-step income statement 1. Prepare and analyze a merchandiser's multi-step income statement. 2 BB5 FILE Merchandising operations and the multi-step income tant el PAGE LAYOUT FORMULAS DATA REVIEW Sigrid HOME INSERT X ch AA * C Editing Paste Alignment Number Conditional Formats She Opber A2 1 is for the vear ended December 31, 20X1 Clipboard Font Styles > A2 so is for the year ended December 31, 20X1. D E - B 1 Noodles Unlimited, Inc, sells swimming pool toys. The following adjusted trial balance 2 is for the year ended December 31, 20X1. 3 4 Credits 6 Debits $37,500 28,600 43,300 2,000 69,000 Account Titles 5 Cash Accounts Receivable Inventory 8 Prepaid Rent 9. Equipment 10 Accumulated Depreciation 11 Accounts Payable 12 Unearned Fees 13 Long-term Notes Payable 7 $20,700 8,800 20,000 75,000