formulas

T

The Thinker

Solving for the nominal rate of interest? How do I insert the formula into
excel since I do not see k* and IRP?
 
B

Bernard Liengme

If you know pv, pmt, fv and nper then use RATE
Remember to work with correct time units. If nper is months and pmt is month
the RATE is monthly rat. Multiply it by 12 to get nominal annual
rate
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
Turning off automatic calculation 0
Annual % Rate calculation 2
Copy addition formula of non-consecutive horizontal cells 2
Work Budget Salary vs Real Time Salary 0
Autonumber field in Excel that behaves the same as Access 0
calculations or macros? 1
Having a 'not applicable' with a 0 ranking on a rating question 0

Top