Additional Information:

3. Capital expenditure to be incurred on 22 February 2021 is expected to amount to $470,000.

4. Sales of plant and equipment on 13 March 2021 are expected to rise to $30,000 in cash.

5. The cash at the bank in hand on January 1, 2021, is expected to be $15,000.

Required:

***Prepare Kholson Ltd.s cash budget for each of the three months during the quarter ending 31 March 2021.

***Please answer the question using the Excel templates given below.***

Question 1 The following budget information relates to Khelson Ltd. for the three months to 31 March 2021: Budgeted Cash Flow Statement For the period ended January, February and March 2011 CASH INFLOWS Change in Debtors Sale of Properties, Plant and Equipment Sale of Short Term Investments CASH OUTFLOW Trade Payables Other Creditors Capital Expenditure Purchase of Short Term Investments Tax Dividends Monthly Net Cash Flow Opening Balance Closing Balance Workings for Purchases \begin{tabular}{|l|l|l|l|} \hline COGS & January & February & March \\ \hline Ending Inventory & & & \\ \hline Beginning Inventory Purchases for the month & & \\ \hline & & & \\ \hline \end{tabular}