Excel Online Structured Activity: Recelvabies Imventment ansect the questions belin. Osten sareaduhet dars. is Nominat cost: frectere cent: eecimal places. Do not rocha intermedate calculationa DSO = Average tecevables os Recelvables investment \begin{tabular}{|c|c|} \hline Credit Terms: & \\ \hline Discount \% & 3.00% \\ \hline Discount period (in days) & 10 \\ \hline Amount due (in days) & 25 \\ \hline Total sales & $1,915,000,00 \\ \hline Number of days in year & 365 \\ \hline \end{tabular} % of customers that take discount and pay on discount day 12% of customers that pay after discount period Average days after purchase by nondiscount customers Calculation of Days Sales Outstanding (DSO): Days sales outstanding (DSO) Calculation of Average Amount of Recelvables: Average receivables Cost of Trade Credit: Cost to discount customeris Nominal cost to nondiscount customers paying tate on Day Effective cost to nondiscount customers paying late on Day Calculation of Account Receivables if Nondiscount Customers Paid When Due: New days sales outstanding (DSONrm) Average receivablestir. fx A B C D E G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 is 16 17 18 19 20 21 22. 23 24 25. 26 27 28 29 30 31