What are the total cash collections for Q1?
What are the total cash disbursements for Q1?
What is the beginning cash balance for Q2?
What are the purchases for Q4?
Current year sales for the next four quarters are as follows:
Q1: $270 Q2:$320 Q3:$310 Q4:$325
Sales for the first quarter of the next year are projected to be $290
Accounts Receivable at the beginning of the year were $100
The beginning cash balance is $50
Customers pay 60% of sales the quarter of the sales and the balance in the following quarter
Purchases from suppliers in a quarter are equal to 60% of the next quarter's forecasted sales
Beginning Accounts payable is $60
Suppliers are normally paid 45% the quarter of the purchases and the remainder the following quarter
Wages, taxes, and other expenses are 25% of current quarter sales
Interest and divided payments are a total of $20 per quarter