What would Total Cash Receipts for June be if Sales for March was 80,000, April was 100,000 and May was 70,000?

JUM August 80,000 75,000 4.000 191692- October November December January February March 2 Worksheet April May June Sales (forecasted) 55,000 62.000 50.000 60.000 75,000 4 Purchases (5% of sales in 2 months) 88.000 100.000 110.000 100.000 56.250 86,000 75,000 82,500 75.000 60,000 58.250 5 3 Cash Receipts 7 Collections: 8 First Month after sale (30%) 15,000 18,000 22,500 26.400 30,000 33.000 9 Second Month after sale (50%) 31,000 25,000 30,000 37,500 44,000 50,000 10 Third Month after sale (20%) 11,000 12,400 10,000 12,000 15.000 17,600 11 Total Cash Receipts 57,000 66,400 62,500 75,900 89,000 100,600 12 13 Cash Disbursements 14 Payments (one-month lag of purchases from row 4) 56,250 68,000 75,000 82,500 75,000 80,000 15 Wages and Salaries 3,000 10,000 7.000 8.000 6,000 4,000 18 Rent 4,000 4,000 4.000 4,000 4,000 17 Other Expenses 1,000 500 1.200 1,500 1,500 1,200 18 Interest expense on existing debe 600 7,500 19 Taxes 4,460 6.200 20 Purchase of Equipment 14,000 21 Loan Repayment 12.000 22 Total Cash Disbursements 84,250 94,500 91,880 96.000 99 100 81,900 23 24. Net Change in Cash for the Period (7.250) (39,100) (29,160) (20.100) (10.100) 18.700 25 Plus: Beginning cash balance 20.000 12.750 10.000 10.000 10.000 10.000 26 Less: Interest on short-term borrowing 0 0 (364) (859) (866) 078) 27 Equat: Ending cash balance before short-term borrowing 12.750 (26,350) (19,524) (10.759) 27,724 28 0 38.350 29 New Financing Needede 29.524 20.759 10.968 (17.724) 12.750 30 Ending cash balance 10,000 10.000 10.000 10,000 10,000 0 31 Cumulative borrowing 36.350 65,874 86,633 97,599 79,875 32 33 9 etv A g 2 (968) $20:28