Hello everyone,
Roughly half of my real estate portfolio is comprised of passive real estate investment partnerships, where I receive monthly income in my checking account every quarter, and there is eventually an exit 3-10 years from the initial investment.
A very typical investment looks like this:
I wire the firm $50,000. Every quarter, I get ACH deposits into my checking account, for ex:
$1500, $1350, $1900, $1100, $1750, etc. etc.
I get a K-1 form every year which I use for taxes.
How do I account for the initial invested capital, both on entry and exit, if I am using the XIRR function in excel? In Personal Capital, I just set the equity portion at "$50,000", assuming that I have $50K of capital tied up, it doesn't go up or down when it comes to NW, although 3-5% capital appreciation is typical. I don't count that since until something is sold or refinanced, it is what it is.
Total excel newb here, but I think its times to track my leveraged real estate, and K-1 partnership incomes properly.
Roughly half of my real estate portfolio is comprised of passive real estate investment partnerships, where I receive monthly income in my checking account every quarter, and there is eventually an exit 3-10 years from the initial investment.
A very typical investment looks like this:
I wire the firm $50,000. Every quarter, I get ACH deposits into my checking account, for ex:
$1500, $1350, $1900, $1100, $1750, etc. etc.
I get a K-1 form every year which I use for taxes.
How do I account for the initial invested capital, both on entry and exit, if I am using the XIRR function in excel? In Personal Capital, I just set the equity portion at "$50,000", assuming that I have $50K of capital tied up, it doesn't go up or down when it comes to NW, although 3-5% capital appreciation is typical. I don't count that since until something is sold or refinanced, it is what it is.
Total excel newb here, but I think its times to track my leveraged real estate, and K-1 partnership incomes properly.
Comment