Happy Valley Rehab Facility provided the financial information below in Exhibit 5-17. Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues: Estimated Patient Patient Revenues, 20X0 Patient Revenues, 20X0 Revenues, 20X1 July $4,200,000 October $4,500,000 January $4,600,000 August $4,400,000 November $4,550,000 February $4,500,000 September $4,500,000 December $4,600,000 March $4,500,000 Receipt of Payment Other Revenues, 20X1 for Patient Services / Revenues January $900,000 Current month of service 45% February $910,000 1st month of prior service 25% March $950,000 2nd month of prior service 10% 3-6 months of prior service 5% Expenses a: Estimated Supplies Other Estimated Expenses, 20X1a Supplies Purchases, 20X0 Purchases, 20X1 Nursing Admin. Other October $900,000 January $1,000,000 January $2,000,000 $100,000 $700,000 November $950,000 February $1,025,000 February $2,100,000 $100,000 $675,000 December $1,000,000 March $1,050,000 March $2,200,000 $100,000 $650,000 April $1,075,000 April $2,300,000 $100,000 $525,000 Timing of Cash Payment for Supplies Purchases Ending Cash Balances 0% Month purchased December, 20X0 $700,000 60% +1 Month b 50% 30% +2 Months 10% +3 Months a All estimated expenses are cash outflows for the given month. b The ending balance for each month as a percentage of the estimated cash outflows for the next month. Happy Valley Rehab Facility provided the financial information below in Exhibit 5-17. Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues: Estimated Patient Patient Revenues, 20X0 Patient Revenues, 20X0 Revenues, 20X1 July $4,200,000 October $4,500,000 January $4,600,000 August $4,400,000 November $4,550,000 February $4,500,000 September $4,500,000 December $4,600,000 March $4,500,000 Receipt of Payment Other Revenues, 20X1 for Patient Services / Revenues January $900,000 Current month of service 45% February $910,000 1st month of prior service 25% March $950,000 2nd month of prior service 10% 3-6 months of prior service 5% Expenses a: Estimated Supplies Other Estimated Expenses, 20X1a Supplies Purchases, 20X0 Purchases, 20X1 Nursing Admin. Other October $900,000 January $1,000,000 January $2,000,000 $100,000 $700,000 November $950,000 February $1,025,000 February $2,100,000 $100,000 $675,000 December $1,000,000 March $1,050,000 March $2,200,000 $100,000 $650,000 April $1,075,000 April $2,300,000 $100,000 $525,000 Timing of Cash Payment for Supplies Purchases Ending Cash Balances 0% Month purchased December, 20X0 $700,000 60% +1 Month b 50% 30% +2 Months 10% +3 Months a All estimated expenses are cash outflows for the given month. b The ending balance for each month as a percentage of the estimated cash outflows for the next month. Happy Valley Rehab Facility provided the financial information below in Exhibit 5-17. Calculate the ending cash balance for January 30, 20X1.[x] Exhibit 5-17 Happy Valley Rehab Facility Revenues: Estimated Patient Patient Revenues, 20X0 Patient Revenues, 20X0 Revenues, 20X1 July $4,200,000 October $4,500,000 January $4,600,000 August $4,400,000 November $4,550,000 February $4,500,000 September $4,500,000 December $4,600,000 March $4,500,000 Receipt of Payment Other Revenues, 20X1 for Patient Services / Revenues January $900,000 Current month of service 45% February $910,000 1st month of prior service 25% March $950,000 2nd month of prior service 10% 3-6 months of prior service 5% Expenses a: Estimated Supplies Other Estimated Expenses, 20X1a Supplies Purchases, 20X0 Purchases, 20X1 Nursing Admin. Other October $900,000 January $1,000,000 January $2,000,000 $100,000 $700,000 November $950,000 February $1,025,000 February $2,100,000 $100,000 $675,000 December $1,000,000 March $1,050,000 March $2,200,000 $100,000 $650,000 April $1,075,000 April $2,300,000 $100,000 $525,000 Timing of Cash Payment for Supplies Purchases Ending Cash Balances 0% Month purchased December, 20X0 $700,000 60% +1 Month b 50% 30% +2 Months 10% +3 Months a All estimated expenses are cash outflows for the given month. b The ending balance for each month as a percentage of the estimated cash outflows for the next month.