How do I track an interest only, ISA or Endowment mortgage or loan

The simplest way to track an interest only mortgage or loan is to set the balloon amount equal to the value of the loan when entering the loan information (this is different to a repayment loan, as you'd normally enter 'zero' there).

It is advisable to leave the interest rate blank when setting loans and mortgages up (unless you have a variable payment), as the way that some banks calculate interest rates might be slightly different to the way Money does. Money allows you to leave one of the parameters blank, as it can calculate one parameter based on the entries in the others. See the image below:

Setting a zero balloon amount when setting up a loan or mortgage account

Money uses a daily interest rate method, and appears not to take much notice of public holidays - this means that it's calculations are rarely the same as the banks'. Expecting Money to produce down to the last penny calculations is unrealistic.

See also Article 202 regarding some additional ideas on tracking an endowment policy.

Article 487 has information on how to change particular parts (specifically the balloon amount) of a loan.

Category: Loans

Keywords: loan, Endowment, interest, mortgage, ISA

Support | About the author | Sitemap | Blog | Contact Me |
This site is provided without any employment or contractual obligation with Microsoft Corporation.
Copyright © Glyn Simpson 1998-2017. All rights reserved.