propertymetrics

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

Suppose that a medium sized accounting firm is looking to expand its footprint by leasing office space in a new city.  After touring several spaces, they have narrowed it down to two options.  The options have similar rental rates, but the firm wants to conserve capital so they need to figure out which one is less expensive. To solve this problem, they need to identify and analyze all of the …

[Read more...] about Introduction to Comparative Lease Analysis

The development spread is a back of the envelope calculation widely used by real estate developers. It is a fast and easy way to size up the financial feasibility of a real estate development project, prior to completing a more in depth analysis. In this article we’ll take a closer look at the development spread and walk through an example of how it is used in practice. What is the Development …

[Read more...] about How the Development Spread Works