Excel Math formulas

[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.

 

[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.

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


--ron

 

[Guest]

I'm trying to figure out the math equations for Present Value, Future
Value, and Payment in Excel.

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.