Insights

I work as an investment professional at a private equity firm in Dallas, TX, and since 2013 I have also been building a financial modeling and private equity training resource with the intention of making instruction simple and content accessible. I wrote about the experience of maintaining both in an article that was later picked up by Forbes (link), which sheds some light on my experience maintaining a “side hustle.”

In this post you will find a template for the acquisition of a fictional 160 unit multifamily property. The template was developed in collaboration with a couple friends that are real estate professionals.

Private equity funds are closed-end investment vehicles, which means that there is a limited window to raise funds and once this window has expired no further funds can be raised. These funds are generally formed as either a Limited Partnership (“LP”) or Limited Liability Company (“LLC”).

I recently developed a quick template to look at potential commission structures for a business with customer concentration and large contracts. I thought a simple version of the Excel workbook would provide some decent Excel formula practice.

The two most commonly used functions for scenario selection are =CHOOSE() and =OFFSET(). The =CHOOSE() function is the simpler of the two, and is sufficient for most simple scenario analysis. If, for example, you only intend to run three scenarios, then you may prefer =CHOOSE(). This function can cause frustration, however, if you are constantly adding or deleting the number of scenarios in your model. The reason is that it requires you link directly to the scenario. The image that follows demonstrates: