Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Selling on installments: payment, mark-up and balance

Selling on installments: payment, mark-up and balance

Free sheet for goldsmiths and shop owners · If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?

A customer wants to take the piece today and pay over several months? Before you agree, work out the installment, the total and what is left after each month, so the figures are clear to you and to the customer.

Notice: this sheet is a calculator only and not a fatwa. Scholars differ on selling gold in installments, so if you have a religious question, ask Dar al-Ifta or a fatwa authority you trust. The mark-up rate is yours to set and to agree with the customer.

Download PDF136 KBDownload Excel60 KB

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. Or try it online without downloading.

Preview of the first page of the "Selling on installments: payment, mark-up and balance" sheet, with the table and the worked example

How to use it

  1. The price: Today's price of the piece, with the making charge and VAT.
  2. The down payment: What the customer pays now.
  3. Months and mark-up: The number of months and the monthly mark-up rate you set.
  4. The table: The month numbers 1, 2, 3 and so on.
  5. The result: The installment, the total and what is left after each month.

Example The calculation with numbers

Price of the piece today (example): 62,000.00 · Down payment (example): 20,000.00 · Number of months (example): 6 · Mark-up per month (example): 2.0%

MonthInstallmentPaid so far (with down payment)Left for the customer to pay
17,840.0027,840.0039,200.00
27,840.0035,680.0031,360.00
37,840.0043,520.0023,520.00
47,840.0051,360.0015,680.00
57,840.0059,200.007,840.00
67,840.0067,040.000.00
ResultValue
Monthly installment7,840.00
Mark-up on the balance5,040.00
Total the customer pays67,040.00
Mark-up as a share of the price8.1%

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

The calculation

Terms used on this sheet

Down payment
The part of the price the customer pays on the day the piece is handed over (المقدم).
Installment
One of the equal monthly payments that follow (قسط).
Flat mark-up
An addition worked out on the starting balance for the whole period, rather than on what is left each month.

Read more

Frequently asked questions

Is the mark-up interest?

The sheet works out a flat mark-up on the balance after the down payment, at the rate you type. Scholars differ on selling gold in installments, so ask a fatwa authority you trust.

What if the gold price rises before the customer finishes paying?

The installment stays fixed at the agreed price. You hand over the gold today and are paid later, so if the price rises, that money will buy less gold. Keep that in mind when you set the down payment and the rate.

Where do I record the payments?

In the credit book sheet: one line for each installment paid, and the sheet shows the balance.

Does the mark-up compound month by month?

No. It is a flat percentage of the starting balance for each month, added once. In the example, 2% a month over 6 months gives a mark-up of EGP 5,040 on a balance of EGP 42,000.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.

Live prices in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.

More free sheets

All free sheets