Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
present value formula
Please tell us in more detail what is needed.
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "SUMIF" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
present value formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Understanding net present value formula in Excel | Excel Worksheet Functions |