I assume the payment is monthly. Where
A1= 7208.78
A2= 60
A3= 4.771%

Try:
=PV(A3/12,A2,-A1)

See excel help for more information.

"topnotchthrillr" wrote:


Hello,

I am an accountant and we use a amortization program called Tvaule. I
was wonder if there is a fucntion that does the same. For instance, If
I wanted to get the loan amount for the following....

Payment 7208.78
Months 60
Annual interest rate 4.771

What function do i need to use and how do i use it?

Thanks


--
topnotchthrillr
------------------------------------------------------------------------
topnotchthrillr's Profile: http://www.excelforum.com/member.php...o&userid=37777
View this thread: http://www.excelforum.com/showthread...hreadid=573496