Question

follow 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 $13,000 in September and April $17,000 in January and 000 in September and Apri, $17,000 in January and March, and $26,000 n February. The f pays cash for 9% of its purchases. It pays for 53% o s purchases in e o ing month and for 38% of its purchases 2 months later ages and s aries amount to 21% o he eding month's sales. Rent of $22,000 per month must be paid. Interest payments of $12.000 are due in January and April. A principal payment of $33,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $79,000 are due in April. The firm also intends to make a $27,000 cash purchase of fixed assets in December. a. Assuming that the firm has a cash balance of $22,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 S15,000 minimum cash balance, determine the required total financing or ex 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 xcess cash balance for each month, November through April a. Assuming that the firm has a cash balance of $22,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.)

I need help solving part b which is filling out the last table. I included the answer to part a and the forecast sales and purchases if that helps. Thank you!

Answer 1

	Xenocore Inc
	Nov	Dec	Jan	Feb	Mar	Apr
Ending Cash	30130	8000	-10710	53250	77620	17220
Minimum Cash balance	15000	15000	15000	15000	15000	15000
Required Total financing	0	7000	25710	0	0	0
Excess cash Balance	30130-15000= 15130	0	0	53250	77620	2220