ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formulas (https://www.excelbanter.com/new-users-excel/203205-formulas.html)

The Thinker

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

JasonP CCTM LV[_2_]

formulas
 
How do you figure the nominal rate of interest?



"The Thinker" wrote:

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


Bernard Liengme

formulas
 
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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"The Thinker" <The wrote in message
...
Solving for the nominal rate of interest? How do I insert the formula into
excel since I do not see k* and IRP?





All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com