…work, an example is helpful. SUMIF Example There are countless ways in which the SUMIF function can be used in real estate financial modeling, but one of the most common ones…

…comparing apples to apples. For example, it’s common for appraisers to value a property using a market-driven cap rate based on comparable properties in the relevant submarket. However, if the…

…simple example, and then we’ll look at a more complicated effective gross income calculation. A simple back of the envelope proforma for a single tenant property might look like this:…

…go through a slightly more complicated example. Advanced Comparative Lease Analysis Example In this example, we will explore two more complicated lease types, but perform the same basic analysis.  The…

…Sometimes one or more of these products are held with the same bank, credit union, or issuer. As it relates to commercial real estate specifically, it is very common for…

…To bring it all together, let’s go through an example of how a swap may be priced.  It can get really complicated so we’re just going to go through a…

…the draw schedule is fairly straightforward.  For example, there could be 5 draws where each one is meant to complete 20% of the project.  Or, in larger deals, the draw…

…and can be found on the FFIEC Website (NOTE:  The example below describes two actual banks, but their names have been withheld for privacy reasons.  In addition, the example is for…

…as “superadequacy.”  It may seem counterintuitive, but it is possible to improve a property too much and that is where the concept of superadequacy comes into play.  For example, if a…