T Vaule function

[topnotchthrillr]

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

 

[JMB]

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.

 

[mckenzie.jonathan]

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]

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