VDB function

krp7168

New Member
Joined
Oct 4, 2006
Messages
1
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 great 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
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

sunnyland

Well-known Member
Joined
Jan 27, 2006
Messages
912
Hello again,

Sorry, I posted my previous post too quickly and only realised later it didn't paste all the rows. So here we are again.
The vdb function switches when the no switch off is less then the no switch on. See sample above. While in green both are similar with the blue it shows that switching to straight line is better greater amount of amortisation.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,955
Messages
5,545,162
Members
410,667
Latest member
Gaexel
Top