The INDEX function in Excel is a powerful lookup function that returns a value at any determined position in an array. The function can return individual values or entire rows and columns. The INDEX function is typically used in combination with the MATCH function, where the MATCH function sends a position to the INDEX function.
Read MoreNet Operating Income (NOI) is a measure of profitability and is the amount of income generated from a real estate investment after vacancy, credit losses, and operating expenses. The Net Operating Income is equivalent to EBIT (earnings before interest and taxes) in other industries. Since NOI can vary greatly depending on the month, NOI is usually looked at over the span of a year.
Read MoreStated broadly, a Distribution Waterfall is a means to disproportionately allocate distributions between various partners in an investment. Generally, as an investment performs better the Distribution Waterfalls will disproportionally allocate in the General Partner’s favor. Distribution Waterfalls are governed by legal partnership agreements, such as Limited Partnership Agreements and Joint Venture Agreements. These legal documents can define the distribution terms any number of ways, but below I cover some common Distribution Waterfall terms and mechanisms.
Read More
