Please assist

Teen Rovers, Helen's Fashion Designs pintores a line of cred from here has esimene the following forms for the firm for par af 2014 and 2015 Emales regarding payments chained from the credit department are as follows collected within the most of sale collected themonth foring the sale, 75 collected the second month following the sale. 155 Payments for labor and materials are made theme after the services were provided are the imated costs of labor plus raw materials May 2014 590,000 June 90,000 May 2014 $180,000 180.000 My 300.000 laly 540.000 126100 862.000 Augu August September October 720,000 September 305 IX October 234.000 November 360.000 November 162.000 90,000 December 90,000 December January 2015 190.000 General and administrative salaries are aproximately $27.000 a month. Lease payments under long term leases are $9.000 a month Depreciation charges are 536,000 a month Miscellaneous expenses are $2,700 a month. Income tax payments of $63.000 are due in September and December. A progress payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of 590.000 should be maintained throughout the cash budget period. a) Prepare a monthly cash budget for the last 6 months of 2014. b) Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to invest. c) Now suppose receipts from sales come in uniformly during the month (that is cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the Sth. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. Teen Rovers, Helen's Fashion Designs pintores a line of cred from here has esimene the following forms for the firm for par af 2014 and 2015 Emales regarding payments chained from the credit department are as follows collected within the most of sale collected themonth foring the sale, 75 collected the second month following the sale. 155 Payments for labor and materials are made theme after the services were provided are the imated costs of labor plus raw materials May 2014 590,000 June 90,000 May 2014 $180,000 180.000 My 300.000 laly 540.000 126100 862.000 Augu August September October 720,000 September 305 IX October 234.000 November 360.000 November 162.000 90,000 December 90,000 December January 2015 190.000 General and administrative salaries are aproximately $27.000 a month. Lease payments under long term leases are $9.000 a month Depreciation charges are 536,000 a month Miscellaneous expenses are $2,700 a month. Income tax payments of $63.000 are due in September and December. A progress payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of 590.000 should be maintained throughout the cash budget period. a) Prepare a monthly cash budget for the last 6 months of 2014. b) Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to invest. c) Now suppose receipts from sales come in uniformly during the month (that is cash receipts come in at the rate of 1 30 each day), but all outflows must be paid on the Sth. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects