T Vaule function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

topnotchthrillr - 20 Aug 2006 04:52 GMT

Hello,

I am an accountant and we use a amortization program called Tvaule.
was wonder if there is a fucntion that does the same. For instance, I
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?

Thank

Reply to this Message

JMB - 20 Aug 2006 05:15 GMT

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.

> Hello,
>
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

mckenzie.jonathan@gmail.com - 20 Aug 2006 18:56 GMT

If you need to reproduce the amortization table function as found in
TValue you will need to use a combination of items. I have used the
PPMT function to achieve the same results as TValue.

> Hello,
>
[quoted text clipped - 15 lines]
> topnotchthrillr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37777
> View this thread: http://www.excelforum.com/showthread.php?threadid=573496

Reply to this Message

topnotchthrillr - 21 Aug 2006 16:16 GMT

Can you give me an example how it is done? For instance, here are m
numbers.

nominal rate is 6.360%
total payments 60
amount of payment is 2018.05
The T-vaule answer is 104,035.2

Reply to this Message