Winde Ok. Check Chos 4 On April the start of the loan pervoa, the cash balance will be $38.500 Accounts receivble on Apt will tot $48.400, of which $2200 will be collected during April and $16.960 will be collected during May. The remainder will be uncollectible Past experience shows that 30% of a marth's as recobected in the month of sale 60% in the morfolowing sale, and in the second month following sale. The other is bad brever collected. Budited sales and expenses for the three month period follow Sates to account Merchase purchases Payroll Lease pays Advertising et purchases Depreciation May June $430,000 $450,000 $127.000 1315,000 $13,000 $163.000 $ 21,400 121,400 $ 19,00 136,200 $ 34,200 30,200 14,60 74,68 169, 35. 116.20 $16.20 $ 16,00 Merchandise purchases are paid in full during the month foliowing purchase Accounts payable for merchandise Durchases during March, which will be paid in April total 186.000 din preparing the cash budget, asume that me $48000 l will be made in April and repaid in June, Interest on the loan wilt $840 Required 1. Calculate the expected cash collections for Art, May, and one and for the three months in tota 2. Prepare a cash budpet by month and in total, for the three month period Complete this question by entering your answers in the tabs below. Nad 44 _ F * 28 Z X N command 96 # Winde Ok. Check Chos 4 On April the start of the loan pervoa, the cash balance will be $38.500 Accounts receivble on Apt will tot $48.400, of which $2200 will be collected during April and $16.960 will be collected during May. The remainder will be uncollectible Past experience shows that 30% of a marth's as recobected in the month of sale 60% in the morfolowing sale, and in the second month following sale. The other is bad brever collected. Budited sales and expenses for the three month period follow Sates to account Merchase purchases Payroll Lease pays Advertising et purchases Depreciation May June $430,000 $450,000 $127.000 1315,000 $13,000 $163.000 $ 21,400 121,400 $ 19,00 136,200 $ 34,200 30,200 14,60 74,68 169, 35. 116.20 $16.20 $ 16,00 Merchandise purchases are paid in full during the month foliowing purchase Accounts payable for merchandise Durchases during March, which will be paid in April total 186.000 din preparing the cash budget, asume that me $48000 l will be made in April and repaid in June, Interest on the loan wilt $840 Required 1. Calculate the expected cash collections for Art, May, and one and for the three months in tota 2. Prepare a cash budpet by month and in total, for the three month period Complete this question by entering your answers in the tabs below. Nad 44 _ F * 28 Z X N command 96 #