clinic's cash flow information for the next six months is below: Calculate the amount of Revenue Collected, Net Cash Flow, Beginning Cash and Ending Cash for July-December based on the collection schedule of 15% of current month's billings, 55% of billings in the last 30 days and 25% of billings from 30-60 days. Will the clinic have sufficient cash througout the forecast period?

Some changes in insurers' billing practice will change that collection rate to 10/50/35. Will they still have sufficient cash to get through the period?-Please answer in excel.

	May	June	July	August	September	October	November	December
Revenue Billed	2,000,000	2,000,000	2,100,000	2,100,000	2,500,000	2,450,000	2,450,000	2,500,000
Revenue Collected
Salaries and wages			1,150,000	1,150,000	1,300,000	1,400,000	1,300,000	1,300,000
Supplies and other expenses			450,000	450,000	550,000	600,000	600,000	500,000
Rent			300,000	300,000	300,000	300,000	300,000	300,000
Consultant expense
Net Cash Flow
Beginning Cash
Ending Cash		50,000
Shortfall
	Current collection		Revised collection rate
Percent collected in month	15%		10%
Percent collected by 30 days	55%		50%
Percent collected by 60 days	25%		35%

What are some of the steps the above clinic could take to improve cash flow?