Hi, trying to calculate capital interest by month till the asset will go in use. SO it is like a monthly compound interest with unequal payments. Here is what i put together, wondering if anybody can help me to optimize (rewrite) this formula cause it is a nightmare to extend it for several years.
Solved by O. D. in 26 mins