Many scenarios arise in which a problem can be
solved most efficiently using customized Excel spreadsheets.
Excel makes payment calculations simple and by
simultaneously calculating all of the most common loan terms, entering the loan
term is seldom necessary. The only thing that needs to be changed are the blue
boxes: the rate and loan amount (and the term if you need to calculate an
Amortization schedules come in many different
types with a variety of different options. This amortization schedule allows the
utilization of several useful features not normally found.
- The loan program is changeable via a
- PMI payments are fully integrated, including
the drop-off point.
- Extra principle payments are permitted
- Row labels are removed to avoid confusion
between row numbers and payment numbers.
- Tools tips are created using Data Validation
Input Messages to help direct new users around the spreadsheet.
- The "Total Cost" over a user-defined period
of time is calculated. The goal is to find the "Total Cost" of several
different loan programs over the period of time that the borrower intends on
keeping the loan. In general, the option with the lowest total cost over
that period is the best option.
Using Excel macros enables a rich set of features
to be utilized.
- This file is digitally signed: While opening
the first time, installing my certificate and adding me to your list of Trusted Sources
will cause subsequently opening
the file will no longer show the macro warning
- Force Macros Enabled: The file cannot be used at
all without macros enabled. All that can be seen is a notification that macros
must be enabled.
- Lock Down: With macros enabled, additional
security features are activated that make it more difficult for the file to
be edited, or saved.
can be forcibly opened to a specifically sized window with a pre-defined toolbar