| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
APR Rate on a Loan
Can anyone help me with this? I'm trying to find the Interest Rate of a loan if I'm given Original amount of loan, term and Payment. Example A2 = Original Amt of Loan A3 = Term in Months A4 = Payment A5 = Interest Rate Yearly B2 = 17420.00 B3 = 48 B4 = 413 B5 = This should be 6.49 %. Either I'm slow or I'm missing some steps. Can anyone give me a formula to get this rate? Thanks, Union -- Union70 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fv & Emi! | Excel Worksheet Functions | |||
| XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions | |||
| loan calculator, int rate changes and fixed prin payment | Excel Discussion (Misc queries) | |||
| Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
| Variable rate loan amortization template | Excel Discussion (Misc queries) | |||
Threaded Mode
