General discussion


Excel: determining an interest rate

By abcs86 ·
Known information:
Present Value
Future Value
Number of Periods

What I need to know:
Given the above, what's the interest rate?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by chitosunday In reply to Excel: determining an int ...

=rate(number of periods,future value,- present value)

Note: Cash inflows is positive while cash outflow should be negative). Hence if present value is your investment , then it should be in negative amount.

Collapse -

by chitosunday In reply to

Why don't you try my formula using live data so you can see what is the result. You don't need a knowledge in calculus to see it. It's just plain
excel financial function. Of course, you can do it the hard way, using math formula but why re-invent the old fashioned wheel when you have the latest improved wheel on hand.

Collapse -


by brendanh In reply to

I need a formula and i can't figure it out.. Im making a rate sheet with premiums.
example: A premium of $616.00 for the first $15,000. If i was to add ($22/1000 excess of $15,000) how could i get it to figure that out for me.

Coverage Single Unit Premium

$200,000 $880.00 $616.00
The first $15,000 ($22/1000 excess of $15,000)

If somone could help me that would be great.

Collapse -

by abcs86 In reply to

I had tried this one before, but I always get #NUM! which, according to the Help, is the result of Excel stopping at 20 me, this happening makes no sense. What's the value (no pun intended) of this function if this is the result?

Collapse -

by stress junkie In reply to Excel: determining an int ...

I don't have much confidence in answer 1. The poster used commas between terms. I've never seen a comma used as an operator in arithmetic expressions.

I believe that this is a calculus problem.

You might be able to get some help from your local bank customer service person if they're not busy. Otherwise I would consult a business oriented math book.

Collapse -

by stress junkie In reply to

Okay. I have to admit that I was ignorant. As the comment in Answer 1 says this is an exercise in Excel. I didn't notice that part of the original question, and I don't know Excel very well.

I apologize to the author of Answer 1.

Collapse -

by abcs86 In reply to

Poster rated this answer.

Collapse -

by misscrf In reply to Excel: determining an int ...

Look in Excel help for INTRATE it is a worksheet function. I could paste the entire help thing here, but it would be so much easier if you look at it and test out their example.

NOMINAL may also help. I found this by looking up "determine interest rate" in help.

Collapse -

by misscrf In reply to

Also, check out the what if anaylsis tools. They may be useful in this scenario where one variable is missing.

Collapse -

by abcs86 In reply to

Yep, I should have mentioned that I've tried these functions. I've even checked Microsoft and Walkenbach sites, but nothing.

Related Discussions

Related Forums