DEV Community

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

Posted on

4

French Amortization Method (PRICE) with T-SQL.

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:

Top comments (0)

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up