Calculat a linear amortization

On 07/14/2025 at 16:21

Hello,

Could you please help me create a depreciation (amortization) formula that automatically stops after 60 months?

I need a straight-line (linear) depreciation, for example, depreciation that starts in August 2015 and stops in July 2020.

Another small detail: every month there is a new addition that starts depreciating automatically and should also stop after 60 months. That means, for example, if it starts in September 2015 it should stop in August 2020. Of course, I need to calculate the total depreciation, summing all the individual depreciations.

Thank you in advance.

On 07/18/2025 at 09:38

Hello

Can you provide us a handmade example with some data, and expected result?

Search for threads similar to "calculat linear amortization"