Question

Cash receipts A firm has actual sales of $60,000 in April and $57,000 in May. It expects sales of $75,000 in June and $96,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are collected evenly over the following 2 months, what are the firm's expected cash receipts for June, July, and August? Complete the cash receipts table below: (Round to the nearest dollar.) April May 57,000 $ June 75,000 $ July 96,000 $ August 96,000 Sales $ 60,000 $ Cash sales Collections: Lag 1 month A Lag 2 months 07 Total cash receipts $C $ D $ [

Answer 1

	April	May	June	July	August
Sales	60000	57000	75000	96000	96000
Cash sales	30000 [ 60000*50% ]	28500 [ 57000*50% ]	37500 [ 75000*50% ]	48000 [ 96000*50% ]	48000 [ 96000*50% ]
Collections :
Lag 1 month		15000 [ 60000*50%*1/2 ]	14250 [ 57000*50%*1/2 ]	18750 [ 75000*50%*1/2 ]	24000 [ 96000*50%/1/2 ]
Lag 2 month			15000 [ 60000*50%*1/2 ]	14250 [ 57000*50%*1/2 ]	18750 [ 75000*50%*1/2 ]
Total cash receipts			66750	81000	90750