Ability To Refinance Explained

Refinancing a loan can be an invaluable strategy to save money. People generally refinance loans on their commercial real estate projects to either get a lower interest rate, or more favorable loan terms. Refinancing a loan works by taking out a second loan to pay off the first loan, and is done when the second loan can provide better terms than the original.

Read More
Eric Bergin
What Are Operating Expenses?

Operating expenses are incurred through the day to day costs required to operate and maintain a property (AKA normal business functions). These expenses do not factor in any sort of improvements and additional purchases. Most commonly, these include taxes, insurance, and maintenance fees

Read More
Eric Bergin
Excel Functions for Private Equity: Comment vs. Note

Refinancing a loan can be an invaluable strategy to save money. People generally refinance loans on their commercial real estate projects to either get a lower interest rate, or more favorable loan terms. Refinancing a loan works by taking out a second loan to pay off the first loan, and is done when the second loan can provide better terms than the original.

Read More
Brittany Martin
Stabilized Returns

Stabilized returns can be a useful metric for any investors that base their purchases on buying “value add” properties. Stabilized returns are a more holistic metric which will reflect the yield of a deal after a business plan has been executed.  

Read More
Eric Bergin
Millage Rate in Real Estate

The millage rate, or effective property tax rate, is the rate used to determine the local property taxes. The tax expense is calculated by dividing the millage rate by 1000 (100 in TSM) and then multiplying that number with the assessed value of the property. This value will be displayed as a property tax expense in the operating expenses section of the cash flow model.

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

Custom formatting is a feature in Excel that allows you to create and add custom number formats to your data. This allows you to display data with additional descriptors without hardcoding and jeopardizing the integrity of your model. With custom formatting, Excel will still be able to read numbers for function calculations but display them in the chosen format.

Read More
Eric Bergin
What Are Management Fees?

Management fees are an expense that will take care of day-to-day operations for your individual property needs. They are multifaceted and if not negotiated properly, can cost you more than previously expected.

Read More
Brittany Martin
Excel Functions for Private Equity: Format Painter

The Format Painter feature of excel allows you to copy the formatting of a cell to one or multiple other cells within the spreadsheet. When referencing formatting, this can refer to the number format of the cell (general, percentage, currency, etc.), font size, color, or characteristics (Italicized, bold, etc.), or even the cell’s fill or border settings.

Read More
Eric Bergin