Requirement #$4$: Prepare adjusting entries using the following information in the General Journal below. Show your calculations using Excel formulas!

One month's insurance has expired.

The remaining inventory of store supplies is $$250.$

The estimated depreciation on store fixtures is $$160.$

The estimated income taxes are $$295.$

Requirement #$5$: Post the adjusting entries on July $31$ below to the General Ledger accounts $2$ General Ledger worksheet$).$ Adjusting entries are referenced in the General Ledger as AE#$1,$ AE#$2,$ etc.

$\backslash$table$[[$Date$,$Account Name,Account Number,Debit,Credit$],[,,,$grad,$],[,,,,],[,,,,],[,,,,],[,,,,],[,,,,],[,,,,],[,,,,],[,,,,]]$