Results 1 to 8 of 8

Help with formula to find interest rate

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Help with formula to find interest rate

    Hello -

    I am trying to solve for the implied interest rate.

    So in this example, I have the option to pay someone $2,000 today, or $23.33 every month for 10 years (120 equal payments) for a total of $2,800.

    I can't figure out which formula(s) to use to find what the implied interest payment would be in this situation so I can decide if it makes sense to pay now or over time.

    What formula(s) would I use?

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1