| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR for 2 cash flows
I have the monthly closing prices and dividends of a stock in 2 separate
column. I want to calculate the IRR for a seven year period, i.e the investor bought the stock and held it for 7 years and received the dividends. I am able to calculate it , but the thing is that I have to do it 156 times. Is there a quick way to replicate it easily using a formula or something else? Thank you very much! Maxime Isabel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IRR formula for monthly cash flows | Excel Worksheet Functions | |||
| How do I calculate IRR using monthly cash flows, not annual? | Excel Worksheet Functions | |||
| Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions | |||
| Future Value function with differenct cash flows | Excel Discussion (Misc queries) | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
Threaded Mode
