



Row/Col

B

C

D

E

F

G

H

17

Discount Rate

10.00%






18


0

1

2

3

4


19

Cashflows

$985

$75

$120

$100

$1,200


20








21

Using the NetPV functions

Contents of left Cell





22

14.55346%

=HIRR(C19:G19)





23

($0.00)

=NetPV(B22,C19:G19,1)




24

12.36620%

=IRR(C19:G19)

(Using regular IRR, understates the IRR)

25









