OilEconomist
Board Regular
 Joined
 Dec 26, 2016
 Messages
 194
 Office Version

 2019
 Platform

 Windows
Thanks in advance for any suggestions, and I will provide feedback on any proposed solutions.
How do I modify the following formula to cut the columns off after the economic limit and beyond (i.e. not include them in the NPV Formula).
= NPV( ( 1 + $B$1 )^(1/12)1, $L$198:$ATO$198)
Cell A1 has the date of the economic limit which is obtained from row 198.
Cell B1 has the discount factor (10% = 0.10)
Cell L198 is the starting period with the monthly cash flows and has the corresponding date of 1/1/2019
Cell ATO198 is the ending period of the monthly cash flows and has the corresponding date of 12/1/2218.
I find where the cash flow first goes negative in row 198 and place the corresponding date in cell A1. How do I ensure the cash flows including that date and after do not get counted in the NPV formula. The date will change depending on my cash flows.
How do I modify the following formula to cut the columns off after the economic limit and beyond (i.e. not include them in the NPV Formula).
= NPV( ( 1 + $B$1 )^(1/12)1, $L$198:$ATO$198)
Cell A1 has the date of the economic limit which is obtained from row 198.
Cell B1 has the discount factor (10% = 0.10)
Cell L198 is the starting period with the monthly cash flows and has the corresponding date of 1/1/2019
Cell ATO198 is the ending period of the monthly cash flows and has the corresponding date of 12/1/2218.
I find where the cash flow first goes negative in row 198 and place the corresponding date in cell A1. How do I ensure the cash flows including that date and after do not get counted in the NPV formula. The date will change depending on my cash flows.