This question has been opened in a new tab. In order to continue your assignment, please save your Excel question. IE2-1 Inferring Investing and Financing Transactions and Preparing a Balance Sheet 2 During its first month of operations ending January 31, 2022, Cuppor International completed the transactions on the schedule shown below. 1.66 Ending Dollar Effect on Transactions Balance points Account 1 2 3 5 6 Cash 50, 000 (7, 000) (10, 000) (22, 000) Skipped Notes Receivable (short term) 7,000 Inventory 12, 000 Prepaid Rent 10, 000 Equipment 70, 000 eBook Land 22, 000 Accounts Payable 12, 000 References Notes Payable 70, 000 Common Stock 1, 000 Additional Paid-in Capital 49, 000 Required: 1. Complete the chart by recording the ending balances in each account. 2. Use the account balances to create a Classified Balance Sheet for January 31, 2022. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.File Home Insert Draw Formulas Data Review View Help Editing v Comments Calibri 11 B . . . ab General .00 .00 . . . A1 * X V fx Accessibility tab summary: The financial transactions of Cuppor International are presented in cells A8 to G19. A statement for requirement is presented in rows 5 and 6. The A B C D E F G H I J K L M During its first month of operations ending January 31, 2022, Cuppor International completed the transactions on the schedule shown below. W N Required: 5 1. Complete the chart by recording the ending balances in each account. 6 2. Use the account balances to create a Classified Balance Sheet for January 31, 2022. 7 8 Dollar Effect on Transactions 9 Account 2 3 4 5 6 Ending Balance 10 Cash $ 50,000 $ (7,000) $ (10,000) $ (22,000) 11 Notes Receivable (short term) 7,000 12 Inventory $ 12,000 13 Prepaid Rent $ 10,000 14 Equipment 70,000 15 Land $ 22,000 F 16 Accounts Payable $ 12,000 17 Notes Payable 70,000 18 Common Stock 1,000 19 Additional Paid-in Capital 49,000 20 21 Cuppor International 22 Balance Sheet 23 > = & Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +A B C D E F G H I J K L LL M DJlance ONCE 35 36 37 38 39 40 41 42 43 44 E A Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +