PVSal function

The PVSal function returns the value at time = 0 of future salaries discounted with interest.

* : Required parameter

Parameters

Default

Description

Sal *

Salary payable from Age1 to Age1 + 1

Age1 *

Age at time-0, fraction allowed

Age2 *

Last age considered, fraction allowed. Salary stops to be paid at Age2.

Sal Increases *

Salary increases rate(s): single rate or vector of rates

Interest *

Interest rate(s): single rate or vector of rates

Example #1

Present value of future salaries between age 50 and 65

Sal = 50000

Age1 = 50

Age2 = 65

Increase = {1%, 5, 2%}

Interest = {2%, 6, 4%}

PVSal(Sal, Age1, Age2, Increase, Interest) returns 679006

Example #2

Present value of future salaries between age 50.25 and 62.5

Sal = 50000

Age1 = 50.25

Age2 = 62.5

Increase = {1%, 5, 2%}

Interest = {2%, 6, 4%}

PVSal(Sal, Age1, Age2, Increase, Interest) returns 567308