Compound Interest
Tables

6 Functions of $1
The 6 Functions of
$1 are compound interest tables found in most real estate investment text books and are
used by real estate appraisers, brokers and investment portfolio managers to determine the present worth of
future benefits from the ownership of investment real estate, the future value of periodic payments at
compound interest, mortgage payments, the discounting of future benefits and various investment analysis
involving the ownership of cash flows for various investments and holding periods. The six functions of a
dollar are the basic building blocks to analyze and determine market values for all types of investment real
estate decisions. The following download includes the six individual functions setup in easy to use
spreadsheet format with detailed instructions for each step in the calculation process. A recent addition to
the templates is a consolidates version that includes all six functions of one dollar as depicted in the
adjacent photo. This template is all inclusive an is similar to the tables found in the back of most real
estate textbooks. By changing the interest rate in the upper left hand corner of the chart the entire chart
recalculates the rates for the entire sheet. Therefore, you can view and/or print a compound interest rate
table for any interest rate you chose without limitation. The templates are prepared to use with Microsoft
Excel and once downloaded to your computer should be saved on a backup CD or floppy disk. This will allow you
to keep an original copy to reinstall in case you corrupt the working file copy stored on your hard drive.
Also provided are templates to calculate mortgage constants, mortgage payments, future value and present
value.
The Following Compound Interest Table
Templates are included in the
6 Functions of
$1:
- The Amount of $1
- The Amount of $1 per Period
- Sinking Fund
- Present Worth of $1
- Present Worth of $1 per Period
- Partial Payment
- Printable Compound Interest Tables (6 functions of $1) for any Interest
Rate.
- Print them and take them with you or take them on your
laptop.
- Mortgage Constant Calculator
- Mortgage Payment Calculator
- Future Value Calculator
- Present Value Calculator
These templates eliminate the need to use the printed tables most people are still
using. By changing the interest rate the template automatically recalculates the factor. By changing the term
it will provide the factor for that term and the selected interest rate. You can copy the entire template
into another spreadsheet or your word processor. These six templates will save you time and of course money.
Also included for those who need a complete set of printed tables is the standard six column table of all six
functions ready to print. It is only necessary to change the interest rate at the top left hand corner of the
page and print the recalculated table or tables for any interest rate. This was recently requested by several
appraisal students and new license examinees. Also included with these six templates are three additional
templates that calculate present worth, future worth and mortgage payments.
To download your copy of
the 6
Functions of $1 plus the three FREE additional
templates, select the "Buy Now" button
below.
To Download your copy of
the
"6 Functions of $1"
spreadsheet template for your computer for
only $29.95
click the "Buy
Now" button below:


|