Year Month Sales Purchases 2019 September $215,000 $123,000 2019 October 245,000 152,000 2019 November 172,000 145,000 2019 December 156,000 102,000 2020 January 140,000 80,000 2020 February 184,000 107,000 2020 March 200,000 100,000 2020 April 250,000 92,000

Cash

budgetAdvanced

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

LOADING...

. The firm makes

12%

of all sales for cash and collects on

44%

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,

$13,000

in January and March, and

$28,000

in February. The firm pays cash for

11%

of its purchases. It pays for

51%

of its purchases in the following month and for

38%

of its purchases 2 months later. Wages and salaries amount to

19%

of the preceding month's sales. Rent of

$22,000

per month must be paid. Interest payments of

$10,000

are due in January and April. A principal payment of

$34,000

is also due in April. The firm expects to pay cash dividends of

$19,000

in January and April. Taxes of

$84,000

are due in April. The firm also intends to make a

$27,000

cash purchase of fixed assets in December.

a. Assuming that the firm has a cash balance of

$23,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.