mDart seller FAQ's_web_source by guym13


									      I want to sell my accounts that my internal staff have worked,
      my collection agencies have worked, but my IT Department is
      months away from masking my data so I can maintain the
      confidentiality of my accounts. What can I do but sit on these
      growing delinquent accounts until the IT Department get
      around to providing me a masked file.

      If your an expert with Excel, you can import the data file, then
      deal with formatting, converting characters to data and the
      numerous math and logic functions that are required to assess
      the data. However, Excel can only handle up to 67,000 accounts.

      Click on the “Get-file” button, answer some questions regarding
      your portfolio, choose how you would like to see the data
      analyzed and click on “Process”. That is it! From importing the
      file to final analysis, you will have more useful information than
      would ever be time and cost effective otherwise, in less than 10
      minutes and mDart does it all at once…

Masked data Portfolio Sales File

                                         mDart Portfolio Import Tool…
When evaluating a portfolio for sale, purchase or work plan, it’s
important to know the breakdown of the account balances? How
do I determine the make up of a portfolio by balance range?

This can be done by sorting the balance column(s) in ascending
or descending order, determining the appropriate ranges as
needed, inserting sub totals at the determined balance breaks,
along with the associated formulas and calculating.

When uploading or importing a file into mDart, you have ability
to adjust balance breakouts or to utilize the pre-programmed
default ranges. This can be changed easily with each portfolio or
with every reprocess of a portfolio.
My company is a national company selling in all of the states.
How can I determine the highest and lowest balances in a
portfolio, along with the average balance and mean average
using conventional tools? Can I figure out if a specific balance
range has more payments than others? I want to be able to offer
this information to a potential buyer.
By arranging and sorting the columns on an a spreadsheet in
ascending or descending order, the high and low balance in he
file can be determined. Advanced users can do this using a
formula. Dividing the total balance of all accounts by the number
of accounts will provide the average balance and once sorted,
the exact middle balance of the total number of accounts is the
mean average. Figuring out payments by balance or balances by
range will require a lot more sorting and calculating.

The Main Dashboard provides all of these items at a glance.
The portfolio file contains many different creditors. What is the
make up of the file by creditor?

This is typically done in a very time consuming and tedious
way, by setting up a spreadsheet and calculating these totals
by arranging the columns as desired, then programming the
math functions required, calculating, resorting and

The Portfolio Analysis Model provides a breakdown by
creditor, displayed by dollar and account volume for the top 15
creditors, along with the Statute of Limitation status by listed
creditor according to whether or not there is a contract or
judgment and the percentage of the file make up by creditor.
This information is provided not only by creditor, but on any
data set that you select during the quick and easy file import.
 I want an idea of how much my portfolio will bring based on the
 outstanding debt in the portfolio. How can I do this?

 Again, if you have the skills or resources, a spreadsheet can
 be populated with formulas to automatically calculate
 recoveries on a particular curve and can even be
 programmed to allow multiple curves.

 It will can calculate various projected liquidation rates for
 you. Once a file has been imported, enter the expected six
 month recovery rate, you can chose from 1 of 3 collection
 recovery curves or enter your proven customized liquidation
 curve and the projections will be tabulated. mDart displays
 the results under the Collection Projection Tab. You can
 easily re-run and refresh, changing the assumptions to
 provide you with an estimated purchase price for the
  How can I determine which accounts are in statute by state?
                  Already have in other file

The ability to program the formulas required to calculate and
monitor state statutes would likely not be found with the most
astute Excel user nor will it be found the majority of the most
sophisticated collection software products on the market.

The Portfolio Analysis Model displays by State the number of
accounts, the dollar amounts that are in and out-statute along
with the respective percentages. mDart can also display the
percentage of the portfolio that is made up by each State.
I can provide a prospective buyer certain credit scores and
recovery scores of my delinquent accounts. How can I show
these results to a prospective buyer?

Determine the desired score ranges, sort the appropriate
column(s) in ascending or descending order, determine the high
and low score for each range, insert sub totals and formulas
then calculate.

 One of the Dashboards included with our Portfolio Analysis
 Model is for Credit and Recovery Scores. Whether analyzing a
 sales portfolio or an existing data file, if you have scoring data,
 mDart will display them numerically and visually by chart and
 graph according to the ranges specified by you during file set
Can I show a prospective buyer what accounts in the portfolio
have greatest probability to collect based on the data in the

There is no way to do this without intensive programming and
analytics using standard products.

mDART’s proprietary Collectibility Index indicates which
accounts have a greatest propensity to pay in comparison to
other accounts in the portfolio. This information can be sorted
in ascending or descending order. This priority of liquidations
can be determined every time the file or portion of the file is
Statute laws vary by State and contract type, changing from time
to time. What is the statute status of the accounts in this portfolio
by product and state? How long will the accounts remain in
statute by state and which will still be in statute three months from

The need to be expert in Excel is understated in this category. The
ability to program the formulas required to calculate and monitor
state statutes would likely not be found with the most astute Excel
user. The results would then still require sorting and subtotaling
by state and contract type.

Changes in state statute laws are regularly updated and there’s
no need to be the highest level user of Excel.               mDart
automatically calculates the Statute of Limitations by state and
contract type each time a file is run or rerun using the software.
           As a seller I get requests to purchase write off accounts
           that are in statue only. I have no way of knowing what
           accounts are still in statue and which accounts are not.

            You could contact all Fifty states and review your
            portfolio and run a spreadsheet in Excel to
            accumulate the potential accounts to sell.

mDART provides a breakdown of which accounts are in statue and out
of statue by state by three (3) different types of accounts, with
contract, with out contract and judgments. This allows the seller to
provide a portfolio for a buyer that meets their specific wants and
I would like to show a potential buyer of my accounts in a
portfolio file, which accounts have recorded a payment in the
last 12 months.
Again, being proficient in Excel is a must. A seller will set up
a spreadsheet, calculating these totals by arranging the
columns as desired, then applying the appropriate math
functions as required. If additional data is desired by type,
division, product, state or other, then the seller must sort,
recalculate, resort and recalculated until the desired
information is achieved.

One of the Dashboards in the Portfolio Analysis Model is the
Payment Review Dashboard. This screen displays the number
of accounts last paid by year and the dollar amounts last paid.
You can also use the “Query” function to readily return this
information by product, state or any other criteria desired.
I know that information is king, but I may not have the answer
about my delinquent accounts that a buyer may want to know.
How can a company interested in selling a portfolio find out
more about their portfolio or data?

An expert with Excel or Access or a business that has
developed an analytical tool, assuming that time, money and
resources were available, could identify the most key
elements, but could be limited in the scope of results.

Processing completes in a matter of minutes, not hours or
days and the mDART results file is displayed in series of
“Dashboards.” These “Dashboards” provide all of this
information and so much more, in an easy to use style, with
little effort, time or cost …
What else can I do to understand a portfolio using conventional
means that hasn’t been covered here already?

Really not to much. As you’ve seen, all of the preceding
require time, skills and resources. To go beyond anything
already discussed would be far out of reach for all but an
absolute expert using conventional means.

The Portfolio Analysis Model includes a query system that
implements standard queries or extracts at the push of a
button. Just select the query type and parameters for the query
and process. The file is automatically created in Excel to:
present accounts for sale, place accounts with an agency, send
a file to the dialer or to utilize other A/R processes.
Standard queries are good, but I want to divide up the accounts
in ways that I can determine, how can I get to this data?

This might be done by sorting on various fields, but would be
time consuming, cumbersome and unsure.

In addition to the Standard Query System, mDART comes
complete with a Query Designer System which enables you to
extract the data in numerous ways and forward the results to a
flat file for your analysis and interpretation. Such as: How
much of a particular portfolio is comprised of debtors living in
the State WV and MA (which doesn’t allow collection fees to be
charged) with certain balance ranges that are in-statute?
Now that I know value of my portfolio, how can I get this
information to my prospective buyer?

Using Excel or your report writer, you can create a file, but to
mask the data, you must manually search and replace the
proper fields with your masking strategy.

All of the working is done for you. First, mDART will mask the
data based on a “keyed” masking algorithm and save the
comma delimited file to your computer. In Addition, mDART will
create HTML version pages of the portfolio Analysis. All
included in a zip file that can be emailed to your prospective
          Disclose the details!

     Know what you don’t know!

Visit us of the web at

To top