develop a dynamic $12-$month cash flow budgeting$/$forecasting tool.

Initial sales of $$1,000,000$ with forecasted monthly growth $2\%$

$20\%$ of sales are collected in month of sale.

$40\%$ of sales are collected the following month.

$25\%$ collected $2$ months later

$18\%$ collected $3$ months later

$2\%$ never collected

Initial cash balance of $$300,000$