1. Assuming that the fimm has a cash balance of $23,000 at the beginning of November, detemine the end-ot-month cash baiances for each month, November theough Afri Complefe the November cash busget for Xenocore, Inc beiow; (Round is the nearest doliar) More info (Click on the icon located on the top-right cemer of the date table beiow in order to copy ti conterts into a upreadsheet.) Total cash receipts \begin{tabular}{lllll} \hline Forecast Purchases & $ & 117,000$ & 148,000$ & $140,000 \\ \hline Cash purchases & & & $ \\ \hline \end{tabular} Payments \begin{tabular}{ll|} Lag 1 month \\ Lag 2 month & $ \\ Salaries and wages & \\ Rent & $ \\ Interest payments & $ \\ Principal payments & $ \\ Dividends & $ \\ Taxes & $ \\ Purchases of fixed assets & $ \\ Total cash disbursements & $ \\ Net cash flow & $ \\ Add: Beginning cash & $ \\ Ending cash & $ \end{tabular} 1. Assuming that the fimm has a cash balance of $23,000 at the beginning of November, detemine the end-ot-month cash baiances for each month, November theough Afri Complefe the November cash busget for Xenocore, Inc beiow; (Round is the nearest doliar) More info (Click on the icon located on the top-right cemer of the date table beiow in order to copy ti conterts into a upreadsheet.) Total cash receipts \begin{tabular}{lllll} \hline Forecast Purchases & $ & 117,000$ & 148,000$ & $140,000 \\ \hline Cash purchases & & & $ \\ \hline \end{tabular} Payments \begin{tabular}{ll|} Lag 1 month \\ Lag 2 month & $ \\ Salaries and wages & \\ Rent & $ \\ Interest payments & $ \\ Principal payments & $ \\ Dividends & $ \\ Taxes & $ \\ Purchases of fixed assets & $ \\ Total cash disbursements & $ \\ Net cash flow & $ \\ Add: Beginning cash & $ \\ Ending cash & $ \end{tabular}