Prepare a cash budget for the above mentioned data please

ASMT 2 ACC5201 202110 KD tourism class - Word ? FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW VIEW Microsoft account 3.1 Preparing a cash budget: Salama and friends have requested your assistance in calculating the cash budget for the next few months. They are concerned that the business often doesn't have money available in their bank account. They have provided you with the following information Budgeted sales for -August: AED 388,200 -September: AED 421,800 -October: AED 585,000 - November: AED 922,000 -December: AED 850,500 Based on previous information, they predict 50% of their sales are cash sales. -Credit sales are received two months after the sale. Salama & friends purchases their items from The Sweet Shop. 60% of their purchases are cash purchases and the other 40% are on credit. -Credit Purchases are paid in the month following the transaction. Total purchases: September: AED 110,600; -October: AED 150,800; -November: AED 130,600; -December: AED 170,200; - January: AED 188,600 They are planning on taking out a loan in November for AED 250 000. The loan repayments will start on the 1st December, calculated at 3%p.a of the loan amount. Wages are paid in the month they occur, and the following information has been provided: October: AED 97,000; November: AED 102,000; December: AED 104,500. The company plans to buy machinery in November for AED 67,000 The bank balance on the 1 October is expected to be AED 38,000 PAGE 8 OF 10 1351 WORDS DE ENGLISH (UNITED KINGDOM) E ES 110% e WE EN 5:13 PM 11/12/2020 ? FILE HOME INSERT DESIGN PAGE LAYOUT ASMT 2 ACC5201 202110 KD tourism class - Word REFERENCES MAILINGS REVIEW VIEW Assessment No. 2 Microsoft account TASK C 3.1 Preparing a cash budget: Salama and friends have requested your assistance in calculating the cash budget for the next few months. They are concerned that the business often doesn't have money available in their bank account. They have provided you with the following information Budgeted sales for -August: AED 388,200 -September: AED 421,800 October: AED 585,000 -November: AED 922,000 -December: AED 850,500 Based on previous information, they predict 50% of their sales are cash sales. . -Credit sales are received two months after the sale. Salama & friends purchases their items from The Sweet Shop. 60% of their purchases are cash purchases and the other 40% are on credit -Credit Purchases are paid in the month following the transaction. Total purchases: -September: AED 110,600; -October: AED 150,800; -November: AED 130,600, -December: AED 170,200; -January: AED 188,600 They are planning on taking out a loan in November for AED 250 000. The loan repayments will start on the 1st December, calculated at 3%p.a of the loan amount. Wages are paid in the month they occur, and the following information has been provided: October: AED 97,000; November: AED 102,000, December: AED104.500 The company plans to buy machinery in November for AED 67,000 The bank balance on the 1 October is expected to be AED 38,000 ES + 70% PAGE 8 OF 10 1350 WORDS [ENGLISH (UNITED KINGDOM) e WT EN 4:25 PM 11/12/2020