Case In Healthcare Finance

2066 Words9 Pages
Case 2 1. Will the clinic need to request a line of credit for the period and, if so, how big should the line be? CASH SURPLUS OR LOAN REQUIREMENTS | January | February | March | April | May | June | Cash at start if no borrowing is done | | $50,000 | $49,563 | $27,500 | $117,936 | $302,842 | $356,061 | Cumulative cash | | | | $49,563 | $27,500 | $117,936 | $302,842 | $356,061 | $323,998 | Target cash balance | | | | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | Surplus cash or total loans outstanding | | | | | | | | to maintain target cash balance | | ($438) | ($22,500) | $67,936 | $252,842 | $306,061 | $273,998 | Line of credit excess cash interest | | ($2.92) | ($150.08) | $226.23 | $841.96 | $1,019.18 | $912.41 | The clinic will need to request a line of credit for the period, and the line should be at least $1019.18. 2. Daily cash budget | Day 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | Billings | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | $11,290 | Patient payments | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | $2,258 | 30-day payors | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 1,613 | 60-day payors | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | Total collections | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | $6,871 | 2 mo prior to use | | | | | 3,375 | | | | | | | 1 mo prior to use | | | | | 5,063 | | | | | | | Total supplies costs | $0 | $0 | $0 | $0 | $8,438 | $0 | $0 | $0 | $0 | $0 | $0 | Collections | $6,871 | $6,871 | $6,871 | $6,871

More about Case In Healthcare Finance

Open Document