Linkedin    Twitter   Facebook

Get Started
Log In

Linkedin

Articles Tagged with: Prepayment Analytics

Loans & MSRs: Managing model assumptions and tuners the easy way

One of the things that makes modeling loan and MSR cash flows hard is appropriately applying assumptions to individual loans. Creating appropriate assumptions for each loan or MSR segment is crucial to estimating realistic performance scenarios, stress testing, hedging, and valuation. However, manually creating and maintaining such assumptions can be time-consuming, error-prone, and inconsistent across different segments and portfolios.

Fortunately, hidden among some of the Edge Platform’s better-known features is a powerful and flexible way of running loan-level analytics on a portfolio using the Platform’s segment builder and loan model assumptions features.

These sometimes-overlooked features allow users to create and apply granular and customized modeling assumptions to a particular loan portfolio, based on its various, unique loan characteristics. Assumptions can be saved and reused for future analysis on different loans tapes.  This feature allows clients to effectively build and manage a complex system of models adjustment and tuners for granular sub-segments.

Applying the segment builder and loan model assumptions features, loan investors can:

    • Decouple how they run and aggregate results from how they assign modeling assumptions, and seamlessly assign different assumptions to various segments of the portfolio, based on user-defined criteria and preferences. For example, investors can assign different prepayment, default, and severity assumptions to loans based on their state, LTV, UPB, occupancy, purpose, delinquency status, loan type, collateral features, or virtually any other loan characteristic.

 

    • Choose from a variety of models and inputs, including RiskSpan models and vector inputs for things like CPR and CDR. Investors can define their own vector inputs as an aging curves by loan age or based on the forecast month, and apply them to different segments of the portfolio. For example, they can define their own CDR and CPR curves for consumer or C&I loans, based on the age of the loans.

    • Set up and save modeling assumptions one time, and then reference them over and over again whenever new loan tapes are uploaded. This saves time and effort and ensures consistency and accuracy in the analysis.

This hidden feature enables investors to customize their analysis and projections for different asset classes and scenarios, and to leverage the Edge Platform’s embedded cash flow, prepayment and credit models without compromising the granularity and accuracy of the results. Users can create and save multiple sets of loan model assumptions that include either static inputs, aging curves, or RiskSpan models, and apply them to any loan tape they upload and run in the forecasting UI.

Contact us and request a free demo or trial to learn more about how to use these and other exciting hidden (and non-hidden) features and how they can enhance your loan analytics.


How an MSR Analytical Solution Can Boost Your Mortgage Banking Business

And why it’s probably less expensive than you think

Mortgage servicing rights (MSRs) are complex and volatile assets that require careful management and analysis. Inherent in MSR risk management is the need to monitor portfolio performance, assess risks and opportunities, evaluate and implement risk-reducing strategies such as recapture and interest rate hedging, and effectively communicate all this to investors and regulators. Handling all this has traditionally required an enormous budget for data, software, and consultants. Many mortgage banks are left with either using outdated and inflexible internal systems or outsourcing their analytics to third parties that lack full transparency and bill clients for every request. 

Not anymore.

The answer is a cloud-native MSR analytical solution that includes slice-and-dice-able Agency loan performance data as well as the models necessary to produce valuations, risk analytics and cash flows across both MSRs and associated derivative hedges, where applicable.

By integrating data, models, and reports, this combined solution enables mortgage banks to:

  • Generate internal metrics to compare with those received from third party brokers and consultants
  • Measure the fair value and cash flows of their MSRs under different scenarios and assumptions including a variety of recapture assumptions
  • Analyze the sensitivity of their MSRs (and associated hedges) to changes in interest rates, prepayment speeds, defaults, home prices and other factors
  • Compare their portfolio’s performance and characteristics with the market and industry peers
  • Generate customized reports and dashboards to share with investors, auditors, and regulators

More specifically, RiskSpan’s comprehensive data and analytics solution enables you to do the following:

1. Check assumptions used by outside analysts to run credit and prepayment analytics

Even in cases where the analytics are provided by a third party, mortgage banks frequently benefit from having their own analytical solution. Few things are more frustrating than analytics generated by a black box with no/limited visibility into assumptions or methodology. RiskSpan’s MSR tool provides mortgage banks with an affordable means of checking the assumptions and methodologies used by outside analysts to run credit and prepayment analytics on their portfolio.

Different analysts use different assumptions and models to run credit and prepayment analytics, often leading to inconsistent results that are difficult to explain. Some analysts use historical data while others rely on forward-looking projections. Some analysts simple models while others turn to complex one. Some analysts are content with industry averages while others dig into portfolio-specific data.

Having access to a fully transparent MSR analytical solution of their own allows mortgage banks to check the assumptions and models used by outside analysts for reasonableness and consistency. In addition to helping with results validation and identification of discrepancies or errors, it also facilitates communication of the rationale and logic behind assumptions and models to investors and regulators.  Lastly, the ability for a mortgage bank to internally generate MSR valuations and cash flows allows for a greater understanding of the economic value (vs. accounting value) of the asset they hold.

2. Understand how your portfolio’s prepayment performance stacks up against the market

Prepayment risk is one of the main drivers of MSR value and volatility. Mortgage banks need to know how their portfolio’s prepayment performance compares with the market and their peers. Knowing this helps mortgage banks field questions from investors, who may be concerned about the impact of prepayments on profitability and liquidity. It also helps identify areas of improvement and opportunity for the portfolio.

RiskSpan’s MSR analytical solution helps track and benchmark portfolio prepayment performance using various metrics, including CPR and SMM. It also helps analysts understand the drivers and trends of prepayments, such as interest rates, loan age, loan type, credit score, and geographic distribution. RiskSpan’s MSR analytical solution combined with its historical performance data provides a deeper understanding of how a portfolio’s prepayment performance stacks up against the market and what factors affect it.

And it’s less expensive than you might think

You may think that deploying an MSR analytical solution is too costly and complex, as it requires a lot of data, software, and expertise. However, this is not necessarily true.

Bundling RiskSpan’s MSR analytical solution with RiskSpan’s Agency historical performance tool actually winds up saving clients money by helping them optimize their portfolios and avoid costly mistakes. The solution:

  • Reduces the need for external data, software, and consultants because all the information and tools needed are in one platform
  • Maximizes portfolio performance and profitability by helping to identify and capture opportunities and mitigate risks, including through recapture analysis and active hedging
  • Enhances reputation and credibility by improving transparency to investors and regulators

RiskSpan’s solution is affordable and easy to use, with flexible pricing and deployment options, as well as user-friendly features and support, including intuitive interfaces, interactive dashboards, and comprehensive training and guidance. Its cloud-native, usage-based pricing structure means users pay only for the compute they need (in addition to a nominal licensing fee).

Contact us to learn more about how RiskSpan’s Edge Platform can help you understand how your MSR portfolio’s performance stacks up against the market, check assumptions used by outside analysts to run credit and prepayment analytics, and, most important, save money and time.


What Do 2024 Origination Trends Mean for MSRs?

While mortgage rates remain stubbornly high by recent historical standards, accurately forecasting MSR performance and valuations requires a thoughtful evaluation of loan characteristics that go beyond the standard “refi incentive” measure.

As we pointed out in 2023, these characteristics are particularly important when it comes to predicting involuntary prepayments.

This post updates our mortgage origination trends for the first quarter of 2024 and takes a look at what they could be telling us.

Average credit scores, which were markedly higher than normal during the pandemic years, have returned and stayed near the averages observed during the latter half of the 2010s.

The most credible explanation for this most recent reversion to the mean is the fact that the Covid years were accompanied by an historically strong refinance market. Refis traditionally have higher FICO scores than purchase mortgages, and this is apparent in the recent trend.

Purchase markets are also associated with higher average LTV ratios than are refi markets, which accounts for their sharp rise during the same period.

Consequently, in 2023 and 2024, with high home prices persisting despite extremely high interest rates, new first-time homebuyers with good credit continue to be approved for loans, but with higher LTV and DTI ratios.

Between rates and home prices, ​​borrowers simply need to borrow more now than they would have just a few years ago to buy a comparable house. This is reflected not just in the average DTI and LTV, but also the average loan size (below) which, unsurprisingly, continues to trend higher as well.

Recent large increases to the conforming loan limit are clearly also contributing to the higher average loan size.

What, then, do these origination trends mean for the MSR market?

The very high rates associated with newer originations clearly translate to higher risk of prepayments. We have seen significant spikes in actual speeds when rates have taken a leg down — even though the loans are still very new. FICO/LTV/DTI trends also potentially portend higher delinquencies down the line, which would negatively impact MSR valuations.

Nevertheless, today’s MSR trading market remains healthy, and demand is starting to catch up with the high supply as more money is being raised and put to work by investors in this space. Supply remains high due to the need for mortgage originators to monetize the value of MSR to balance out the impact from declining originations.

However, the nature of the MSR trade has evolved from the investor’s perspective. When rates were at historic lows for an extended period, the MSR trade was relatively straightforward as there was a broader secular rate play in motion. Now, however, bidders are scrutinizing available deals more closely — evaluating how speeds may differ from historical trends or from what the models would typically forecast.

These more granular reviews are necessarily beginning to focus on how much lower today’s already very low turnover speeds can actually go and the extent of lock-in effects for out-of-the-money loans at differing levels of negative refi incentive. Investors’ differing views on prepays across various pools in the market will often be the determining factor on who wins the bid.

Investor preference may also be driven by the diversity of an investor’s other holdings. Some investors are looking for steady yield on low-WAC MSRs that have very small prepayment risk while other investors are seeking the higher negative convexity risk of higher-WAC MSRs — for example, if their broader portfolio has very limited negative convexity risk.

In sum, investors have remained patient and selective — seeking opportunities that best fit their needs and preferences.

So what else do MSR holders need to focus on that may may impact MSR valuations going forward? 

The impact from changes in HPI is one key area of focus.

While year-over-year HPI remains positive nationally, servicers and other investors really need to look at housing values region by region. The real risk comes in the tails of local home price moves that are often divorced from national trends. 

For example, HPIs in Phoenix, Austin, and Boise (to name three particularly volatile MSAs) behaved quite differently from the nation as a whole as HPIs in these three areas in particular first got a boost from mass in-migration during the pandemic and have since come down to earth.

Geographic concentrations within MSR books will be a key driver of credit events. To that end, we are seeing clients beginning to examine their portfolio concentration as granularly as zipcode level. 

Declining home values will impact most MSR valuation models in two offsetting ways: slower refi speeds will result in higher MSR values, while the increase in defaults will push MSRs back downward. Of these two factors, the slower speeds typically take precedence. In today’s environment of slow speeds driven primarily by turnover, however, lower home prices are going to blunt the impact of speeds, leaving MSR values more exposed to the impact of higher defaults.


Enriching Pre-Issue Intex CDI Files with [Actual, Good] Loan-Level Data

The way RMBS dealers communicate loan-level details to prospective investors today leaves a lot to be desired.

Any investor who has ever had to work with pre-issue Intex CDI files can attest to the problematic nature of the loan data they contain. Some are better than others, but virtually all of them lack information about any number of important loan features.

Investors can typically glean enough basic information about balances and average note rates from preliminary CDI files to run simple, static CPR/CDR scenarios. But information needed to run complex models — FICO scores, property characteristics and geography, and LTV ratios to name a few — is typically lacking. MBS investors who want to run to run more sophisticated prepayment and credit models – models that rely on more comprehensive loan-level datasets to run deeper analytics and scenarios – can be left holding the bag when these details are missing from the CDI file.

The loan-level detail exists – it’s just not in the CDI file. Loan-level detail often accompanies the CDI file in a separate spreadsheet (still quaintly referred to in the 21st Century as a “loan tape”). Having this data separate from the CDI file requires investors to run the loan tape through their various credit and prepayment models and then manually feed those results back into the Intex CDI file to fully visualize the deal structure and expected cash flows.

This convoluted, multi-step workaround adds both time and the potential for error to the pre-trade analytics process.

A Better Way

Investors using RiskSpan’s Edge Platform can streamline the process of evaluating a deal’s structure alongside the expected performance of its underlying mortgage loans into a single step.

EDGEPLATFORM

Here is how it works.

As illustrated above, when investors set up their analytical runs on Edge, RiskSpan’s proprietary credit and prepayment models automatically extract all the required loan-level data from the tape and then connect the modeling results to the appropriate corresponding deal tranche in the CDI file. This seamlessness reduces all the elements of the pre-trade analytics process down to a matter of just a few clicks.

Making all this possible is the Edge Platform’s Smart Mapper ETL solution, which allows it to read and process loan tapes in virtually any format. Using AI, the Platform recognizes every data element it needs to run the underlying analytics regardless of the order in which the data elements are arranged and irrespective of how (or even whether) column headers are used.

Contact us to learn more about how RMBS investors are reaping the benefits of consolidating all of their data analytics on a single cloud-native platform.


Case Study: How a Large Financial Institution Allayed Regulator Concerns by Digitizing its Model Performance Tracking

The Situation 

One of the largest financial institutions in the world, operating in a highly competitive and regulated environment, found itself under increasing scrutiny over the fragmented state of its model performance tracking regime.

Failing to meet both internal standards and external regulatory expectations, the the institution’s model performance tracking relied on a loan-level analytical framework that overloaded its legacy systems and hindered its ability to react to changing market dynamics. These inadequacies led to significant challenges beyond regulatory scrutiny, including inefficiencies in risk management processes and higher overhead costs. The outlook for rectifying these shortcomings was murky. 

The Challenge 

The institution’s challenges were twofold.  

First, regulatory pressure was mounting, with potential repercussions including fines and restrictions on business activities. Regulators demanded transparent, accurate, and timely reporting of model performance, which the institution’s existing system could not provide. 

Second, the operational issues stemming from lackluster model performance tracking were beginning to affect the institution’s ability to capitalize on opportunities. These impacts included inaccurate risk assessments, suboptimal asset allocation, and impaired decision-making capabilities, all of which eroded the institution’s competitive edge.

The Solution 

The institution sought RiskSpan’s expertise to deliver a sustainable and effective MPT framework. The trust the institution placed in RiskSpan was grounded in RiskSpan’s history of helping other financial institutions navigate similar MPT shortcomings. 

RiskSpan conducted an in-depth gap analysis, developed a customized solution, and provided training and support. Designed to enhance the accuracy, efficiency, and transparency of model performance tracking, the solution incorporated advanced analytics, a holistic governance approach, and robust data management practices. Key components included:

Model Inventory Management: Creating a centralized repository for all models, including inputs, assumptions, and ownership to streamline tracking and compliance.

Model Performance Dashboard: Implementing a real-time monitoring dashboard that provides insights into each model’s performance, deviations from expected outcomes, and potential areas of concern.

Regulatory Compliance: Automating the generation of reports to ensure compliance with regulatory standards, reducing manual errors, and freeing up resources for other critical functions.

Training and Support: Providing comprehensive training to the institution’s staff to ensure they can effectively utilize the new system and offering ongoing support to address any issues promptly.

The partnership led to transformative outcomes, including improved risk management, reduced manual errors, and operational costs.

What this means for you (and your bank)

Precise model performance tracking can enhance risk management, regulatory compliance, and operational efficiency. Our expertise ensures that our clients are equipped with robust, cutting-edge solutions tailored to their specific needs. If you are encountering challenges, we encourage you to reach out to us for a consultation.


RiskSpan, Dominium Advisors Announce Market Color Dashboard for Mortgage Loan Investors


ARLINGTON, Va., January 24, 2024 – RiskSpan, the leading tech provider of data management and analytics services for loans and structured products, has partnered with tech-enabled asset manager Dominium Advisors to introduce a new whole loan market color dashboard to RiskSpan’s Edge Platform.

This new dashboard combines loan-level market pricing and trading data with risk analytics for GSE-eligible and non-QM loans. It enables loan investors unprecedented visibility into where loans are currently trading and insight on how investors can currently achieve excess risk-adjusted yields.

Dashboard

The dashboard highlights Dominium’s proprietary loan investment and allocation approach, which allows investors to evaluate any set of residential loans available for bid. Leveraging RiskSpan’s collateral models and risk analytics, Dominium’s software helps investors maximize yield or spread subject to investment constraints, such as a risk budget, or management constraints, such as concentration limits.

“Our strategic partnership with RiskSpan is a key component of our residential loan asset management operating platform ,” said Peter A. Simon, Founder and CEO of Dominium Advisors. “It has enabled us to provide clients with powerful risk analytics and data management capabilities in unprecedented ways.”

“The dashboard is a perfect complement to our suite of analytical tools,” noted Janet Jozwik, Senior Managing Director and Head of Product for RiskSpan’s Edge Platform. “We are excited to be a conduit for delivering this level of market color to our mortgage investor clients.”

The market color dashboard (and other RiskSpan reporting) can be accessed by registering for a free Edge Platform login at https://riskspan.com/request-access/.

### 

About RiskSpan, Inc. 

RiskSpan offers cloud-native SaaS analytics for on-demand market risk, credit risk, pricing and trading. With an unparalleled team of data science experts and technologists, RiskSpan is the leader in data as a service and end-to-end solutions for loan-level data management and analytics.

Its mission is to be the most trusted and comprehensive source of data and analytics for loans and structured finance investments. Learn more at www.riskspan.com.

About Dominium Advisors Dominium Advisors is a tech-enabled asset manager specializing in the acquisition and management of residential mortgage loans for insurance companies and other institutional investors. The firm focuses on newly originated residential mortgage loans made to high quality borrowers – GSE eligible, jumbo and non-QM. Its proprietary loan-level software makes possible the construction of loan portfolios that achieve investor defined objectives such as higher risk-adjusted yields and spreads or limited exposure to tail risk events. Learn more at dominiumadvisors.com.


Connect with us at SFVegas 2024

Click Here to book a time to connect

RiskSpan is delighted to be sponsoring SFVegas 2024!

Connect with our team there to learn how we can help you move off your legacy systems, streamline workflows and transform your data.

SFA-Attendees
Click Here to book a time to connect

Don’t miss these RiskSpan presenters at SFVegas 2024

Bernadette Kogler

Housing Policy:
What’s Ahead
Mon, Feb 26th, 1:00 PM

Tom Pappalardo

Future of Fintech
Wed, Feb 28th, 9:15 AM

Divas Sanwal Photo (3)

Divas Sanwal

Big Data & Machine Learning: Impacts on Origination
Wed, Feb 28th, 11:05 AM

Can’t make the panels?

Click here to make an appointment to connect. Or just stop by Booth 13 in the exhibit hall!


Impact of Mr. Cooper’s Cyber Security Incident on Agency Prepayment Reporting

Amid the fallout of the cyberattack against Mr. Cooper on October 31st was an inability on the large servicer’s part to report prepayment activity to investors.

According to Freddie Mac, the incident “resulted in [Mr. Cooper’s] shutting down certain systems as a precautionary measure. As a result, Freddie Mac did not receive loan activity reporting, which includes loan payoffs and payment corrections, from Mr. Cooper during the last few days of the reporting period related to October loan activity.”

Owing to Mr. Cooper’s size, were curious to measure what (if any) impact its missing days of reporting might have on overall agency speeds.

Not a whole lot, it turns out.

This came as little surprise given the very low prepayment environment in which we find ourselves, but we wanted to run the numbers to be sure. Here is what we found.

We do not know precisely how much reporting was missed and assumed “the last few days of the reporting period” to mean 3 days.

Assuming 3 days means that Mr. Cooper’s reported speeds of 4.5 CPR to Freddie and 4.6 CPR to Fannie likely should have been 5.2 CPR and 5.4 CPR, respectively. While these differences are relatively small for to Mr. Cooper’s portfolio (less than 1 CPR) the impact on overall Agency speeds is downright trivial — less than 0.05 CPR.

Fannie MBSFreddie MBS
Sch. Bal.195,221,550,383168,711,346,228
CPR (reported)4.64.5
CPR (estimated*)5.45.2
*assumes three days of unreported loan activity and constant daily prepayments for the month

Fannie Mae and Freddie Mac will distribute scheduled principal and interest when servicers do not report the loan activity. Prepayments that were not reported “will be distributed to MBS certificateholders on the first distribution date that follows our receipt and reconciliation of the required prepayment information from Mr. Cooper.”


Snowflake Tutorial Series: Episode 3

Using External Tables Inside Snowflake to work with Freddie Mac public data (13 million loans across 116 fields)

Using Freddie Mac public loan data as an example, this five-minute tutorial succinctly demonstrates how to:

  1. Create a storage integration
  2. Create an external stage
  3. Grant access to stage to other roles in Snowflake
  4. List objects in a stage
  5. Create a format file
  6. Read/Query data from external stage without having to create a table
  7. Create and use an external table in Snowflake

This is the third in a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.

Episode 1, Setting Up a Database and Uploading 28 Million Mortgage Loans, is available here.

Episode 2, Using Python User-Defined Functions in Snowflake SQL, is available here.

Future topics will include:

  • OLAP vs OLTP and hybrid tables in Snowflake
  • Time Travel functionality, clone and data replication
  • Normalizing data and creating a single materialized view
  • Dynamic tables data concepts in Snowflake
  • Data share
  • Data masking
  • Snowpark: Data analysis (pandas) functionality in Snowflake

RiskSpan’s Snowflake Tutorial Series: Ep. 2

Learn how to use Python User-Defined Functions in Snowflake SQL

Using CPR computation for a pool of mortgage loans as an example, this six-minute tutorial succinctly demonstrates how to:

  1. Query Snowflake data using SQL
  2. Write and execute Python user-defined functions inside Snowflake
  3. Compute CDR using Python UDF inside Snowflake SQL

This is this second in a 10-part tutorial series demonstrating how RiskSpan’s Snowflake integration makes mortgage and structured finance analytics easier than ever before.

Episode 1, Setting Up a Database and Uploading 28 Million Mortgage Loans, is available here.

Future topics will include:

  • External Tables (accessing data without a database)
  • OLAP vs OLTP and hybrid tables in Snowflake
  • Time Travel functionality, clone and data replication
  • Normalizing data and creating a single materialized view
  • Dynamic tables data concepts in Snowflake
  • Data share
  • Data masking
  • Snowpark: Data analysis (pandas) functionality in Snowflake

Get Started
Log in

Linkedin   

risktech2024