Please perform the following tasks: 1 Prepare the Adjusting Journal Entries at January 31, 2023 based on the information provided in a. through h. above and record them in the Adjusting Journal Entries column on the '1-31-23 Trial Balance' worksheet. 2 Extend that data to compute the Adjusted Trial Balance on the '1-31-23 Trial Balance' worksheet. Note: For this assignment, you do not have to post the adjusting entries to the General Ledger 3 From the Adjusted Trial Balance, prepare the four fundamental nancial statements at January 31, 2023: a. Income Statement b. Statement of Retained Earnings c. Balance Sheet d. Statement of Cash Flows unadjusted trial balance No. Account Debit Credit 101 Cash 68,186 106.1 A/R - Alex's Engineering Co. 4,000 106.2 A/R -Wildcat Services 106.3 A/R -West Leasing 12,750 106.4 A/R -IFM Co. 106.5 A/R -Liu Corp. 106.6 A/R -Gomez Co. 106.7 A/R -Delta Co. 106.8 A/R -KC, Inc. 11,400 106.9 A/R -Dream, Inc. 3,200 107 Allowance for Doubtful Accounts 1,730 119 Merchandise inventory 13,252 126 Computer supplies 850 128 Prepaid insurance 3,420 131 Prepaid rent 1,875 163 Office equipment 5,000 164 Accumulated depreciation-Office equipment 125 167 Computer equipment 30,700 168 Accumulated depreciation-Computer equipment 964 201 Accounts payable 10,187 203 Interest Payable 210 Wages payable 236 Unearned computer services revenue 240 Short-Term Notes Payable 245 Notes Payable 307 Common stock 112,000 311 Paid-in-Capital in Excess of Par 5,000210 Wages payable 236 Unearned computer services revenue 240 Short-Term Notes Payable 245 Notes Payable 307 Common stock 112,000 311 Paid-in-Capital in Excess of Par 5,000 318 Retained earnings 12,866 319 Dividends 3,600 103 Computer services revenue 12,000 413 Sales 26,450 414 Sales returns and allowances 400 415 Sales discounts 502 Cost of goods sold 16,340 612 Depreciation expense-Office equipment 613 Depreciation expense-Computer equipment 87 623 Wages Expense 2,100 633 Interest Expense 250 637 Insurance Expense 540 Rent Expense 652 Computer Supplies Expense 655 Advertising Expense 656 Bad Debt Expense 676 Mileage Expense 677 Miscellaneous Expenses 684 Repairs Expense-Computer 705 Gain on Sale of Equipment 808 Loss on Sale of Equipment 452 901 Income Summary Totals 179,592 179,592Ramona is appiying for a line of credit with a local bank and has been requested to provide nancial statements for the month ended January 31, 2023. As a result, you will need to prepare a worksheet using the unadjusted trial balance and then adjusting the balances for the following additional items prior to nancial statement preparation. Since it is the policy of Computer Solutions to only record adjusting entries at year end you will not record adjusting entries in the general journal or post to the general ledger, but will instead complete a worksheet to arrive at the adjusted balances at January 31, 2023 _:ru:: a. The January 31 amount of computer supplies still available totals $660. b. One more month has expired since the company purchased its annual insurance policy at a $4,560 cost for 12 months of coverage. 0. Lyn Addie has not been paid for nine days of work at the rate of $150 per day. d. e. One month has passed since any prepaid rent has been transferred to expense. Depreciation on the computer equipment needs to be recorded for January. The equipment is being depreciated using the straight-line method and has a useful life of seven years and satvage value of $3,700. (Round to nearest dollar.) Depreciation on the ofce equipment needs to be recorded for January. The equipment is being depreciated using the straight-line method and has a useful life of ten years and no saivage value. (Round to nearest dollar.) . The January 31 amount of merchandise inventory still available totals $13,203. Based on the [FM (30. write-off in January, management maintains that the estimate that 10% of ending Accounts Receivable balance will be uncollectable is reasonable