show work please

Revenue Expenses 30% Patient Estimated patient revenues, 20x0 revenues, 20X1 Given 1 October $5,000,000 Given 2 January 9 $5,300,000 November $5.200,000 February 310 $5.350.000 December $5.300.000 11 March 55,400,000 12 Other Estimated cash 13 revenues, 20x1 outflows, 20x1" 14 Given 3 January $190,000 Given 4 January 15 $5.250.000 February $220,000 February $5.300.000 16 March $240.000 March $5.350.000 17 April $5.400,000 18 Receipt of payment 19 for Patient Ravenues and Services Ending cash balances 20 Given 5 Current month of Service 60% Given 6 December 20X0 $1,700,000 21 1st month of prior service 22 2nd month of prior service 10% 40% 23 3rd months of prior service 0% 24 25 Cash Outflows for the current month 26 The ending balance for each month an a.percentage of the estimated cash outflows for the next month 27 28 lowa Diagnostic Center 29 For the Quarter Ending March 31, 20X1 30 Item Formula stalanuary February 31 Operating cash inflows From October Givens 1,5) SO 33 B From November Givens 1,5) 520.000 34 c From December Givens 1.5) 1.590,000 35 D From January Givens 2.5] 3,180,000 36 E From February Givens 2,5] From March Givens 2,5) 38 Other revenues Given 3] 190.000 39 H Net cash Infows [Sum AG 5.480.000 40 1 Forecasted cash outflows Given 4 5,250,000 41 Mority/quarterly net cash flow [ 230,000 42 K Beginning balance 10) 1.700.000 43 L Caah before borrowing or investing [JK] 1.930,000 44 M Required cash balance Id 2.120,000 45 N Surplus (deficit) ILM (100,000) 46 o Investment of surplus in short-term investments [o] 47 P Short-term borrowing 190,000 48 Ending cash balance LO:P3 1524120.000 March Quarter 32 A 1 37 F SO 520.000 1.590,000 3,180,000 0 0 190.000 5.480,000 5.250,000 230,000 1.700.000 1.830.000 0 0 o oooool 0 0 1.930,000 0 120,000 924120.000 SO