MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Financial DCF Calculation


Posted by Peter Brazel on February 13, 2002 9:49 PM

PV=Present Value
FV=Future Value
%i=Interest Rate
N=Periods

Given any three of the above the fourth can be calculated.

Has anybody designed the functions to do this.


Posted by Jon Swanson on February 13, 2002 10:00 PM

Use the =PMT function, this should work....It is under the formula toolbar. Click on the equal sign next to the box you enter data in....Hope this helps.