Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise