Homework SourseCash lags are as follows Cash collected in month of service
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
| 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 |
Solution
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 |
