Your hospital has billed charges of $4,000,000 in February. If your collection experience indicates that 20 percent is paid in the month billed, 40 percent in the second month, 20 percent in the third month, and 5 percent in the fourth month, determine the following values:

1. Net patient revenue for February
2. Collections of February charges in February
3. Net accounts receivable at the end of March for February billings
4. Please provide the answer in excel with the formulas.

Answer rating: 100% (QA)

aNet patient revenue for February4000000 b Collections of February ... View the full answer