Articles

When working with a commercial real estate data set, there are occasions where it is necessary to create a sum for a range of values, but only if they meet certain criteria.  Fortunately, there is an easy way to accomplish this task using a built in Microsoft Excel function known as "SUMIF." In this article, the SUMIF function is defined, the syntax for using it is …

[Read more...] about How to Use SUMIF In Commercial Real Estate Analysis

Whether you work at a financial institution, develop real estate, invest in property, or act as a broker, there’s a common thread that binds all facets of the real estate world together.  It’s highly likely that you have one or more financial products like a credit card, debit card, deposit account, car loan, commercial real estate loan, and/or checking account.  Sometimes one or more of these …

[Read more...] about Understanding The Right of Offset

Imagine you are a mid-level manager at a fast growing small business.  As part of the company's expansion plans, you have been tasked with finding office space in a new city and deciding whether to lease it or purchase it.   Fortunately, there is an objective way to make this decision.  But, it can be a little bit complicated.  In this article, we are going to …

[Read more...] about Introduction to Lease vs. Own Commercial Real Estate Analysis