It is because of the way that excel calculates depreciation (see the
help for
more information). Instead of leaving the last component of the
function
blank (the [factor]) put a 3 and it will give you your 7000.

=DDB(cost, salvage, life, period, [factor])

for the first year it would read:

=DDB(260000, 7000, 7, 1, 3)


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=517389