This is the third in a series of VBA, User Defined Functions for Mortgage Backed Securities. The other two solved for __price given yield __and __yield given____ ____price__. Actually the sixth if you include the functions solving for the __market value of servicing, IO, and PO__). As was true of the previous two functions, it allows for a number of option. It also, as before, includes an amortization schedule as a proof of the function’s calculations.

Download “http://pistulka.com/Excel_Shared/MortgageDuration.xlsm“