hi can I have help with this question please

questions 1 and 2 A1_cash_budget A2_fin_projection To uestion1) Bristol Pic is founded in 1st March. The same day, you are given the following cash budget assumptions No Assumption Inputs 1 Beginning cash balance in May (and the minimum ending cash for each month) $900 N Sales in March E48,000 3 Sales are expected to grow at 5% the % of sales as CoD (cash/cheque on delivery) 30% the % of sales collected in the first month after the sale 30% the % of sales collected in the second month after the sale 40% 7 Inventory purchases as the % of the following month's sales 65% 8 Manpower and fixed costs as the % of the current moth's sales 17% 9 Rent payment each month 25,500 10 Any borrowing in the current month will be paid back next month 11 Monthly interest cost (payable next month) on the borrowed amount 3.5% equired: 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 in Apply Red coloured conditional formatting to negative figures and their cells, - Use Arial font 11; 000 comma separated, no decimals, f for currency (40 marks)