Ivory Consulting

Solutions

Portfolio Analytics - Ivory's Portfolio Product

Ivory's new Portfolio Analytics leapfrogs all existing tools for analysis of equipment finance portfolios to pricing new or existing portfolio for either buying or selling.

Portfolio Analysis

Ivory understands the unique challenges portfolio analysis presents for equipment finance companies. Buying, selling, securitizing or even just reporting on hundred or thousands of equipment finance transactions can be daunting, and spreadsheets with a million cells in them provide scant confidence. Doing ‘what if’ analysis often requires making a number of uncomfortable simplifying assumptions. And, always, validating the numbers is a huge challenge not often fully met.

Ivory’s new software Portfolio Analytics tools is designed specifically to handle these unique challenges:

  • Accounting classification – are the transactions Operating, Direct Finance, Leveraged or simple loans?
  • Tax classification – are the transactions tax affected? If so, how do you want to measure the tax deferral benefit?
  • Residuals – for transactions with residuals, evaluating a portfolio means dealing with changing – sometimes, rapidly changing – residual estimates.

Portfolio Analytics gives you the full power of SuperTRUMP’s analytic and pricing functionality, including several hundred reports, to use on hundred or thousand of transactions at a time, plus it provides even more specialized tools designed specifically for equipment finance portfolios:

  • Import – pull in a thousand SuperTRUMP transactions, or a thousand transactions from spreadsheets or accounting systems;
  • Nested groups – create transactions, groups of transactions, portfolios of groups, portfolios of portfolios, with full analysis and ‘what if’ capabilities at each level;
  • Forecasting – creates forecasted business from simple spreadsheet instructions, that can be layered onto existing business for a combined forecast;
  • “Chop” – grab up to tens of thousands of deals and price them for purchase as of a selected date. Portfolio Analytics will keep remianing cash flows and determine a price for an economic yield - for either the buyer or seller;
  • Overrides – say the individual transactions contain cost or residual assumptions that are no longer valid. Portfolio allows you to override those assumptions and replace them with current, more correct assumptions, and see what happens to the portfolio yield.