Toll Free 1-877-506-2744
How can we help?

Advanced Analytics

Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

Sections

 

The Advanced Analytics screen can be viewed in an Opportunity if your local Administrator has given you access. For information on granting access to Advanced Analytics for Administrators, visit Setting Up Security Profiles.

 

Accessing Advanced Analytics

On the Opportunity Screen, click the Advanced Analytics button on the upper right side.

The Advanced Analytics button is next to Assumptions at the upper right.

 

This opens the Analytics screen with options for Profitability, Credit Risk, and Amortization on the side.

 

Profitability

The Profitability section is focused on factors that impact the profitability of the loan. For this example, we are displaying Net Income, ROA, and ROE. However, the profitability measures may be different on your screen. 

 

Rate Sensitivity

  • This will only be displayed for fixed rate loans

The Rate Sensitivity Graph shows the profitability of a fixed rate loan.

This graph shows the Initial Rate versus return and where the current Rate is compared to the suggested Rate to meet the Target Return on a fixed rate loan. 

 

Spread Sensitivity

  • This will only be displayed for floating rate loans

The Spread Sensitivity Graph shows the profitability of a floating rate loan.

This displays the resulting return as we change the Spread of the floating rate loan, and where the current rate is compared to the target.

 

Rate and Spread Sensitivity

  • This will only be displayed for adjustable rate loans

The Rate and Spread Sensitivity shows the profitability of an adjustable rate loan.

Rather than show the return versus either the Initial Rate or the Spread, we have instead calculated the Rate vs the Spread, displayed 30-40 values that will hit the target exactly (though some are teaser rates, left of the target), and additionally what combinations would be below target (red area) and which would be above (green) and where the Current and Target suggestions are.

 

 

LOC Usage Sensitivity

  • This will only be displayed for lines of credit

The LOC Usage Sensitivity chart shows the ROE of lines of credit.

The LOC Utilization Sensitivity chart shows the return for the range from 0% to 100% utilization and where the return is on that line based on the current loan details. This example shows us the importance of either a high level of confidence in our Estimated Utilization or a good reason to considering adjustments to the fee structure.

 

 

Credit Risk

The Credit Risk section is focused on factors that impact the credit risk associated with the loan.

The Credit Risk Rating Sensitivity shows the ROE and Net Income for five risk ratings.

This chart shows us two ratings on either side of our current Risk Rating. We can see the impact if the actual Risk Rating is below or above our expectations and what that means not only in terms of return but also Net Income and the Equivalent amount of Rate from our current position.

Collateral Sensitivity

  • This will only be displayed if you have collateral attached to this loan

The Collateral Sensitivity chart shows the impact of collateral value on ROE.

For Collateral Sensitivity, we calculate the return from 50% below the Collateral Value to 50% above so we can see the relative impact to return across a fairly wide range.

 

 

Amortization

The "Amortization" section displays the amortization table for this loan. You can use the "Copy to Clipboard" button and easily transfer it over to Excel.

The Amortization table displays amortization information over the life of the loan.

 

When you paste this information into Excel, if some of the information is pasted as pound signs, you can easily fix this by widening the columns.

 

The exported Amortization table may show pound signs but can be fixed by widening columns

 

Follow the directions in Microsoft's Support Article to change the column width to automatically fit the contents.

 

Information

The Information section allows you to select the desired scenario from a drop-down menu, and displays the Short Code for the selected scenario. This can then be copied to the clipboard.

information.PNG

 

 

 

Scenario Comparison

The Scenario Comparison section shows the financial statement, as it appears in the opportunity, for each scenario currently being priced.

scen._comparison.PNG

 

You can hover over the columns to see additional financial information for each scenario in the chart.

 

hover_text.PNG

 

You can use the "Copy to Clipboard" button and easily transfer it over to Excel. 

 

excel_1.PNG

 

 

Horizon Financials

The Horizon Financials section shows the financial statement, as it appears in the opportunity, for each scenario being priced for specific durations of the loan.

 

horizon.PNG

 

You can hover over the columns to see additional financial information for each scenario in the chart.

 

horizon_hover.PNG

 

The drop-down menu at the top allows you to select the financial statements for different durations of the loan (the first year, the first two years, the first three years, etc.) until its maturity. You can also choose to see the financial statements for the entire term by selecting "Lifetime".

 

horizon_dropdown.PNG

 

The Copy to Clipboard button at the top allows you to copy this information to your clipboard to paste into Excel.

 

excel_1.PNG

Was this article helpful?
Have more questions?