need help on finding excess cash balance

Save Homework: Finance Homework 1 Question 6, P4-10 simil. HW Score: 48,39% 29.01 f60 points Foto 10 O Points of 6 Cashbudget-Basie Grenoble Energies had sales of $40.000 in Marchand $39.000 in Art. Forecast for May Jun July are 170.300.379.000.000 espect Thermos con wishes to maintain a minimum cash balance of $4.500.Given the following data prepared Werpretach budget for a month of May, June and 11) The femmes 24 of sale for cash, rected in the next month, and the remaning to recolected in the second month ang sa The firm receives the income of $2,300 per month as the file can evenpechd purchases, as made for cash. 48.700,510,200, w $80.000 for the merita / May Though way, respectively 4) Rantis $3.000 per month Wages and salaries we 10% of the prevous month sales 5) Cash dividends of $3.000 will be patine 7) Payment of proper and were 300 denne 8) A cash purchase of equipment coming 56.500 is scheduled os Tasoft.000 are due inne S 0 3 1 3.000 We ardate Dividende 0 Princar and Phase equipment Te dua 0 Totalcain diments 58.600) ound to the nearest rar. Pesto put i the values in the table before checking your wors) March An May Net cathow 3 2140 A Beginning cash 44500 Ending cath Minimum 4500 Required to racing payo $ Exchange marketable secte) $ 5 1640 $ 0 4140 Clear Final che in this Vinwan camole Get more help Save Homework: Finance Homework 1 Question 6, P4-10 simil. HW Score: 48,39% 29.01 f60 points Foto 10 O Points of 6 Cashbudget-Basie Grenoble Energies had sales of $40.000 in Marchand $39.000 in Art. Forecast for May Jun July are 170.300.379.000.000 espect Thermos con wishes to maintain a minimum cash balance of $4.500.Given the following data prepared Werpretach budget for a month of May, June and 11) The femmes 24 of sale for cash, rected in the next month, and the remaning to recolected in the second month ang sa The firm receives the income of $2,300 per month as the file can evenpechd purchases, as made for cash. 48.700,510,200, w $80.000 for the merita / May Though way, respectively 4) Rantis $3.000 per month Wages and salaries we 10% of the prevous month sales 5) Cash dividends of $3.000 will be patine 7) Payment of proper and were 300 denne 8) A cash purchase of equipment coming 56.500 is scheduled os Tasoft.000 are due inne S 0 3 1 3.000 We ardate Dividende 0 Princar and Phase equipment Te dua 0 Totalcain diments 58.600) ound to the nearest rar. Pesto put i the values in the table before checking your wors) March An May Net cathow 3 2140 A Beginning cash 44500 Ending cath Minimum 4500 Required to racing payo $ Exchange marketable secte) $ 5 1640 $ 0 4140 Clear Final che in this Vinwan camole Get more help