Declining Balance depreciation Fixed Assets

Hi

We have a customer requesting for declining balance calculation for fixed assets.

Requirement as follows:

30% Declining Balance

BV = Book value, ND = No. of Depreciation Days, DBP = Declining-Balance Percent, DA = Depreciation Amount, P = DBP/100, D = ND/360                           

The formula for calculating the depreciation amounts is: DA = BV * (1-(1-P)D)                           

Example:   Asset cost 5826,62;  DPIS 31-03-2008

    

Date	Dprn	Net Book Value
31-03-2008	5,77	5820,85
30-04-2008	170,47	5650,38
31-05-2008	165,47	5484,91
30-06-2008	160,63	5324,28
31-07-2008	155,92	5168,36
31-08-2008	151,36	5017
30-09-2008	146,93	4870,07
31-10-2008	142,62	4727,45
30-11-2008	138,45	4589
31-12-2008	134,39	4454,61
31-01-2009	130,46	4324,15
28-02-2009	126,64	4197,51
31-03-2009	122,93	4074,58
30-04-2009	119,33	3955,25
31-05-2009	115,83	3839,42
30-06-2009	112,44	3726,98
31-07-2009	109,15	3617,83
31-08-2009	105,95	3511,88
30-09-2009	102,85	3409,03
31-10-2009