ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating an Implied Interest Rate (https://www.excelbanter.com/excel-discussion-misc-queries/108789-calculating-implied-interest-rate.html)

SJT

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.


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com