final finance problem i need this tomorrow

week_11_example_problems.2.xls

Problem 1

	January	February	March	April
Sales		50,000	65,000	75,000
Cash Sales (collect 50% in current month)		25,000	32,500	37,500
Collections (collect 50% from prior month)			25,000	32,500
Other receipts			150,000
Total cash receipts		25,000	207,500	70,000
Variable disbursements (60% of sales, one month prior)	30,000	39,000	45,000	35,000
Fixed disbursements	15,000	15,000	15,000	15,000
Other disbursements		25,000
Total cash disbursements	45,000	79,000	60,000	50,000
Net change during the month	(45,000)	(54,000)	147,500	20,000
Beginning cash	10,000	(35,000)	(89,000)	58,500
Ending cash	(35,000)	(89,000)	58,500	78,500
Required cash	5,000	5,000	5,000	5,000
Excess cash to invest			53,500	73,500
Cash borrowed	40,000	94,000

	June	July	August	September	October	November
Sales	$100,000	$500,000	$100,000	$50,000	$100,000	$1,000,000
Cash sales (60% collected in current month)	60,000	300,000	60,000	30,000	60,000	600,000
Collections (40% collected in following month)		40,000	200,000	40,000	20,000	40,000
Other Receipst					100,000
Total cash receipts	60,000	340,000	260,000	70,000	180,000	640,000
Variable disbursements (80% of sales)	80,000	400,000	80,000	40,000	80,000	800,000
Fixed disbursements	10,000	10,000	10,000	10,000	10,000	10,000
Other disbursements			80,000
Total cash disbursements	90,000	410,000	170,000	50,000	90,000	810,000
Net change during the month	(30,000)	(70,000)	90,000	20,000	90,000	(170,000)
Beginning cash	50,000	20,000	(50,000)	40,000	60,000	150,000
Ending cash	20,000	(50,000)	40,000	60,000	150,000	(20,000)
Required cash	10,000	10,000	10,000	10,000	10,000	10,000
Excess cash to invest	10,000		30,000	50,000	140,000
Cash borrowed		60,000				30,000