Please answer all questions

Question 22 (1 point) Saved CASH BUDGET (spreadsheet analysis - refer to your handout for guidance). The following is a partially completed worksheet for a cash budget. The required minimum cash balance per month is $20,000 and the beginning cash balance is $22,000. Interest rate on any new short-term loan is 0.5% per month. Use the data for the next set of questions. First, calculate total cash collection for the month of JUNE Jan Feb Mar Apr May Jun $100,000 $110,000 $80,000 $110,000 $150,000 $200,000 Projected sales Cash collections: Current month: 70% 1 month after sales: 30% Total cash collection Total purchases Cash payment (1 month after sale) 90,000 $160,000 $107,000 $89,000 $101,000 $138,000 $185,000 $77,000 $56,000 $77,000 $105,000 $140,000 $157,500 72,000 Jan Feb Mar Apr May Jun Cash collection - brought forward Cash disbursements: Purchases - brought forward Total cash expenses Total cash payout 35,000 45,500 33,000 33,000 45,500 33,000 Question 23 (1 point) Calculate total cash payout in JANUARY. 1) $107,000 2) $160,000 3) $138,000 4) $185,000 5) $105,000 5 Question 24 (1 point) Calculate surplus/deficit for month of MARCH. 1) $0 2) -$9,000 3) -$12,500 4) $55,000 Question 25 (1 point) Calculate ending cash balance for month of JUNE. 1) $0 2) -$9,000 3) $61,500 4) $52,500 5) $52,000 Question 26 (1 point) Calculate ending cash balance for month of APRIL. 1) $0 2) -$9.000 3) $61,500 4) $52,500 5) $52,000 Question 27 (1 point) Calculate additional financing needed for the month of APRIL. 1) $0 2) -$9,000 3) $61,500 4) $52,500 5) $20,000 Submit Quiz 19 of 27 questions saved