Cash budget. Jim Zeeman Clinic provided the financial information in Exhibit 5.14.

Prepare a cash budget for the clinic for the quarter ending March 20X1.

Transcribed Image Text:

EXHIBIT 5.14 JIM ZEEMAN CLINIC Givens Revenues and Expenses Patient Revenues, 20X0 Estimated Patient Revenues, 20X1 Given 1 October $4,000,000 Given 2 January $4,400,000 November December $4,200,000 February $4,600,000 $4,400,000 March $4,800,000 Other Revenues, 20X1 Estimated Cash Outflows, 20X1 Given 3 January $78,000 Given 4 January $3,000,000 February March $120,000 $200,000 February $3,200,000 March $3,400,000 April $3,000,000 Receipt of Payment for Patient Revenues and Services Ending Cash Balances Given 6 December $800,000 Given 5 Current month of service 1st month of prior service 60% 20X0 30% b 40% 2nd month of prior service 10% 3rd+ months of prior service 0% "Cash outflows for the current month. *The ending balance for each month as a percentage of the estimated cash outflows for the next month.