DEV Community

loading...
Cover image for French Amortization Method (PRICE) with T-SQL.

French Amortization Method (PRICE) with T-SQL.

sousallan profile image Allan Rodrigues ・1 min read

What is FRENCH AMORTIZATION METHOD? (Also known as PRICE)

The amortization by the French method, progressive or classic, is characterized by the payment of overdue interest, that is to say, at the end of each payment, and payment of constant instalments in each period.
Interest decreases as loan periods pass and amortized capital increases in evey new period.
The follow image contains the formula to calculate a banking loan.

Alt Text

Mês = Month;
Prestação = Payment;
Juros = Interest;
Amortização = Amount amortized;
SD (Saldo Devedor) = Fixed Amount.

Translate to Transact SQL

You can download the script SQL_CALCULAR_PRICE.sql on my Github, to analyze how to calculate PRICE using T-SQL. Follow the link:

Discussion (0)

pic
Editor guide