Calculates the shortest and longest average life as a date and in years given a sinking fund schedule
Introduced in release: 1.0 Component: Generic Purpose:
Given a sinking fund schedule (sinks taken at the head), the outstanding amount, the overfund amount, and optionally the voluntary amount, this routine will calculate the shortest and longest average life. A sinking fund schedule is entered as a series of time periods during which a certain amount is to be sunk at a given frequency (for example, between Jan 1, 1988 and Jan 1, 1990, sink $15,000 every 6 months). The sink amount may be specified as a single amount (which would apply to each time period) or as an array of amounts to be used during calculations for each corresponding time period. The same applies to the (optional) voluntary amounts, which are specified as percentages of the sink amount for that period (that is, a voluntary amount of 0.25 means 25 percent of the sink amount).
Alternatives:
If the average life with sinks taken out at the tail is needed use sf_al_tail.
Results:
The average life values are returned both as a number of years and as a date.
Error Conditions:
Returned values should be ignored for a non-zero status. See Errors.
Main Index
TIPS Home