As the financial manager of Gabex Solutions, prepare the Cash flow forecast for the second quarter of 2023, April - July 2023. The accounting department provided the following actual and forecasted sales and cost of sales figures for the required period: Additional information: - The closing bank balance as of 31 March 2023 amounted to R7 049025. - The monthly minimum cash balance requirement is set at R3 132900 . - The monthly sales are: 65% cash sales and - 35% credit sales, collected: - 20% collected 30 days after sales - 10% collected 60 days after sales - 4% collected 90 days after sales - 1% written off as irrecoverable - The monthly cost of sales: 40% wages which gets paid every month on the last day of the month and 60% relate to inventory purchases, paid: - 70% paid 30 days after purchase - 30% paid 60 days after purchase - Sales commission is paid at 13% of monthly sales; this is paid the month after the sales occurred. - Other fixed operating and administration expenses get paid in cash monthly and is estimated to be R3 132900 month. - A provisional tax payment of R1 044300 will be due at the end of June. - The company's dividend policy is to pay a dividend in the second month of each quarter. A dividend will only be paid if the cash balance at the end of the month prior to the month of payout is in excess of double the monthly minimum cash balance requirement. In such a case, 25% of the available cash at the end of the month prior to the payout, after considering the current month's costs, will be paid out as a dividend. Required: Using the provided information above, prepare a detailed Cash Budget in Excel for Gabex Solutions for the period April to June 2023. The Cash Budget should include the following: - A worksheet area on a separate sheet. This area should be used to calculate your cash collections and payment from debtors and supplies for each month. Make use of the following format: - After completing the worksheet area, prepare the actual Cash budget on a separate Excel sheet and make use of the necessary calculations and information to complete the Cash Budget. Make use of the following format: - Add a notes area to the sheets where necessary, to reference relevant formulas to. - Make use of an IF function to Calculate the potential Dividend payment in the dividend payment month. - Make use of an IF function to Calculate the potential Borrowing for each month