"Complex" Depreciation

Hi, I have a problem with writing a general model to cope with straight line depreciation.

The model should be able to cope with various depreciation periods (e.g 4 years, 5 years or 10 years) - although for a particular project the period is constant - and investments in different years.


As an example a typical scenario I am trying to model is as follows.

Project Life 20 years

Investments are made at different points in the project cycle e.g. 100 in year 1, another 100 in both years 3 and 4 and another 100 in say year 7.

The depreciation period is 4 years.

There is no salvage value.

As a preference, I would prefer not to use macros.

I hope my description of the problem is clear

Thanks in advance

Thanks for the reply and in the meantime I have been playing and looking through the forum. I found a post by Bjornar and played with his solution and I think I have solved my problem

I attach a solution to my own problem!

Thanks again