Write a version of the present value function with two interest rates, one for positive cash flows and another for negative cash flows. The function should be written for use in a worksheet, and accept both column and row ranges as parameters. The function declaration line should be:

Function MyPV(CF As Variant, PositiveR As Double, _NegativeR As Double) As Double

Transcribed Image Text:

A BC D E F 1 MYPV IN ACTION 2 PositiveR 3 NegativeR 10%| -100 G 5% 100 =MYPV(C2:E2,$B$2,$B$3) -100 -100 -248.6852 <-- =MYPV(C3:E3,$B$2,$B$3) 100 86.17762|<-- =MYPV(C4:E4,$B$2,$B$3) 100 100 272.3248 <-- 4 -100 100 -63 <-- =MYPV(C2:C4,$B$2,$B$3)