+ Reply to Thread
Results 1 to 3 of 3

Calculating Yearly Compounded Interest Rate

  1. #1
    Registered User
    Join Date
    02-03-2017
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    34

    Calculating Yearly Compounded Interest Rate

    Good day everyone,

    I have a project that I need to do.

    I need to get a function to work out interest rate.

    I have the following:

    Cost of product
    Present value
    Payment per month
    Period

    I would like to know how to work out the interest rate. So that means I don't have the percentage.

    How would I go about doing that?

    For everything that I have searched the formula has the interest rate percentage in the formula.

    Thanking you in advance

    P.S. We are working on Compounded interest rate (Yearly)
    Last edited by Landi; 08-31-2017 at 04:48 AM.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Calculating Yearly Compounded Interest Rate

    there is a function RATE
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-03-2017
    Location
    South Africa
    MS-Off Ver
    2013
    Posts
    34

    Re: Calculating Yearly Compounded Interest Rate

    @Tim201110,

    Thank you for the formula. It did however not work.

    I did get a formula to work on the yearly compounded interest.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating needed annual interest rate
    By rezikooooo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2016, 04:22 AM
  2. Calculating effective interest rate
    By YoDadio in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-12-2015, 03:17 PM
  3. Replies: 8
    Last Post: 05-07-2013, 02:37 PM
  4. Replies: 6
    Last Post: 04-22-2013, 12:50 AM
  5. Replies: 1
    Last Post: 02-12-2012, 12:45 AM
  6. Replies: 0
    Last Post: 08-08-2011, 09:13 PM
  7. Calculating average interest rate
    By djsquare8 in forum Excel General
    Replies: 1
    Last Post: 07-15-2010, 11:39 AM

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