|
|
| Characteristics |
Standard Edition
|
Law Edition
|
Loan Manager
|
|
General
|
| Windows 98, 2000, XP, Vista |
|
|
|
| Multi currency (all Windows currencies) |
|
|
|
| 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 (actuarial method) |
|
|
|
| |
Compound interest (actuarial method - exact days)
|
|
|
|
| |
Capitalized simple interest (using the compounding
periods belwo) |
|
|
|
| |
Capitalized simple interest (for short
periods) |
|
|
|
| |
Compounding: annually, semiannually, quarterly,
monthly, 4 weeks, bimonthly, biweekly, weekly, daily |
|
|
|
| |
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% |
|
|
|
| |
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... |
|
|
|
| |
Line tagging according to type of event: due payment,
paid payment, late paid payment, unpaid or partial payment,
(including what should have been paid), interest rate change,
fees, additional principal (new loan granted), invoice, returned
check, withdrawal |
|
|
|
| |
Line comment: possible to put a comment on each
payment (or other vent) line |
|
|
|
| |
Interest only, fixed principal, normal refund
(interest first) or any combination |
|
|
|
| |
Adjustable rate mortgage (ARM) calculation |
|
|
|
| |
Step payments (automatically) (in dollars (or
other currency) or in 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 computation |
|
|
|
| |
Collection of judgment amounts: Pre/Post
judgment interest and court 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. |
|
|
|
| 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) |
|
|
|
| |
For simple interest calculation, refunded
principal is first applied to principal before the refund of
interest - irregular method to be applied in peculiar situations |
|
|
|
| |
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 |
|
|
|
| Global portfolio reports |
|
|
|
| |
Record list of all selected records |
|
|
|
| |
Record list with totals at any date (total interest,
total principal refunded, balance) |
|
|
|
| |
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 |
|
|
|
| Custom letters/reports (customer mailings) and
reports - client data merge function |
|
|
|
|
Record management
|
| Detailed client data |
|
|
|
| Detailed lender data |
|
|
|
| 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, additional principal (new
loan granted), invoice, returned check, withdrawal |
|
|
|
| Line comment - possible to put a comment on each
payment (or other vent) line |
|
|
|
| Tool allowing to update all active
records for which payments were not made on or before a specified
date |
|
|
|
| Global portfolio reporting |
|
|
|
| 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
|
| Password protection for software access |
|
|
|
| User permission levels |
|
|
|
|