Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Installment sale calculator: payment and total

Installment sale calculator: payment and total

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. This calculator is the same as the "Selling on installments: payment, mark-up and balance" sheet. It runs in your browser and saves no data.

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.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

MonthInstallmentPaid so far (with down payment)Left for the customer to payDelete

Result

Who this calculator is for

This is the online version of the "Selling on installments: payment, mark-up and balance" sheet, made for goldsmiths and shop owners. A table for installment sales: from today's price of the piece, the down payment, the number of months and the mark-up rate you set, it works out the monthly installment, the total, and what is paid and left after each month.

The question it answers: If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?

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.

Worked example

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%

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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%

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Selling gold on installments: the payment and the total.

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.

Related calculators

All calculators · All free sheets