Unit Mix in Financial Modeling

Unit mix is defined as a mix of different number of bedroom apartments in a development or apartment complex. Normally, the number of bedrooms ranges from one to five, and any given apartment complex will have a mix of bedroom options and different floor plans for each type. Every development is trying to achieve the perfect “mix” of each type of apartment for their property, to maximize profit and keep the property occupied year round. 

Read More
Eric Bergin
Excel Tips for Private Equity: Conditional Formatting

Conditional Formatting is a feature in Excel that allows you to apply special formatting to cells that meet certain criteria. Typically, conditional formatting is used to color specific cells in order to emphasize or differentiate between values within the spreadsheet. Whether these values are certain investment return requirements, minimums on inventory levels, or cash flow levels, conditional formatting serves to organize data in a more digestible fashion. 

Read More
Eric Bergin
XNPV in Distribution Waterfall Calculation

A Distribution Waterfall is a method of distributing money between the General and Limited Partners involved in an investment. Typically, the waterfall disproportionately allocates distributions to the General Partners after certain returns have been achieved in an effort to incentivize the General Partners to maximize returns. Distribution Waterfalls are governed by the legal documents of the partnership such as Joint Venture Agreements and Limited Partnership Agreements.

Read More
Eric Bergin
Drawdowns in Private Equity Real Estate

A drawdown (aka capital call) is the legal right of a private equity firm to demand a portion of the committed capital from the limited partners to pay for a newly identified investment or expense. It is the act of transferring the promised funds to the investment target. 

Read More
Eric Bergin
Equity Markets in Real Estate

Equity Markets, also common referred to as the stock market, is a market in which shares of companies are issued, bought, and sold. Equity markets facilitate the exchange of shares between both institutional and individual investors, and can be executed through multiple exchange platforms.

Read More
Eric Bergin
What Are Expense Recoveries?

Expense recoveries are the amount of money a landlord is reimbursed by tenants to cover operating expenses at a property. Within non-residential real estate - such as retail or office buildings – tenants sign leases with agreements that specify a base rent, which may be calculated as a yearly dollar amount per rentable square foot of space, plus additional expenses.

Read More
Eric Bergin