Excel Functions in EAC ToolsExcel Functions in EAC Tools\Period certain annuity functionsPeriod certain annuity functions\PVCOPPA

PVCOPPA

PVCOPPA calculates the present value of a certain-only annuity based on the so-called PPA assumption for interest (3 segment rates).

Syntax

PVCOPPA(InterestRate1, InterestRate2, InterestRate3, [YearsCertain], [Frequency], [COLA])

Parameter Name

Description

InterestRate1

Segment rate 1 -- to discount payments made during the first 5 years (years 1 to 5). Must be a single number.

·       Note: A value that is greater than 25% (i.e. 0.25) will be divided by 100; e.g. if you enter 2.75 it will be treated as .0275 or 2.75%.

InterestRate2

Segment rate 2 -- to discount payments made during the next 15 years (years 6 to 20).

InterestRate3

Segment rate 3 -- to discount payments made after the first 20 years (years 21 and later).

YearsCertain

Number of years guaranteed payments. May be an integer, or a factional amount (e.g. years & months).
Optional, default = 0

Frequency

Number of payments per year:
Optional, default = 12

Frequency

Description

1

annual

2

semi-annual

4

quarterly

6

bi-monthly

12

monthly

99

continuous

 

COLA

Periodic cost-of-living adjustment applied to the benefit amount.
Optional, default = 0
Rates can be defined using these COLA definitions
.