Excel Math formulas

R

rympierc

I'm trying to figure out the math equations for Present Value, Future
Value, and Payment in Excel. I want to make sure they are the exact
same equations as what it uses so my numbers don't get screwed up. If
anyone could help me out I'd really appreciate it.
 
R

Ron Rosenfeld

I'm trying to figure out the math equations for Present Value, Future
Value, and Payment in Excel. I want to make sure they are the exact
same equations as what it uses so my numbers don't get screwed up. If
anyone could help me out I'd really appreciate it.
Click to expand...

Excel solves for the one in terms of the others. See HELP for PV for the
equation.


--ron
 
J

joeu2004

[email protected] said:
I'm trying to figure out the math equations for Present Value, Future
Value, and Payment in Excel.
Click to expand...

I cannot say for sure what Excel does. But the typical formula is:

0 = PV + (1 + i*TYPE)*PMT*( (1 - (1+i)^(-n)) / i ) + FV*(1+i)^(-n)

Solve for PV, FV or PMT. Solve for i iteratively.
 
Top