Please help with Question 39

Please solve & show all work

e. Which bank would be the better choice for Tuckhoe Hospital? 39, 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. EXHIBIT 5.14 JIM ZEEMAN CLINIC Givens Revenues and Expenses Patient Revenues, 20XO Estimated Patient Revenues, 20X1 Given 1 October November December $4,500,000 Given 2 January $4,700,000 February $5,100,000 March $5,100,000 $5,500,000 $5,800,000 Other Revenues, 20X1 Estimated Cash Outflows, 20X1 Given 3 January February March $82,000 Given 4 January $140,000 February $220,000 March $3,400,000 $3,600,000 $4,000,000 $4,600,000 April Ending Cash Balances Receipt of Payment for Patient Revenues and Services Given 6 December $1,300,000 20XO b 40% Given 5 Current month of service 1st month of prior service 2nd month of prior service 3rd+ months of prior service 60% 30% 10% 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