Simplicty and flexibility!


Function::Mathematical

Presentvalue


Parameters


Returns/Result


Examples


Reference

presentvalue

Type

Financial Function

Purpose

The presentvalue function calculates the required starting amount for a financial transaction given the futurevalue, installment payment, interest rate, and number of payment periods.

Syntax

presentvalue( futurevalue, installment, rate, periods)

Returns

A numeric value (the initial value before any installment payments are made).

Usage

If the installment payment increases the value of the investment (e.g., an annuity), the installment is expressed as a positive amount. If the payment decreases the value of the investment (e.g., loan amortization), the installment is expressed as a negative amount.

The interest rate, installment payments, and time periods must be based on the same terms. For example, if the periods are expressed in months, the monthly interest rate is expressed as the annual rate/12.

Example 1

presentvalue( 0, -150, 7.9 / 12, 48)

Returns: 6156.12

 

This example calculates the auto loan amount you can afford to borrow at an interest rate of 7.9% if you want to repay the loan in 48 monthly payments of $150.

 

Example 2

presentvalue( 125000, 150, 10 / 12, 240)

Returns: 1514.00

 

This example calculates the required starting balance for a savings plan designed to accrue a $125,000 balance in 20 years based on monthly payments of $150 and an annual interest rate of 10%.

 

Note: DataEase financial functions are derived from the formula shown below. (The double asterisks (meaning "raise to the power") cannot be used in a script).

 

futurevalue = principal * ( ( 1 + ( rate/100) ) * * periods) + ( installment/( rate/100) ) * ( ( ( 1 + ( rate/100) ) * * periods) - 1)

 

When typing fractions like 7.9 / 12, DataEase requires that you type a space before and after the / division symbol.

See Also


On the forum about Presentvalue

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

How can i delete a Style sheet?...

Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10

I run W7 and since a few days&nbsp;Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....

Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40

[@EOF@]...

Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10

On the blog about Presentvalue


dg3_HelpView