Hi,
I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast ,
[TABLE="width: 394"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Asset Current Cost[/TD]
[TD]Accumulated Depreciation[/TD]
[TD]Net Book Value[/TD]
[TD]Date Placed In Service[/TD]
[TD]Life In Years[/TD]
[/TR]
[TR]
[TD]15,597.50[/TD]
[TD]12,698.06[/TD]
[TD]2,899.44[/TD]
[TD]12-May-2011[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
I want to calculate Depreciation of this asset on annual basis until April 2021 - where it take part of the month for the current year 2019 - as Asset register as 30th of June 2019 .
Please can you help me to write a formula 0 with If function - dont want to use macro for this small task
It shoule automatically stop calculating depreciation when total depreciation = to Cost of Asset in the year .
I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast ,
[TABLE="width: 394"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Asset Current Cost[/TD]
[TD]Accumulated Depreciation[/TD]
[TD]Net Book Value[/TD]
[TD]Date Placed In Service[/TD]
[TD]Life In Years[/TD]
[/TR]
[TR]
[TD]15,597.50[/TD]
[TD]12,698.06[/TD]
[TD]2,899.44[/TD]
[TD]12-May-2011[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
I want to calculate Depreciation of this asset on annual basis until April 2021 - where it take part of the month for the current year 2019 - as Asset register as 30th of June 2019 .
Please can you help me to write a formula 0 with If function - dont want to use macro for this small task
It shoule automatically stop calculating depreciation when total depreciation = to Cost of Asset in the year .