Average Life VBA Function For MBS

This is the fourth  in a series of VBA, User Defined Functions for Mortgage Backed Securities (MBS). The other three are, solve for price given yield , yield given price and Macaulay Duration . Actually the seventh UDF, if you include the functions solving for the market value of Servicing, IO, and PO). As was true of the previous three functions, it allows […]