Depreciation Formula

[slstewart249]

I am building a 5 yr depreciation forecast and am having trouble with creating the correct formula. I am trying to build an excel table with Col A the Fiscal Year the Capital is purchased, Col F-I, the Qtr the capital is purchased and Col K the life of the asset. I am trying to get the formulas in Col L-Col Q need factor in the Year the asset was purchased and the life of the asset. I've tried varies nested approaches and am stuck. Thanks for your help in advance!

 

[bosco_yip]

Try.......

In L12, copy across and down :

=IF(((RIGHT($A12,2)+$K12-1)>=0+RIGHT(L$11,2))*(RIGHT(L$11,2)>=RIGHT($A12,2))*($J12>0),$J12/$K12/52*L$9,0)

Regards

 

[John Jairo V]

Hi to all!

Another approach could be:

=OR($A12=L$11,ABS(SUM($K12:K12)-$K12-$J12/2)<$J12/2)*$J12/$K12/L$9*52

Blessings!