Valuing a Mortgage Portfolio With Cash Flow Analysis

This Excel spreadsheet could help small to medium size banks, credit unions, and mortgage investors, to evaluate their mortgage portfolio. It could also be used for commercial and consumer loans as long as the user understands that the modelĀ uses a 30/360 mortgage day count. The difference between valuing a portfolio of mortgages and mortgage backed […]