DB depreciation function

Norina

New Member
Joined
Jul 11, 2019
Messages
2
Hello, I have a list of assets that went in service in different dates and I want to use DB function to calculate depreciation BY MONTH. I tried =DB($J$43,0,60,R2,4) where:
J43 is end of PPE balance
0 salvage value
useful life 60 months
R2 =1 or the first period when depreciation start
4 is 4 months left since asset is acquired in Aug and first depreciation start in Sept. By the third month the asset is fully depreciated.

Question:
How do I fix the formula?
How do I make "4" to be dynamic?

Asset Id End Ppe Balance Recalculated EOL In service Date08/31/201409/30/201410/31/2014
237457-90,280.0202/28/20203/1/2015
23747742,571.8105/28/20206/1/2015
230865253,255.4407/28/20198/1/2014$84,418.48$168,836.96$0.00

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
 

Forum statistics

Threads
1,085,723
Messages
5,385,498
Members
401,957
Latest member
Socksnpants

Some videos you may like

This Week's Hot Topics

Top