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 Novermber 2019 through Apri 2020, follow (1). The fim makes 12% of all sales for cast and colects on 44% of 3 s sales in each of the 2 months following the sale, Other cash inflows are expected to be $11,000 in Seplember and Apeil, $15,000 in danuary and March, and $26,000 in February. The firm pays cash for 12% of its purchases. It pays for 53% of its purchases in the following month and for 35% of ts purchases 2 months later. Wages and salakies amount to 22% of the preceding month's sales. Remt of $10,000 per month must be pald. Interest payments of $9,000 are due in Lanuary and Apri. A principal payment of $28,000 is also due in Apol. The firm expects 10 pay cash dividends of $19,000 in January and April. Taxes of $78,000 are due in Apri. The firm also intends to make a $24,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $23,000 at the beginning of November, determine the end-ol-month cash balances for each month, November through April. b. Assuming that the fim wishes 10 maintain a $16,000 minimum cash baiance, determine the roquired total financing crescess cash balance for each month, November through April. c. If the firm were requesting a line of credt to cover needed francing for the period Nowember to Apel, how large would this line have to be? Explain your answer. 2. Assuming that the firm has a cath balance of $23,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: (Fiound to the nearest dolac) Rent Interest payments Principal payments Dividends Taxes Purchases of fixed assets Total cash disbursements Net cash flow Add: Beginning cash Ending cash \begin{tabular}{lr} $ & 1y,000 \\ $ & 0 \\ $ & 0 \\ $ & 0 \\ $ & 0 \\ $ & 0 \\ \hline$ & 197090 \\ \hline$ & 17390 \\ \hline$ & 23,000 \\ \hline$ & 40390 \\ \hline \hline \end{tabular} More info (Click on the icon here a spreadsheet.)