Modeling Home Equity

For many people, the equity they've built (or are building) in their home is a significant portion of their overall savings/investments — modeling it, however, can be tricky.

The following topics will be covered in this Guide:

  1. Entering Loan / Mortgage Information
  2. Modeling Starting Equity and the Increase of Property Value
  3. Modeling the Sale of Your Home

Entering Loan / Mortgage Information

When you add a new 'Home Equity' item from the Accounts & Taxes tab, the Item Properties window will automatically appear, as shown below:

Loan / Mortgage Information

After entering the values above, click 'OK' to calculate your equity over time. Principle accrues based on a standard amortization schedule, and you can see those values in the Defined Contributions column on the account's output data.

NOTE: The checkbox Receives Unfunded Contributions is always set to true for Home Equity items. This means there is no corresponding decrease from Income or from other Accounts as the Home Equity item grows, and assumes you have a corresponding loan / mortgage payment as an Expense.

Modeling Starting Equity and the Increase of Property Value

If you paid a significant down payment or if this is a re-finance, then you have equity at the start of the loan. To model the value of this equity, enter the amount as the Starting Balance for the item. Note: This is equity that exists in the first year of the loan only, regardless if the loan was begun in the past (which can be set using the "Start on Year" field, as discussed above).

Item Information

While the Interest Rate field determines the accrual of principle over the lifetime of the loan, the % Growth of the Home Equity item determines the rate of increase in the value of your home (it is defaulted to 3.5%). Each year's ending balance for a Home Equity item is based on both the growth in value of your home along with the accrual of principle.

Modeling the Sale of Your Home

By default, the End Age of the Home Equity item is set to 30 years from the Start Age. The reason it is not set by the Number of Years field in the Loan Information section is to allow you to set a sale year independent of the term of the loan (either to sell the home before the loan is paid off, or perhaps some years after). In addition, OnTrajectory automatically calculates your tax-free gains based on the 'Single / Married' option located in Settings on the Basic Settings tab, as shown below:

Basic Settings