+ Reply to Thread
Results 1 to 6 of 6

Daily Compounding Interest Formula Based on Two Different Rates

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    Voorheesville, NY
    MS-Off Ver
    Excel 2007
    Posts
    66

    Daily Compounding Interest Formula Based on Two Different Rates

    What I am trying to do is to create a formula for the attached spreadsheet that calculates the daily compounding interest based on the higher rate of the two rates for the first five years then after 5 years the calculation should only be based solely on the blocked rate.

    Please help!

    Thank you,
    Cheryl
    Attached Files Attached Files
    Last edited by dache416; 05-30-2014 at 08:54 AM.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Problem with Formula

    Well this would get you the correct rate:
    IF(B15<MIN(B$15:B$2267)+365*5+1,MAX(F15:H15),H15)

  3. #3
    Registered User
    Join Date
    05-05-2014
    Location
    Voorheesville, NY
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Problem with Formula

    Hi ragulduy,

    Thank you very much for your reply. Your formula, won’t worked on what I am trying to do – sorry. I do have a formula that I am currently using. In a separate worksheet, I am using this formula (IF(AND(B15>=$J$8,B15<=$J$9),1,0)*D15*(MAX(F15,H15)/365)+D15) for the first 5 years, and this formula (IF(AND(B15>=$J$8,B15<=$J$9),1,0)*D15*(H15/365)+D15) after 5 years.

    I am looking to combine these two concepts into one formula that can calculate the interest (daily compounding) using the higher rates for the first 5 years from the start date. After 5 years, it calculates the interest (daily compounding) using the blocked rate from the 5-years date.

    Thanks,
    Cheryl

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Problem with Formula

    If(b15<min(b$15:b$2267)+365*5+1,(if(and(b15>=$j$8,b15<=$j$9),1,0)*d15*(max(f15,h15)/365)+d15),(if(and(b15>=$j$8,b15<=$j$9),1,0)*d15*(h15/365)+d15))

  5. #5
    Registered User
    Join Date
    05-05-2014
    Location
    Voorheesville, NY
    MS-Off Ver
    Excel 2007
    Posts
    66

    Re: Problem with Formula

    Thank you very much ragulduy. Your formula works - except a few cents diffence.

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Problem with Formula

    Not a good idea to ignore Moderators requests in this forum, I suggest you to take some minutes to read forum rules before you post again.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ 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. Replies: 1
    Last Post: 01-06-2014, 03:54 AM
  2. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  3. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  4. Problem reading formula with ActiveCell.Formula
    By Matija in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 06:10 AM
  5. Formula Problem
    By dragan7746 in forum Excel General
    Replies: 3
    Last Post: 12-01-2006, 05:42 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