Assumption Inputs1Beginning cash balance in May (and the minimum ending cash for each month) 9002Sales in March 48,0003Sales are expected to grow at 5%4the % of sales as CoD (cash/cheque on delivery) 30%5the % of sales collected in the first month after the sale 30%6the % of sales collected in the second month after the sale 40%7Inventory purchases as the % of the following month's sales 65%8Manpower and fixed costs as the % of the current moth's sales 17%9Rent payment each month 5,50010Any borrowing in the current month will be paid back next month 11Monthly interest cost (payable next month) on the borrowed amount 3.5%Required: Prepare a cush budget from May to August applying the following requirements -The relevant worksheet for this task is 'A1_cash_budget' (The main layout of the table is provided, you need to input assumptions and build formulas)-Apply Red coloured conditional formatting to negative figures and their cells,-Use Arial font 11; 000 comma separated, no decimals, for currency