| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
