|
|
| Characteristics |
Standard Edition
|
Law Edition
|
Loan Manager
|
|
General
|
| Windows 98, 2000, XP, Vista, 7, Server |
|
|
|
| Multi currency (all Windows currencies) |
|
|
|
| Multi currency within the same portfolio |
|
|
|
| Multi lingual (English, French) |
|
|
|
|
Industry standards
|
International standards and recognized
principles for the calculation of interest (Americas,
Europe, Asia, Australia, Africa)
- United States banking rules (Regulation Z, Truth in Lending
Act)
- European Community rules (Directive 98/7/CE)
- Canadian rules |
|
|
|
|
Day count: Actual/Actual (aka Actual/365), Actual/365(Fixed),
30/360, Actual/360
ISO (International Organization for Standardization
) nomenclature
|
|
|
|
| Weeks in year: 52 or 52.x |
|
|
|
|
Calculations
|
| Amortization (payment table) |
|
|
|
| |
Simple interest |
|
|
|
| |
Compound interest (effective rate method) |
|
|
|
| |
Compound interest (effective rate method - exact
days) |
|
|
|
| |
Capitalized simple interest (using the compounding
periods below) |
|
|
|
| |
Capitalized simple interest (for short
periods) |
|
|
|
| |
Compounding: annually, semiannually, quarterly,
monthly, 4 weeks, bimonthly, biweekly, weekly, daily |
|
|
|
| |
Possible to capitalize simple interest at any
desired date |
|
|
|
| |
Fixed interest rate or fluctuating rates over
time (rates can be changed in an existing loan) |
|
|
|
| |
Variable interest rates using interest tables
(included in Margill or create your own) |
|
|
|
| |
Variable interest rates + or - x% |
|
|
|
| |
Interest up to 999% |
|
|
|
| |
Payments: annually, semiannually,
quarterly, monthly, twice monthly, every x days (e.g..: 28,
14, 10, 7 or any other frequency) |
|
|
|
| |
Compounding period may be other than payment period |
|
|
|
| |
Payments may be partially or totally irregular
(including dates and payment amounts) |
|
|
|
| |
Payment possible in one lump sum at end of loan
(or at any point in the loan) |
|
|
|
| |
First payment date may be any date on or after
the origination date (same day, short, long, one or multiple
periods after) |
|
|
|
| |
Regular and irregular payments - late payments,
missed payments, additional principal, lump sums, fees... |
|
|
|
| |
Payment types: due payment, paid payment, late
paid payment, unpaid or partial payment, (including what should
have been paid), returned check, interest rate change, fees,
penalties, insurance, taxes, additional principal (new loan
amounts granted), invoice, withdrawal, investment, corresponding
PAID statuses (for example paid penalty) and a few others |
|
|
|
| |
Principal, fees, taxes, insurance that do or do
not bear interest |
|
|
|
| |
Court Fees (Lawyer Fees), Prejudgment interest
that do or do not bear interest |
|
|
|
| |
Line comment: possible to add a comment on each
payment line |
|
|
|
| |
Interest only, fixed principal, normal refund
(interest first) or any combination |
|
|
|
| |
Adjustable rate mortgage (ARM) calculation |
|
|
|
| |
Reverse mortgage |
|
|
|
| |
Step payments (automatically) (in currency) or
as a percentage (%)) |
|
|
|
| |
Computation of unknown variable (payment, principal,
interest rate, amortization period) |
|
|
|
| |
Computation of uniform payment in irregular scenarios
to yield balance = x |
|
|
|
| |
Computation of uniform interest rate in irregular
scenarios to yield balance = x |
|
|
|
| |
Fees and points (up to 5 types) may be added at
start of loan |
|
|
|
| |
APR (Annual percentage rate) computation
(regular and irregular scenarios) |
|
|
|
| |
APY (Annual percentage yield) computation
(regular and irregular scenarios) |
|
|
|
| |
Total cost of credit (TCC) computation |
|
|
|
| |
Collection of judgment amounts: Pre/Post
judgment interest, court and attorney fees and other fees bearing
interest or not and as of date x. Collection with regular and
irregular payments |
|
|
|
| |
Pre-judgment and post judgment interest tables
for USA, Canada, Europe, Australia (see
complete list). Or create your own tables. |
|
|
|
| |
Refund order may be adapted. From interest first
to any other portal scenario(according to legislation) |
|
|
|
| Simple interest between 2 dates |
|
|
|
| |
Fixed interest rate |
|
|
|
| |
Variable interest rates (interest rate table) |
|
|
|
| |
Daily interest (per diem) |
|
|
|
| |
Civil year cutoff date for computation or anniversary |
|
|
|
| |
Pre/Post judgment interest
computation |
|
|
|
| |
Pre-judgment and post judgment interest tables
for USA, Canada, Europe (see
complete list) |
|
|
|
| Compound interest between 2 dates |
|
|
|
| |
Compounding: annually, semiannually, quarterly,
monthly, 4 weeks, bimonthly, biweekly, weekly, daily |
|
|
|
| |
Fixed interest rate |
|
|
|
| |
Variable interest rates (interest table) |
|
|
|
| |
Daily interest (per diem) |
|
|
|
| |
Pre-judgment and post judgment interest tables
for USA, Canada, Europe (see
complete list). Or create your own tables. |
|
|
|
|
Accrual by installment calculation
Start at 0.00 principal and increase of principal
over time)(example - investments over time, late/unpaid rent
or salaries)
|
|
|
Computation done easily with negative payments
|
| |
Simple interest |
|
|
|
| |
Compound interest (on date of payment) |
|
|
|
| |
Regular/Irregular installments |
|
|
|
| |
Daily interest (per diem) |
|
|
|
| |
Pre-judgment and post judgment interest
tables for USA, Canada, Europe (see
complete list). Or create your own tables. |
|
|
|
| Present value |
|
|
|
| |
Regular and irregular future installments |
|
|
|
| |
Indexed future installments (indexation table) |
|
|
|
| Annual rate of return |
|
|
|
| Amount indexation |
|
|
|
| |
Download Consumer price indices (US, Canada, Europe,
Australia) and major world stock market indices. |
|
|
|
| Payment / Indexation (%) converter |
|
|
|
| Nominal / Effective (real) interest rate converter
(and vice versa) |
|
|
|
| |
Including equivalent rates (based on compounding) |
|
|
|
| Date calculations |
|
|
|
| Sales tax calculations (USA, Canada, Europe) |
|
|
|
|
Reports
|
| Detailed payments schedule (line by line detail) |
|
|
|
| Detailed payments schedule with end-of-year (or
at any date) totals |
|
|
|
| Quarterly and yearly reports |
|
|
|
| Principal, Court fees, Prejudgment interest and
Other fees report |
|
|
|
| Global portfolio reports |
|
|
|
| Reports between two dates (for example monthly,
quarterly, annual reports, etc.) |
|
|
|
| |
Record list of all selected records |
|
|
|
| |
Record list with totals at any date (total interest,
total principal refunded, balance) |
|
|
|
| |
Create custom reports in seconds.
Custom record list - select from over 150 data fields.
Export to Excel, CSV, TXT formats
Accounting data (for example, paid vs accrued interest, year-to-date
interest, outstanding balances, due interest balance, etc.)
Portfolio analysis (refund rate)
Convert multiple currencies to one currency (based on exchange
rate entered)
|
|
|
|
| |
Global summary of all selected records |
|
|
|
| |
Global summary of all selected records at any
date (portfolio total interest, total principal refunded, balance).
Obtain partial or complete portfolio totals at any point in
time or for end of fiscal year. |
|
|
|
| |
Special events (payment status report) and line
by line comment report |
|
|
|
| |
Doubtful accounts |
|
|
|
| |
Report for all or partial (sorted) portfolio |
|
|
|
|
Data merge features to easily produce: contracts, letters,
invoices and statements
Including IRS 1098, Truth in lending disclosure, etc.
|
|
|
|
|
Record management
|
| Summary client data |
|
|
|
|
Detailed client data including unlimited of custom fields
Custom scroll menus
|
|
|
|
|
Detailed lender data
Multiple lenders
|
|
|
|
|
Socioeconomic data - unlimited custom fields
Custom scroll menus
|
|
|
|
| Database for loans (mortgages, lines
of credit, investments...) |
|
|
|
| Security (guarantee) for a loan |
|
|
|
| Payment by payment record update according to
type of event: due payment, paid payment, late paid payment,
unpaid and partial payment, (including what should have been
paid), interest rate change, fees, penalties, insurance, taxes,
additional principal (new loan granted), invoice, returned check,
withdrawal |
|
|
|
| Line comment - possible to add a comment on each
payment (or other vent) line |
|
|
|
| Payments due or yet unpaid on a specific
day |
|
|
|
| Tool allowing to update all active
records for which payments were not made on or before a specified
date |
|
|
|
| Age of payments (30, 60, 90, etc.
days late) and other Metro 2 codes |
|
|
|
| Global / partial portfolio reporting |
|
|
|
| Grace period granted |
|
|
|
| Minimum payment |
|
|
|
| Record history (changes made to each Record: date,
time and by whom) |
|
|
|
| Sort function by any criteria (client, type of
loan, creditor, loan date, loan amount, etc.) |
|
|
|
| Quick client data entry (when same client / lender
/ data for multiple loans) |
|
|
|
| Record duplication (simply copy record and duplicate) |
|
|
|
|
Security and Data integrity
|
| Password protection for software access |
|
|
|
| User permission levels (administrator,
power user, normal user, read-only) |
|
|
|
| Limit access to a user's own records
only |
|
|
|
| Opened Records are blocked to other
users (read-only access) |
|
|
|
| Data entry constraints for data integrity |
|
|
|
|
Other features
|
|
Alerts (reminder calendar) or what must be done
4 types of alerts
|
|
|
|
| Attach files (PDF, images, documents)
to a Record |
|
|
|
|
