Formula to calculate maximum principal debt

facethegod

Well-known Member

Joined

Aug 1, 2006

Messages

767

• Apr 1, 2008

• #2

Does this give you your desired result:


=FV(3.58%,5,-1704752,,0)/(1+3.58%)^(5)

 

Upvote 0

R

Rhonda

New Member

Joined

Jul 28, 2005

Messages

36

• Apr 1, 2008

• #3

Thanks - I tried the FV formula and my result was zero??

 

Upvote 0

facethegod

Well-known Member

Joined

Aug 1, 2006

Messages

767

• Apr 1, 2008

• #4

What are your inputs.. and your expected results? When i try that formula as i have posted it returns: $7,679,636.51

 

Upvote 0

R

Rhonda

New Member

Joined

Jul 28, 2005

Messages

36

• Apr 1, 2008

• #5

Here is what I entered??? (I copied and pasted this directly from the cell)


=FV(3.58%,5-1704752,,0)/(1+3.58%)^(5)

 

Upvote 0

facethegod

Well-known Member

Joined

Aug 1, 2006

Messages

767

• Apr 1, 2008

• #6

looks like you are missing a comma(,) between the 5 and the -1704752....

 

Upvote 0

R

Rhonda

New Member

Joined

Jul 28, 2005

Messages

36

• Apr 1, 2008

• #7

Perfect!! Thanks so much - the formula works fine now. Much appreciated!

 

Upvote 0