"And thinking your little spreadsheet calculations are even remotely comparable to a properly prepared depreciation schedule?? I can't work out which are bigger"
From one example with purchasing values in the low 300k and 400k i was able to model and be within +/-20% for a property with a purchase price of 800k... image if you guys instead of being stubborn did share your depreciation values....?
Also my guess is the bulk of the 20% error is with the value in the first year!... all the other years should be fairly accurate as I explained.
Also, what do you mean when you say +/-20%... which is it? I gave a range, maximum and minimum. Do you mean your actuals are -20% of the maximum set of values? if so then that means your values lay between my max and min set of values...?
Can someone else do another example, this time lower purchase values like in 400-600k range?
also why call my spreadsheet little...
The table and graph are just end products.. how do you know what calculations went behind it all?
Indeed. You are correct. I used the wrong column in your matrix. Apologies. Your spreadsheet is within +/- 20% of the correct figure.
Hope that works out for you.
Blacky
From one example with purchasing values in the low 300k and 400k i was able to model and be within +/-20% for a property with a purchase price of 800k... image if you guys instead of being stubborn did share your depreciation values....?
Also my guess is the bulk of the 20% error is with the value in the first year!... all the other years should be fairly accurate as I explained.
Also, what do you mean when you say +/-20%... which is it? I gave a range, maximum and minimum. Do you mean your actuals are -20% of the maximum set of values? if so then that means your values lay between my max and min set of values...?
Can someone else do another example, this time lower purchase values like in 400-600k range?
also why call my spreadsheet little...
The table and graph are just end products.. how do you know what calculations went behind it all?