| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formulas
Solving for the nominal rate of interest? How do I insert the formula into
excel since I do not see k* and IRP? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
