Hi absolute Newb here - I have some real estate (and also some brokerage accounts!) that I only own a fraction of - how should I set up assets together with expenses etc that only contributw a portion to my Net Worth?
Welcome to the Tiller Community!
Could you provide a little more detail on the “own a fraction of” assets?
-
For the real estate, is the fractional ownership due to still paying off a mortgage or joint ownership or some other situation?
-
For the brokerage accounts, is the fractional ownership due to an oustanding loan within the accounts, etc…?
Thanks fehenger - both the real estate and brokerage accounts are jointly owned (in different proportions!)
Interesting question, @quaverquaver. It sounds like you are pulling the full asset values in to your Balance History sheet?
This is a new one… I don’t think there is an easy, out of the box solution for this that doesn’t involve some advanced formula modifications.
If it were me, I’d add a new column to the overrides section of the (hidden) Accounts sheet called “Ownership %”. I’d manually add a value for every partial account and then use formulas to default to 100% when none was provided. Then, I’d pull these “override” values into the formula driven hidden summary area of the Accounts sheet to the right (this would be a good place for the default to 100% if not provided formula). Then I would modify the hidden area of the Net Worth to apply the percent ownership from the Accounts summary data to all balances.
It’s not a small amount of work, but if you are handy I’m confident this is the right way to architect it.
Wow thanks for the detailed suggestion! I’ll give it a try !
It’s not trivial. Think of it like a fun adventure and let us know how it goes.