The PI is the NPV of all cash flows divided by the initial investment.

You would also get the same NPV using the TVM worksheet

P/Y=C/Y=1

2nd CLR TVM

6 N 6 I/Y 35 PMT 120 FV CPT PV 256.7016163

The PI is the NPV of all cash flows divided by the initial investment.

You would also get the same NPV using the TVM worksheet

P/Y=C/Y=1

2nd CLR TVM

6 N 6 I/Y 35 PMT 120 FV CPT PV 256.7016163