Practical guide — mathematical formula, 12 worked examples (5M to 50M DZD), impact of rate/duration/down, amortization tables.
Universal mathematical formula
M = C × [t / (1 - (1+t)-n)]. M monthly, C capital, t = annual rate/12, n = years × 12. Step example: 10M DZD at 5% over 20yr → M = ~66,200 DZD/month, total cost 15.88M, interest 5.88M. Mental shortcut: 5% × 20yr → monthly ≈ capital × 0.66%.12 worked examples — from accessible F2 to premium villa
Segment 1 small (5-10M): F2 Sétif 5M 15yr = 31,640 DZD/mo. F3 Constantine 7M 20yr = 37,000 DZD/mo. Segment 2 mid (10-20M): F3 Alger 15M 20yr = 79,190 DZD/mo. F4 Oran 18M 20yr = 89,090 DZD/mo. Segment 3 comfort (20-30M): F4 Dely Ibrahim 20M 20yr = 98,990 DZD/mo. F5 Constantine 25M Mourabaha = 131,630 DZD/mo. Segment 4 premium (30-50M): Villa Hydra 35M 20yr = 161,720 DZD/mo. Villa Club des Pins 40M Mourabaha = 196,530 DZD/mo. Diaspora France villa 50M via Chaabi EUR 4.25% = ~929 EUR/mo.Impact of 3 key variables — rate, duration, down
Rate (10M DZD 20yr)
3%: 55.46k, 4%: 60.6k, 5%: 66k, 5.75%: 70.2k, 6.2%: 72.8k. Each +1% = +8-10% monthly.Duration (10M 5%)
10yr: 106k, 15yr: 79k, 20yr: 66k, 25yr: 58k. 20→25yr saves -11% monthly but +30% total.Down (15M 20yr 5%)
10% down: 89k, 20%: 79k, 30%: 69k, 40%: 59k, 50%: 49k monthly.Amortization tables — understanding repayment
10M DZD 5% 20yr: Year 1 = 62% interest / 38% capital. Year 10 = 40%/60%. Year 20 = 5%/95%. Early repayment optimal in years 1-7.Inter-bank 2026 comparison — same property, different offers
F3 15M 20yr 20% down. CNEP conventional 5%: 79,190 DZD/mo total interest 7M. CPA Mourabaha 6.2%: 87,340 DZD/mo total 8.9M. Chaabi France EUR 4.25%: ~283 EUR/mo (13% cheaper than CNEP DZ).Online calculators — 2026 recommended tools
Official: cnepbanque.dz/simulation, BADR, Al Salam, Chaabi Bank France. Independent: DZ-Immobilier, Excel PMT function =PMT(rate/12;years*12;-capital). Mobile: Loan Calculator, CNEP app.Common calculation errors
1) Forgetting annual→monthly rate conversion. 2) Forgetting years→months. 3) Not including death insurance (0.2-0.4%/yr). 4) Confusing total cost vs interest cost. 5) Underestimating annex fees (notary, dossier, MRH).Editorial Q&A
How much can I borrow with 100k DZD/mo salary?
33% ratio: max 33k monthly = ~5M capital 20yr 5% = ~6.25M property max.Formula works for Mourabaha?
Yes exactly same.Why monthly doesn't drop more with longer duration?
Diminishing marginal effect: 10→15yr -25%, 15→20yr -17%, 20→25yr -11%.Early repayment worth it?
Almost always yes, especially years 1-7.Frequently Asked Questions
Formula for calculating real estate credit monthly?
M = C × [t / (1 - (1+t)^-n)]. M monthly, C capital, t = annual rate/12, n = years × 12.
Cost of 1M DZD over 20 years at 5%?
~6,600 DZD/month. Total interest ~590k DZD. Total repaid ~1.59M DZD.
Impact of rate on monthly?
+1% = +8-10% monthly + +30-40% total interest. -0.50% = ~500k savings on 10M/20yr.
Impact of duration?
20→25yr reduces monthly -11% but increases total +30%. Recommend shortest compatible with living.
Impact of down payment?
10→20% down reduces monthly -11%. 10→30%: -22%. Bonus: >30% down allows negotiating -0.25 to -0.50% rate.
How to calculate in Excel?
=PMT(rate/12; years*12; -capital). Example 10M 5% 20yr: =PMT(0.05/12; 240; -10000000) = 65,996.
Works for Mourabaha?
Yes exactly. Mourabaha margin mathematically equivalent to fixed rate.
Borrow with 100k DZD/mo salary?
33% ratio: max 33k monthly. At 5% 20yr = ~5M capital, ~6.25M property max.