Loading...
HomeMy WebLinkAboutCB FEB 2020 ADJUSTED INVOICE REFUNDORIGINALLY BILLED Regular Rate (0.75% Up to 95%) Bonus Rate (1.75% Over 95%) SHOULD HAVE BEEN BILLED Regular Rate (0.75% Up to 95%) Bonus Rate (1.75% Over 95%) FEB 2020 Collection fees to be billed CAROLINA BEACH CAROLINA BEACH TOTAL FEB 2020 Collection fees to be billed CAROLINA BEACH CAROLINA BEACH TOTAL 5848.67 112166.39 118015.06 10780.1 107237.3 118017.4 0.0075 0.0175 0.0075 0.0175 43.865 1962.9118 80.8508 1876.6528 Total Due 43.865 1962.9118 2006.7769 Total Due 80.8508 1876.6528 1957.5035 Adjusted Bills ($ 4,635,811.43) - Payments ($ 4,511,433.25) - Refunds ( 0.00) + Write offs ($ 175.09) = Receivable ($ 124,553.27) Adjusted Bills ($ 4,635,811.43) - Receivable ($ 124,553.27) = Net Payments + Interest ($ 4,511,258.16) Adjusted Bills ($ 4,635,811.43) x 95% = $ 4,404,020.86 Net Payments + Interest ($ 4,511,258.16) -$ 4,404,020.86 = Bonus Rate ($ 107,237.30 Payments ($ 114,916.30) + Write Offs ($ 1.17) + Interest ($ 3,099.93) - Refunds ($ 0.00) = $ 118,017.40 $ 118,017.40 - Bonus Rate $ 107,237.30 = Regular Rate ($ 10,780.10) Difference Payments ($ 454,318.36) + Write Offs ($ 3,674.09) + Interest ($ 21,529.11) - Refunds ($ 3,115.99) = $ 476,405.57 -49.28 REFUND DUE