Scribd
Upload
733 views6 pages

Schedule of Cash Collection: Feb Sale March Sale

The document summarizes cash collection and budget for a company over three months: April, May, and June. It shows sales amounts by month and percentages collected. Total cash collection for the quarter was $1.5 million. The cash budget details opening balances, accounts receivable, expenses, and financing activities. Borrowing of $90,000 in April was repaid in May with $9,000 of interest paid. The ending cash balance remained steady at $64,400 for May and June.

Uploaded by

mohammad bilal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
733 views6 pages

Schedule of Cash Collection: Feb Sale March Sale

The document summarizes cash collection and budget for a company over three months: April, May, and June. It shows sales amounts by month and percentages collected. Total cash collection for the quarter was $1.5 million. The cash budget details opening balances, accounts receivable, expenses, and financing activities. Borrowing of $90,000 in April was repaid in May with $9,000 of interest paid. The ending cash balance remained steady at $64,400 for May and June.

Uploaded by

mohammad bilal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Schedule of Cash Collection

April May June


Sales 400000 600000 500000
Feb sale
250000x20% 50000
March sale
300000x35% 105000
300000x20% 60000
April Sale
400000x40% 160000
400000x30% 120000
400000x20%
May Sale
600000x40% 240000
600000x35%
June Sale
500000x40%
TOTAL 715000 1020000
CASH BUDGET FOR THE QUARTER
APRIL MAY JUNE
Opening bal 48500 40000 64400
Add: Account Rec 315000 440000 490000
Total 363500 480000 554400
less: Disbursement
payments 67500 82500 75000
direct labour exp 75000 85000 105000
mfo exp 56000 76000 50000
selling & admin e 70000 80000 60000
dividend 45000
machine 100000 200000
Total Disbursem 413500 323500 490000
excess/ deffecien -50000 156500 64400
FINANCING
borrowing 90000 _ _
repayment -90000 _
interest -2100 _
Total FINANCING 90000 -92100 _
ENDING CASH B 40000 64400 64400
ection
Quarter
1500000
QUARTER
QUARTER
48500
1245000
1293500

225000
265000
182000
210000
45000
300000
1227000
66500

90000
-90000
-2100
-2100
64400

You might also like