Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an Implied Interest Rate
I would like to create a spreadsheet that analyzes payment options. The
alternative is to pay $30,000 for something today or to pay $32,100 in twelve months from today w/ monthly payments of 32,100/12. What Excel formula would I use to calculate the implied interest rate? Thank you in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
financial function ..please | Excel Worksheet Functions | |||
FVSCHEDULE should allow cell reference for interest rate schedule | Excel Worksheet Functions | |||
Fv & Emi! | Excel Worksheet Functions | |||
to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) |