DO IT USING EXCEL, AND POST THE EXCEL SCREENSHOT AND FORMULA IN EXCEL SCREENSHOT. THANK YOU

Question 50 5 pts Treble Note Music sells 1380 musical instruments a year at an average price per instrument of $795. All sales are credit sales with terms of 2/10, net 30. The company has found that 76 percent of its customers take advantage of the discounted price. What is the amount of the firm's average accounts receivable? The discount amount is applied to a customer's account only after payments have been received and processed. Assume a 365-day year. $45,890 $44,485 $46,100 O $46,825 0 $43,565