Accounts Receivable Turnover Worksheet - Excel

Sample Co. AR Turns and Balance Calculation Worksheet Annualized AR Sales $3,500,000 = 4.67 AR Turns Avg AR Balance $750,000 Days per Year 365 = 78.2 Avg AR Collection Days AR Turns 4.67 Days per Year 365 = 12.17 Target AR Turns Target AR Collection Days 30.0