Please find the below attached question and give the answer properly.

Prepare monthly cash budget for six months beginning from April 2017 on the basis of the following information:- (1) Estimated monthly sales are as follows:- (*) January 1,00,000 June 80,000 February 1,20,000 July 1,00,000 March 1,40,000 August 80,000 April 80,000 September 60,000 | May 60,000 October 1,00,000 (Wages and salaries are estimated to be payable as follows:- April 9,000 July 10,000 May 8,000 August 9,000 June 10,000 September 9,000 (it) of the sales, 80% is on credit and 20% for cash. 75% of the credit sales are collected within one month and the balance in two months. There are no bad debt losses. (iv) Purchases amount to 80% of sales and are made on credit and paid for in the month preceding the sales. (V) The firm has 10% debentures of 1,20,000. Interest on these has to be paid quarterly in January, April and so on. (V) The firm is to make an advance payment of tax of 3 5,000 in July, 2017. (vii) The firm had a cash balance of 3 20,000 on April 1, 2017, which is the minimum desired level of cash balance. Any cash surplus/deficit above/below this level is made up by temporary investments/liquidation of temporary investments or temporary borrowings at the end of each month (interest on these to be ignored)