Hi! I unlocked one of your answered questions. The problem asks for the answers to provide formulas in the excel sheet but I cannot see them. Can you show me how please? I have attached the assignment and the answers you gave.

Karise Repairs Income Statement For the Year Ended December 31, 2015 Repairs fees earned $ Expenses: Depreciation expense-Equipment Wages Expense Insurance Expense Rent Expense Office Supplies Expense Utilities Expense Total Expense Net Income $ 113,800 5,500 44,000 1,000 14,000 3,100 3,100 70,700 43100 Karise Repairs Statement of Owner's Equity For the Year Ended December 31, 2015 C. Karise, Capital, January 1, 2015 Add net income $33,000 43,100 $76,100 18,500 Less Withdrawals C. Karise, Capital, December 31, 2015 57600 Karise Repairs Balance Sheet December 31, 2015 Assets Current Assets Cash Office Supplies Prepaid Insurance Plant Assets Equipment Accumulated depreciation-equipment Total Assets $ 55,000 5,500 18,000 1,800 2,500 49,500 $ 71,800 $ 13,000 1,200 14,200 Liabilities Current Liabilities Accounts Payable Wages Payable Total Current Liabilites Equity C. Karise, Capital Total Liabilities and equity 57,600 $ 71,800 Karise Repairs Work Sheet For the Year Ended December 31, 2015 No. Account 101 Cash 124 Office Supplies 128 Prepaid insurance 167 Equipment 168 Accumulated Depreciation, Equipment 201 Accounts Payable 210 Wages Payable 301 C. Karise, Capital 302 C. Karise, Withdrawals 401 Repair fees earned 612 Depreciation Expense, Equipment 623 Wages Expense 637 Insurance Expense 640 Rent Expense 650 Office supplies Expense 690 Utilities Expense 901 Income Summary Totals Adjusted Trial Balance Debit Credit Closing Entries Debit Credit $20,000 2,000 2,600 59,000 $20,000 2,000 2,600 59,000 5,900 $15,500 1,100 38,000 17,000 103,900 103,900 17,000 5,900 38,000 1,300 12,000 3,700 2,900 63,800 40,100 $164,400 Post Closing Trial Balance Debit Credit $164,400 $224,800 5,900 15,500 1,100 61,100 0 0 0 0 0 0 0 0 0 40,100 17,000 5,900 38,000 1,300 12,000 3,700 2,900 103,900 $224,800 $83,600 $83,600 Karise Repairs General Journal Debit December 31, 2015 Closing Entries Repair Fees Earned Income Summary Credit 115,600 115,600 Income Summary Depreciation Expense, Equipment Wages Expense Insurance Expense Rent Expense Office supplies Expense Utilities Expense 69,500 Income Summary C. Karise, Capital 46,100 C. Karise, Capital C. Karise, Withdrawals 20,000 5,900 40,000 800 15,000 4,400 3,400 46,100 20,000 ACCT 211 INDIVIDUAL LEARNING PROJECT INSTRUCTIONS The Individual Learning Project consists of 3 parts. All answers must be submitted in an Excel document, as indicated in the instructions to each part. Each tab must be labeled as the corresponding part. For example, tab one must be labeled \"Part 1\". Part 1: The adjusted trial balance of Karise Repairs on December 31, 2015, follows. Assume there are no owner investments. No. Account Title 101 Cash 124 Office supplies 128 Prepaid insurance 167 Equipment Accumulated depreciation 168 Equipment 201 Accounts payable 210 Wages payable 301 C. Karise, Capital 302 C. Karise, Withdrawals 401 Repair fees earned Depreciation expense 612 Equipment 623 Wages expense 637 Insurance expense 640 Rent expense 650 Office supplies expense 690 Utilities expense Totals KARISE REPAIRS Adjusted Trial Balance December 31, 2015 Debit $ 18,000 1,800 2,500 55,000 Credit $ 5,500 13,000 1,200 33,000 18,500 113,800 5,500 44,000 1,000 14,000 3,100 3,100 $ 166,500 $ 166,500 In an Excel spreadsheet, on one tab: 1. Prepare an Income Statement, using formulas for totals 2. Prepare a Statement of Owners' Equity, using formulas for totals and figures that are linked to other financial statement information 3. Prepare a Classified Balance Sheet, using formulas for totals and figures that are linked to other financial statement information. 4. The adjusted trial balance of Karise Repairs on December 31, 2015, follows. Page 1 of 3 ACCT 211 Part 2: The adjusted trial balance of Karise Repairs on December 31, 2015, follows (NOTE: these figures are different than what was provided in Part 1): No. Account Title 101 Cash 124 Office supplies 128 Prepaid insurance 167 Equipment Accumulated depreciation 168 Equipment 201 Accounts payable 210 Wages payable 301 C. Karise, Capital 302 C. Karise, Withdrawals 401 Repair fees earned Depreciation expense 612 Equipment 623 Wages expense 637 Insurance expense 640 Rent expense 650 Office supplies expense 690 Utilities expense Totals KARISE REPAIRS Adjusted Trial Balance December 31, 2013 Debit $ 20,000 2,000 2,600 59,000 Credit $ 5,900 15,500 1,100 38,000 17,000 103,900 5,900 38,000 1,300 12,000 3,700 2,900 $ 164,400 $ 164,400 On a separate tab in Excel, transfer the adjusted trial balance into a new tab within your Excel document. 1. Enter the adjusted trial balance in the first two columns of a six-column table using formulas for the totals column. 2. Use additional columns to enter closing entry information, using formulas to calculate the totals column 3. Use additional columns to show a post-closing trial balance, using formulas to calculate the totals column. Page 2 of 3 ACCT 211 Part 3: The adjusted trial balance of Karise Repairs on December 31, 2015, follows (NOTE: The amounts are different from the other parts of this project). No. Account Title 101 Cash 124 Office supplies 128 Prepaid insurance 167 Equipment Accumulated depreciation 168 Equipment 201 Accounts payable 210 Wages payable 301 C. Karise, Capital 302 C. Karise, Withdrawals 401 Repair fees earned Depreciation expense 612 Equipment 623 Wages expense 637 Insurance expense 640 Rent expense 650 Office supplies expense 690 Utilities expense Totals KARISE REPAIRS Adjusted Trial Balance December 31, 2015 Debit $ 19,000 1,300 2,300 59,000 Credit $ 5,900 15,500 1,100 33,000 20,000 115,600 5,900 40,000 800 15,000 4,400 3,400 $ 171,100 $ 171,100 1. On a separate tab in Excel, prepare the appropriate closing journal entries. Debits should be listed first, and credits should be indented. Descriptions are not required. Submit your Individual Learning Project by 11:59 p.m. (ET) on Monday of Module/Week 7. Page 3 of 3