# Mortgage Portfolio Model

Model mortgage prepayments, defaults, and cash flows by vintage to calculate portfolio yield, duration, and price volatility.

- Canonical: https://finamodel.com/templates/mortgage-portfolio
- Download (.xlsx): https://finamodel.com/templates/mortgage-portfolio.xlsx
- Category: Capital Markets
- Model type: Portfolio
- Difficulty: Advanced
- Audiences: Credit & risk, Fund managers
- Tags: mortgage, prepayment, cpr, duration, rate-risk

## Related templates

- [Loan Portfolio CDR Model](https://finamodel.com/templates/loan-portfolio-cdr)
- [Fixed Income Portfolio Model](https://finamodel.com/templates/fixed-income-portfolio)
- [Credit Portfolio CDO Model](https://finamodel.com/templates/credit-portfolio-cdo)