Effective Age Calculator (Spreadsheet for Appraisers)
This free tool was designed to help residential real estate appraisers determine the effective age of the property they’re appraising based on using condition ratings for components of the property.
What Does it Give You?
The end result it provides is an effective age, a straight-line depreciation %, a non-straight-line depreciation %, and also a UAD “C” rating that you can use (if you want) as the Condition rating for the property in question. This is all provided based upon tables of data that you can customize and based upon the information you enter about the property
What if You Don’t Like Something About it?
The entire spreadsheet is unlocked and fully customizable. So, if you don’t like the rating tables, the property component categories, or anything else, you can simply change it based on your preferences.
NOTE: I am not providing phone or email support for this spreadsheet but the video above explains in detail how it works and how to use it. Click the below button to download this free spreadsheet. It was designed for Excel but it does work fine in Google Sheets (although it doesn’t look quite as good).
REFERENCES
The following provided direct help in brainstorming ideas and testing this tool. MANY thanks to:
Woody Fincham, SRA, AI-RRS, ASA, RAA, RAC
References found online that were utilized in creating this tool:
"George Dell's Effective Age Decomposition SFR" © by George Dell, SRA, MAI, ASA, CRE
NOTE: George Dell has fantastic classes and online information/resources which I highly recommend. Click the link to go to his site: https://www.valuemetrics.info/
"Development of Effective Age Estimates" by ASA (available at the below link): https://www.appraisers.org/docs/default-source/discipline_rp/dzierbicki-development-of-effective-age-estimates.pdf?sfvrsn=2c338ed7_0
"Effective Age Calculator" by the Washington State Department of Revenue: https://propertytax.dor.wa.gov/Aspx/EffectiveAgeCalculator.aspx
"Section P - Depreciation and Percent Good Tables" by Haywood County Assessor (2017): https://www.haywoodcountync.gov/DocumentCenter/View/262/Section-P---Depreciation-and-Percent-Good-Tables-PDF
Craftsman Depreciated Cost Tables: https://www.craftsman-https://www.craftsman-book.com/media/static/previews/2020_NBC_book_preview.pdf