CAS 6


xwal
- Financial

Summary

Calculate weighted average life of a fixed-rate mortgage or bond

Examples

wal 9.5 360 
21.33763311 
wal 9.5 180 360 

Syntax

wal IntRate Term (AmTerm) (Freq) (AvgLife)

Right Arguments

Name Data Type Input Type Description Optional Default
IntRate Numeric Field, Constant Interest Rate No
Term Numeric Field, Constant Stated Term No
AmTerm Numeric Field, Constant Amortization Terms Yes
Frequency Numeric Field, Constant Frequency per year Yes 12
AvgLife Numeric Field, Constant Average Life in years Yes

Result

Type: Numeric





Build 6.0.624