Cash budget-Advanced The actual sales and purchases for Xenocore, Inc., for September and October 2010 Nong with its forecasts and purchases for the period November 2010 through Aont 2020, follow 6. The firm makes 18% of all sales for cash and collects on 41% of its sales in each of the 2 months following the sale Omer sahifows are expected to be $12,000 in September and Art $15.000 in Jay and March, and 529,000 in February. The firm pays cash for 10% of its purchases. It pays for 49% of its purchases in the following month and for 41% of its purchases 2 months later. Wages and salaries around 18% of the preceding month's sales Rent of $19,000 per month must be paid Interest payments of $12.000 are due in January and April. A principal payment of $34.000 is also due in Aarl. The form expects to say cash dividends of $19,000 in January and Art Taxes of $4,000 are due in Aort. The film also intends to make a $24.000 cash purchase of fored assets in December a. Assuming that the firm has a cash balance of $21,000 at the beginning of November, determine the end-of-month canh balansors for each month November through April b. Assuming that the firm wishes to maintain a $15.000 minimum cash balance, determine the required total financing or excels cash balance for each month November through Apt. e. If the firmware requesting a line of credit to cover needed financing for the period November to April, how loon would this to have to be? Explain your aniwa 1. Assuming that the fet ha a can balance of $21,000 at the beginning of November, determine the end of month canh balances for each monti, November to enl. Complete the November cath butt for Xenocore, Ine below (Round to the to the nero dolor.) More Info (Click on the conhece order to copy the contents of the datatable below into a spreadshot) Month Sales Purchase 2010 September $215,000 $115,000 2010 October 254,000 148,000 2019 November 100,000 2019 December 150,000 97.000 2920 January 145,000 82,000 2020 February 179,000 110,000 2020 March 203.000 100,000 2020 April 250.000 85,000 143.000 Dong