Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cach budget Advanced The actual sales and purchases for Xenocore, Inc. for September and October 2019, along with its forecast sales and purchases for the
Cach 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 makas 18% of all sales for cash and collects on 41% of its sales in each of the 2 months following the sale. Other cash infons are spected to be $14.000 in September and April, $15,000 in January and March, and $25,000 in February. The firm pays cash for 95 of its purchases. It pays for 50% of its purchases in the following month and for 36% of its purchases 2 months later. Wages and salaries amount to 21% of the preceding month's sales. Rent of 20000 per month must be paid. Interest payments of S9,000 an de in January and Apri. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April Tous of $75,000 ane due in April. The film also intends to make a $24,000 cash purchase of ixed assets in December ..Acuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month auch balances for each month, November through Apri b. Assuming that the firm wishes to maintain a $13.000 minimum cash balance, determine the required total financing or excess cash balance for each month November through April Q. the firmware requesting a line of credit to cover nooded financing for the period November to April, how large would this line have to be? Explain your answer. Dividends s Purchases of found assets Total cash disbursements $ 212,380 Not cash flow 20,000 Add Beginning cash 24.490 Encing cash Complete the December cash budget for Xenocore, Inc. below. Round to the nearest dollar) S O $ 5 Yanooore, Ing. Oot Now $ 245,000 5 173,000 $ Deo 155.000 Forecast salos 5 $ $ S 5 $ $ 52,000 $ 137,000 $ 106,000 Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month 2 Salaries and wages Rent $ 5 $ 5 5 Interest payants Principal payments Dividends 5 s Tas 5 Purchases of found assets 5 S Total cash disbursements Not cash flow Add Beginning cash S $ Ending cash s Enter any number in the odit fields and then click Check Answer ? 6 parts Clear All | Check Answer Cach 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 makas 18% of all sales for cash and collects on 41% of its sales in each of the 2 months following the sale. Other cash infons are spected to be $14.000 in September and April, $15,000 in January and March, and $25,000 in February. The firm pays cash for 95 of its purchases. It pays for 50% of its purchases in the following month and for 36% of its purchases 2 months later. Wages and salaries amount to 21% of the preceding month's sales. Rent of 20000 per month must be paid. Interest payments of S9,000 an de in January and Apri. A principal payment of $30,000 is also due in April. The firm expects to pay cash dividends of $20,000 in January and April Tous of $75,000 ane due in April. The film also intends to make a $24,000 cash purchase of ixed assets in December ..Acuming that the firm has a cash balance of $20,000 at the beginning of November, determine the end-of-month auch balances for each month, November through Apri b. Assuming that the firm wishes to maintain a $13.000 minimum cash balance, determine the required total financing or excess cash balance for each month November through April Q. the firmware requesting a line of credit to cover nooded financing for the period November to April, how large would this line have to be? Explain your answer. Dividends s Purchases of found assets Total cash disbursements $ 212,380 Not cash flow 20,000 Add Beginning cash 24.490 Encing cash Complete the December cash budget for Xenocore, Inc. below. Round to the nearest dollar) S O $ 5 Yanooore, Ing. Oot Now $ 245,000 5 173,000 $ Deo 155.000 Forecast salos 5 $ $ S 5 $ $ 52,000 $ 137,000 $ 106,000 Collections Lag 1 month Lag 2 month Other cash receipts Total cash receipts Forecast Purchases Cash purchases Payments Lag 1 month Lag 2 month 2 Salaries and wages Rent $ 5 $ 5 5 Interest payants Principal payments Dividends 5 s Tas 5 Purchases of found assets 5 S Total cash disbursements Not cash flow Add Beginning cash S $ Ending cash s Enter any number in the odit fields and then click Check Answer ? 6 parts Clear All | Check
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started