Please provide detailed explanation, include excel file. Thanks!

E7-10 Discounts Nelson Company bought inventory for $50,000 on terms of 2/15, [1/60. It pays for the rst $37,500 l0 7.4 of inventory purchased within the discount period and pays for the remaining $12,500 two months later. Required: 1. Prepare the journal entries to record the purchase and the payment under both the (a) gross price and (b) net m price methods. Assume that Nelson uses the periodic inventory system. a: new 2. Next Level Which of the two methods yields a conceptually preferable valuation of inventory