Month Revenue is Earned | Patient service revenue for month | Cash receipts by month | Total cash receipts for month for the month of service |
Jan | 65,000 | ||
Feb | 75,00 | ||
March | 95,000 | ||
April | 105,000 | ||
May | 85,000 | ||
June | 85,000 | ||
Totals |
Cash lags are as follows
Cash collected in month of service: 40%
Cash collected in month after month of service: 40%
Cash collected two months after month of service: 5%
Please fill in the above table
we are assuming that balance 15% amount we have received in one month after of service
Month Revenue is Earned | Patient service revenue for month | Cash receipts by month | Total cash receipts for month for the month of service |
Jan | 65,000 | 26,000.00 | 26,000.00 |
Feb | 75,00 | 29,000.00 | 3,000.00 |
March | 95,000 | 50,750.00 | 38,000.00 |
April | 105,000 | 84,375.00 | 42,000.00 |
May | 85,000 | 90,625.00 | 34,000.00 |
June | 85,000 | 88,500.00 | 34,000.00 |
Totals | 369,250.00 | 177,000.00 |
Get Answers For Free
Most questions answered within 1 hours.