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)?
System Requirements
WARNING
Versions
Technical and Application support
Contact information
License
Purchase additional licences / Upgrade loan level

Help & Support
Help file in Margill
Live support
Support, maintenance and update contract

Backup (data)

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

Updates
Software
Interest tables (& Sales tax table)

Tools & Settings
Calendar
Pocket calculator
Shortcuts
Right mouse click
Payment update tool
Undo function
Search tool
Record log
Default settings & Profiles

General Defaults
Language
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
Late and/or unpaid salaries, rent, annuities
Investment portfolio

Other calculations

Nominal / Effective Interest Rate Converter
Sales Tax Calculations
Date Calculations

Refund options

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%

Record Summary Window
General
Displayed column selection and order

Record Window
What is a Record?
Record Data
Doubtful accounts
Borrower (client) information
Security (guarantee)
Creditor (Lender)
Annual Percentage Rate (APR)
Advanced functions

Annual Percentage Rate (APR)
General
Fees paid up-front or financed
Additional fees
Nominal & Effective APR (APY)
APR undefined
APR tags (fee names)
APR report

Results Table (Amortization, payment)
Line Status & Line Comment
Displayed column selection
Change of compounding or calculation methods
Payments

Unpaid 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
Payments recomputed for interest-only payments
Payments recomputed for fixed principal payments

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
Calculation method for short periods
Add principal or fees to the initial loan amount
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

Saving, Reports, Export & Printing
Saving
Reports available

Detailed schedules
Global Summary
Record List
Special Events Report
Doubtful Accounts Report
APR disclosure box (USA only)
Bad Debt Report
Loan Securities (Guarantees) Report
Fees Report

Reports (Snapshot) at a Specific Date
Custom reports / letters
Printing
Printing problems
End of year totals
Export to TXT, HTML, XLS, PDF, XML

Calculation methods
General
Actuarial (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

Definitions and Glossary

Bibliography