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. Jon Feb Mar Apr May Jun $100.000 $10,000 $80,000 $10,000 $150,000 $200,000 Projectes les Goh Collections Current mort monthster sales 90.000 Total collection Totat purchased CEER Dent month after se $160,000 $27.000 72.000 $107.000 $89,000 $101,000 $133,000 $135,000 $26.000 377.000 5103.000 $149,000 $137.500 Fon Feb MA AP VINY Jun cash collection-brought Morandi Cash Bisbursement Purche brought forward Toto Chen Tout 33 000 2200 33.000 13.000 45100 33.000 Question 23 (1 point) Calculate total cash payout in JANUARY 1) $107.000 2) $160,000 3) $138,000 04) $185,000 5) $105,000 Question 24 (1 point) Calculate surplus/deficit for month of MARCH 1) $0 O 21-59,000 O 3) -$12,500 O4) $55,000 Question 25 (1 point) Calculate ending cash balance for month of JUNE 1) so 2)-59.000 3) $61.500 4) $52.500 5) 552.000 Question 25 (1 point) Calculate ending cash balance for month of JUNE. 1) So 2) $9,000 3) $61,500 4) $52,500 57 $52,000 Question 26 (1 point) Calculate ending cash balance for month of APRIL 1) so 2) -$9,000 3) $61,500 O 41 $52.500 5) $52.000 Question 27 11 point Calculate additional financing needed for the month ot APRIL 1) 50 259.000 33 561,500 41 552.500 120.000 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. Jon Feb Mar Apr May Jun $100.000 $10,000 $80,000 $10,000 $150,000 $200,000 Projectes les Goh Collections Current mort monthster sales 90.000 Total collection Totat purchased CEER Dent month after se $160,000 $27.000 72.000 $107.000 $89,000 $101,000 $133,000 $135,000 $26.000 377.000 5103.000 $149,000 $137.500 Fon Feb MA AP VINY Jun cash collection-brought Morandi Cash Bisbursement Purche brought forward Toto Chen Tout 33 000 2200 33.000 13.000 45100 33.000 Question 23 (1 point) Calculate total cash payout in JANUARY 1) $107.000 2) $160,000 3) $138,000 04) $185,000 5) $105,000 Question 24 (1 point) Calculate surplus/deficit for month of MARCH 1) $0 O 21-59,000 O 3) -$12,500 O4) $55,000 Question 25 (1 point) Calculate ending cash balance for month of JUNE 1) so 2)-59.000 3) $61.500 4) $52.500 5) 552.000 Question 25 (1 point) Calculate ending cash balance for month of JUNE. 1) So 2) $9,000 3) $61,500 4) $52,500 57 $52,000 Question 26 (1 point) Calculate ending cash balance for month of APRIL 1) so 2) -$9,000 3) $61,500 O 41 $52.500 5) $52.000 Question 27 11 point Calculate additional financing needed for the month ot APRIL 1) 50 259.000 33 561,500 41 552.500 120.000
