PLEASe solve and show steps

a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. Complete the November cash budget for Xenocore, Inc. below:(Round to the nearest dollar.)

Complete the December cash budget for Xenocore, Inc. below:(Round to the nearest dollar.) Xenocore, Inc. Oct Nov Dec Forecast sales $ 246,000 $ 165,000 $ 158,000 Cash sales $ Collections Lag 1 month $ Lag 2 month $ Other cash receipts $ Total cash receipts $ Forecast Purchases $ 155,000 $ 137,000 $ 102,000 Cash purchases $ Payments 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 $ Part 3 Complete the January cash budget for Xenocore, Inc. below:(Round to the nearest dollar.) Xenocore, Inc. Nov Dec Jan Forecast sales $ 165,000 $ 158,000 $ 145,000 Cash sales $ Collections Lag 1 month $ Lag 2 month $ Other cash receipts $ Total cash receipts $ Forecast Purchases $ 137,000 $ 102,000 $ 81,000 Cash purchases $ Payments 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 $ Part 4 Complete the February cash budget for Xenocore, Inc. below:(Round to the nearest dollar.) Xenocore, Inc. Dec Jan Feb Forecast sales $ 158,000 $ 145,000 $ 182,000 Cash sales $ Collections Lag 1 month $ Lag 2 month $ Other cash receipts $ Total cash receipts $ Forecast Purchases $ 102,000 $ 81,000 $ 105,000 Cash purchases $ Payments 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 $ Part 5 Complete the March cash budget for Xenocore, Inc. below:(Round to the nearest dollar.) Xenocore, Inc. Jan Feb Mar Forecast sales $ 145,000 $ 182,000 $ 202,000 Cash sales $ Collections Lag 1 month $ Lag 2 month $ Other cash receipts $ Total cash receipts $ Forecast Purchases $ 81,000 $ 105,000 $ 103,000 Cash purchases ) $ Payments 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 $ Part 6 Complete the April cash budget for Xenocore, Inc. below:(Round to the nearest dollar.) Xenocore, Inc. Feb Mar Apr Forecast sales $ 182,000 $ 202,000 $ 248,000 Cash sales $ Collections Lag 1 month $ Lag 2 month $ Other cash receipts $ Total cash receipts $ Forecast Purchases $ 105,000 $ 103,000 $ 85,000 Cash purchases $ Payments 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 $

Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020, follow i]. The firm makes 14% of all sales for cash and collects on 43% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $10,000 in September and April, $16,000 in January and March, and $28,000 in February. The firm pays cash for 8% of its purchases. It pays for 45% of its purchases in the following month and for 47% of its purchases 2 months later. Wages and salaries amount to 22% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $9,000 are due in January and April. A principal payment of $35,000 is also due in April. The firm expects to pay cash dividends of $21,000 in January and April. Taxes of $81,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $17,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer. \begin{tabular}{llrr} Year & \multicolumn{1}{c}{ Month } & \multicolumn{1}{c}{ Sales } & \multicolumn{1}{c}{ Purchases } \\ \hline 2019 & September & $206,000 & $118,000 \\ 2019 & October & 246,000 & 155,000 \\ 2019 & November & 165,000 & 137,000 \\ 2019 & December & 158,000 & 102,000 \\ 2020 & January & 145,000 & 81,000 \\ 2020 & February & 182,000 & 105,000 \\ 2020 & March & 202,000 & 103,000 \\ 2020 & April & 248,000 & 85,000 \\ \hline \end{tabular} Cc arest dollar.) b. Assuming that the firm wishes to maintain a $17,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. Complete the table below: (Round to the nearest dollar.) c. The line of credit should be at least $ (Round to the nearest dollar. Type the full name of the month, e.g., February.) Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2019, along with its forecast sales and purchases for the period November 2019 through April 2020, follow i]. The firm makes 14% of all sales for cash and collects on 43% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $10,000 in September and April, $16,000 in January and March, and $28,000 in February. The firm pays cash for 8% of its purchases. It pays for 45% of its purchases in the following month and for 47% of its purchases 2 months later. Wages and salaries amount to 22% of the preceding month's sales. Rent of $20,000 per month must be paid. Interest payments of $9,000 are due in January and April. A principal payment of $35,000 is also due in April. The firm expects to pay cash dividends of $21,000 in January and April. Taxes of $81,000 are due in April. The firm also intends to make a $25,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month cash balances for each month, November through April. b. Assuming that the firm wishes to maintain a $17,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. c. If the firm were requesting a line of credit to cover needed financing for the period November to April, how large would this line have to be? Explain your answer. \begin{tabular}{llrr} Year & \multicolumn{1}{c}{ Month } & \multicolumn{1}{c}{ Sales } & \multicolumn{1}{c}{ Purchases } \\ \hline 2019 & September & $206,000 & $118,000 \\ 2019 & October & 246,000 & 155,000 \\ 2019 & November & 165,000 & 137,000 \\ 2019 & December & 158,000 & 102,000 \\ 2020 & January & 145,000 & 81,000 \\ 2020 & February & 182,000 & 105,000 \\ 2020 & March & 202,000 & 103,000 \\ 2020 & April & 248,000 & 85,000 \\ \hline \end{tabular} Cc arest dollar.) b. Assuming that the firm wishes to maintain a $17,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April. Complete the table below: (Round to the nearest dollar.) c. The line of credit should be at least $ (Round to the nearest dollar. Type the full name of the month, e.g., February.)