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 |
IRR for 2 cash flows
I don't understand why you say you have to calculate it 156 times, but
regardless, you have two choices. If the dividends are regular, you can use IRR. IRR will quite happily take a range of 156 cells. Remember, like all financial functions, IRR will calculate the periodic return. So if your dividends are quarterly, you will get a quarterly return, which you would need to multiply by 4 to get an annual rate. If the dividends are irregular (happen at different intervals), use XIRR. For this function, you create a table of the cash flows and the dates they occurred. -- Regards, Fred "Maxymus" wrote in message ... 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 |
All times are GMT +1. The time now is 12:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com