# Software

## General discussion

Locked

### Excel: determining an interest rate

By ·
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 +

Collapse -
by 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 -

Stressjunkie,
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 -

### CAN SOMEONE HELP ME?

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.

\$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 -

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

Collapse -
by 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 -

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 -

Collapse -
by 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 -

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

Collapse -

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

## Related Discussions

• 1

#### by which software I can make my PD portable?

webtechexprt ·

• 8

#### what is the best chatbot software for small business?

nathanlohey ·

• 2

Buchiiii ·

• 2

#### Which open-source time tracking software is the best?

riedelrichard21 ·

• 2

#### Best email marketing software

aswanthsingampalli ·