Please could someone help me to prepare the cash budget for the months of October, November and December noting any needed financing required or excess cash available, for the company below. Please include your workings. Many thanks in advance!

PPBM03T 15 May/June 2019 [15 marks] QUESTION 3 Brandao, a financial analyst for Nair's Restaurant in Pretoria, has prepared the following sales (income) and cash disbursement (expenses) estmates for the period August through December of the current year 2018 Sales (receipts) Disbursements (expenses) 300 000 Month August September October November December 400 000 500 000 500 000 500 000 600 000 700 000 400 000 500 000 700 000 The following additional information applies to Nair's Restaurant 90% of sales are made for cash and the remaining 10% are made one month later 1 2 Most disbursements (expenses) are on a cash basis Additionally, a bad debts estimate of R1 000 per month has to be included to the company's disbursements figure The business plans to buy and pay for a new delivery van in November The cost of this van will be R15 000 However, the company will trade-in an exIsting van valued at R4 000 as part of the deal The firm wishes to maintain a monthly minimum cash balance of R50 000 5 The beginning cash balance for September is R25 000 REQUIRED Prepare a cash budget for the months of October, November and December noting any needed financing required or excess cash available Use the space provided here below to conduct your preliminary calculations and complete your cash budget in the space provided below (a) (15) PRELIMINARY CALCULATIONS TURN OVER]