The finance manager wants to prepare a cash budget until June $2024.$ The finance manager has received the following information from the marketing and operations managers:

The sales in October $2023$ were $$150,000.$ The finance department has determined that, based on the past sales data and near$-$term market conditions, it may be reasonable to expect that sales will grow by a modest $1\%$ each month.

The credit department expects:

a$.60\%$ of the sales each month to be collected in the same month.

b$.38\%$ of the sales to the collected in the following month.

c$.2\%$ of the sales will not be collected $($bad debts$)$

The Accounts Department expects the cost of raw materials to be $45\%$ of sales for each month.

The company pays the suppliers as follows:

a$.50\%$ of the purchases are paid in the same month.

b$.$ Remaining $50\%$ of the purchases are paid in the following month.

Wages and Salaries are $$60,000$ each month and paid in the same month.

Depreciation expense is $$25,000$ each month.

The company will pay taxes of $$45,000$ in the month of April.

The company is expected to purchase a new machine worth $$50,000$ in May $2024.$ It is expected to pay for the machine in two equal instalments in May $2024$ and in June $2024.$

The company pays rent of $$12,000$ monthly.

The company has an outstanding loan. The company pays an interest of $$18,000$ in March and an another $$18,000$ in September each year.

Questions:

$1.$ Determine the total cash inflows until June $2024.$ Show your work in Excel.

$2.$ Determine the total cash outflows until June $202.$ Show your work in Excel.

$3.$ Determine the expected change in cash until June $2024.$ Show your work in excel.

$4.$ Assume that the begining balance in january $2024$ is $$8000$ and the target cash balance each month us $$10,000.$ Determine the excess cash or loan needed for january $2024-$june $2024.$ Show work in excel.