Forum Discussion

Mohammed A Elrify's avatar
Mohammed A Elrify
Brass Contributor
Sep 18, 2016

Suggestion and the recommendation of special functions depreciation

Excel includes 5 formulas to calculate depreciation (SLN,DB,DDB,VDB,SYD) and all of these formulas do not include cells for Starting Date and end date for the cycle to calculate depreciation using it...
Excel Desktop
Formulas & Functions
arthshah's avatar
arthshah
Copper Contributor
Oct 25, 2022
Hi Mohammed, I have an asset, it's basis for depreciation, and life, assuming the salvage value to be zero, can you help me with an automated excel formula that can calculate the month by month depreciation till the asset value becomes zero?

Thanks,
Arth

Resources