Property
The Property Tab tracks the performance of owned real estate as well as associated mortgages.
Manual User Cells:
• Property purchase & live price information
• Mortgage details
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. |
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. |
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. |
Mortgage Offsets can be dealt with in many different ways. Uniquely, Offset accounts can count as both a Cash account as well as down payments on your loan. Since this money can flex in between it can be a grey area, but for the purposes of the Sheet it needs to be more definite.
It is recommended that you come up with a theoretical minimum floor/emergency Cash amount that you have earmarked for emergencies, investments or general purchases ($30,000 for example). This $30,000 balance would go in the Cash tab as "Offset Account".
In the Property tab for "Mortgage amount paid" you would put the remainder of this balance (ie. Total Offset Balance - $30,000). That way as your Offset Cash balance grows, in the Sheet more of your mortgage will be reflected as paid off over time.
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 modified 2yr ago