Hello: Given a simple series of identical cash flow where you need to calculate NPV OR I, do you tend to use the TVM worksheet or the CF function on the calculator. Also, is BGN mode comparable to using CF from 0 across the two functions? Thank you
For calculation of NPV, where cash flows are identical you can use the CF function. For calculation of interest rate, you have to use TVM function.
PV(CF t) = CF / (1+r)^t or PV(CF t) = CF *e^-rt That’s all you need to know.