Depreciation & interest calculation on initial capital investment & sustaining investment

Dear All,

I need to calculate depreciation & interest amount for capital investment in a project. Attaching the sample file showing brief requirement/description and as below-

1. The investments are related to one particular project. There will be some project duration (14 years in this case) and there will be some depreciation period (input data).
2. Table-1 shows the pattern of capital investments over a different period during the project duration.
2. Table-2 shows the auto calculated depreciation amount based on inputs in Table-1 & other inputs in input section.
3. Table-3 will populate interest amount based on remaining capital investment value & rate of interest (considering maximum depreciation period as defined in input section). If, in cases where depreciation period is shorter than the project duration, depreciation & interest in remaining years should be nil.

Thank you
Regards
Kaustav

I think the lack or a response is down to you not manually including what you expect as an answer. then someone can work out the formulas to help you. Why not manually add results, shade the cells and say you wish formulas to represent this.

Hi!
I manually calculated one line for calculating the depreciation for an example.