Gobears81
Senior Member
- Joined
- Nov 7, 2013
- Professional Status
- Certified General Appraiser
- State
- Illinois
Nothing wrong with your table. But I've always felt that this type of calculation was oversimplifying depreciation and suggesting that all three forms directly vary with age.Market sale abstraction utilizing replacement cost (from American Society of Appraisers)
Sale price less land value from comparable sale = Depreciated Improvement Value
Calculate Total Replacement Cost for comparable sale
Total Replacement Cost - Depreciated Improvement Value = Total Depreciation
Total Depreciation / Total Replacement Cost = Percentage of Depreciation of Improvements
Total Economic Useful Life x Percentage of Depreciation of Improvements = Effective age estimate
Repeat for your comparable sales and you get a range which you can use to support you effective age estimate.
Set it up in a spreadsheet and it is quickly developed.
View attachment 72602
You need to know: land values, replacement costs, total economic useful life of comparable sales.
External/ economic obsolescence: No change with age
Functional obsolescence: Becomes more significant over time, but can certainly be prevalent from Day 1
This leaves physical depreciation as the only item that is mostly dependent on age. But I've seen misuse of these types of calculations, as newer properties with economic obsolescence suggest a high depreciation per year, which is applied to older properties and depreciation is overstated