Question

Iowa Diagnostic Center's projected Patient Revenues for the first six months of 2013 are given below:
Jan. $200,000 April $400,000
Feb. $240,000 May $320,000
Mar. $280,000 June $320,000
25% of patient revenues are collected in cash at time service is provided, 50% are collected in the month following provision of service, and the remaining 25% are collected in the second month following provision of the service. Payroll expenses are 75% of that month's revenues. Total other estimated expenses are $60,000/month. The company's cash balance as of February 28, 2013 will be $40,000. Excess cash will be used to retire short term borrowing (if any). Iowa Diagnostic will have no short term borrowing as of February 28, 2013. Assume that the interest rate on short term borrowing is 1% per month. The company must have a minimum cash balance of $25,000 at the beginning of each month. Round all answers to the nearest $100

what will be Iowa Diagnostic Center's ending cash balance (before borrowing) in March?

Answer 1

	Cash Budget
	Beginning cash balance			$   40,000.00
Add:	Cash collected			$ 240,000.00
	Total cash available			$ 280,000.00
Less:	Disbursements
	Payroll expenses			$ 210,000.00	($ 280000 x 75%)
	Other estimated expenses			$   60,000.00
	Total disbursements			$ 270,000.00
	Ending cash balance			$   10,000.00
	(before borrowing)

Workings:

Computation of cash collection from revenue
Particulars			Jan	Feb	March
Revenues			$ 200,000.00	$ 240,000.00	$ 280,000.00
Cash collection for the month of:
Jan			$   50,000.00	$ 100,000.00	$   50,000.00
Feb				$   60,000.00	$ 120,000.00
March					$   70,000.00
Total collection for March					$ 240,000.00