ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Return of Principal and IRR (https://www.excelbanter.com/excel-discussion-misc-queries/205093-return-principal-irr.html)

Will[_3_]

Return of Principal and IRR
 
When calculating Internal Rate of Return (IRR) for a stock investment,
should the year 3 figure when you sell the stock include the return of
principal as part of the year 3 cash stream)?

Example, you buy stock today for $8, and have three years of dividends of
$1.88/year. In year three you sell the stock for $20. Is the array that
IRR takes as input:

$8 // stock price
$1.88 // year one dividend
$1.88 // year two dividend
$21.88 // $20 sale price + $1.88 year three dividend

--
Will



Fred Smith[_4_]

Return of Principal and IRR
 
Yes, this is the correct cash flow stream. Just remember that the initial
cash flow is -8.00, as it was money paid out. The remaining three are money
received.

Regards,
Fred.

"Will" wrote in message
...
When calculating Internal Rate of Return (IRR) for a stock investment,
should the year 3 figure when you sell the stock include the return of
principal as part of the year 3 cash stream)?

Example, you buy stock today for $8, and have three years of dividends of
$1.88/year. In year three you sell the stock for $20. Is the array
that
IRR takes as input:

$8 // stock price
$1.88 // year one dividend
$1.88 // year two dividend
$21.88 // $20 sale price + $1.88 year three dividend

--
Will





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

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