Vishal Srivastava
Member
Hi Experts,
This is in continuation to my previous question where an excellent solution was provided by XORLX.
Now I am again in a dilemma to solve the next problem.
I am working with a financial model where I have to adjust losses over the next 8 years.
The loss will be adjusted on the basis of FIFO. This means losses occurred first would be adjusted first.
I have uploaded a sample paper to clarify my question.
Here, I'm looking for a single formula that will give me the "Total Balance Amount" after the loss adjustment.
Hope I have given the proper explanation.
Please help!
This is in continuation to my previous question where an excellent solution was provided by XORLX.
Now I am again in a dilemma to solve the next problem.
I am working with a financial model where I have to adjust losses over the next 8 years.
The loss will be adjusted on the basis of FIFO. This means losses occurred first would be adjusted first.
I have uploaded a sample paper to clarify my question.
Here, I'm looking for a single formula that will give me the "Total Balance Amount" after the loss adjustment.
Hope I have given the proper explanation.
Please help!