yaswanth92
Member
Hi everyone,
Thank you for looking into this. I am struggling to find the dynamic excel formula to deal with capex replacement every 10 years.
In the excel file attached, I have created an example where I have added some capital costs in year 1 and it's life is for 10 years. But then, trick here is I won't be able to replace it fully in every 10 years and it has to be in line with the normal distribution curve starting to replace in year 6 till year 14. And, the second cycle has to start from year 16 to year 24 and so on.
Also, capital costs are added every year and the formula has to be dynamic enough to capture the replacement based on the normal distribution curve and on the year it's added. For example, costs added in year 2 has to start the replacement in year 7 to 15 and year 17 to 25 and so on.
Appreciate your help on this.
Thank you for looking into this. I am struggling to find the dynamic excel formula to deal with capex replacement every 10 years.
In the excel file attached, I have created an example where I have added some capital costs in year 1 and it's life is for 10 years. But then, trick here is I won't be able to replace it fully in every 10 years and it has to be in line with the normal distribution curve starting to replace in year 6 till year 14. And, the second cycle has to start from year 16 to year 24 and so on.
Also, capital costs are added every year and the formula has to be dynamic enough to capture the replacement based on the normal distribution curve and on the year it's added. For example, costs added in year 2 has to start the replacement in year 7 to 15 and year 17 to 25 and so on.
Appreciate your help on this.
