Brandon Roth | Capital Markets @ IPA

There's a common error that I see in some Excel models today that results in a property being undervalued. Since property values have fallen in many markets over the last few years, a new buyer's NOI will likely be higher than the existing owner's NOI because the new buyer's property taxes will be lower. If you were to estimate the value of your property based on a cap rate and the in-place NOI without adjusting the property taxes for the new buyer, then you're likely going to undervalue the property. There's a simple shortcut to estimate the new buyer's NOI based on a reset tax basis without creating a circular reference. Step 1: Add the Property Tax Expense back to the NOI Step 2: Add the Tax Rate to the Cap Rate Step 3: Divide the higher NOI by the higher cap rate This will equal the same result as using your original cap rate with the buyer's NOI inclusive of the reset property taxes. Note: Property tax calculations based for a new purchase will vary state to state. In California, the property taxes will be based on the new purchase price.