Dec 162017
 
Loan Master mortgage reduction system. Allows a home buyer to analyze various strategies used to reduce mortgage payments.
File MC100.ZIP from The Programmer’s Corner in
Category Databases and related files
Loan Master mortgage reduction system. Allows a home buyer to analyze various strategies used to reduce mortgage payments.
File Name File Size Zip Size Zip Type
CATALOG.DOC 22999 7834 deflated
DISTRIB.AGR 6947 1216 deflated
FILE.LST 987 549 deflated
MANUAL.DOC 90345 20776 deflated
MCHELP.DBF 1989 552 deflated
MCHELP.DBT 22016 4370 deflated
MCHELP.NTX 4096 733 deflated
MCMENU.EXE 226759 106510 deflated
MCPARM.DBF 1161 417 deflated
READ.ME 1483 650 deflated
SCHEDULE.BLK 706 246 deflated
SYSOP.TXT 1902 833 deflated
WHO_USES 936 400 deflated

Download File MC100.ZIP Here

Contents of the READ.ME file


Mortgage Comparison and Reduction Strategies
By: Bottom Line Software.

1)
Check the file list. Be sure you have all the files. If not, or if
they have become damaged in shipment or transmission, for a new,
original copy, on disk, by mail, send $9.95 to:

Bottom Line Software, Inc
P.O. Box 1804
Burleson, Tx 76028-1804

or, leave a credit card order at:

817-447-5524

Be sure to specify the Mortgage Comparison and Reduction Strategies
shareware disk. Be sure to specify 3 1/2 inch disk if you want that
size. We ship 5 1/4 if size is not specified.

2)
Copy these files to your working floppy, or hard disk:

MCMENU.EXE
MCPARM.DBF
MCHELP.DBF
MCHELP.DBT
MCHELP.NTX
SCHEDULE.BLK

3)
Log on to your working disk. Start the program by typing the
command:

MCMENU (return)

4)
When your curiosity is satisfied, exit the program and print the
manual. To print the manual, assuming it is on a floppy in drive a:

COPY a:manual.doc prn:

If the manual is not on drive A: replace the a: in the above command
with the letter specifying the drive on which the manual file
resides.

EXAMPLE:

COPY b:manual.doc prn:

COPY c:manual.doc prn:




Contents of the MANUAL.DOC file


Mortgage Comparison and Reduction Strategies
By: Bottom Line Software.

1)
Check the file list. Be sure you have all the files. If not, or if
they have become damaged in shipment or transmission, for a new,
original copy, on disk, by mail, send $9.95 to:

Bottom Line Software, Inc
P.O. Box 1804
Burleson, Tx 76028-1804

or, leave a credit card order at:

817-447-5524

Be sure to specify the Mortgage Comparison and Reduction Strategies
shareware disk. Be sure to specify 3 1/2 inch disk if you want that
size. We ship 5 1/4 if size is not specified.

2)
Copy these files to your working floppy, or hard disk:

MCMENU.EXE
MCPARM.DBF
MCHELP.DBF
MCHELP.DBT
MCHELP.NTX
SCHEDULE.BLK

3)
Log on to your working disk. Start the program by typing the
command:

MCMENU (return)

4)
When your curiosity is satisfied, exit the program and print the
manual. To print the manual, assuming it is on a floppy in drive a:

COPY a:manual.doc prn:

If the manual is not on drive A: replace the a: in the above command
with the letter specifying the drive on which the manual file
resides.

EXAMPLE:

COPY b:manual.doc prn:

COPY c:manual.doc prn:




























































































LOAN MASTER

Mortgage Reduction Strategies

Version 1.00

Date 07-28-89

Copyright 1989


Bottom Line Software

P. O. Box 1804
Burleson, Texas 76028-1804
817-447-5524


































TABLE OF CONTENTS

License agreement and warranty . . . . . . . . . . . . . . . 1

Manual installation . . . . . . . . . . . . . . . . . . . . . 2

Help function . . . . . . . . . . . . . . . . . . . . . . . . 3

Menu operations . . . . . . . . . . . . . . . . . . . . . . . 3
Using the menus . . . . . . . . . . . . . . . . . . . . 3
Selecting menu options . . . . . . . . . . . . . . . . . 4

Data entry screens . . . . . . . . . . . . . . . . . . . . . 4
Data entry cursor control keys . . . . . . . . . . . . . 5
Browse screens . . . . . . . . . . . . . . . . . . . . . 7
Browse Cursor Control Keys . . . . . . . . . . . . . . . 8

Mortgage Reduction Menus . . . . . . . . . . . . . . . . . . 10
Menu Functions . . . . . . . . . . . . . . . . . . . . . 10

The Main Menu . . . . . . . . . . . . . . . . . . . . . . . . 10

The Reports Menu . . . . . . . . . . . . . . . . . . . . . . 12
Mortgage Comparison Report . . . . . . . . . . . . . . . 13

Mortgage Reduction Overview . . . . . . . . . . . . . . . . . 14


Prepayment variations . . . . . . . . . . . . . . . . . . . . 14
Prepayment Examples . . . . . . . . . . . . . . . . . . 14
Regular periodic prepayments . . . . . . . . . . . 14
Irregular and one time payments . . . . . . . . . . 15

Interest Computation Basis . . . . . . . . . . . . . . . . . 15

Recalculating a schedule . . . . . . . . . . . . . . . . . . 17

Printing Reports . . . . . . . . . . . . . . . . . . . . . . 18
Printing an amortization schedule . . . . . . . . . . . 18
Printing a mortgage comparison . . . . . . . . . . . . . 18

The Parameter File . . . . . . . . . . . . . . . . . . . . . 19
Changing the company name . . . . . . . . . . . . . . . 19
Prepared by: . . . . . . . . . . . . . . . . . 19
Changing the Mortgage Comparison Report Header . . . . . 19
Changing the Amortization Schedule Header . . . . . . . 20
Change the printer setup . . . . . . . . . . . . . . . . 20
Printer control codes. . . . . . . . . . . . 21
Printer graphics characters. . . . . . . . . . 21
Visual update system. . . . . . . . . . . . . 21

Tutorial, How to Use the Program . . . . . . . . . . . . . . 22
Comparing mortgages . . . . . . . . . . . . . . . . . . 22
Compare prepayment strategies . . . . . . . . . . . . . 25













Schedule File Specifications . . . . . . . . . . . . . . . . 30
Detailed Field Descriptions . . . . . . . . . . . . . . 31
































































License agreement and warranty

By using this product, I agree to comply with the following
license agreement.

The program and the users manual contain valuable
intellectual property and trade secrets of Bottom Line Financial
Software, Inc. I understand that I may make as many copies as I
want for backup but I will not sell, rent, loan, give or
otherwise transfer possession of any copy of the program or of
any other materials supplied to any person or other entity.

I may use multiple copies of this software on different
computers in the same office at the same time. I may not use
multiple copies at different offices (addresses). Each different
office, branch, physical location, or address requires a new paid
licensed copy.

This product is supplied with only one warranty. Within 30
days of receipt, if this product fails to perform any advertised
function, I may return it postage prepaid, with a printout of
any erroneous result, or a written description of the advertised
function which failed, for a full refund. Computer rounding
differences are not considered to be erroneous operation.

Bottom Line Financial Software disclaims any other warranty
expressed or implied, including without limitation, the
warranties of merchantability or fitness for any purpose.


IN NO EVENT SHALL BOTTOM LINE SOFTWARE BE LIABLE
FOR LOSS OF BUSINESS PROFITS OR LOSS OF INTEREST INCOME
OR LOSS OF PRINCIPAL PAYMENTS, OR OTHER LOSSES CAUSED
BY USE OF SCHEDULES, REPORTS, SCREEN DISPLAYS OR ANY
OTHER OUTPUT FROM THIS SOFTWARE, OR LOSSES CLAIMED BY
DEBTORS OR CREDITORS OF LICENSED OR UNLICENSED USERS OF
THIS SOFTWARE.


Both the software and the manual are furnished under the
terms of this license agreement. Both are copyrighted by Bottom
Line Software and neither may be reproduced or copied except in
accordance with the terms of the license agreement. Both the
Software and the manual are, and remain the property of Bottom
Line Software.

Information in this document is subject to change without
notice.





LOAN MASTER Mortgage Comparison System 1












Installation

The Distribution disk contains software to install the
Mortgage Reduction Strategies system on either the hard disk C:
or to a floppy disk in drive B:

To use the installation software, place the distribution
disk in drive A:. Log onto drive A: by typing the command:

A:(return)

The colon is required. (return) means to press the return or
enter key. Do not type the letters "return".

This command will display a menu on the screen. The menu
will offer several selections. two of these will be to install
the system on either disk C: or disk B:


Subdirectories

The installation software installs the system in the current
directory. If you want the system installed in a special
subdirectory, you must first create that subdirectory and then
make it the current directory by using the dos commands MD to
make the directory and CD to select the directory. See your DOS
manual for details of how to use these commands.


Manual installation


Required files:

The Mortgage comparison system must have these files to
operate:

MCMENU.EXE
MCPARM.DBF
SCHEDULE.BLK

The help system is optional and consists of these files:

MCHELP.DBF

MCHELP.NTX (Created by program)

MCHELP.DBT





LOAN MASTER Mortgage Comparison System 2












To install the software manually, use the DOS copy command
to copy these files to your working floppy disk or to your hard
disk.


Help function

Loan Master has a built in help function. Help screens are
available to instruct the operator on various functions and
operations. On screen help is not always available. When it is,
it is accessed by pressing the function key marked F1.

Help screens appear as windows. In some cases, the amount
of text required will not fit in the space available. In these
cases help screens can be scrolled to display more text by
pressing the down arrow or the PgDn keys.

To exit a help screen, press the Esc key. In some cases you
will need to press it twice.


Menu operations

Loan Master is completely menu operated. You never have to
remember any commands.

A menu is a list of tasks, or functions the program can
perform. Entering a new loan, is a menu function. Printing a
trial balance is a menu function. Since one menu cannot display
all the possible functions the system can perform, related tasks
are listed together on menus.


Using the menus

Menus consist of a list of options, or items, preceded by
an option number. The option number is listed to the left of the
menu item. To keep the screen clean and readable, menus are
limited to no more than eight options plus the ninth, return
option. Option 9 is always return.

The return option takes you back to the point in the program
from which you came to the current menu. This may be to a
previous menu or to some other function.

The return option on the main menu returns you to DOS, or to
your automatic menu system, if you have one installed on your
machine.





LOAN MASTER Mortgage Comparison System 3












Selecting menu options

There are two ways to select a menu option.

If you know exactly what you want to do and how to do it,
simply press the numeric key corresponding the menu option. To
select option 3, press the 3 key. You may select either the 3 key
on the typewriter keyboard, or if the NumLock key is set to
numbers, you may use the 3 key on the numeric key pad. DO NOT
use the function key labeled F3.

If you are a new user and not yet confident in your
knowledge of the menu options and the functions they perform, you
may use the cursor keys, or to select a menu option.

Cursor key selection is done by highlighting a menu
selection and pressing the return key.

Highlighting means that one selection will be displayed in a
manner that is noticeably different from the rest of the options.
Highlighting usually results in the selected option being
displayed in reversed colors. Some computer video displays may
handle this in a different manner.

When an option is highlighted, selected, a message will
appear at the bottom of the screen. This message will give
additional information about the selected option.

To select an option, press either the or the keys. If
you press the up key, the highlight bar will jump to the next
higher option on the screen (Lower number, higher physical
position). The down key has the opposite effect.

The highlight bar will "roll around" from top to bottom or
from bottom to top. If you press Up when the bar is on the top
selection, it will "roll around" to the bottom selection and vice
versa.

It is always possible to select any option with either key.
It is never necessary to change keys after you have selected the
key to press.


Data entry screens

When the program needs information from the operator, it
displays a data entry screen. Usually data entry screens occupy
the entire screen. Occasionally, as in the case of a simple yes
or no answer, the computer will open a small window on the screen
and ask "Is this the loan you want? Y/N". in this instance the
remainder of the screen will stay as is was before.


LOAN MASTER Mortgage Comparison System 4












Data entry screens use prompts ( messages, questions ), to
ask for data. It uses fields to receive data. A field is a
specific, isolated, identified, delineated, area in which data is
entered on the screen, stored, in memory or on disk.

Usually prompts will appear on the screen followed by the
data field to its immediate right. This is not always the case.
The prompt may be below, above, left, or right of the data field.
It is the responsibility of the programmer to make it evident to
the user which field refers to which field.

When the prompts and fields are printed on the screen, the
fields may or may not already contain data. If the program is
building a new record, the data fields will be empty. If the
operator has asked to edit an old record, the fields will contain
the old data.

If the program is asking a question to verify a command you
have already given, or implied, the response field will contain a
default answer. A default answer is the answer the computer will
use unless you tell it something different. If you ask to delete
loan number 33, the program will find it and display it on the
screen. It will then ask you, "Is this the loan you want to
delete? Y/N". The response field will contain a "N". "N" then, is
the default answer. If you simply press the key, you
have answered "N". The purpose for this manner of operation is to
require the operator to think about the answer and to take a
positive step, pressing "Y" before deleting a loan.


Data entry cursor control keys

During data entry, you will move the cursor around the
screen and enter or change data until you have it like you want
it. You will use the cursor control keys to control the cursor.

The cursor control keys are controlled by the NumLock and
the Shift keys. The NumLock key toggles the numeric key pad back
and forth between the numeric mode and the cursor control mode.

The Shift key does the same thing but on a temporary basis.
for example: You have the numeric key pad set for cursor control.
You move the cursor to a numeric entry. Next press and hold down
the shift key, this action changes the numeric keypad to numeric
entry. You now enter your number (still holding down the shift
key) and then release the Shift key. The numeric key pad shifts
back to cursor control.

If you are a WordStar fan, you will find the Wordstar
diamond works pretty much as you would expect but none of the
other WordStar commands are implemented.


LOAN MASTER Mortgage Comparison System 5













DATA ENTRY CURSOR CONTROL KEYS

^ Indicates the Control key labeled Ctrl. Thus ^LeftArrow means
hold down the control key while pressing the LeftArrow key.

This key: Does this:

Home Move the cursor to the beginning of the current
field.

^Home Move the cursor to the beginning of the first
field on this screen.

End Move the cursor to the last character of the
current field.

^End Move the cursor to the beginning of the last field
on this page.

UpArrow Move the cursor to the previous field.

DownArrow Move the cursor to the next field. Will not end
the current input screen by continuing to the next
screen.

RightArrow Move the cursor one character to the right in
the current field.

^RightArrow Move the cursor to the beginning of the next
word in the current field.

LeftArrow Move the cursor to the left one character in the
current field.

^LeftArrow Move the cursor to the beginning of the
current word. If it is already at the
beginning, move it to the beginning of the
previous word.

^T Delete from the cursor to the end of the current
word.

^Y Delete from the cursor to the end of the current
field.

PgUp PgDn Save the data on the current screen and continue
to the next screen.

Esc Continue to the next screen. Do not save the
changes, if any that were made to the current
screen.

LOAN MASTER Mortgage Comparison System 6













^U Restore the current field to its original value.
This only works before the cursor is moved out of
the field. Once the cursor has been moved, the
only way to restore the original value is to
retype it.

Backspace Delete the character to the left of the cursor.

Delete Delete the character under the cursor

Insert Toggle between insert and typeover modes.


Browse screens

The browse screen options allow you to browse through the
data files. Each data record is displayed on one line across the
screen. Several records are displayed on each screen with the
fields appearing in columns.

The browse screens use the real field names from the data
files. These names are somewhat more cryptic than the data input
screen prompts but they are readable. They are listed in the
section on the data files. See Data File Specifications for
details of the field names.

The browse screen looks like this:


Record 1 of 36

MTRAN_NO MTRAN_DATE MACCR_RATE MPMT_AMT MACCR_DAYS MINT_DUE

0 08/01/89 0.1200 123.44 0 0
1 09/01/89 0.1200 123.44 31 99.80
2 10/01/89 0.1200 123.44 30 98.10
3 11/01/89 0.1200 123.44 31 96.38





The record contains many more fields than can be displayed
on the screen on a single line. To accomplish the goal of one
loan on one line, the line scrolls across the screen. As you use
the cursor keys to move your view to the right, the columns on
the left side of the screen scroll off the screen to the left
while the formerly invisible columns to the right of the screen
scroll onto the screen from the left.

Try it. It much simpler to do than to describe.

LOAN MASTER Mortgage Comparison System 7












Browse Cursor Control Keys

This key Does this:

Up Move the cursor up one line, (record, loan,
transaction)

Down Move the cursor down one line, (record, loan,
transaction)

Right Move the cursor one column (field) to the
right. If the cursor is in a field and the
editing mode is on, move the cursor one
character to the right.

Left Move the cursor one column (field) to the
left. If the cursor is in a field and the
editing mode is on, move the cursor one
character to the left.

Turn on the editing mode (feature) and edit the
data in the currently selected field. If the edit
mode is already on, quit editing the current
field, keep the edited field and continue on the
next field to the right.

^ CtrlUp Not used.

^ CtrlDn Not used.

^ CtrlRight Scroll the entire data base one column to the
left. (Moves the cursor to the right)

^ CtrlLeft Scroll the entire data base one column to the

right. (Moves the cursor to the left)

PgDn Move down one page (further into the data base).

PgUp Move up one page (back towards the top of the
database).

^PgUp Move to the top, first record in the data
base.

^PgDn Move to the bottom, last record of the data
base.

End Move to the right most column on the screen.

Home Move to the left most column on the screen.



LOAN MASTER Mortgage Comparison System 8












^End Move to the last field to the right of the current
record and scroll the screen so that field is in
the right most column of the screen.

^Home Move to the first field of the current record
and place the first field of each record in
the left most column on the screen.

Esc Exit the browse function and return to the menu.












































LOAN MASTER Mortgage Comparison System 9












Mortgage Reduction Menus

The Mortgage Reduction system is completely menu operated.
All functions and reports are accessed through one of these
menus. The menus are:

Mortgage Comparison System Main menu. All system
functions and sub menus
are accessed through this
menu.

Report Menu Printed Report Menu. All
printed reports are selected
from this menu.


Menu Functions


The Main Menu offers the following selections.

1) Make an amortization schedule.

This function presents a data input screen and requests
information about a mortgage. When it has received the
data, it creates an amortization schedule ON THE DISK.
It does not print the schedule. It does not display
the schedule on the screen. Other functions are
available for those tasks.

2) Compare Mortgages.

This function is similar to the Make Schedule function
but is used for comparing multiple mortgages. This is
for comparing completely different mortgages, not for
variations on a base mortgage.

You will be asked for the number of mortgages to
compare. The current maximum is five. You will then be
asked to supply a filename for the mortgage schedules.
You are allowed only seven characters for the file
name. The system will add a version number, 1 to 5 and
an extension ".dbf" to the characters you give.

You do not have to use all seven characters.








LOAN MASTER Mortgage Comparison System 10












3) Compare Mortgage Reduction Strategies.

This function is similar to the Compare Mortgages
function. The difference is that you are asked for the
number of variations of this mortgage. You will then
enter a base mortgage plus variations in payment
schedule.

Note that the base mortgage counts as one variation.
Thus a base mortgage plus a variation of one extra
payment per year and another variation of $25.00 extra
each month would count as three variations.

Again, these schedules are created on the disk. They
are not printed or displayed.

4) Browse a Schedule File.

This is the function that is used to display a schedule
on the screen. It asks for a filename and then
displays the file on the screen, one transaction per
line.

The browse function also allows you to change any
transaction. You may change the Date, the amount or
the interest rate of any transaction. There is also a
function to recalculate the schedule after you have
changed it.

5) Recalculate a Schedule file.

You may use the browse function to change the dates or
amounts of payments or to insert or delete payments.
Any of these modifications requires that the schedule
be recalculated. This option allows you to recalculate
any schedule file.

6) Blank. Not used.

7) Update the parameter file.

The parameter file stores variable information that
will be different from one user to the next but which
will usually remain constant for any given user. This
includes the user's name and address and information
about the user's printer.

8) Printed Reports Menu.

This function displays another menu, the printed
reports menu. All printed reports are requested from
the printed reports menu.

LOAN MASTER Mortgage Comparison System 11













9) Return to DOS.

This function closes all files that may still be open
and returns to the DOS prompt.



The Reports Menu has two selections, a mortgage comparison
report and an amortization schedule.











































LOAN MASTER Mortgage Comparison System 12






The Mortgage Comparison Report looks like this:

{Mortgage Curtailment Strategy Report}
{Increase profit by paying less interest.}

Prepared by: Prepared for:

{Bottom Line Financial Services} {Name of Mortgagee goes here}
{P.O. box 1804 } {Address line 1 }
{Burleson, Tx 76028-1804} {Address line 2 }
{Address line three ---------->} {Address Line 3 }
{ADDRESS LINE FOUR ----------->} {Address Line 4 }


End {Name of }{Variation }{Variation }{Variation }{Variation }
of {Base Mort }{1 here }{2 here }{3 here }{4 here }
Year {Here }{You enter }{your text }{in these }{columns }

Mortgage balance at end of year:

1989 9,843,856 9,843,856 9,832,247 9,843,856 9,843,856
1990 9,803,870 9,690,545 9,778,001 9,748,087 9,692,303
1991 9,758,814 9,516,658 9,716,930 9,639,614 9,520,415
1992 9,708,043 9,321,851 9,648,111 9,517,942 9,327,842
1993 9,650,832 9,102,337 9,570,554 9,380,839 9,110,846
1994 9,586,367 8,854,984 9,483,161 9,226,348 8,866,330
1995 9,513,725 8,575,126 9,384,684 9,051,706 8,589,687
1996 9,431,871 8,259,776 9,273,718 8,854,915 8,277,959
1997 9,339,635 7,904,431 9,148,678 8,633,165 7,926,696
1998 9,235,702 7,505,153 9,007,781 8,383,851 7,532,000
1999 9,118,587 7,054,104 8,849,014 8,102,359 7,086,130
2000 8,986,619 6,546,983 8,670,111 7,785,724 6,584,829
2001 8,837,915 5,974,413 8,468,519 7,428,375 6,018,835
2002 8,670,351 5,330,361 8,241,360 7,026,263 5,382,174
2003 8,481,535 4,604,626 7,985,392 6,573,152 4,664,769
2004 8,268,774 3,785,717 7,696,960 6,062,018 3,855,263
2005 8,029,028 2,862,949 7,371,948 5,486,060 2,943,092
2006 7,758,877 1,824,285 7,005,717 4,837,613 1,916,350
2007 7,454,464 653,893 6,593,038 4,106,927 759,391
2008 7,111,444 0 6,128,021 3,283,572 0
2009 6,724,920 0 5,604,029 2,355,237 0
2010 6,289,375 0 5,013,581 1,309,166 0
2011 5,798,593 0 4,348,249 130,985 0
2012 5,245,566 0 3,598,537 0 0
2013 4,622,403 0 2,753,742 0 0
2014 3,920,206 0 1,801,806 0 0
2015 3,128,954 0 729,142 0 0
2016 2,237,350 0 0 0 0
2017 1,232,670 0 0 0 0
2018 100,570 0 0 0 0
2019 0 0 0 0 0

Interest Cost : 26,696,335 15,686,557 24,020,676 19,293,379 15,771,023
Interest savings : 0 11,009,777 2,675,658 7,402,956 10,925,312
Final maturity : 01/01/19 06/01/08 08/01/16 01/01/12 07/01/08
Years to maturity: 30.0 19.4 27.6 23.0 19.5


You may customize this report by entering the text listed in {brackets}.
LOAN MASTER Mortgage Comparison System 13












Mortgage Reduction Overview

Mortgage reduction strategies are as varied as the people
who use them. There are many ways to accomplish the goal of
reducing interest expense but they all have one thing in common.
They all depend on some type of prepayment schedule.

Some strategies involve regular periodic prepayments,
others involve irregular periodic or perhaps one time
prepayments. Loan Master will handle them all. If you can think
of it, Loan Master can do it.

This flexibility is purchased at the price of some
complexity but on the other hand that complexity comes with added
utility.

Loan Master works like this. All mortgages and alternative
strategies to be compared are stored in disk files. These files
can then be displayed on the screen, modified, recalculated,
printed, or compared. When an acceptable schedule is made, it
can be kept indefinitely for future reference. If in the future,
changes need to be made, the file can be modified and
recalculated.


Prepayment variations

There are essentially three types of prepayment variations,
ont time prepayments, regular periodic prepayments, and irregular
periodic prepayments. Loan Master can easily handle any of these
variations.


Prepayment Examples

Regular periodic prepayments

Assume the base mortgage has monthly payments.

Fixed amount each month:

This variation can be handled two different ways.

1) Create another mortgage schedule and enter the
payment amount as the sum of the regular payment
amount plus the prepayment amount.


2) Use the base mortgage with its original payment
amount and add a prepayment variation for the
amount of the prepayment.



LOAN MASTER Mortgage Comparison System 14













Fixed amount quarterly, semiannually, or annually, etc.

This variation can be handled by adding a
prepayment variation. When asked to enter the
prepayment variation, enter the date of the first
additional payment, the number of additional payments
and the number of additional payments per year. If the
additional payment is quarterly, the payments per year
would be four.


Thirteen regular monthly payments per year with the
thirteenth being made on a regular payment date.

This is tricky because it is not thirteen payments per
year! If you tell the computer 13 payments per year, it will
think you mean one payment each four weeks. What you really
mean is 11 payments of the regular amount followed by a
twelfth payment of double the regular amount.

To set up this variation, you must set up a base
mortgage and add a prepayment variation. The prepayment
variation is one annual payment in the amount of the regular
monthly payment.


Irregular and one time payments

Irregular payments or one time prepayments are added
manually to the payment schedule. This is done through the browse
function. You must enter the date of the payment, the interest
rate and the amount of the payment, all the other data will be
calculated. If you add payments directly from the browse
function without proceeding through the add payment variation
screen, be sure to sort the file to place the payments in order
by date and to recalculate the schedule before printing or
comparing it.


Interest Computation Basis


The basis of interest computation refers to the divisor used
in the interest formula. The formula for computing interest is
very simple:


Interest = Rate x Principal x Time




LOAN MASTER Mortgage Comparison System 15












This is the base formula we all learned in school. It is so
simple it quite often is inadequate to describe real world
situations like partial periods.

To make the computations simpler, the money lenders many
years ago decided to divide the year in to twelve months of
thirty days each. Using this system, the year has only 360
days.



The interest for one month becomes:

principal x 1(month)
interest = rate x -----------------------
12 (months)

This simplifies to:


principal
interest = rate x ------------
12



For periods of an odd number of days the formula becomes:



principal x days
interest = rate x -----------------------
360



The bankers loved it. They charged interest on a daily
basis, every day, one day at a time. This means they modified
the formula to look like this:














LOAN MASTER Mortgage Comparison System 16













Formula for one year's interest (360 basis)



365 days
interest = rate x principal x -------------
360 days

or


interest = rate x principal x 1.0139



This results in an interest amount 1.39% greater than would
be produced by the basic interest formula. This becomes very
significant for lenders with large loan portfolios.

This type calculation is very seldom used for calculating
interest on mortgages, almost never for home mortgages.
Occasionally, when dealing with a flexible lender, partial
payments are made between payment dates. When this is done, we
must have a way to allocate the interest for a partial payment
period.

Loan Master provides both methods. It does not make
judgements. It does not make assumptions. You must tell it
which method to use.


Recalculating a schedule

When a new schedule is created, the interest and principal
amounts of each payment are calculated and the ending balance and
other data is stored in the file. This data is stored for each
and every payment. A 30 year mortgage will have 361 records in
the file. The first record is not a payment but a record of the
original amount, date. rate, etc.

If you add or change a payment or a payment date, the
interest, principal, and ending balance amounts will change for
each payment after the payment you changed. When you have made
such changes in a schedule file, it becomes necessary to
recalculate the schedule. The recalculate function from the main
menu us used to recalculate the amended schedule.






LOAN MASTER Mortgage Comparison System 17












When you select this menu option, you will be asked for a
file name. You must give the complete name. If the file is
version 3 of a series of mortgages being compared, you must enter
the 3. Example

mortgage3

You will then be asked if you have made any changes or added
any payments since the schedule was recalculated. If you reply
"Y", the schedule will be sorted into order by transaction date
before it is calculated. If you reply "N", the schedule will not
be sorted. This is a critical question. If you have changed the
date order of any payment and do not resort the schedule, the
results will be inaccurate.


Printing Reports

All reports are printed from disk files. The disk files
contain amortization schedules which have been previously
generated and which may or may not have been modified by adding
regular of irregular payments.


Printing an amortization schedule

To print an amortization schedule you must first create the
schedule by using the menu function to create a schedule.

When a schedule exists on the disk, you can print an
amortization schedule by selecting the amortization schedule
option from the print menu. You will be asked for a filename.
Enter the file name. Be sure the printer is on line and that it
has plenty of paper.


Printing a mortgage comparison

A mortgage comparison report lists year end balances of
several mortgages in parallel columns. See the sample report.

The comparative report does not know or care whether the
mortgages are exactly the same, totally different, or variations
of a single mortgage. This report reads from one to five
schedule files and prints the year end balances on the printer.

The files must have names the program can find. the names
must conform to the following convention.

The base file name is seven characters or less, assigned by
you. The program will add a number 1, 2, 3, 4, or 5. to the


LOAN MASTER Mortgage Comparison System 18












seven character name you assign and the file extension is ".DBF"
Thus filenames look lime this:

MORTGAGE1.DBF
MORTGAGE2.DBF
MORTGAGE3.DBF
MORTGAGE4.DBF
MORTGAGE5.DBF



The Parameter File

The parameter file stores information the program needs to
know about how you want the program to perform. This is data that
will be different for each user but information you will not want
to reenter each time the system starts.

The parameter file menu offers these options:


1) Change the Company Name.

2) Change the mortgage comparison header.

3) Change the Amortization Schedule Header.

4) Change the printer setup.

9) Return (to the prior menu)


Customizing the Reports

Changing the company name

Prepared by:

Selection 1 from the parameter file manu allows you to enter
of change the company name. This name is printed on both the
amortization schedule and on the mortgage comparison report. The
report will state that it was prepared by the company (or person)
listed in the parameter file.


Changing the Mortgage Comparison Report Header

The mortgage comparison report has a two line header. This
is the topmost two lines on the first page of the schedule.
These two lines can contain any text you like.



LOAN MASTER Mortgage Comparison System 19












To change this text, select the option to change the
mortgage comparison header option from the parameter file menu.

You will see a screen that looks like this:



Update the mortgage comparison header


Header line 1 The text of the current header will

Header line 2 appear here in two lines.


You may enter any text you like on these two lines. Do not
worry about centering it, the program will do that for you.



Changing the Amortization Schedule Header

The amortization schedule has a two line header. This is
the topmost two lines on the first page of the schedule. These
two lines can contain any text you like.

To change this text, select the option to change the
Amortization Schedule Header from the parameter file menu.

You will see a screen that looks like this:


Update the Amortization Schedule Header


Header line 1 The text of the current header will

Header line 2 appear here in two lines.

You may enter any text you like on these two lines. Do not
worry about centering it, the program will do that for you.


Change the printer setup


Option four from the parameter file menu allows you to
specify data about what your printer can and cannot print.





LOAN MASTER Mortgage Comparison System 20













Selection this option, displays a screen that looks like
this:


Update printer information

Maximum printer width (characters) 80

IBM compatible control codes T/F T

IBM compatible graphics characters T/F F



You should set this information to correspond to your
printer.

Although most printers will print 132 characters per line
using condensed print, this version of the program does not print
reports wider than 80 characters. The maximum printer width
should be left at 80.

Printer control codes.

A future version will allow printing reports in condensed
print. The current version does not send any printer control
codes.

Printer graphics characters.

The report headers use the ascii character 205 to make
lines to set off special areas of the report. If your printer
does not print these characters, the lines will appear as
repeated strings of letters across the page.

If this setting is set to F, the program will substitute
the equal sign " = " for this purpose.


Visual update system.

This setting is either "on" or "off".

The visual update system informs the user of what the
program is doing at every moment. This system is usually
comforting to beginners and many times obnoxious to experts. Turn
it on or off as you like.

See the tutorial section for a more complete description of
the visual update system.


LOAN MASTER Mortgage Comparison System 21














Tutorial, How to Use the Program

Comparing mortgages

Now you are ready to compare mortgages. We will use the
visual update feature so you can see exactly what is happening as
the schedules are built and compared.

First from the main menu, select the option to update the
parameter file. From the parameter file menu, select the option
to turn the visual update system on or off. The menu will tell
you if the option is on or off. If it is off, turn it on. If it
is already on, you can just return to the main menu.

From the main menu, select the option to compare mortgages.
You will be asked how many mortgages you want to compare. Tell
it 3. You will next be asked for a file name. You will be
allowed only seven characters for your file name. The mortgage
schedules to be created will be named with the name you select
plus a number. The first schedule will have the number 1 added,
the second will have a 2, and so on.

When asked for the name to use for the schedule, reply
"eraseme", without the quotes. The three schedules will be named
eraseme1.dbf, eraseme2.dbf, and eraseme3.dbf.

When the program has determined the name of the schedules,
it will create three blank schedule files on your disk. this
process will take a few seconds.

You will be presented a blank data entry screen to enter
data about a mortgage. The screen will ask for the following
data:

Date of mortgage
Date first payment
Amount of mortgage
Number of payments
Number payments per year
Interest rate per year
Payment amount

Enter the following data for your first mortgage:

Date of mortgage 01/01/89
Date first payment 02/01/89
Amount of mortgage 100,000.00
Number of payments 36
Number payments per year 12
Interest rate per year 10.00

LOAN MASTER Mortgage Comparison System 22












Payment amount

Note that no entry was made for the payment amount. With
the cursor on the blank payment amount space, press the enter
key. This in effect enters zero as the payment amount. Almost
instantly, the number $3,226.72 will appear in the payment amount
space. This is the normal payment necessary to amortize the loan
you entered.

The cursor will now appear back at the top of the screen on
the date of the mortgage. If you have made any errors or if you
have changed your mind, you can change any of the data. Use the
op and down arrow keys to move the cursor to the data you want to
change and retype it. It can also be edited. Refer to the
section on data entry and editing for information on editing.

When you are satisfied with the data. When the numbers are
as you want them, press the PgDn key on your keyboard.

The computer will now begin to construct an amortization
table on the disk. This table will contain each payment
necessary to amortize the loan. While the schedule is being
created, the screen will display the calculations on the screen.
The numbers will change rapidly. This display is not really
intended to inform you of the results. It is intended to keep
you informed about the progress of the procedure.

When the schedule is completed, with no intervention from
the user, the screen will clear and redisplay the mortgage data
entry screen. This time however the spaces will already contain
data. It will be the data from the previous mortgage. It is
assumed that the mortgages you are comparing will have some
common data. You may reenter all new data, or simply change the
numbers that have changed.

In this case, change the interest rate to 11.00. To do this,
press the down arrow key until the cursor is on the prior rate of
10%. When the cursor is on the old rate, simply type the new
rate, 11(enter).

Now move the cursor to the payment space and enter 0. This
will cause the program to recalculate the payment.

Before:

Date of mortgage 01/01/89
Date first payment 02/01/89
Amount of mortgage 100,000.00
Number of payments 36
Number payments per year 12
Interest rate per year 10.00
Payment amount 3,226.72

LOAN MASTER Mortgage Comparison System 23













After:

Date of mortgage 01/01/89
Date first payment 02/01/89
Amount of mortgage 100,000.00
Number of payments 36
Number payments per year 12
Interest rate per year 11.00
Payment amount 0


After entering the 0 payment amount, the computer will
compute and display the correct payment amount, $3,273.87.


The screen will now look like this:

Date of mortgage 01/01/89
Date first payment 02/01/89
Amount of mortgage 100,000.00
Number of payments 36
Number payments per year 12
Interest rate per year 10.00
Payment amount 3,273.87


The cursor will again be at the top of the screen on the
data of mortgage. Again you may make changes to any data. (If you
change anything that would change the payment amount, remember to
change the payment amount to 0 so the program will recalculate it
for you.)

Since we do not need to make any changes, simply press the
PgDn key again to accept this page of data. The second mortgage
schedule will now be constructed on the disk and again, you may
monitor the progress of the calculations on the screen.

Once again, (the third time, since we requested 3 schedules)
the mortgage data input screen will be displayed. By now, you
should be able to simply change the rate to 12%, change the
payment to 0 and press the PgDn key. The third schedule will now
be constructed on your disk.

Your disk now contains three files named eraseme1.dbf,
eraseme2.dbf, and eraseme3.dbf. These files hold the mortgage
amortization schedules you have just requested.

Now that you have three amortization schedules on disk, how
do you compare them? From the main menu, select the printed
reports menu. On the print menu you will see a selection to print
mortgage comparisons. Select that option. You will be asked for

LOAN MASTER Mortgage Comparison System 24












the number of files to compare. Tell it 3. Again you will again
be asked for a file name, Tell it "eraseme". No 1 or 2 or 3. No
"DBF". Just "eraseme".

The program will look for the three files eraseme1.dbf,
eraseme2.dbf and eraseme3.dbf. It will read the files and
construct year end totals and balances for each mortgage and
print them out in parallel columns on the report.

Before printing, be sure the printer is on line and has
paper.


Compare prepayment strategies

Comparing prepayment strategies is different from comparing
mortgages. When you compare mortgages, you specify each mortgage
completely. When comparing prepayment strategies, you specify
one base mortgage and several additional prepayment strategies.

We will use the visual update feature so you can see exactly
what is happening as the schedules are built and compared.

First from the main menu, select the option to update the
parameter file. From the parameter file menu, select the option
to turn the visual update system on or off. The menu will tell
you if the option is on or off. If it is off, turn it on. If it
is already on, you can just return to the main menu.

From the main menu, select the option to compare prepayment
strategies. You will be asked how many mortgages you want to
compare. Remember that the base mortgage counts as one. Tell it
3. This will allow one base mortgage and two prepayment
strategies.

You will next be asked for a file name. You will be allowed
only seven characters for your file name. The mortgage schedules
to be created will be named with the name you select plus a
number. The first schedule will have the number 1 added, the
second will have a 2, and so on.

When asked for the name to use for the schedule, reply
"eraseme", without the quotes. The three schedules will be named
eraseme1.dbf, eraseme2.dbf, and eraseme3.dbf.

When the program has determined the name of the schedules,
it will create three blank schedule files on your disk. this
process will take a few seconds.





LOAN MASTER Mortgage Comparison System 25













You will be presented a blank data entry screen to enter
data about a mortgage. The screen will ask for the following
data:


Date of mortgage
Date first payment
Amount of mortgage
Number of payments
Number payments per year
Interest rate per year
Payment amount

Enter the following data for your first mortgage:

Date of mortgage 01/01/89
Date first payment 02/01/89
Amount of mortgage 100,000.00
Number of payments 36
Number payments per year 12
Interest rate per year 10.00
Payment amount

Note that no entry was made for the payment amount. With
the cursor on the blank payment amount space, press the enter
key. This in effect enters zero as the payment amount. Almost
instantly, the number $3,226.72 will appear in the payment amount
space. This is the normal payment necessary to amortize the loan
you entered.

The cursor will now appear back at the top of the screen on
the date of the mortgage. If you have made any errors or if you
have changed your mind, you can change any of the data. Use the
op and down arrow keys to move the cursor to the data you want to
change and retype it. It can also be edited. Refer to the
section on data entry and editing for information on editing.

When you are satisfied with the data. When the numbers are
as you want them, press the PgDn key on your keyboard.

The computer will now begin to construct an amortization
table on the disk. This table will contain each payment
necessary to amortize the loan. While the schedule is being
created, the screen will display the calculations on the screen.
The numbers will change rapidly. This display is not really
intended to inform you of the results. It is intended to keep
you informed about the progress of the procedure.

When the schedule is finished, the program will produce two
copies, one named eraseme2.dbf. The other named eraseme3.dbf.


LOAN MASTER Mortgage Comparison System 26












These schedules are exactly like the original. We will then add a
schedule of prepayments to each of them.

When the schedules are completed, with no intervention from
the user, the screen will clear and display the mortgage
variation data entry screen.

The Prepayment Variation Screen looks like this:

Enter prepayment variation

Date first payment 01/01/89
Number payments
No pmts per year
Payment amount

The date fist payment space will contain the date of the
first payment of the original mortgage. If your prepayment
variation calls for a monthly prepayment, you may start it on the
first month or at any other month. Your prepayment variation may
be monthly, quarterly, semiannually or annual. It may start at
any date after the date of the mortgage.

For our lesson, we will use a variation of $100.00 per month
starting on the date of the original first payment.

The cursor is on the date of first payment. Since that is
the date we want, we do not need to change it. Press the down
arrow to move the cursor to the number of payments space. Since
this is a monthly variation, enter 36 payments, the same as the
original mortgage. It will not take that many to pay it off but
since we don't know how many are needed we must be sure to
specify enough. The program will discard unneeded payments after
the balance reaches zero.

The cursor should now be in the payments per year space, if
not use the up or down arrow keys to move it there. Since this
is a monthly payment variation, the number of payments per year
is 12. Since the space already contains 12, we simply move on to
the next item by pressing the enter key of the down arrow key.

The next item requests the prepayment amount. Enter $100.00.











LOAN MASTER Mortgage Comparison System 27













The screen should now look like this:

Enter prepayment variation

Date first payment 01/01/89
Number payments 36
No pmts per year 12
Payment amount 100.00

If not, change it to match the above.

When the final entry is made, the screen will display the
Add Table visual display which will show you the payments as they
are added to the file. The numbers will change to rapidly for
you to read them but you will know that something is happening.

When all the payments have been added, the browse screen
will be displayed. In this case we will use this opportunity to
add a single payment to the schedule. The cursor will be at the
bottom of the screen on the last payment in the file. If you use
the up and down arrow or the PgUp and PgDn keys, you can display
the entire schedule on the screen. If you do this, you will
notice that the payments are not in date order and the interest
and balances have not been calculated for the added payments.
Don't worry. (See the section of the browse function for more
details about how it works.).

If you moved the cursor from the last payment, press
Ctrl+PgDn to return to the bottom of the schedule.
The cursor is now on the last payment in the file. Press the Down
arrow key. A new blank payment will appear at the bottom of the
screen. The payment number will be zero and the indicator at the
top right of the screen will state the payment is "new".

The cursor is on the payment number. Press the right arrow
key. The highlight will move to the date space but the cursor
will not be displayed. NOTE that the highlight and the cursor are
not the same thing. The cursor is the small blinking underline
"_". You can enter or change data only where the cursor is
visible.

With the highlight on the date space, press the return key.
The cursor will appear in the date space and you can now enter
the payment date. Enter 07-15-90.

Press the right arrow key again to move the highlight to the
rate space. Again the cursor is not visible. Press return to
display the cursor. You may now enter the rate. Enter .12. Note
that unlike the data entry screens, on this screen the rate must
be entered as a decimal. 12% must be entered as 0.12.


LOAN MASTER Mortgage Comparison System 28












Press the right arrow key again to move the cursor to the
payment amount space. Again you must press the enter key to
display the cursor, then enter the payment amount, $1000.00. (Do
not enter the $)

This looks complete, but it is not. There are two more
things the program must know for each payment. These two items
tells it how to compute the interest on the payment.

Use the right arrow key to move the highlight to the space
labeled mint_basis. Press return to display the cursor and enter
a 4. Since this space is only one character in width, you do not
need to press the return or enter key to enter the 4. Now move
the highlight to the space labeled mpmt_type and enter a 1.

The payment is now fully specified. Press the Esc key to
exit the browse screen.

The payment schedule will now be sorted into order by date
and then recalculated. The visual update system will keep you
informed about what is happening. When the schedule is sorted
into order by date, it will be recalculated and any extra
payments after the balance reaches zero will be discarded.

If you watch the recalculate screen closely, you will see
that the last payment is payment number 70. It may or may not be
a full payment. (It may be for less that the amount specified but
will be for the amount necessary to bring the balance to 0.)

Now that the first prepayment variation is fully specified,
calculated, and stored in a disk file, you will be asked to
specify the second prepayment variation.

Our second variation will be 1000.00 per quarter, with the
first prepayment due on April 1, 1989.

Change the variation table to look like this:

Enter prepayment variation

Date first payment 04/01/89
Number payments 12
No pmts per year 4
Payment amount 1000.00

Where did the numbers come from?

The original mortgage was for thee years. Three years of
quarterly payments is 12 payments.

There are four quarters in a year so the number of payments
per year is 4.

LOAN MASTER Mortgage Comparison System 29













The first payment would be due one quarter, three months
after the date of the mortgage or April first.

When the screen is completed, press the page down key. The
add table display will be displayed, followed by the sort
message. When the browse screen appears, you may browse if you
like. When you are ready to continue, press the Esc key to exit
the browse function. The schedule will now be sorted and
recalculated.

We now have three files named eraseme1.dbf, eraseme2.dbf and
eraseme3.dbf. The first file contains the original (base),
mortgage. The other files contain the prepayment variations in
the order we entered them.

Now you will use the browse function to see the results.
Select the browse function from the main menu. when asked for the
filename, reply "eraseme1" with out the quotes.

The browse function will display the original mortgage.

This time, the highlight is placed on payment number 0. This
is not really a payment, but a record of the amount of the
mortgage and the original payment terms.

Press Ctrl+PgDn to go to the last payment. Use the right
arrow key to move the highlight to the transaction date and write
it down. Continue to use the right arrow key until you have
highlighted the space called mint_acuml. This is the total
interest paid during the entire life of the loan. Write it down.

Repeat the procedure for "eraseme2" and "eraseme3", Compare
the date of the final payment. Which variation paid off first?
Compare the cumulative interest figures, which loan was least
expensive? Which loan was most expensive?


Schedule File Specifications

The amortization schedule files produced by the program all
have the same structure. A list of field names along with their
data types is reproduced here. This file is a Dbase compatible
file and can be read or modified with Dbase III.



Date of last update : 08/03/89
Field Field Data Field Dec Description
No Name Type Width
1 MTRAN_NO Numeric 3 Transaction number
2 MTRAN_DATE Date 8 Transaction due date

LOAN MASTER Mortgage Comparison System 30












3 MACCR_RATE Numeric 7 4Accrual interest rate
4 MPMT_AMT Numeric 12 2Scheduled payment amount
5 MINT_BASIS Numeric 1 Interest basis(1)
6 MPMT_TYPE Numeric 1 Payment Type(2)
7 MACCR_DAYS Numeric 4 Days since last payment
8 MINT_DUE Numeric 12 4Interest Due
9 MINT_PAID Numeric 12 2Interest paid
10 MINT_UNPD Numeric 12 4Interest unpaid (after)
11 MINT_ACUML Numeric 12 2Total interest paid
12 MPRIN_DUE Numeric 12 2Principal Due, unpaid
13 MPRIN_PAID Numeric 12 2Principal paid
14 PRINPREPD Numeric 12 2Principal prepaid(*)
15 MPRIN_UNPD Numeric 12 2Principal past due(*)
16 MPRIN_ADV Numeric 12 2Principal increase(*)
17 MBEG_BAL Numeric 12 2Balance before payment
18 MEND_BAL Numeric 12 2Balance after payment
19 MFORCE_INT Logical 1 Force this interest amount (*)
20 MFORCE_PRN Logical 1 Force this principal amount(*)
21 MDATE_PAID Date 8 Date actually paid(*)
** Total ** 179


(*) indicates fields not currently in use by this version of the
system. They will be activated in future releases as time permits
and in priority of user requests.

Detailed Field Descriptions


MTRAN_NO Numeric 3 Transaction number

The transaction number. Each file has a transaction number
zero which is not a payment but represents the original
status of the loan. It stores the original loan amount,
payment amount, interest rate, dates of mortgage and first
payment, payment frequency and types, and any other
information necessary to specify the terms of the original
mortgage.


MTRAN_DATE Date 8 Transaction due date

The transaction date. This is the scheduled data of each
transaction. When a real mortgage is paid, the actual
payment may or may not be made on this date.


MACCR_RATE Numeric 7 4 Accrual interest rate

This is the interest rate, the accrual rate at which the
interest will be computed for this payment. This rate will
be applied to the balance due since the date of the prior

LOAN MASTER Mortgage Comparison System 31












payment. To change the interest rate between payments, it is
necessary to add a transaction on the date the rate is to
change. The added transaction will have the new rate but the
payment amount will be zero.


MPMT_AMT Numeric 12 2 Scheduled payment amount

The scheduled payment amount. This amount will usually be
the same from payment to payment but it is not required to
be. It will be applied to the interest and principal
according to the rule set by the field named MPMT_type.


MINT_BASIS Numeric 1 Interest basis(1)

The interest basis refers to the method of counting the
number of days when computing interest.

Interest computation basis 360/365 days divisor


1 360/360 Normal periodic amortization
(Always computes one period's interest)

2 365/360 Actual day amortization with 360 divisor

3 365/365 Actual day amortization with 365 divisor

4 Same as 1 but computes 0 interest for partial period



MPMT_TYPE Numeric 1 Payment Type(2)

The payment type determines how the payment amount is
allocated to interest and principal.


1 Normal amortization interest plus principal. Take the
interest first then apply what ever is left to the
principal.

2* Constant principal reduction + all accrued int. Apply
the full payment amount specified to the principal and
collect enough additional payment to cover all interest
due.

7* Rule of 78ths, Sum of years digits. Split the payment
by taking the accrual factor for this month and
multiplying it by the total finance charge. The result
is the interest due this month.

LOAN MASTER Mortgage Comparison System 32














MACCR_DAYS Numeric 4 Days since last payment

Days since the date of last payment. If interest basis is 2
or 3, this is the actual number of days for which interest
will be computed. If the basis is 1 or 4, this field is
ignored.


MINT_DUE Numeric 12 4 Interest Due

The interest amount due as of the date of this payment.


MINT_PAID Numeric 12 2 Interest paid

The interest amount actually paid from this payment.


MINT_UNPD Numeric 12 4 Interest unpaid (after)

The interest remaining due but unpaid after the payment due
today was paid. This amount is normally zero but may be
greater than zero if the payment amount is not large enough
to pay all the interest due.


MINT_ACUML Numeric 12 2 Total interest paid

Accumulated interest paid since the mortgage began. This is
the total of all the interest amounts paid from the first
payment to the current payment. At the date of the final
payment, when the balance reaches zero, this field will
contain the total interest cost for the entire life of the
mortgage.


MPRIN_DUE Numeric 12 2 Principal Due, unpaid

Principal Due as of the date of the payment. This is the
amount of principal which should be paid with the current
payment.


MPRIN_PAID Numeric 12 2 Principal paid

Principal paid with this payment. This is the amount of
principal actually deducted from the balance with this
payment.



LOAN MASTER Mortgage Comparison System 33












PRINPREPD Numeric 12 2 Principal prepaid(*)

Principal prepaid. This is the amount of principal that has
been deducted from the balance before it was due. This
amount is not calculated for prepayment variations because
the program does not know which payments were originally
scheduled and which were added later.


MPRIN_UNPD Numeric 12 2 Principal past due(*)

When a payment is not sufficient to pay the entire amount of
principal due, this field will contain the principal amount
remaining unpaid.


MPRIN_ADV Numeric 12 2 Principal increase

Principal advance. Increase in amount of principal. This
field is used in payment number zero to record the original
amount of the principal.


MBEG_BAL Numeric 12 2 Balance before payment

This is the balance due before this payment is paid. It is
always the same as the ending balance from the previous
payment.


MEND_BAL Numeric 12 2 Balance after payment

This is the principal balance remaining unpaid after the
current payment has been paid.


MFORCE_INT Logical 1 Force this interest amount (*)

In some cases, an interest payment is scheduled which has no
relationship to the actual interest accrued to the date of
the payment. One example would be prepaid interest.

When this field is set to T, (true), the amount specified in
the interest payment field will be applied to interest
regardless of the amount due. The amount prepaid or if the
case may be, unpaid will be carried forward to future
payments.


MFORCE_PRN Logical 1 Force this principal amount(*)



LOAN MASTER Mortgage Comparison System 34












In some cases, a principal payment is scheduled which has no
relationship to the actual interest accrued to the date of
the payment. In other words a payment is scheduled in which
the entire amount will be applied to principal and the
interest due will just be ignored.

When this field is set to T, (true), the amount specified in
the principal payment field will be deducted from the
balance regardless of the amount of interest or principal
due. The amount prepaid or if the case may be, unpaid will
be carried forward to future payments.


MDATE_PAID Date 8 Date actually paid(*)

Date this payment was actually paid. In real life, most
payments are paid on a date close to but not actually on the
exact due date. This field allows the user to maintain a
schedule which shows both the due data and the date paid.
Use the browse function to record this date.

































LOAN MASTER Mortgage Comparison System 35












Index


amortization schedule . . . . . . . . . . . 3, 10, 12, 18-20, 30
browse . . . . . . . . . . . . . . . . 3, 7-9, 11, 15, 28-30, 35
cursor control . . . . . . . . . . . . . . . . . . . 3, 5, 6, 8
Data entry . . . . . . . . . . . . . . . . . 3-6, 22, 23, 26-28
Editing data
Browse screen . . . . . . . . . . . . . . . . . . . . . . 8
field descriptions . . . . . . . . . . . . . . . . . . . . 4, 31
file specifications . . . . . . . . . . . . . . . . . . 4, 7, 30
Files required . . . . . . . . . . . . . . . . . . . . . . . . 2
help . . . . . . . . . . . . . . . . . . . . . . . . . . . 2, 3
How to use the program . . . . . . . . . . . . . . . . . . 3, 22
installation . . . . . . . . . . . . . . . . . . . . . . . 2, 3
Interest formula . . . . . . . . . . . . . . . . . . . . . . 16
license agreement . . . . . . . . . . . . . . . . . . . . . 1, 3
MACCR_DAYS . . . . . . . . . . . . . . . . . . . . . . 7, 31, 33
MACCR_RATE . . . . . . . . . . . . . . . . . . . . . . . . 7, 31
main menu . . . . . . . . . . . . . . . 3, 10, 17, 22, 24, 25, 30
MBEG_BAL . . . . . . . . . . . . . . . . . . . . . . . . 31, 34
MDATE_PAID . . . . . . . . . . . . . . . . . . . . . . . 31, 35
MEND_BAL . . . . . . . . . . . . . . . . . . . . . . . . 31, 34
Menu operations . . . . . . . . . . . . . . . . . . . . . . . . 3
MFORCE_INT . . . . . . . . . . . . . . . . . . . . . . . 31, 34
MFORCE_PRN . . . . . . . . . . . . . . . . . . . . . . . 31, 34
MINT_ACUML . . . . . . . . . . . . . . . . . . . . . 30, 31, 33
MINT_BASIS . . . . . . . . . . . . . . . . . . . . . 29, 31, 32
MINT_DUE . . . . . . . . . . . . . . . . . . . . . . . 7, 31, 33
MINT_PAID . . . . . . . . . . . . . . . . . . . . . . . . 31, 33
MINT_UNPD . . . . . . . . . . . . . . . . . . . . . . . . 31, 33
mortgage comparison . . . . . . . . . . . 2, 3, 10, 12, 13, 18-20
Mortgage Comparison Report . . . . . . . . . . . . . . . . . 13
MPMT_AMT . . . . . . . . . . . . . . . . . . . . . . . 7, 31, 32
MPMT_TYPE . . . . . . . . . . . . . . . . . . . . . . 29, 31, 32
MPRIN_ADV . . . . . . . . . . . . . . . . . . . . . . . . 31, 34
MPRIN_DUE . . . . . . . . . . . . . . . . . . . . . . . . 31, 33
MPRIN_PAID . . . . . . . . . . . . . . . . . . . . . . . 31, 33
MPRIN_UNPD . . . . . . . . . . . . . . . . . . . . . . . 31, 34
MTRAN_DATE . . . . . . . . . . . . . . . . . . . . . . 7, 30, 31
MTRAN_NO . . . . . . . . . . . . . . . . . . . . . . . 7, 30, 31
prepayment . . . . . . . . . . . . . . 3, 14, 15, 25, 27-30, 34
PRINPREPD . . . . . . . . . . . . . . . . . . . . . . . . 31, 34
printing reports . . . . . . . . . . . . . . . . . . . 3, 18, 21
recalculate . . . . . . . . . . . . . . . 11, 15, 17, 23, 24, 29
reports menu . . . . . . . . . . . . . . . . . . . 3, 11, 12, 24
strategy . . . . . . . . . . . . . . . . . . . . . . . . . . 13
subdirectories . . . . . . . . . . . . . . . . . . . . . . . . 2
Tutorial . . . . . . . . . . . . . . . . . . . . . . . 3, 21, 22
variations . . . . . . . . . . . . . . 3, 10, 11, 14, 18, 30, 34



LOAN MASTER Mortgage Comparison System 36







 December 16, 2017  Add comments

Leave a Reply