Aqua Gardens Forecasts sales as follows:
June $100,000
July $150,000
August $75,000
All sales are made on credit; 60% are collected in the month after the sale and 40% is collected in the second month after the sale.
May's sakes were $50,000 and April sales were $40,000
Prepare a monthly schedule of cash receipts for June, July and August. Please do this in a table in either word or excel.
What would the accounts receivable balance be at the end of August?