Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the answer i put could be wrong so please answer the entire question Cash budget Advanced The actuales and purchase for Xerocore, Inc. for September

the answer i put could be wrong so please answer the entire question image text in transcribed
image text in transcribed
Cash budget Advanced The actuales and purchase for Xerocore, Inc. for September and October 2010. along with its forecast sales and purchases for the period November 2015 April 2000, follow The frin maks 18% of all sales for cash and colects on 41% of its sales in each of the 2 months following the sale. Other cash flows are expected to be $12.000 in September and Agri 515,000 in January and March, and $29.000 in February. The firm pays cash for 10% of its purchases pays for 49% of a purchases in the following month and for 41% of ts purchases 2 months later Wages and salaries amount to 18% of the preceding month's sales Rento 510.000 per month must be paid interest payments of $12.000 are due in January and April Aprincipal payment of 532.000 i due in April. The firm expecta to pay cash dividends of $19.000 in January and Apriles of $84.000 aree in April. The firm also intends to make a $24.000 cash purchase of feast in December 1. Assuming that the firm has a cath bilance of $21.000 at the beginning of November, demensomoth cash bales for each month November through April D. Assuming that the firm wishes to maintain a $15,000 minimum cash boomine the roured total financing or excess cash balance for each month November through Apel c. The firm were resting a line of credit to covered trading for the period November to April, how we would leave to be? Explain your answer Assuming at the fem has a cash balance of $21,000 at the beginning of November, determine the end of mon cash balances for each month November through Art. Complete the November cash budget for Xenocore, Inc. below Round to the nearest dolar) Xenocore, Inc Sept Oct Now Forecast 3 215.000 $ 254.000 5 100 000 Cash 1700 Coco Lagt mot 104,100 Lag 2 month 8.150 Omer cash recept $ Torel $ 230 Forca $ 115.000 1000 1 160.000 Chh 14.300 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 trough April 2000, follow 6. The firm makes 18% of all sales for cash and collects on 41% of is sales in each of the 2 months following the sale. Other cash inflows are expected to be $12.000 in September and April $15,000 in January and March, and $29,000 in February. The firm pays cash for 10% of its purchases pays for 49% of its purchases in the following month and for 41% of its purchases 2 months later Wages and Balanes amount to 18% of the preceding months sales Rent of $19,000 per month must be paid. Interest payments of $12.000 are due in January and Agri. A principal payment of $34,000 o duen Aarl Thermexpacts to pay cash avidends of $10,000 in January and April. Taxes of $84,000 are due in April. The female neds to make a $24.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 mon cash balances for each month November through April b. Assuming that the firm wishes to maintain a $15.000 minimum cash balance, dermine the required total financhor Ocash 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 fine have to be? Explain your answer Assuming at the firm has a cash balance of $21,000 at the beginning of November,Colorine e end of mich balances for anch month, November through April Complete the November cash budou for Xenocore, Inc below. (Round to the nearest dot. Sept Nov Xenocore, Inc. Oct 215,000 $ 254.000 $ $ $ 100.000 30,700 5 104,100 88,150 Torces Canon Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash burchases $ $ $ s 115.000 S 148.000 $ s. 230,000 543.000 14,300 Enter wy number in the edit fields and then continue to the next question Cash budget Advanced The actuales and purchase for Xerocore, Inc. for September and October 2010. along with its forecast sales and purchases for the period November 2015 April 2000, follow The frin maks 18% of all sales for cash and colects on 41% of its sales in each of the 2 months following the sale. Other cash flows are expected to be $12.000 in September and Agri 515,000 in January and March, and $29.000 in February. The firm pays cash for 10% of its purchases pays for 49% of a purchases in the following month and for 41% of ts purchases 2 months later Wages and salaries amount to 18% of the preceding month's sales Rento 510.000 per month must be paid interest payments of $12.000 are due in January and April Aprincipal payment of 532.000 i due in April. The firm expecta to pay cash dividends of $19.000 in January and Apriles of $84.000 aree in April. The firm also intends to make a $24.000 cash purchase of feast in December 1. Assuming that the firm has a cath bilance of $21.000 at the beginning of November, demensomoth cash bales for each month November through April D. Assuming that the firm wishes to maintain a $15,000 minimum cash boomine the roured total financing or excess cash balance for each month November through Apel c. The firm were resting a line of credit to covered trading for the period November to April, how we would leave to be? Explain your answer Assuming at the fem has a cash balance of $21,000 at the beginning of November, determine the end of mon cash balances for each month November through Art. Complete the November cash budget for Xenocore, Inc. below Round to the nearest dolar) Xenocore, Inc Sept Oct Now Forecast 3 215.000 $ 254.000 5 100 000 Cash 1700 Coco Lagt mot 104,100 Lag 2 month 8.150 Omer cash recept $ Torel $ 230 Forca $ 115.000 1000 1 160.000 Chh 14.300 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 trough April 2000, follow 6. The firm makes 18% of all sales for cash and collects on 41% of is sales in each of the 2 months following the sale. Other cash inflows are expected to be $12.000 in September and April $15,000 in January and March, and $29,000 in February. The firm pays cash for 10% of its purchases pays for 49% of its purchases in the following month and for 41% of its purchases 2 months later Wages and Balanes amount to 18% of the preceding months sales Rent of $19,000 per month must be paid. Interest payments of $12.000 are due in January and Agri. A principal payment of $34,000 o duen Aarl Thermexpacts to pay cash avidends of $10,000 in January and April. Taxes of $84,000 are due in April. The female neds to make a $24.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 mon cash balances for each month November through April b. Assuming that the firm wishes to maintain a $15.000 minimum cash balance, dermine the required total financhor Ocash 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 fine have to be? Explain your answer Assuming at the firm has a cash balance of $21,000 at the beginning of November,Colorine e end of mich balances for anch month, November through April Complete the November cash budou for Xenocore, Inc below. (Round to the nearest dot. Sept Nov Xenocore, Inc. Oct 215,000 $ 254.000 $ $ $ 100.000 30,700 5 104,100 88,150 Torces Canon Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash burchases $ $ $ s 115.000 S 148.000 $ s. 230,000 543.000 14,300 Enter wy number in the edit fields and then continue to the next

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions