Carrier, fill in GREEN cells only
DSO
Total Revenue for July 2008 through December 2008
# of days in cycle * 184
Average Revenue per day
(*For those on a period accounting basis, use the number of calendar
days in your fiscal year.)
Accounts Receivable @ 12/31/2008
Average Revenue per day $ -
DSO #VALUE!
Bad Debt Ratio
Bad debts written to reserve from July 2008 -Dec 2008
Bad debt written off to expenses from July 2008-Dec 2008 $ -
Total collections of previously written off bad debt $ -
Net Bad Debt #VALUE!
Bad Debt Ratio #VALUE!
Collection Effectiveness Index
Accounts Receivable @ 7/1/2008
Total Revenue for July 2008 through December 2008
Accounts Receivable @ 12/31/2008
Current Receivables @ 12/31/2008
CEI #VALUE!