Please answer pictured requirments

Requirement #4: Prepare adjusting entries using the following information in the General Journal below. Show your calculations using Excel formulas! 1) One month's insurance has expired 2) The remaining inventory or store supplies is $250. 3) The estimated depreciation on store fixtures js $160. 4) The estimated income taxes are $295. Requirement #5 Post the adjusting entries on July 3 f below to the General Ledger accounts (2 - Genera/ Ledger uorksheet). Adjusting entries are referenced in the General Ledger as AE#I, AE#2, etc. Account Name ount Numbe Debit Credit During its month of operation (July), Jane s Skateboards completed the following transactions: Instructions: Record these transactions in the next worksheet titled "l - Journal Entries". te: These figures are different from the demo videos you watched under the Content Tab in the Online Class JEOI JE02 JE03 JE05 JE06 JE07 JE08 JE09 JEIO JEII JE12 JE13 July I July 2 'July 3 July S July 6 IJuly 8 IJuly 10 'July 11 'July 18 July 20 July 25 July 26 Jul 30 business by making a $100,000 deposit into the bank account in exchange for shares Of common Stock - Par value SIO Paid S16.OOO for shelf fixtures for the Jane's Skateboard storefront paid for the on a I-year insurance paid for the Skateboards Store rent Purchased Credit - 1000 costing S25 from Acme MFG Purchased on Credit Store supplies costing S600 from Wkes Supy Paid S200 Janea Skateboards July telephone bin Sold 24 S50 each to a customer who paid cash paid S300 1/2 of the Supplies rchased on July 8 from Mike's Sup" Sold Skateboards to a Customer paid cash Sold Skateboards to a customer Who paid cash Paid S500 for Jane's Skateboards July electric Paid to Jane's Skateboards sharehold s for di%idend declared on Jul 30