please include excel formulas to input into cells. Thank you!

AquaZone Company, a manufocturer of water heaters, sold 2,000 units on October 2,2023 . The units have a list price of $425 each, but the customer was given a 30% trade discount. The terms of the sale were 2/10,n/30. 1. Assume Aquaone uses the eross method of accounting for cash discounts. a. Prepare the journal entry to record the sale on October 2 assuming that the gross method of accounting for cash discounts is used (icnore cost of roods) a. Prepare the journal entry to record the sale on October 2 assuming that the net method of accounting for cash discounts is used (iznore cost of goods). b. Assume the cuistomer pays the amount due on October 10,2023. Prepare the journal entry to record the collection. c. Assume the customer pays the amount due on November 6, 2023. Prepare the journal entry to record the collection