Linkedin    Twitter   Facebook

Get Started
Log In

Linkedin

Articles Tagged with: Loans

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.


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.


RiskSpan to Launch Usage-based Pricing for its Edge Platform at SFVegas 2024 

New innovative pricing model offers lower costs, transparency, and flexibility for analytics users 

RiskSpan, a top provider of cloud-based analytics solutions for loans, MSRs, structured products and private credit, announced today the launch of a usage-based pricing model for its Edge Platform. The new pricing model enables clients flexibility to pay only for the compute they use. It also gives clients access to the full platform, including data, models, and analytics, without having to license individual product modules. 

Usage-based pricing is a trend that reflects the evolving nature of analytics and the increasing demand for more flexible, transparent, and value-driven pricing models. It is especially suited for the dynamic and diverse needs of analytics users, whose data volumes, usage patterns, and analytical complexity requirements often fluctuate with the markets.

RiskSpan was an early adopter of the Amazon Web Services (AWS) cloud in 2010. Its new usage-based pricing, powered by the AWS cloud, enables RiskSpan to invoice its clients based on user-configured workloads, which can scale up or down as needed. 

“Usage-based pricing is a game-changer for our clients and the industry,” said Bernadette Kogler, CEO of RiskSpan. “It aligns our pricing with the value we deliver and the outcomes we enable for our clients. It also eliminates the waste and inefficiency of paying for unused, fixed-fee compute capacity, year after year in long-term, set price contracts. Now our clients can optimize their spending while experimenting with all the features our platform has to offer.”

“We are excited RiskSpan chose AWS to launch its new pricing model. Our values are aligned in earning trust through transparent variable pricing that allows our customers to innovate and remain agile.” said Ben Schreiner, Head of Business Innovation, at Amazon Web Services. “By leveraging the latest in AWS technology, including our generative AI services, RiskSpan is accelerating the value they deliver to their customers, and ultimately, the entire financial services industry.”

Usage-based pricing offers several benefits for RiskSpan clients, including: 

  • Lower Costs: Clients pay only for what they need, rather than being locked into an expensive contract that may not suit their current or future situation. 
  • Cost Sharing: Clients can share costs across the enterprise and better manage expense based on usage by individual functions and business units. 
  • Transparency: Clients can monitor their usage and directly link their analytics configuration and usage to their results and goals. They can also better control their spending by tracking their usage and seeing how it affects their bill. 
  • Flexibility: Clients can experiment with different features and options of RiskSpan’s Edge Platform, as they are not restricted by a predefined package or plan. 

For a free demo, visit https://riskspan.com/ubp/.

### 

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.


What is the Draw of Whole Loan Investing?

Mortgage whole loans are having something of a moment as an asset class, particularly among insurance companies and other nonbank institutional investors. With insurance companies increasing their holdings of whole loans by 35 percent annually over the past three years, many people are curious what it is about these assets that makes them so appealing in the current environment.

We sat down with Peter Simon, founder and CEO of Dominium Advisors, a tech-enabled asset manager specializing in the acquisition and management of residential mortgage loans for insurance companies and other institutional investors. As an asset manager, Dominium focuses on performing the “heavy lifting” related to loan investing for clients. 

How has the whole loan asset class evolved since the 2008 crisis? How have the risks changed?

Peter Simon: Since 2008, laws and regulations like the Dodd-Frank act and the formation of the Consumer Financial Protection Bureau have created important risk guardrails related to the origination of mortgage products. Many loan and mortgage product attributes, such as underwriting without proper documentation of income or assets or loan structures with negative amortization, which contributed to high levels of mortgage defaults in 2008 are no longer permissible. In fact, more than half of the types of mortgages that were originated pre-crisis are no longer permitted under the current “qualified mortgage” regulations.  In addition, there have been substantial changes to underwriting, appraisal and servicing practices which have reduced fraud and conflicts of interest throughout the mortgage lifecycle.

How does whole loan investing fit into the overall macro environment?

Peter Simon: Currently, the macro environment is favorable for whole loan investing. There is a substantial supply-demand imbalance – meaning there are more buyers looking for places to live then there are homes for them to live in. At the current rates of new home construction, mobility trends, and household formation, it is expected that this imbalance will persist for the next several years.  Demographic trends are also widening the current supply demand imbalance as more millennial buyers are entering their early 30s – the first time-homebuyer sweet spot.  And work from home trends created by the pandemic are creating a desire for additional living space.

Who is investing in whole loans currently?

Peter Simon: Banks have traditionally been the largest whole loan investors due to their historical familiarity with the asset class, their affiliated mortgage origination channels, their funding advantage and favorable capital rules for holding mortgages on balance sheet.  Lately, however, banks have pulled back from investing in loans due to concerns about the stickiness of deposits, which have been used traditionally to fund a portion of mortgage purchases, and proposed bank capital regulations that would make it more costly for banks to hold whole loans.  Stepping in to fill this void are other institutional investors — insurance companies, for example — which have seen their holdings of whole loans increase by 35% annually over the past 3 years. Credit and hedge funds and pension funds are also taking larger positions in the asset class. 

What is the specific appeal of whole loans to insurance companies and these other firms that invest in them?

Peter Simon: Spreads and yields on whole loans produce favorable relative value (risk versus yield) when compared to other fixed income asset classes like corporate bonds.  Losses since the Financial Crisis have been exceptionally low due to the product, process and regulatory improvements enacted after the Financial Crisis.  Whole loans also produce risks in a portfolio that tend to increase overall portfolio diversification.  Borrower prepayment risk, for example, is a risk that whole loan investors receive a spread premium for but is uncorrelated with many other fixed income risks.  And for investors looking for real estate exposure, residential mortgage risk has a much different profile than commercial mortgage risk.

Why don’t they just invest in non-Agency securities?

Peter Simon: Many insurance companies do in fact buy RMBS securities backed by non-QM loans.  In fact, most insurance companies who have residential exposure will have it via securities.  The thesis around investing in loans is that the yields are significantly higher (200 to 300 bps) than securities because loans are less liquid, are not evaluated by the rating agencies and expose the insurer to first loss on a defaulted loan.  So for insurance investors who believe the extra yield more than compensates them for these extra risks (which historically over the last 15 years it has), they will likely be interested in investing in loans.

What specific risk metrics do you evaluate when considering/optimizing a whole loan portfolio – which metrics have the highest diagnostic value?

Peter Simon: Institutional whole loan investors are primarily focused on three risks: credit risk, prepayment risk and liquidity risk. Credit risk, or the risk that an investor will incur a loss if the borrower defaults on the mortgage is typically evaluated using many different scenarios of home price appreciation and unemployment to evaluate both expected losses and “tail event” losses.  This risk is typically expressed as projected lifetime credit losses.  Prepayment risk is commonly evaluated using loan cash flow computed measures like option adjusted duration and convexity under various scenarios related to the potential direction of future interest rates (interest rate shocks).

How would you characterize the importance of market color and how it figures into the overall assessment/optimization process?

Peter Simon: Newly originated whole loans like any other “new issue” fixed income product are traded in the market every day.  Whole loans are generally priced at the loan level based on their specific borrower, loan and property attributes.  Collecting and tabulating loan level prices every day is the most effective way to construct an investment strategy that optimizes the relative differences between loans with different yield characteristics and minimizes credit and prepayment risks in many various economic and market scenarios.


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.


The future of analytics pricing is RiskSpan’s Usage-based delivery model

Usage-based pricing model brings big benefits to clients of RiskSpan’s Edge Platform

Analytic solutions for loans, MSRs and structured products are typically offered as software-as-a-service (SaaS) or “on-prem” products, where clients pay a monthly or annual fee to access the software and its features. The compute needed to run analytic workloads is typically purchased in advance and is fixed regardless of the need or use case.  

However, this traditional pricing model is not always the best fit for the dynamic and diverse needs of analytics users. It is technologically outdated and does not meet users where they are – with varying data volumes, usage patterns, and analytical complexity requirements that fluctuate with the markets. It is simply wasteful for companies to pay for unused, fixed-fee compute capacity, year-after-year in long-term, set price contracts, when their needs don’t require it. 

Usage-based pricing is a trend that reflects the evolving nature of analytics and the increasing demand for more flexible, transparent, and value-driven pricing models.

RiskSpan has just announced the release of industry-innovating usage-based pricing that allows clients to scale up or down, based on their needs. Further, clients of the RiskSpan platform will now benefit from access to the full Edge Platform, including data, models and analytics – eliminating the need to license individual product modules. The Platform supports loans, MSRs and securities, with growing capabilities around private credit. Analyzing these assets can be compute- and data-intensive because of the need for collateral (loan-level) data and models to price, value, and calculate risk metrics.

A Single Platform
Integrated Data | Trade Analytics | Risk Management

Core Engine

Usage-based pricing is an innovative alternative approach based on user-configured workloads. It enables RiskSpan to invoice its clients according to how much compute they actually need and use, rather than a fixed fee based on the modules they purchased during the last budget cycle.  

Usage-based pricing benefits RiskSpan clients in several ways, including: 

    • Lower Costs: Clients pay only for what they need, rather than being locked into an expensive contract that may not suit their current or future situation.

    • Cost-Sharing Across the Enterprise: Clients can share costs across the enterprise and better manage expense based on usage by internal functions and business units.

    • Transparency: Clients can monitor their usage and directly link their analytics configuration and usage to their results and goals. They can also better control their spending, as they can track their usage and see how it affects their bill.

    • Flexibility: Clients can experiment with different features and options of the Platform, as they are not restricted by a predefined package or plan.

Usage-based pricing is not a one-size-fits-all solution, and it may not be suitable for every organization. Based on needs, large enterprise workloads will require specific, customized licensing and may benefit from locked in compute that comes with volume discounts.

Bottom Line on RiskSpan’s Usage-based Pricing Model

CONS of Traditional Fixed Fee Pricing PROS of Usage-Based Pricing
Flat-fee pricing models force customers to pay for unused capacity​. Lower Costs — Pay only for what you use, not the wasted capacity of a dedicated cluster
Unused capacity cannot be shared across the enterprise, which translates into wasted resources and higher costs. Cost Sharing — Costs can be shared across the enterprise to better manage expense based on usage by your internal functions and business units
Fixed pricing models make it difficult for customers to scale up or down as needed. Transparency — Transparent pricing that fits your specific analytics workload (size, complexity, performance)
Traditional “product module-based” purchasing runs the risk of over-buying on features that will not be used. Flexibility — Scale up and scale down your use as new and in-place features become useful to you under different market conditions

With the introduction of usage-based pricing, RiskSpan is adding core value to its Edge Platform and a low-cost entry point to bring its solution to a wider base of clients. Its industry-leading capabilities solve challenges facing various users in the loans, MSR, and structured portfolio domains. For example:

    1. Loan/MSR Trader seeks analytics to support bidding on pools of loans and/or MSRs. Their usage is ad-hoc and will benefit from usage-based pricing. Traders and investors can analyze prepay and credit performance trends by leveraging RiskSpan’s 20+ years of historical performance datasets.

    1. Securities Trader (Agency or Non-Agency) wants more flexibility to set their prepay or credit model assumptions to run ad-hoc scenario analysis not easily handled by their current vendor.

    1. Risk Manager wants another source of valuation for periodic MSR and loan portfolios to enhance decision making and compare against the marks from their third-party valuation firm. 

    1. Private Credit Risk Manager needs a built-for-purpose private credit analytics system to properly run risk metrics. Users can run separate and run ad hoc analysis on these holdings.

For more specific information about how RiskSpan will structure pricing with various commitment levels, click below to tell us about your needs, and a representative will be in touch with you shortly. 


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

RiskSpan Adds CRE, C&I Loan Analytics to Edge Platform

ARLINGTON, Va., March 23, 2023 – RiskSpan, a leading technology company and the most comprehensive source for data management and analytics for mortgage and structured products, has announced the addition of commercial real estate (CRE) and commercial and industrial (C&I) loan data intake, valuation, and risk analytics to its award-winning Edge Platform. This enhancement complements RiskSpan’s existing residential mortgage toolbox and provides clients with a comprehensive toolbox for constructing and managing diverse credit portfolios.

Now more than ever, banks and credit portfolio managers need tools to construct well diversified credit portfolios resilient to rate moves and to know the fair market values of their diverse credit assets.

The new support for CRE and C&I loans on the Edge Platform further cements RiskSpan’s position as a single-source provider for loan pricing and risk management analytics across multiple asset classes. The Edge Platform’s AI-driven Smart Mapping (tape cracking) tool lets clients easily work with CRE and C&I loan data from any format. Its forecasting tools let clients flexibly segment loan datasets and apply performance and pricing assumptions by segment to generate cash flows, pricing and risk analytics.

CRE and C&I loans have long been supported by the Edge Platform’s credit loss accounting module, where users provided such loans in the Edge standard data format. The new Smart Mapping support simplifies data intake, and the new support for valuation and risk (including market risk) analytics for these assets makes Edge a complete toolbox for constructing and managing diverse portfolios that include CRE and C&I loans. These tools include cash flow projections with loan-level precision and stress testing capabilities. They empower traders and asset managers to visualize the risks associated with their portfolios like never before and make more informed decisions about their investments.

Comprehensive details of this and other new capabilities are available by requesting a no-obligation demo at riskspan.com.

### 

About RiskSpan, Inc. 

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

Our 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.


RiskSpan Incorporates Flexible Loan Segmentation into Edge Platform

ARLINGTON, Va., March 3, 2023 — RiskSpan, a leading technology company and the most comprehensive source for data management and analytics for residential mortgage and structured products, has announced the incorporation of Flexible Loan Segmentation functionality into its award-winning Edge Platform.

The new functionality makes Edge the only analytical platform offering users the option of alternating between the speed and convenience of rep-line-level analysis and the unmatched precision of loan-level analytics, depending on the purpose of their analysis.

For years, the cloud-native Edge Platform has stood alone in its ability to offer the computational scale necessary to perform loan-level analyses and fully consider each loan’s individual contribution to a mortgage or MSR portfolio’s cash flows. This level of granularity is of paramount importance when pricing new portfolios, taking property-level considerations into account, and managing tail risks from a credit/servicing cost perspective.

Not every analytical use case justifies the computational cost of a full loan-level analysis, however. For situations where speed requirements dictate the use of rep lines (such as for daily or intra-day hedging needs), the Edge Platform’s new Flexible Loan Segmentation affords users the option to perform valuation and risk analysis at the rep line level.

Analysts, traders and investors take advantage of Edge’s flexible calculation specification to run various rate and HPI scenarios, key rate durations, and other calculation-intensive metrics in an efficient and timely manner. Segment-level results run at both loan and rep line level can be easily compared to assess the impacts of each approach. Individual rep lines are easily rolled up to quickly view results on portfolio subcomponents and on the portfolio as a whole.

Comprehensive details of this and other new capabilities are available by requesting a no-obligation demo at riskspan.com.

This new functionality is the latest in a series of enhancements that further the Edge Platform’s objective of providing frictionless insight to Agency MBS traders and investors, knocking down barriers to efficient, clear and data-driven valuation and risk assessment.

###

About RiskSpan, Inc. 

RiskSpan offers cloud-native SaaS analytics for on-demand market risk, credit risk, pricing and trading. With our data science experts and technologists, we are the leader in data as a service and end-to-end solutions for loan-level data management and analytics. Our 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.


Get Started
Log in

Linkedin   

risktech2024