Question 1 (10 marks) YOU CAN USE EXCEL and PRINT YOUR WORKSHEET (8x11). Student Services Incorporated (SSI) acts as a wholesaler to the various student retail shops that operate on campuses throughout Canada. It supplies clothing, records, and confectionary items. The company has a $75,000 line of credit available with a local bank, and it draws on its account in amounts of $5,000 at a time. [Thus, if it needs $5,001, it must borrow $10,000.] SSI has not drawn on the credit line yet. As at December 31, 2023, the firm had a cash balance of $7,000, which is the minimum balance that it wants to maintain. Any excess cash is used to repay the line of credit. [Ignore interest on the line of credit.] The following additional information is available. Actual Sales Forecasted sales October 2023 $100,000 January 2024 $100,000 November 2023 $75,000 February 2024 $50,000 December 2023 $40,000 March 2024 $30,000 April 2024 $100,000 May 2024 $70,000 June 2024 $70,000 Sales/Accounts Receivable: All sales are on credit and terms are net 30 days (1 month). From past experience 50 percent of the accounts are collected 1 month after the sale, 40 percent are collected 2 months after the sale, and 10 percent are collected 3 months after the sale. Bad debts are negligible. Cost of Goods Sold/Purchases: The goods are ordered, received, and paid for in the month prior to sale. Purchases (units) are equal to 90% of next month's sales and the gross profit margin is 30%. Administrative Expense: The administrative expense is $4,000 per month (which includes $1,000 for depreciation expense) plus a bonus of 4 percent of sales realized during the last quarter of the calendar year. This bonus is paid in February of each year. Dividends: In March, $6,000 in dividends will be paid. Taxes: The tax rate is 40 percent. For the past year, $2,000 in taxes must be paid by January 15, and no other taxes are payable in the period January to April. - Wa $12 0001 01;: -|- Automatic Loom v Salaries: Wages and salaries amount to 15 percent of the monthly dollar sales or $12,000, whichever is greater. Capital Expenditures: The company will buy new fixed assets for $20,000 in January. These assets have a five-year life with no residual value. Prepare a schedule of cash receipts, a schedule of cash payments and a cash budget for the period January to April 2024. YOU CAN USE EXCEL and PRINT YOUR WORKSHEET (\"portrait\"). Question 2 (4 marks) A firm has found itself having cash flow problems. It pays its suppliers on terms of 1I10 net 35. In the past, it has always taken the cash discount. However, it finds itself in a situation where it cannot come up with the cash needed to pay within 10 days for purchases. In 35 days, it will have the necessary cash. If it chooses to borrow money to pay for purchases it would be forced to go to a finance company specializing in high-risk loans. It would be forced to pay a rate of 2 percent per month (24 percent APR) on the loan. What should the firm do? (4 marks) ONLY SUBMIT PAGES 2-3. 1 ASSIGNMENT #6 (14 marks) Name (Last, First): Student #: Question 1 (10 marks) YOU CAN USE EXCEL AND PRINT YOUR WORKSHEET (\"portrait\"). Schedule of Cash Receipts (in thousands of dollars) JAN. FEB. I MARCH APRIL V 2 01 3 - + Automatic Zoom Student #: Question 1 (10 marks) YOU CAN USE EXCEL AND PRINT YOUR WORKSHEET ("portrait"). Schedule of Cash Receipts (in thousands of dollars) JAN. FEB. MARCH APRIL SHOW YOUR WORK (where needed): Schedule of Cash Payments (in thousands of dollars) JAN. FEB. MARCH APRIL