Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what detail formula of IRR function?
what ditail formula of IRR function ?
or How to calculate IRR function ? IRR (Internal Rate of Return) Tanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what detail formula of IRR function?
IRR uses iteration to find the result.
Using your initial guess, or 10% if you don't supply one, IRR calculates the present value of each cash flow. It then sums all the present values. If the sum is greater than zero, it calculates a new guess less than 10%. If it's less than zero, it increases the guess. It continues doing this until the sum of the present values is zero (or close enough as defined by your options). Regards, Fred "hamid" wrote in message ... what ditail formula of IRR function ? or How to calculate IRR function ? IRR (Internal Rate of Return) Tanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Loses Formula Detail | Excel Discussion (Misc queries) | |||
picture detail | Excel Discussion (Misc queries) | |||
sumif with detail | Excel Discussion (Misc queries) | |||
IF Dilema detail | Excel Discussion (Misc queries) | |||
grab detail when = 1 | Excel Worksheet Functions |