TruncVector function

Actuarial Excel Addin

The TruncVector function, allows to produce a vector of rates (interest rates, indexation rates, salary increase rates, ...) that is 'Duration' years after time 0.

See also: Vt.

* : Required parameter

Parameters

Default

Description

Vector *

A vector of rates

Duration *

Duration in years, fraction allowed

Example #1

Vector = {3.25%, 4.5, 2%}

Duration = 2.15

TruncVector(Vector, Duration) returns {3.25%, 2.35, 2%}

Example #2

Vector = {3.25%, 4.5, 2%}

Duration = 10

TruncVector(Vector, Duration) returns {3.25%, 0, 2%}

Example #3

Vector = {3.25%, 4.5, 2%, 7.2, 1%}

Duration = 6

TruncVector(Vector, Duration) returns {3.25%, 0, 2%, 5.7, 1%}