I have a string of Cashflows that can vary based on "timeframe". I have put in a table that looks for the number of months and then matches the cashflows within that period to come up with an NPV.
Here's the problem. I can't get the NPV calculation correct. The Excel Help is not helpful in determining which flows to use. I have tried to create an "array" but I still do not think I have the NPV calculation correct.
Can you take a look?
Thank you in advance.