F W PSU SNIL Court Vodules Problems P7.1 (LO) Excel (Determine Proper Cash Balance) Francis Equipment Co. closes its books regularly on December 31, but at the end of 2020 it held its cash book open so that a more favorable balance sheet could be prepared for credit purposes. Cash receipts and disbursements for the first 10 days of January were recorded as December transactions. The information is given below. 1. January cash receipts recorded in the December cash book totaled $45,640, of which $28,000 represents cash sales, and $17,640 represents collections on account for which cash discounts of $360 were given. 2. January cash disbursements recorded in the December check register liquidated accounts payable of $19.450 on which discounts of $250 were taken. 3. The ledger has not been closed for 2020. 4. The amount shown as inventory was determined by physical count on December 31, 2020. The company uses the periodic method of inventory. Instructions a. Prepare any entries you consider necessary to correct Francis's accounts at December 31, Assume that the balance sheet that was prepared by the company showed the following amounts: b. To what extent was Francis Equipment Co. able to show a more favorable balance sheet at December 31 by holding its cash book open? (Compute working capital and the current ratio.) Cash Accounts receivable Inventory Accounts payable Other current liabilities $39.000 42,000 67,000 Pa (LO 3) $45,000 14,200 park (Bad-Debt Reportine The follow