Finance Assignment

su-mhc6305-w1-a4.xls

Receivables Management

Receivables Management Case Study					© 2007 South University
Down East Pharmaceuticals
Select the appropriate input values and enter them in cells colored red. Once you do this, the base case solution will appear.
INPUT DATA:			KEY OUTPUT:
Sales Forecasts:			Average Collection Period (Days):
			End of March		0.0
	Month	Sales	End of June		0.0
	January	$0
	February	0	Receivables Balance:
	March	0	End of March		$0
	April	0	End of June		$0
	May	0
	June	0	Aging Schedules:
				End of March	End of June
Assumed Collection Pattern:			0 - 30:	0.0%	0.0%
			30 - 60:	0.0%	0.0%
Month of sale		0.0%	Over 60:	0.0%	0.0%
One month after sale		0.0%
Two months after sale		0.0%	Payment Pattern:
				End of March	End of June
			Total	0.0%	0.0%
MODEL-GENERATED DATA:
Calculation of Average			End of Month
Collection Period (ACP):			March	June
Receivables balance			$0	$0
Average daily sales			$0.00	$0.00
ACP			0.0	0.0
Aging Schedules:
Age of
Account	End of March		End of June
in Days	A/R	%	A/R	%
0-30	$0	0.0%	$0	0.0%
30-60	0	0.0%	0	0.0%
60-90	0	0.0%	0	0.0%
Total	$0	0.0%	$0	0.0%
Uncollected Balances Schedules:
End of March:
			Accts Rec	Remaining
	Month	Sales	for month	Rec/Sales
	January	$0	$0	0.0%
	February	0	0	0.0%
	March	0	0	0.0%
		Total	$0	0.0%
End of June:
			Accts Rec	Remaining
	Month	Sales	for month	Rec/Sales
	April	$0	$0	0.0%
	May	0	0	0.0%
	June	0	0	0.0%
		Total	$0	0.0%