------ - Tax Interest calculation where demand is adjusted against deposits on FIFO Basis

[dishantrai]

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 :

 

[vletm]

dishantrai
You should upload an Excel-file
as You've read from
How to get the Best Results at Chandoo.org
https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

 

[macropod]

Cross-posted at: https://www.excelforum.com/excel-fo...is-offset-against-deposits-on-fifo-basis.html
Please read Chandoo's policy on Cross-Posting in the forum rules: https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

 

[dishantrai]

Excel File attached. Someone please help.. ------

 

[vletm]

dishantrai
Did You read Forum-Rules?
No...
... and there cannot be any U....t!

 

[dishantrai]

U..t?

 

[vletm]

You skipped a question:
> Did You read Forum-Rules?

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Seem, still not ...
Open and read it - especially ...
Please Don't