Answer using excel !

PT WIDIATMAJA records merchandise inventory on a periodic basis. Financial statements are prepared annually on December 31. Below is presented the Unadjusted and After Adjusted Trial Balance as of December 31, 2020.

Requested: 1. Make the necessary adjusting entries. 2. Prepare an Income Statement for the period 2020 3. Prepare Retained Earnings Statement 4. Prepare a Statement of Financial Position for 2020

Account Store Building Acc. Depre.Building Merch. Inventory Account Receivable Cash Bank Loan Account Payable Salary Payable Share Capital Ord. Retained Earnings Dividend Sales Sales Return & All. Sales Discount Purchase Freight-in Purchase Return Purchase Discount Cost Of Goods Sold Office Salary Exp. Office Utility Exp. Office supplies Exp. Store Supplies Exp. Store Salary exp. Advertising Exp. Depre. Exp. Building Freight-out TOTAL PT WIDIATMAJA WORK SHEET For The Month Ended Dec.31 2020 (In 000) Adit. Trial Trial Balance Balance Income Stat Stat. of FP Debit Credit Debit Credit Debit Credit Debit Credit 2170 2170 91 161 840 945 910 980 1225 1225 1155 1155 140 140 133 175 1715 1715 301 301 231 231 4410 4480 35 35 56 56 2030 280 140 42 2023 35 56 63 63 28 28 42 42 49 70 91 91 70 42 42 8127 8127 8127 8127