require assistance in solving an accounting cycle problem

by

I want an expert in Accounting and Excel to solve the problem mentioned here. It should be solved in Excel.