AudioFile Products Ltd. is a retailer of sound systems. The company is planning its cash needs for the month of January 2024. In the past. AudioFile has had to borrow money during the post-Christmas season to offset a significant decline in sales. The statement of financial position showed the following at its fiscal year-end, December 31, 2023 Other information: Assets Current Cash a. Cash collection Accounts receivable Inventory $20,000 280,000 126.000 ii. i. December credit sales % cash sales each month PPE, net 426,000 4,000,000 iii. % credit sales collected in same month $4,426,000 iv. %credit sales collected in next month b. Liabilities C. January total sales Inventory information $400,000 0% 30% 70% $300,000 Current Operating loan $200,000 i. February total sales $250,000 Accounts payable Non-current borrowings 190,400 390,400 3.000.000 iii. ii. Gross profit ratio all months 30% % purchases paid in cash same month 20% 3.390,400 iv. % inventory on hand needed for next month's sales 60% d. Shareholders Equity Accounts payable at Dec. 31 all relate to inventory purchases and will be paid in full in January Common shares Retained earnings 70,000 965,600 e. Variable expenses as % of total sales $0 1,035.600 f. Fixed expenses $4,426,000 i. Depreciation, including any January budgeted PPE purchases $10,000 ii. Other fixed operating expenses, paid each month $20,000 g. Interest is paid monthly on opening balances of the operating loan and non- current debt. Interest rate per month: 1% h. Corporate income tax rate 20% Income taxes are paid at the end of the fiscal year. 1. Monthly cash dividends paid to shareholders j. Budgeted PPE purchases for January k. January repayments of principal on non-current debt 1. Desired minimum cash balance at end of January m. Maximum operating loan balance at end of January . Any excess cash will be used to pay down the operating loan. Q. Any cash not able to be provided by the operating loan will be raised by issuing common shares. Required: 1. Using a format the budget worksheet below (must), record the above information. $5,000 $0 $10,000 $20,000 $200,000 ASSETS LIABILITIES + S/H EQUITY Tran Cash + S. Acc. Rec. Invent + + PPE Op. Loan Acc. + Pay. L/T Debt Com mon + + Share Ret. Earn. Desc.. S Cf. 20,0 00 280,0 00 126,0 00 4,000,0 00 200,0 00 190,4 00 3,000,0 00 70,00 965,6 00 Total S 2. Prepare a statement of financial position at January 31, 2024 and budgeted income statement, statement of changes in equity, and statement of cash flows for the month ended January 31, 2024. Show all calculations. For SCF purposes, assume the operating loan is part of cash and cash equivalents. 3. Apprise management of budgeted January operating loan needs and the dollar amount of any shares that may need to be issued.