Home Insights & Reports [Done]

Insights & Reports [Done]

My Reports and Deal Reports

Within the Reports tab on platform, a user will see both My Reports and Deal Reports tabs. Reports located under the My Reports tab are private reports that are created by that user. Deal Reports are reports that were created by the Deal Owner or pre-built by T-REX. When a

Reports Functionality

Report Widget Functionality: Both My Reports and Deal Reports can contain different types of graph and table widgets. Within one report, users can add up to 12 reporting widgets. Users can minimize or expand the widgets within their reports. To reorganize the layout of the report, simply drag the widgets

Insights Functionality

T-REX Insights strengthen the platform's reporting tools for collateral, pool and bond level data. Insights uses business intelligence functionality for users to quickly digest trends and understand the drivers behind these variations. These enhanced pre-built dashboards are equipped with reporting tools that can give insight across entire deal

Cash Flow Data

Under the Cash Flow Tables section of the reports, the user can find various cash flow reports that will help them assess the cash flows in the deal, with great agility and flexibility. See detailed information about each report linked below: * Deal Cashflow * Solar Project Cashflow * Loan Cashflow * Pro Forma

Cash Flow Reports Functionality

Renaming Cash Flow Tables: Users have the capability to rename their report by double-clicking on the current name, typing in the new name for their report, then clicking either enter or another point on the screen, and the Report’s new name will save automatically.  Editing Functionality:  Additional editor functionality

Deal Cashflow

Within Cashflow Data, users can run a Deal Cashflow report. With this template, a user can customize their view of projected cash flows for the deal, including collateral, bond-related fields, and bond steps, which are steps from the waterfall. This report will show collateral and bond fields by default. When

Solar Project Cashflow

The Project Cash Flow Table allows the user to see input fields related to the assets. Cash Flow Tables allow users to see the projected cash flows based on the field inputs of the asset within the Portfolio tab. The user can filter the fields by All Categories or select

Loan Cashflow

The loan Cashflow report presents users with the cash flows for the amortization of the loans in the Deal. Scenarios: The user can choose which scenario will be executed on this Report.  All scenarios defined under the Scenarios tab will appear in the drop-down.   As of Date: The user can

Pro Forma

Pro Forma tables allow users to see all unlevered pre-tax, levered pre-tax, and levered after-tax economics for the projects. Scenarios: The user can choose which scenario will be executed on this Report.  All scenarios defined under the Scenarios tab will appear in the drop-down.  Pro Forma Timeline: In the Pro

Capital Structure Cashflow

The Capital Structure cashflow report allows the user to see all the calculated fields relating to the bond fields. This Report is only accessible on Securitized deals.  Present the cashflows for the distributions to the bonds in this deal, along with all associated expenses and reserves.  The Report will display,

Custom Cashflow

The Custom Cashflow Report allows users to see only the fields they are interested in. Users can filter any field from the collateral, bond, or waterfall steps-related field. When creating a New Deal Cashflow Report, the user can customize the report by choosing which sections to include, which scenario to

Cashflow Tracker

The Cashflow Tracker Table allows the user to see specific Cashflows that occur within the Waterfall, during the waterfall steps. The user can stress the Report based on a specific Scenario. Once the Report is generated, the user can use the buttons located at the top right which are shown

Bond Factor

Factors are standard calculations required for ongoing bond reporting. The T-REX Bond Factor Table lets users see a single period, tranche distribution report. When creating the Bond Factor report, the user can customize the report by choosing which distribution period to generate the report, what multiplier to calculate the values

Data Explorer

The Collateral Data Explorer report provides rich functionality on slicing & dicing performance data. The report allows for filtering, sorting, drill down on the data, column movement, column resize, grouping, drag and drop fields, pivoting and more! Collateral Data Explorer Functionality: Users will open the reports section and create a

Benchmarks and Performance Data (Collateral Performance Data)

T-REX benchmarks enable users to obtain direct comparisons between different deals. The user can aggregate collateral-level data across deals to compare deal performance and determine key insights. Some examples include:  * Do the assets of this pool appear to share similar risks to other collateral pools? * Is the collateral pool changing

Collateral Performance Data

Collateral Performance Data reports are reports that allow users to run reports on each of the field inputs related to the assets. Users can select and prioritize or remove data fields within this report. This report can be customized based on the user's needs.  Collateral Performance Data Report

Charts & Graphs Functionality

Renaming Charts & Graphs  Users have the capability to rename their charts & graphs. Double click on the current name, type in the new name for the chart or graph, then click either enter or another point on the screen. The new name will save automatically.  Editing Functionality  Additional editor

Performance Data Charts & Graphs

Performance Data Charts & Graphs are equipped with greater flexibility and customizability for improved data visualization. Performance Data Graphs offer a revamped reporting wizard that enables users to Plot Key Performance Data Points (e.g., default or prepayment rates) by groupings (e.g., geography or credit score). In seconds, create

Time Series Line Graph

T-REX users have the ability to run Times Series Line graphs on performance data.   Generating a Time Series Line: After opening a deal on T-REX, click the Reports tab to create a new report widget. Under the Charts & Graphs category, select Time Series Line. A report wizard will open

Pie Chart

Users have the ability to run pie charts on T-REX.   Generating a Pie Chart:  After opening a deal on T-REX, click the Reports tab to create a new report widget. Under the Charts & Graphs category, select Pie Chart.   A report wizard will open where users must define their selections

Single Period Column Graph

Users have the ability to run single period column graphs on T-REX.    Generating a Single Period Column Graph:  After opening a deal on T-REX, click the Reports tab to create a new report widget. Under the Charts & Graphs category, select Single Period Column.   A report wizard will open where

Cashflow Graph Functionality

Cashflow Graph Functionality Once a loan or bond graph is generated, the user can generate multiple graphs within the same report for easy comparisons. The user can also filter out lines by clicking on their names at the bottom of the graph. Lines that are filtered out will appear in

Loan Graph

Users have the ability to run loan graphs on T-REX. The Loan Graph allows the user to examine various aspects of the loans in the deal visually.  Loan Graph -Watch the tutorial video! Generating a Loan Graph:  After opening a deal on T-REX, click the Reports tab to create a

Bond Graph

Users have the ability to run bond graphs on T-REX. The Bond Graph allows the user to examine various aspects of the bonds visually. Generating a Bond Graph:  After opening a deal on T-REX, click the Reports tab to create a new report widget. Under the Charts & Graphs category,

Price Yield Analytics

The Price Yield Reports are based on the inverse relationships between Price and Yield, which allows the user to calculate one from the other. The user can run various types of Price Yield Reports. See details on the following pages: * Loan Price Yield * Solar Price Yield * Bond Price Yield  * Bond

Price Yield Table Functionality

Renaming Price Yield Tables Users have the capability to rename their report by double clicking on the current name, typing in the new name for their report, then must click either enter or another point on the screen and the Report’s new name will save automatically.   Editing Functionality Additional

Solar Price Yield

The Solar Price Yield report allows users to run sensitivity analysis on the valuation of solar projects. Users can target specific rates of return and prices. The table will present the chosen criteria under all existing scenarios in the deal.    Field Definitions # of Steps: The user can define how many

Loan Price Yield

The Bond Price Yield report allows users to run sensitivity analysis on the valuation of loans. Users can target specific rates of return and prices. The table will present the chosen criteria under all existing scenarios in the deal.    User Definitions # of Steps: The user can define how many steps

Bond Price Yield

The Bond Price Yield report allows users to run sensitivity analysis on the valuation of tranches in a deal. Users can target specific rates of return and prices. The table will present the chosen criteria under all existing scenarios in the deal.

Bond Scenario

The Bond Scenario report allows users analyze economics for each tranche in the deal, considering yield convention and index rate. Bond scenario table  - Watch the tutorial video!

Stratification Table

The Stratification Table provides users with a detailed understanding of the makeup of various asset characteristics within the Portfolio, as well as how that collateral is concentrated among customizable Bucket characteristics.   Detailed Functionality Description: The data for the Stratification Table will come from the deal or PDS Link selected within

Setup Tools in Stratification Tables

The Stratification Table set up tools save time by automatically defining the rows within the table. Users can define ranges for numeric data by setting the number of steps between the min and max values and set discrete buckets for text data by selecting the fields to bring into the

Table Maker

Table Maker Reports contain tables related to a particular class of data that can be presented to investors. Examples of different data classes include bond data, revenues, and the priority of payments. The user with Report Admin capabilities is able to create these reports. These tables allow the Report Admin

Sub Buckets in Stratification Tables

Stratification Table sub-buckets allows users to create sub buckets in their Stratification Tables. This set up tool allows multiple nested buckets to be created, akin to a pivot table, and display totals for each Bucket. Detailed Functionality Description: The set-up allows users to define buckets for multiple sub-segmentation. Totals and

Need help?

Our fanatical 24x7 support is standing by. Contact us!

Link copied to clipboard.
You've successfully subscribed to Quantum by FINSIGHT
Great! Next, complete checkout for full access to Quantum by FINSIGHT
Welcome back! You've successfully signed in.
Unable to sign you in. Please try again.
Success! Your account is fully activated, you now have access to all content.
Success! Your billing info is updated.
Billing info update failed.