| | M6A2 - Health Care Administrator Case Study Project – Part 1 | | | | Budget Form |
| | Description | Gross Receivable | January Collections | February Collections | March Collections | Total Collected Excluding 2% Discount | 15% Not Collected | Remaining Receivable Balance |
| | November Receivables | 15,000 | 7,500 | 0 | 0 | 7,500 | 7,500 | 0 |
| | December Receivables | 25,000 | 10,000 | 7,500 | 0 | 17,500 | 7,500 | 0 |
| | January Receivables | $200,000 | 100,000 | 40,000 | 30,000 | 170,000 | 30,000 | 0 |
| | February Receivables | $210,000 | 0 | 105,000 | 42,000 | 147,000 | 31,500 | 31,500 |
| | March Receivables | $220,000 | 0 | 0 | 110,000 | 110,000 | 33,000 | 77,000 |
| | Less: 2% discount | | 2,000 | 2,100 | 2,200 | 0 |
| | Total cash inflows from receivables | $670,000 | 115,500 | 150,400 | 179,800 | 452,000 | 109,500 | 108,500 |
| | Cash disbursements for expenses in month incurred | | 75,000 | 80,000 | 80,000 |
| | Cash disbursements for expenses in month AFTER incurred | | 80,000 | 80,000 | 80,000 |
| | Cash Balance change from operations for month | | 39,500 | 9,600 | 19,800 |
| | Cash balance, beginning | | 40,000 | 40,000 | 40,000 |
| | Cash from financing | | 39,500 | 9,600 | 19,800 |
| | Cash balance, ending | | 40,000 | 40,000 | 40,000 |
ltdprinwival
CaseStudyExcel1.xlsx
