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?
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
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 Date | 08/31/2014 | 09/30/2014 | 10/31/2014 |
237457 | -90,280.02 | 02/28/2020 | 3/1/2015 | |||
237477 | 42,571.81 | 05/28/2020 | 6/1/2015 | |||
230865 | 253,255.44 | 07/28/2019 | 8/1/2014 | $84,418.48 | $168,836.96 | $0.00 |
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>