Why do I get an error with these cash flows?
Cell Formulas | ||
---|---|---|
Range | Formula | |
B6 | B6 | =(1+IRR($B$7:$B$106,0.1))^12-1 |
A8:A106 | A8 | =+A7+1 |
C7:C106 | C7 | =(1+IRR(B$7:B7))^12-1 |