present value formula

S

SUMIF

I need a simple formula to get the result says, 48,000 (pmt) in 4 years time
to 44,678 (present value)

See below example

Pmt 5% PV
Year 0 (12,000) 1 (12,000.00)
1 (12,000) 0.952380952 (11,428.57)
2 (12,000) 0.907029478 (10,884.35)
3 (12,000) 0.863837599 (10,366.05)
4 (48,000) 3.723248029 (44,678.97)

Please help
 
B

bplumhoff

Hello,

Your example obviously shows the present value of 4 annual payments of
12,000 money units (starting today), discounted at 5%:

=-12000*SUMPRODUCT((1+5%)^-(ROW(INDIRECT("1:4"))-1))

[The numbers behind year 4 are just sums of the numbers above, as it
seems]

HTH,
Bernd
 
Top