Please answer in excel format

PROBLEM 1 Some of the transactions of ABC Company whose credit terms are 2/10. n/30 follow; June 1 Cash sales, P180,000, Sales on Account, P650,000. Received returned merchandise sold on account P90.000. 10 Collected the amount due on sales. What is the Journal Entry? PROBLEM ? Several purchase transactions of the DEF company are presented below: The credit terms of the company are 3/1, n/30. Oct 6 Purchased merchandise for cash, P200,000 FOB shipping point. 12 Purchased merchandise on account. P700.000. 15 Returned merchandise purchased on account, P50,000, 17 Paid supplier the amount due. 19 Paid freight charges of P7,000 on merchandise acquired last Oct 6. What is the Journal Entry? PROBLEM 3 & 4 On June 16, GHI Company sold merchandise to JKL Company for P6,000, terms 2/10, n/30. Shipping costs were P600. JKL company received the goods and GHI company. Invoice on June 17. On June 24. JKL company sent the payment to GHI company., which GHI company received on June 25. Both GHI company and JKL company use the periodic inventory system. The following are several arrangements regarding the shipping costs: A. Shipping terms are FOB shipping point, freight collect. JKL company paid the shipping costs on June 17 and remitted P5.880 on June 24. Required: 1. Prepare the entries for GHI company to record the sale and cash receipt 2. Prepare the entries for JKL company to record the purchase, the payment of shipping costs and the cash remittance. B. Shipping terms are FOB destination, freight prepaid. GHI company paid the shipping costs on June 16 JKL company remitted P5,880 on June 24. Required: 1. Prepare the entries for GHI company to record the sale, the payment of shipping costs and the cash receipt. 2. Prepare the entries for JK.L company to record the purchase and cash remittance.PROBLEM 5 MNO company entered into the following transaction during the month of June: June 2 Purchased 1,000 tires at a cost of P600 per tire, 1/10, n/45. 4 Paid trucking firm P 8,000 to ship the tires purchased on June2. 5 Purchased 600 tires at a cost of P600 per tire, 2/10, n/30. 6 Paid trucking firm P5.000 to ship the tires purchased on June 5. 7 Returned 150 of the tires purchased on June 2 because they were defective. Received a credit on open account from seller. 11 Paid tires purchased on June 2. 13 Sold 700 tires from those purchased on June 2. The selling price was P900 per tire, 1/10 n/30. 22 Received cash from sale of tires on June 13. 30 Paid for tires purchased on June 5. What is the Journal Entry? PROBLEM 6 & 7 Nicolas engaged in the following transaction in August: Aug I Sold merchandise to lacierda on credit, n/30, FOB shipping point, P21,000. 3 Purchased merchandise on credit from Cabellon n/30 FOB shipping point, P38,000. 5 Paid Southmin for freight charges on merchandise received, P290. 6 Purchased store supplies on credit from Ipil, n/20. P6.360. Purchased merchandise on credit from Pagadian Company n/30. FOB shipping point, P36,000. Pagadian company paid P200 for freight. 12 Returned some of the merchandise received on Aug 3 for credit, P6,000. 15 Sold merchandise on credit to Columban Stores, n/30, FOB shipping point P12,000. 16 Returned some of the store supplies purchased on Aug 6 for credit, P2,000. 17 Sold merchandise for cash P10,000. 18 Accepted for full credit a return from Lacierda. P2,000. 24 Paid accounts to Cabellon. 25 Received full payment from Lacierda. What is the Journal Entry?PROBLEMS Angela engaged in the following transactions in December Dec 7 Sold merchandise on credit to Caindec company. n/30. FOB shipping point P30,000. Purchased merchandise on credit from Kho Company, n/30. FOB shipping point P60,000. 9 Paid Dinopol Company for shipping charges on merchandise purchased on Dec & P254. 10 Purchased merchandise on credit from Magallanes Company, n/30, FOB shipping point, P95,400. Freight costs of P600 was paid by Magallanes. 13 Purchased office supplies on credit from Carlos Company, n/10, P24,000. 14 Sold merchandise on credit to Zosa Company, n/30, FOB shipping point, P24,000. 14 Returned damaged merchandise received from kho company on Dec 8 for credit, P6,000 17 Received check from Caindes Company for his purchase on Dec 7. 18 Returned portions of the office supplies received on Dec 13 for credit because the wrong items were sent, P4,000. 19 Sold merchandise for cash, P18.000. 20 Paid Magallanes Company for purchase on Dec 10. 21 Paid Kho Company. 24 Accepted from Zosa Company a return of merchandise, P2,000. What is the Journal Entry? PROBLEM 9 & 10 Abiles Company and Nicolas Company engaged in the following transactions for the month of May: May 4 Abiles sold merchandise on account to Nicolas, P162,000. Terms: FOB destination, 2/10, n 30, Freight charges amounted to P2,000. 5 Abiles sold merchandise on account to Nicolas, P710,000. Terms: FOB shipping point, 2/10,n/30. Freight charges amounted to P8,000. Nicolas paid freight charges on purchase of May 5. Abiles received returned merchandise from Nicolas in the amount of P12,000 from May 4 sale. 9 Abiles received payment from Nicolas for the May 4 transaction. 10 Abiles paid transportation charges on the May 4 Shipment. 12 Abiles received payment from Nicolas for the May 5 transaction. 18 Abiles sold merchandise on account to, P250,000 list price. Terms:40% trade discount, FOB shipping point, 2/10, n/30. 21 Nicolas paid freight charges on the May 18 transaction, P3,000. 23 Abiles received payment from Nicolas foe the tomount due from the May 18 transaction