X Excel template - Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Comments X Cut Arial 10 AI General TIX == a Wrap Text SE3Merge & Center AutoSum" AY LECopy Paste BI U Dab Da $ % -2,8 Insert Delete Format Clear & Format Painter Conditional Format Cell Formatting as Table Styles Tables Sort & Find & Filter Select Editing ndo Clipboard Font Alignment Number Cells 17 A B D E F . K L M N o P Q R S V w Receivables investment Credit Terms Discount % Discount period (in days) Amount due (in days) 3.00% 10 40 $842,000.00 365 40.00% 60.00% 90 Total sales Number of days in year 0 % of customers that take discount 1 and pay on discount day 2 % of customers that pay after discount period Average days after purchase 3 by nondiscount customers 4 5 Calculation of Days Sales Outstanding (DSO): 6 Days sales outstanding (DSO) 7 8 Calculation of Average Amount of Receivables: 9 Average receivables 0 1 Cost of Trade Credit: 2 Cost to discount customers 3 Nominal cost to nondiscount customers paying late on Day 4 Effective cost to nondiscount customers paying late on Day 5 Calculation of Account Receivables if 6 Nondiscount Customers Paid When Due: 58.00 Formulas =(C11C5)+(C12"C13) #N/A 0.00% 90 90 #N/A #N/A 7 New days sales outstanding (DSONew) 8 Average receivablesNew 9 #N/A #N/A = Sheet1 +