| | M6A2 - Health Care Administrator Case Study Project – Part 1 | | | | Budget Form |
| | 1. Read the Case Study 13.3: North Side Hospital in module |
| | 2. Complete the form to prepare a cash forecast (budget) for the months of January, February, and March using the case study as a guide. |
| | Description | Gross Receivable | January Collections | February Collections | March Collections | Total Collected Excluding 2% Discount | 15% Not Collected | Remaining Receivable Balance |
| | November Receivables |
| | December Receivables |
| | January Receivables |
| | February Receivables |
| | March Receivables |
| | Less: 2% discount |
| | Total cash inflows from receivables |
| | Cash disbursements for expenses in month incurred |
| | Cash disbursements for expenses in month AFTER incurred |
| | Cash Balance change from operations for month |
| | Cash balance, beginning |
| | Cash from financing |
| | Cash balance, ending |
ltdprinwival
CaseStudyExcel.xlsx
