Depreciation and asset purchase

[polimetla gopal]

Hello all,

I have a "table 1" where I listed class wise assets purchased (calculated bases on product expansion plan) as rows and months in columns.
Each class of asset have different life and after completion of life I have to buy assets again.

Then I have "table 2" another table that calculated the depreciation of each class.

I wanted to create another month wise table to calculate the cost of assets to be purchased after the end of life of assets bought as per "table 1".

Sample table attached.

Thanks in advance.

gopal.