Property
The Property Tab tracks the performance of owned real estate as well as associated mortgages.
Entering in a Property
To enter in a property, simply fill out the various yellow cells in the Property rows.
Row
Explanation
Date of Purchase
The date that you settled on the property.
Primary Residence
Yes/No - This factors into your FIRE calculations as your primary residence is not included in your total Net Worth. In a future release, this will also influence CGT estimates for sold properties.
Purchase Value
How much you paid for the property.
Net Rent Profit to Date
How much profit you have received on the property. This factors into your overall gain figures.
Estimated Gain (%) per year
The estimated Gain (%) per year, handy when comparing to other assets.
Entering in a Mortgage
To enter in a property, simply fill out the various yellow cells in the Mortgage rows.
Field
Explanation
Mortgage Start Date
The date your mortgage started.
Interest Frequency
How often your interest is calculated per year. This is could be daily or monthly for example.
Annual Interest Rate
What your annual interest rate is.
Regular Payment / month
How much you pay towards your Mortgage in total each month.
Start Mortgage Balance
What your initial mortgage balance is.
Current Mortgage Balance
What your current mortgage balance is.
Mortgage Payments Paid
If known, how much you've paid on your mortgage to date.
Total Interest/Fees accrued
How much you've accrued in fees or interest.
Estimated interest/period
An estimate of the amount of fees you pay per period (see interest frequency).
Estimated total interest on Mortgage
An estimate of how much interest you'll pay on your mortgage over its lifetime.
Estimated Final Payment Date
An estimated date of when you'll finish your mortgage.
How to include your Mortgage Offset Account
Starting in v2.15 is a new ability to automatically include your mortgage offset in your property tracking. This involves entering your mortgage offset as a cash account in the cash tab, and marking the 'Offset' checkbox to classify that account as an offset account.
This will:
Make sure this account isn't tracked as a normal Cash account in your overall Cash balance
Will automatically include this account in the Property tab field 'Mortgage Payments Paid ($)'
In the Sheet Options tab field 'Cash - Offsets include emergency fund' - if this is set to "Yes" your Emergency Fund amount will be deducted first out of this offset balance before being applied to your Mortgage balance. By default this is set to no.
Please note that by default the Offset column is hidden by default and needs to be unhidden to be usable. You can unhide this column by clicking the arrows at the "E" label at the top of the column.
Rental Income & Investment Properties
Income from a an investment property should be entered into the Side Income tab. Rename one of the example columns as needed and enter the after-tax rent each month.
Rental income can also be accounted for in the Property tab in the "Net Rent Profit To Date ($)" row, which will include this rental profit in your overall property return value.
Last updated