Tax Interest calculation where demand is offset against deposits on FIFO Basis

Hi,

I need urgent help in automating interest calculation in case where the tax demand is adjusted against the deposits made on different dates. The deposits are utilized on FIFO basis.

I have prepared a video on the process I follow to compute the interest manually. If someone can please look at it and help me automate the process I would be grateful.

Link to the video youtube. watch?v=-7zr7kvL9Bo

Cross-posted at: https://chandoo.org/forum/threads/ta...o-basis.43501/
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html