ACC 3010 Fall 2020 I need help with the GREEN portion of the assignment. I have attached images, if you could help out that would be great. Also, please include formula's. Thank you.
may need. Add the January journal entry information to the Worksheet in the January columns. You can do this in one of 2 ways - (1) Post the journal entries to ledger accounts using T-accounts to represent ledger accounts and then use those totals to post to the worksheet or (2) use excel to add all entries for a particular account into the correct column in the worksheet (ie., add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use for T Accounts if you want but the T Accounts are NOT required Prepare an unadjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Excel formulas must be used throughout the project to obtain full credit. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab.. Highlight the entire worksheet area and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Prepare adjusting entries for the month of January given the information provided. Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet ). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements. Prepare closing entries for the end of the period Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. A B D E F CLOSING JOURNAL ENTRIES -ZKTZ Consulting Inc ACCOUNT DEBIT DATE CREDIT 1 2 3 4 5 6 7 3 1 3 ZKTZ Consulting Inc Income Statement ZKTZ Consulting Inc Balance Sheet ZKTZ Consulting Inc Statement of Retained Earnings BEGINNING NUMBERS JANUARY ENTRIES ADJUSTMENTS TRIAL DEBIT DEBIT CREDIT DEBIT TRIAL DEBIT 74,824 CREDIT CREDIT DEBIT CREDIT CREDIT 49,200 0 0 6985 ACCOUNT Cash Accounts Receivable Supplies Prepaid Rent Land 10,590 63,210 11,500 16,240 9,000 0 37,586 8,950 0 0 0 2,550 16,240 9.000 0 4680 750 74,824 9,535 11,560 8,250 58,300 67,500 58,300 67,500 0 0 0 0 0 0 0 0 0 58,300 67,500 0 8,950 0 0 0 295 295 8,950 8,950 0 0 0 85 85 0 0 0 10,590 0 5,650 0 0 0 6560 50 0 0 0 0 0 0 0 0 0 5,650 0 0 11,760 30,000 175,000 0 5,650 6560 50 10,780 30,000 175,000 11.7607 980 0 0 30,000 0 175,000 0 Computer Equipment Accumulated Depreciation, Comp Equip Office Furniture Accumulated Depreciation, Off Furn Accounts Payable Salaries Payable Interest Payable Uneamed Revenue Long-term Notes Payable Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Supplies Expense Utilities Expense Interest Expense Depreciation Expense, Comp Equip Depreciation Expense, Office Furniture 0 0 0 0 500 500 0 500 0 0 7965 31,965 24,000 0 0 6,560 0 0 0 6,560 0 0 6560 750 0 4680 0 24,000 0 0 0 0 0 0 0 117,946 1,986 0 ol 0 117,946 1,986 0 0 0 246,410 0 c 0 0 0 13,120 750 4680 1,986 50 295 85 260,385 501 295 85 20385 0 246,410 20385 260385 185,590 185,590 BEGINNING NUMBERS JANUARY ENTRIES UNADJUSTED TRIAL BALANCE ADJUSTMENTS ADJUSTED TRIAL BALANCE CREDIT CREDIT CREDIT 0 DEBIT CREDIT DEBIT =SUM(F3) =SUM('ADJUSTING JE =SUM(F4+H4) =SUM('ADJUSTING JEESUM(F5-15) =SUM('ADJUSTING JEESUM(F6-16) =SUM(F7) =SUM(F8) =SUM('ADJUSTING JE =SUM(D10) =SUM('ADJUSTING JE =SUM(19) 10590 ACCOUNT DEBIT Cash 49200 Accounts Receivable Supplies 10590 Prepaid Rent Land 58300 Computer Equipment 67500 Accumulated Deprecia Office Furniture Accumulated Deprecia Accounts Payable Salaries Payable Interest Payable Unearned Revenue Long-term Notes Pay Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Supplies Expense Utilities Expense Interest Expense Depreciation Expense Depreciation Expense DEBIT CREDIT DEBIT =JE!C6+JE!C8+JE!C1 =JE!D3+JE!D5+JE!D1 74824 =JE!C9 =JE!D18 =SUM(D4-E4) =JE!C15+JE!C21 0 =SUM(D5-E5) =JE!C2 0 =D6 0 =B7 0 =B8 0 =D9 =JE!C4 0 =SUM(D10-E10) 0 =D11 =JE!D16 0 0 =D13 0 =D14 =JE!D14 =D15 =JE!D7 =D16 0 =D17 0 =D18 =JE!C23 0 =D19 =JE!D10 =D20 =JE!C11 0 =D21 0 =D22 0 =D23 =JE!C19 0 =D24 0 =D25 0 =D26 0 =D27 =SUM(D3:D27) =SUM(E3:E27) =SUM(F3:F27) =SUM('ADJUSTING JE =SUM('ADJUSTING JE =SUM('ADJUSTING JE MooloolololololololollOdoloroolol 0 0 =E6 =E7 =E8 =E9 =E10 =E11 5650 =E13 =E14 =E15 =E16 =C17 =E18 =E19 =E20 =E21 =E22 =E23 =E24 =E25 =E26 =E27 =SUM(G3:27) =SUM(111) =SUM(G12) =SUM(113) =SUM(114) =SUM(G15-H15) =SUM(G16) =SUM(G17) 175000 =SUM(G20+120) =SUM(F19) =SUM('ADJUSTING JE =SUM('ADJUSTING JE =SUM(F21+H21) =SUM('ADJUSTING JE| SUM(H22) =SUM('ADJUSTING JE =SUM(H23) =SUM(F24) =SUM('ADJUSTING JE =SUM(H25) =SUM('ADJUSTING JE SUM(H26) =SUM('ADJUSTING JE =SUM(H27) =SUM(H3:H27) =SUM(13:127) =SUM(J3:J27) =SUM(K3:K27) =SUM(B3:B28) =SUM(C3:C28)
