I don't understand how you get the values of the beginning balance for Dec - Apr with simply the info from part a. where it notes november's cash balance is 20,000$. Not sure how to calculate the remaining months (dec - apr) i have all my forecasted sales and purchases but am stuck on the bottom portion after total cash disbursements. PLEASE EXPLAIN THE NET CASH FLOW, BEGINNING CASH (how you got the values) and ending cash. thank you soooooo much.

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 a The firm makes 20% of all sales for cash and collects on 40% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $11,000 in September and April, $17,000 in January and March, and $25,000 in February. The firm pays cash for 10% of its purchases. It pays for 45% of its purchases in the following month and for 45% of its purchases 2 months later. Wages and salaries amount to 18% of the preceding month's sales. Rent of $18,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 $22,000 in January and April. Taxes of $84,000 are due in April. The firm also intends to make a $26,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. 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.) Xenocore, Inc. Oct Nov Sept 213,000 $ Forecast sales $ 249,000 $ 167,000 33400 Cash sales $ Collections $ 99600 $ 85200 Lag 1 month Lag 2 month Other cash receipts Total cash receipts $ $ 218200 Forecast Purchases $ 117,000 $ 151,000 $ 135,000 $ Cash purchases Payments Lag 1 month Lag 2 month $ $ Enter any number in the edit fields and then continue to the next question. More Info e in order to copy the contents of the data table below into a (Click on the icon here spreadsheet.) Year 2019 2019 2019 2019 2020 2020 2020 2020 Month September October November December January February March April Sales $213,000 249,000 167,000 162,000 145,000 180,000 203,000 245,000 Purchases $117,000 151,000 135,000 101,000 78,000 107,000 97,000 88,000 Print Done