Please help with the following case study! I am so lost!

I need help with requirement 5 & Requirement 9

Excel File Edit View Insert Format Tools Data Window Help B ()) : 33% Sat Mar 19 9:18:12 PM Judy See Q E ACCT503_W4_Case_Study Q . Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ^ Arial 10 . A- A- = Insert Wrap Text E = General * Delete Paste BI UTVS. A. Merge & Center $ % F.0 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter A29 X v fx B C D E F G H I J K L M N O P Q R S T U V Requirement #4: AWN Prepare adjusting entries using the following information in the General Journal below. Show your calculations! a) One month's insurance has expired. b) The remaining inventory of supplies is $400. 10 c) The estimated depreciation on equipment is $125. 11 12 d) The estimated income taxes are $3,000. 13 14 General Journal 15 Date Description (Account Name) Debit Credi 16 31-Jul Insurance Expense (4200/12) 350 17 Prepaid Insurance 350 18 19 31-Jul Supplies Expense (1000-400) 600 20 Supplies 600 21 22 31-Jul Depreciation Expense 125 Accumulated Depreciation - 23 Equipment 125 24 25 31-Jul Income Tax Expense 3,000 26 ncome Tax Payable 3,00 30 Requirement #5: Post the adjusting entries to the General Ledger T-accounts and compute adjusted balances. Just add to the balances that are already listed. 34 35 36 37 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted Trial Balance Financial Statements Closing Entries Post-Closing Trial Balance Grading Rubric + Ready Count: 3 + 106%Excel File Edit View Insert Format Tools Data Window Help B " ()) : 33% Sat Mar 19 9:18:28 PM Judy See Q E ACCT503_W4_Case_Study Q . Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ^ Arial 10 . A- A = Insert = Wrap Text General E Ly * Delete Paste B = # Merge & Center $ - % 00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter D14 X V fx 17000 A C D E F G H 1 J K L M N O P Q R This Sheet will be used for Requirements 2, 5, and 9. P W N . Requirement #2: Post the July journal entries to the following T-accounts and compute ending balances. Cash (111) Tax Preparation Revenue 60,000 3,500 17000 8,000 10 3,000 200 9,000 9,000 1.50 .500 13 500 600 17000 15 16 62,200 18 Prepaid Insurance (117) Rent Expense (511) 4,200 350 3,500 3500 3850 Supplies (119) Salaries Expense (512) 1,000 600 3,500 3500 400 Equipment (144) Insurance Expense (513) 10,000 350 350 10,000 Accumulated Depreciation-Equipment (145) Supplies Expense (514) 125 600 600 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted Trial Balance Financial Statements Closing Entries Post-Closing Trial Balance Grading Rubric + Ready + 100%Excel File Edit View Insert Format Tools Data Window Help B ()) : 33% Sat Mar 19 9:18:40 PM Judy See Q E ACCT503_W4_Case_Study Q . Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ^ Arial 10 . A- A = = Wrap Text General Insert E * Delete Past B Merge & Center $ - % 00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter D14 X fx 17000 A C D E F G H 1 J K L M N O P Q R 10,000 350 350 10,000 Accumulated Depreciation-Equipment (145) Supplies Expense (514) 125 600 600 125 48 Accounts Payable (212) Depreciation Expense (515) 500 1,000 125 125 7,500 B,000 0 Income Tax Payable (213) Income Tax Expense (516) 3000 3000 3000 3000 Common Stock (311) 60,000 Retained Earnings (312) 11075 17000 600 60,000 5325 Dividends (313 600 600 Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted Trial Balance Financial Statements Closing Entries Post-Closing Trial Balance Grading Rubric + Ready + 100%Excel File Edit View Insert Format Tools Data Window Help B " ()) 8 33% Sat Mar 19 9:18:45 PM Judy See Q E ACCT503_W4_Case_Study Q . Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ^ Insert Arial 10 . A- A = E = Wrap Text General * Delete Paste E # Merge & Center $ % F.0 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter H14 X v fx A B C D E F G H J K L M N O P Q R Requirement #8: Prepare the closing entries at July 31 in the General Journal below. General Journal Date Description (Account Name) Debit Credit 31-Ju Tax Revenue 17,000 10 Income Summary 17,000 11 12 31-Ju Income Summary 11,075 13 Rent expense 3,500 14 Salaries Expense 3.500 15 Insurance Expense (from adjustment) 350 16 Supplies Expense 600 17 Depreciation Expense 125/ 18 ncome Tax Expense 3.000 31-Ju Income Summary (Balance) $ 5,925 Retained Earnings $ 5,925 31-Ju Retained Earnings 600 Cash 600 34,600 34.600 Requirement #9: Post the closing entries to the General Ledger T-accounts and compute ending balances. Just add to the adjusted balances already listed. Account Name Debit Credit Cash Salary Expenses Rent Expenses Supplies Equipment Accounts Payable Stock 39 Insurance Dividends Revenue GRE Accumulated Depreciation Expense Journal Entries General Ledger Trial Balance Adjusting Entries Adjusted Trial Balance Financial Statements Closing Entries Post-Closing Trial Balance Grading Rubric + Ready + 100%