Answer to Question #145356 in Financial Math for Auguste Nkole

Question

The actual sales figures of 2018: November N$80 000, December N$90 000, budgeted figures for 2019 are : January N$75 000,February N$75 000, March N$80 000, debtors are: 60% within the month of sale, 25% within the first month after sale, 15% within the second month after sale, actual purchases figures for 2018: November N$50 000,December N$60 000, Purchases for 2019: January N$55 000, February N$45 000, March N$55 000, All purchases are on credit and experience shows that 90% are settled in the month of purchase and the balance settled during the following month. Overheads of N$20 000 per month (including N$5 000 depreciation) are settled monthly. Taxation of N$8 000 has to be paid in February and the company will receive settlement of an insurance claim of N$25 000 in March. The company estimates that it will have a favourable bank balance of N$81 250 on 31 March 2019.Required: Prepare a Cash Budget for the months January, February, and March 2019 in column format.

Answer 1

Dear Auguste Nkole, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order