Margill Loan Manager

User Guide Table of Contents

The User Guide is available as a Help file in MLM (easy-to-use and search) and available as a PDF file that can be printed (approx. 240 pages).

Introduction
What is Margill Loan Manager (MLM)?
Fundamental principles of operation
System Requirements
Networking capabilities and Database
Technical and Application support
License
Purchase additional license / Upgrade loan level

Versions

Getting started
Start and Exit the software
Demo mode
Registration code and Key
Administrator and Users
Locked Records and Alerts
Regional settings (Windows)
Import Margill Standard Edition (*.FLC) files to MLM format
Creating the first Record
Duplicating Records
Deleting a Record

Help & Support
User Guide
Live support
Knowledge Base (Web)
Support, maintenance and update contract

Backup (data)

Updates
Software
Interest tables (& Sales tax table)

Tools & Settings
Tools & Settings
Payment update ("Post Payments")
Calendar
Pocket calculator
Shortcuts
Notes
Right mouse click
Undo function
Search tool
Record log
Custom fields
Scroll menus
Multi Currency
Defining Line Statutes
Setting the Records' Unique Identifier
Database Reindexation
Default settings & Profiles

General Defaults
Language
Internet Connection
Profiles

Margill Loan Manager Calculations
Amortization & payment schedules
How to do...

Loan (car, personal, commercial)
Add-on Interest Loan
Rate Adjusted Payments
Mortgage
Adjustable Rate Mortgage (ARM)
Reverse mortgage
Line of credit
Collection - Bills, Invoices...
Lease
Insurance and Taxes
Late and/or unpaid salaries, rent, annuities
Investment portfolio
Loan or other with fees (insurance taxes, penalties or invoices) not bearing interest
Loan without interest on part of the principal only
Irregular interest compounding

Other calculations

Nominal / Effective Interest Rate Converter
Sales Tax Calculations
Date Calculations

Refund options

Alerts (Agenda, Follow-ups)

Interest rate tables (variable interest rates)
Central Bank interest rates
Legal / Judgment (pre/post judgment) interest rates
Creating new interest tables
Updating / changing interest tables
Variable rates + or - x%
Fixed Rate at Origination Date

Record Summary Window
Displayed column selection and order

Record Window
What is a Record?
Record Data

Changing the basic loan data in a Record
Doubtful accounts

Security (guarantee)

Annual Percentage Rate (APR)
Fees paid upfront or financed
Additional fees
Nominal & Effective APR
APR undefined
APR tags (fee names)
APR report

Results Table (Amortization, payment)
Introduction
Line Status & Line Comment
"Payment" Type Line Statuses
Accounting data and Line Status
Data Integrity
Results table columns
Displayed column selection
Change of compounding or calculation methods
Payments

Unpaid payments
Partial or Late Payments
Grace period
Additional payments
Step payments
Rate adjusted payments
Interest-only payments
Fixed principal payments
Changing one payment or multiple payments
Lump sum payments / Prepayments
Adding lines (payments, principal, etc.)
Payments - positive and negative
Payments (equal) recomputed to yield a balance = 0.00 or other amount

Changing the date of a payment
Deleting a line or lines
Adding or changing interest rates in a Results table
Interest rate (equal) recomputed to yield a balance = 0.00 or other amount
Interest Rate recomputed to adjust Line (period) Interest amount
Calculation method for short periods
Additional principal, fees, penalties, insurance and taxes
Total payments, interest, principal

Unknown interest rate

Regular loan
Irregular loan (determination of rate in completed schedule)

Balance options & information
Balance other than 0.00 in Data entry window
Compute final payment for balance= 0.00 or other amount
Ignore small loan balance (add to interest fee)
Balance column in schedule

Reports
Detailed schedules
Global Summary
Record List
Record List (Customized)

Report Fields

Accounting data
Portfolio Analysis
Special Events Report
Doubtful Accounts Report
Due, Outstanding and Unpaid Payments Reports
Electronic Funds Transfer by Pre-Authorized payments
APR disclosure box (USA only)
Reports (Snapshot) at a Specific Date or Between Two Dates (Periodic reports)
Letters, Contracts, Invoices and Statements (Document merge)

Invoices and Statements
External Merge Forms

Importing into Accounting packages (QuickBooks, Simply Accounting, Acomba)

Saving, Reports, Export & Printing
Saving
Printing
Printing Problems
End of year totals
Export to TXT, HTML, XLS, PDF, XML
Export accounting transactions (credits and debits) to the General Ledger

Calculation methods
Effective Rate (Normal) method
Simple Interest
Simple interest (capitalized)
U.S. Rule
Day count
Short & Long periods
Leap year
Reference date
Weeks in a year (payments & compounding)
Fraction of cents (or other units)
Change in payment schedule
Irregular payments schedule
Date inclusion and exclusion
Balance at date x comparisons
Calculation of interest on the Outstanding amounts
Refund order for principal, fees and others

Definitions and Glossary

Bibliography