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 . The firm makes 24% of all sales for cash and collects on 38% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $12,000 in September and April, $17,000 in January and March, and $27,000 in February. The firm pays cash for 8% of its purchases. It pays for 53% of its purchases in the following month and for 39% of its purchases 2 months later. Wages and salaries amount to 19% of the preceding month's sales. Rent of $18,000 per month must be paid. Interest payments of $11,000 are due in January and April. A principal payment of $31,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $75,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 $21,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 $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April 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. a. Assuming that the firm has a cash balance of $21,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.) Oct Nov Xenocore, Inc. Sept 208,000 $ $ 250,000 $ $ $ 173,000 More info Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts $ (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $ $ $ Forecast Purchases $ 121,000 $ 153,000 $ 135,000 Year 2019 2019 2019 2040 2019 2020 2020 2020 2020 Month September October November December January February March April Sales $208,000 250,000 173,000 159,000 140,000 176,000 196,000 253,000 Purchases $121,000 153,000 135,000 99,000 82,000 114,000 98,000 86,000 $ Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent $ $ $ S $ $ $ Print Done Interest payments Principal payments $ Dividends Taxes $ Purchases of fixed assets $ $ Total cash disbursements Net cash flow S Add: Beginning cash S $ Ending cash $ Cash budget-Advanced the actual sales and purchases for Xcncore, Inc. for September and October 2019. along with ts forccasi sales and suchecs for the pricd Noremcr 2015 trough Apl2020. w . Thim makes 24 cal sales forces and oclck cn 25% vis sales in cach of the 2 months following the sale orecaci infons AH Spal: $12000 - Apr $12,00 in. Ana Mand, Farhry. The impacto libe perstry for 28%. I primi la mare rolux 2 meelbul J19changer HR $18 CIE W tm. to paid Interspayons of 511.000 are dupanuary and il aprinda payment of $31.000 is also due in April. Thom exposto pay cach chords of 20000 in January and Apr. Taxes or 575.000 are duo in April. The imas miendo lo make a $26.GOO cash p-rc-asp of bod wat in December ..suring the most $21.CO.I ang al Nachwuch Contour chal, Newrough April Asuming to their wishes to a man a $15.com-un banco delom in the cured loannig ar ces chance for asch month November througe pril c. tren were requesting a line of creditor necded Trading for the cricd Normer Ari, new large would ta line has to bc? Explain your arawr 1. Luring the im ex H21CO. Ingol Ninth Cance for cl, New Rough Compiero Nomber cach budget for encoreInc. below: Roud to rosesl doilari Xenocore, Inc Scpc at Noy S 205,000 5 200.000 5 173,000 5 3 Focact sa os CON 5 5 3 3 S $ 121,000 3 163.000 3 5 195.000 $ 3 Lag 1 month Lag 2 month Cther cash rcceps Teld For Purchases Cash purchas Le 1 oth Lag 2 month Sebarkada Real Innerst payoris Principal parents Diw T : Punte fatal THIN Not cash w Add Degiming cah Endng cash $ $ 3 $ $ 5 5 $ 5 5 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 . The firm makes 24% of all sales for cash and collects on 38% of its sales in each of the 2 months following the sale. Other cash inflows are expected to be $12,000 in September and April, $17,000 in January and March, and $27,000 in February. The firm pays cash for 8% of its purchases. It pays for 53% of its purchases in the following month and for 39% of its purchases 2 months later. Wages and salaries amount to 19% of the preceding month's sales. Rent of $18,000 per month must be paid. Interest payments of $11,000 are due in January and April. A principal payment of $31,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April. Taxes of $75,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 $21,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 $15,000 minimum cash balance, determine the required total financing or excess cash balance for each month, November through April 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. a. Assuming that the firm has a cash balance of $21,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.) Oct Nov Xenocore, Inc. Sept 208,000 $ $ 250,000 $ $ $ 173,000 More info Forecast sales Cash sales Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts $ (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $ $ $ Forecast Purchases $ 121,000 $ 153,000 $ 135,000 Year 2019 2019 2019 2040 2019 2020 2020 2020 2020 Month September October November December January February March April Sales $208,000 250,000 173,000 159,000 140,000 176,000 196,000 253,000 Purchases $121,000 153,000 135,000 99,000 82,000 114,000 98,000 86,000 $ Cash purchases Payments Lag 1 month Lag 2 month Salaries and wages Rent $ $ $ S $ $ $ Print Done Interest payments Principal payments $ Dividends Taxes $ Purchases of fixed assets $ $ Total cash disbursements Net cash flow S Add: Beginning cash S $ Ending cash $ Cash budget-Advanced the actual sales and purchases for Xcncore, Inc. for September and October 2019. along with ts forccasi sales and suchecs for the pricd Noremcr 2015 trough Apl2020. w . Thim makes 24 cal sales forces and oclck cn 25% vis sales in cach of the 2 months following the sale orecaci infons AH Spal: $12000 - Apr $12,00 in. Ana Mand, Farhry. The impacto libe perstry for 28%. I primi la mare rolux 2 meelbul J19changer HR $18 CIE W tm. to paid Interspayons of 511.000 are dupanuary and il aprinda payment of $31.000 is also due in April. Thom exposto pay cach chords of 20000 in January and Apr. Taxes or 575.000 are duo in April. The imas miendo lo make a $26.GOO cash p-rc-asp of bod wat in December ..suring the most $21.CO.I ang al Nachwuch Contour chal, Newrough April Asuming to their wishes to a man a $15.com-un banco delom in the cured loannig ar ces chance for asch month November througe pril c. tren were requesting a line of creditor necded Trading for the cricd Normer Ari, new large would ta line has to bc? Explain your arawr 1. Luring the im ex H21CO. Ingol Ninth Cance for cl, New Rough Compiero Nomber cach budget for encoreInc. below: Roud to rosesl doilari Xenocore, Inc Scpc at Noy S 205,000 5 200.000 5 173,000 5 3 Focact sa os CON 5 5 3 3 S $ 121,000 3 163.000 3 5 195.000 $ 3 Lag 1 month Lag 2 month Cther cash rcceps Teld For Purchases Cash purchas Le 1 oth Lag 2 month Sebarkada Real Innerst payoris Principal parents Diw T : Punte fatal THIN Not cash w Add Degiming cah Endng cash $ $ 3 $ $ 5 5 $ 5 5