hi can you help me solve this please

Question1) Bristol Plc is founded in 1st March. The same day, you are given the G Question1) 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) E900 2 Sales in March E48,000 3 Sales are expected to grow at 5% 4 the % of sales as CoD (cash/cheque on delivery) 30% 5 the % of sales collected in the first month after the sale 30% 6 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 E5,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% 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 (40 marks) Question2) Brown Pic is founded in 1st January 2021 (financial year end is 31 December) The questions 1 and 2 Al_cash_budget |A2_fin projection Total mark