Homework answers / question archive / The XYZ company specializes in homemade biscuits and receives all income from sales

The XYZ company specializes in homemade biscuits and receives all income from sales

Finance

Share With

The XYZ company specializes in homemade biscuits and receives all income from sales. The sales revenue estimates (in million S) for the company are as follows: Q1 = 500, Q2 = 550. Q3 = 600. Q4 = 650, and QI of next year = 650. The average collection period for accounts receivables is 60 days. Beginning receivables (Q1 beginning) is $200 million. The purchases are 50% of next quarter sales. Beginning payables (Q1 beginning) is $150 million. The accounts payable period is 30 days. Wages and other expenses every quarter are 20% of the sales reveme of that quarter. A CAPEX of $50 million is planned end of Quarter 3. Dividends and interest payments are $10 million every quarter. There are no other expenses. The beginning cash balance (Q1 beginning) is S30 million. How much will be the cash balance at the end of Quarter 42 XYZ company wants to maintain a cash balance of $35 million every quarter. Will there be any cash deficit in any quarter?