+ Reply to Thread
Results 1 to 5 of 5

Blended Rate Formula

  1. #1
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    Blended Rate Formula

    Could someone please help me with a formula

    If I have

    100,000 at 7%
    and
    15,000 at 11%


    what would be the rate of the total debt 115,000


    thanks

    Josh

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by Josh_123456
    Could someone please help me with a formula

    If I have

    100,000 at 7%
    and
    15,000 at 11%


    what would be the rate of the total debt 115,000


    thanks

    Josh
    try this
    =(100000*.07)+(15000*.11)

  3. #3
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    That didn't seem to work

    I tried an online one and this was the result

    100,000 at 7 %

    and

    25,000 at 9 %

    equals a blended rate of 125,000 at 7.4 %


    So I am trying to figure how to build this into a formula.

    Thanks for trying

    Josh

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Assuming A1 has the first amount, B1 the first rate and A2 has the second amount, and B2 has the second rate, this formula will give you the blended rate:

    =((A1*B1)+(A2*B2))/SUM(A1:A2)

  5. #5
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    thank you

    Thank you,

    it works great

+ Reply to Thread

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