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.