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.