Reference no: EM132626874
Questions -
Q1. Dante Manufacturing has a cash balance of P8,000 on August 1 of the current year. The company's controller forecast the following cash receipts and cash disbursements for the upcoming two months of activity. Purchases Sales January P 142,000 P 172,000 February 148,000 166,000 March 136,000 165,000 April 154,000 178,000 May 160,000 166,000 Customers pay 60% of their balances in the month of sale, 30% in the month following sale, and 10% in the second month following sale. The company pays all invoices in the month following purchase and takes advantage of a 3% discount on all amounts due. Cash payments for operating expenses in May will be P119,500; Crispin's cash balance on May 1 was P127,800.
Required - Determine the following: 1. Expected cash collections during May. 2. Expected cash disbursements during May. 3. Expected cash balance on May 31.
Q2. Fernando Company developed the following data for the month of August: 1. August 1 cash balance P123,000. 2. Cash sales in August P800,000. 3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in the following month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000.
Required - 1. Anticipated cash receipts from accounts receivable in August. 2. Anticipated total cash available from all sources in August. 3. August cash payments for purchases made in July and August. 4. Anticipated cash balance on August 31.