View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SUMIF SUMIF is offline
external usenet poster
 
Posts: 2
Default present value formula

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