If you could fill out the cash budget for Xenocore, Inc. and explain how you got those values that would be very helpful in filling out the other months.

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.) Year 2015 2015 2015 2015 2016 2016 2016 2016 Month September October November December January February March April Sales $206,000 254,000 168,000 164,000 140,000 184,000 201,000 254,000 Purchases $122,000 148,000 145,000 102,000 83,000 112,000 95,000 87,000 Complete the December cash budget for Xenocore, Inc. below: (Round to the nearest dollar.) Xenocore, Inc Nov $ 254,000 $ 168,000 $ 164,000 Oct Dec Forecast sales Cash sales Collections Lag 1 month