use excel formulas to get the answer! must use cells given!

Stevenson Company manufactures bicycles. On August 15,2023 , the company sold 2,250 bikes to a customer for $500 each. The terms of the sale were 2/10,n/30. Stevenson uses the gross method of accounting for cash discounts. 1. Prepare the journal entry to record the sale on August 15 (ignore cost of goods). 2. Assume the customer pays the amount due on August 23, 2023. Prepare the journal entry to record the collection. 3. Assume instead the customer does not pay until September 14, 2023. Prepare the journal entry to record the collection. 2. Assume the customer pays the amount due on August 23, 2023. Prepare the journal entry to record the collection. 3. Assume instead the customer does not pay until September 14, 2023. Prepare the journal entry to record the collection. Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show you Nothing in this area will be graded, but it will be submitted with your assignment