VDB Depreciation Question
Hi All,
I understand that if you set the no_switch argument of the VDB function to false, your calculation will switch to straight line (SLN) once SLN is greater than the declining balance. However, I cannot seem to get this to work. By way of example: =SLN(2400,300,10) equates to 210 of depreciation expense per year (for ten years). =VDB(2400,300,10,0,1,2,FALSE) equates to the following depreciation expenses per year: Year 1 480.00 Year 2 384.00 Year 3 307.20 Year 4 245.76 Year 5 196.61 Year 6 157.29 Year 7 125.83 Year 8 100.66 Year 9 80.53 Year 10 22.12 My question is why doesn’t this formula switch to straight-line in year 5 when the VDB balance is obviously less than straight-line???? Any guidance would be much appreciated! Kevin |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com