Benchmarking
Remember that we have multiple options on how we sell these loans: 1. Execute a whole loan trade with these counterparties; 2. bundle them together with Fannie Mae or Freddie Mac through UMBS bonds.
Because selling our loans to a securitizer is a much more efficient process, we would only want to trade to whole loan counterparties if they can beat price we can get from UMBS bonds.
UMBS bonds are traded publicly, getting this data and using it as a benchmark is quite simple. We just need to upload the data into Power BI and match it to each loan.
If you have lost progress, close any open workbooks and load 2_2_market_data_solution.pbix
from the Exercises folder on the Desktop.
This exercise is part of the course
Case Study: Mortgage Trading Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
