Help for the required part

1. Cash Budget (50 points) 0:19.90 0.0.3-nollenime Street 8 Company is preparing a cash budget for the first 3 months of 2 Dividend income of P150,000 on stock investment should be collected in March. E month cash fixed operating expenses must be paid in the amount of P210,0 Collections on accounts receivable are estimated as follows: 60 percent collected in the month of sale 25 percent collected in the month following the sale 15 percent collected in the second month following the sale Payment for merchandise purchases are scheduled so that 70 percent of th payments are made in the month of purchase, with the balance paid in the followin month. The cash balance is estimated at P175,000 for January 1, 2020. Estimate sales and purchases by month are as follows: Net Sales Purchases. Purchases Net Sales ommydimasak Nov. 2019 P560,000 P320,000 Feb. 2020 P700,000 P400,000 Dec. 2019 550,000 380,000 March 2020 650,000 3.80.000 Jan. 2020 640,000 420,000 April, 2020 580,000 350 Income tax payment of P100,000 to be made in January and P150,000 for asset acquisition on March. A bond payable principal payment of P80,000 will be made in February with interest of P10,000 added. Required: Prepare a Cash Budget for each month of the first quarter of 2020 and total first quarter for 2020. A minimum cash balance of P150,000 every end of each month should be maintained. Any cash deficiency, a short term loan at 12 percer per annum interest, in multiples of P25,000 maybe availed at the beginning of th month and will be repaid if cash is available at the end of the month. 1. Cash Budget (50 points) 0:19.90 0.0.3-nollenime Street 8 Company is preparing a cash budget for the first 3 months of 2 Dividend income of P150,000 on stock investment should be collected in March. E month cash fixed operating expenses must be paid in the amount of P210,0 Collections on accounts receivable are estimated as follows: 60 percent collected in the month of sale 25 percent collected in the month following the sale 15 percent collected in the second month following the sale Payment for merchandise purchases are scheduled so that 70 percent of th payments are made in the month of purchase, with the balance paid in the followin month. The cash balance is estimated at P175,000 for January 1, 2020. Estimate sales and purchases by month are as follows: Net Sales Purchases. Purchases Net Sales ommydimasak Nov. 2019 P560,000 P320,000 Feb. 2020 P700,000 P400,000 Dec. 2019 550,000 380,000 March 2020 650,000 3.80.000 Jan. 2020 640,000 420,000 April, 2020 580,000 350 Income tax payment of P100,000 to be made in January and P150,000 for asset acquisition on March. A bond payable principal payment of P80,000 will be made in February with interest of P10,000 added. Required: Prepare a Cash Budget for each month of the first quarter of 2020 and total first quarter for 2020. A minimum cash balance of P150,000 every end of each month should be maintained. Any cash deficiency, a short term loan at 12 percer per annum interest, in multiples of P25,000 maybe availed at the beginning of th month and will be repaid if cash is available at the end of the month