Copy of Cash Budget solution.xlsx

solutions.
DEBTORS COLLECTION SCHEDULE
credit sales MAY JUNE

April = R 580 000 30% R 174,000
May = R 580 000 60% R 348,000 30% R 174,000
June = R 600 000 60% R 360,000 30%
July = R 650 000 60%

TOTAL. R 522,000 R 534,000

PURCHASES
APRIL MAY
Cash 30% R 240,000 30% R 204,000 30%
Credit 70% R 560,000 70% R 476,000 70%
Total Purchases R 800,000 R 680,000

CREDITORS PAYMENT SCHEDULE
MAY JUNE
April R 560,000
May R 476,000
June

TOTAL R 560,000 R 476,000



CASH BUDGET
MAY JUNE
Opening Balance R -70,000 R -241,000
Cash Sales R 300,000 R 320,000
Credit Sales R 522,000 R 534,000
Cash Available R 752,000 R 613,000
Total Cash Outflow R -829,000 R -786,000
Cash Purchases R -204,000 R -240,000
Credit Purchases R -560,000 R -476,000
Salaries and Wages R -65,000 R -70,000
Other Cash Outlows R -164,000 R -14,000
Interest R -14,000 R -14,000
Bonuses
Tax R -150,000
Closing Balance R -241,000 R -187,000