Fill in the missing cells in the following cash budget. Interpret the values for NCF and the ending

cash position.

Develop a cash budget for the next two months using the following information:

Monthly sales forecasts are $$210,000$ and $$30,000$ for the next two months

Sales in the current month were $$140,000$

$80$ percent of sales are collected in the month of sale, with the remainder collected in the follow$-$

ing month

Cost of goods sold equal $70$ percent of sales

The monthly lease payment is $$75,000$

The cash position at the end of the current month is $$70,000$

The target cash balance is $$40,000$