This is really cool, thanks for sharing.
What happened in BG28 on the "other income and assets" tab?
Typo: "mortgate" -> "mortgage" in a few places.
For my lazy tastes, on the "investments" tab, going in and updating the individual share counts and cost bases as contributions are made into investments seems like too much work. I'd rather just update the balances.
[/quote]
BG28 on "other income & assets" is linked to equal BG12 on the "expenses & debt" tab. It is basically saying when the mortgage is first paid, that is when the equity portion begins to grow by the amount paid.
BG 29 on "other income and assets" equal to BG28 (the cell next to it) plus BH 12 on "expenses & debt". So it would be the previous equity balance plus the latest equity portion of the mortgage payment. This formula can then be dragged to the right 15 years, 30 years, or however long you have left to pay.
You also could just zero out these cells and update your house equity balance once a month, quarterly, annually, whatever works best for you.
As for investments, you could just update quarterly or annually. I only put my longer term investments in this sheet. I have a Robinhood account where I day-trade and it is not included in my personal FIRE sheet.
Thanks for the spelling error. I was sure there was some in there.
