Calculate weighted average life of a fixed-rate mortgage or bond
wal 9.5 360
21.33763311
wal 9.5 180 360
wal IntRate Term (AmTerm) (Freq) (AvgLife)
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 |
Type: Numeric