Spot-style interest rates discount the benefit payable in each future year to the determination date by the rate specified for that duration from the determination date. The .csv or .txt file name must end with the letters "_SPOT.CSV" or "_spot.txt" (not case-sensitive). The format ProAdmin expects for this type of file is year (between 1900 and 2200, inclusive), month (between 1 and 12, inclusive), first rate (between 0 and 1, inclusive), first duration (between 1 and 99, inclusive), second rate, second duration, third rate, etc., ending with the final rate. Durations must be positive integers in ascending order from left to right. Each row must end with a final rate. Below is an example of a valid spot rate table.

 

 This is an example of the segment rates used under PPA.