# 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?

Source: https://qintar.app/en/tools/shop-installment-sales.html
Language: English
قنطار (Qintar)، qintar.app

---

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](https://qintar.app/en/sheets/shop-installment-sales.html). 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.**

## 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:

| Result | Value |
| --- | --- |
| Monthly installment | 7,840.00 |
| Mark-up on the balance | 5,040.00 |
| Total the customer pays | 67,040.00 |
| Mark-up as a share of the price | 8.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

- Balance after the down payment = price − down payment.
- Mark-up = balance × monthly mark-up rate × number of months (a flat mark-up on the balance).
- Installment = (balance + mark-up) ÷ number of months.
- Left after each month = total − paid so far.

## 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](https://qintar.app/en/sheets/shop-installment-sales.html). For a step-by-step explanation: [Selling gold on installments: the payment and the total](https://qintar.app/en/articles/gold-installment-sales.html).

## 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

- [Cash close calculator: count the drawer and compare](https://qintar.app/en/tools/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Credit book: each customer's balance after every entry](https://qintar.app/en/tools/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap and refining calculator: how much pure gold?](https://qintar.app/en/tools/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?
- [Wholesaler account: balance in pure gold and making charge](https://qintar.app/en/tools/shop-wholesaler-account.html)How many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- [Gold shop monthly profit calculator](https://qintar.app/en/tools/shop-monthly-profit.html)How much did the shop make this month after expenses?

[All calculators](https://qintar.app/en/tools/) · [All free sheets](https://qintar.app/en/sheets/)
