T Vaule function
 

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

T Vaule function
 

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

T Vaule function
 

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.

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

T Vaule function
 

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

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


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