Budgets
Creditors Payment Schedules
August September October November
Total sales A calculation may be needed to nd sales or cost of sales
Use formula: sales - cost of sales = gross pro t
Cost of sales OR: gross pro t / cost of sales = mark-up percentage
Cash purchases Ratio between cash and credit purchases should be given to you otherwise a
calculation may be necessary
Credit purchases
Payments to
creditors
August Use percentages given to calculate how much we repay our dept for that month
* dont forget to calculate our discount received only after calculating how much we
September paid in that month
October
November
Cash Payments to creditors Sum of payments Sum of payments
in the October in the November
column column
Debtors Collection Schedules
August September October November
Total sales A calculation may be needed to nd sales or cost of sales
Use formula: sales - cost of sales = gross pro t
OR: gross pro t / cost of sales = mark-up percentage
Cash sales Ratio between cash and credit purchases should be given to you otherwise a
calculation may be necessary
Credit sales
Debtors
collections
August Use percentages given to calculate how much our debtors repay us for that month
* dont forget to calculate their discount allowed only after calculating how much
September they paid in that month
fi fi fi
Creditors Payment Schedules
August September October November
Total sales A calculation may be needed to nd sales or cost of sales
Use formula: sales - cost of sales = gross pro t
Cost of sales OR: gross pro t / cost of sales = mark-up percentage
Cash purchases Ratio between cash and credit purchases should be given to you otherwise a
calculation may be necessary
Credit purchases
Payments to
creditors
August Use percentages given to calculate how much we repay our dept for that month
* dont forget to calculate our discount received only after calculating how much we
September paid in that month
October
November
Cash Payments to creditors Sum of payments Sum of payments
in the October in the November
column column
Debtors Collection Schedules
August September October November
Total sales A calculation may be needed to nd sales or cost of sales
Use formula: sales - cost of sales = gross pro t
OR: gross pro t / cost of sales = mark-up percentage
Cash sales Ratio between cash and credit purchases should be given to you otherwise a
calculation may be necessary
Credit sales
Debtors
collections
August Use percentages given to calculate how much our debtors repay us for that month
* dont forget to calculate their discount allowed only after calculating how much
September they paid in that month
fi fi fi
