Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to I perform principal component analysis in excel | Excel Discussion (Misc queries) | |||
Amortisation with a lump sum principal payment during term | Excel Worksheet Functions | |||
how do i calculate principal payed in one year in excel | New Users to Excel | |||
Extra Payments go toward principal or interest in template? | Excel Discussion (Misc queries) | |||
Data $9,620,320 principal, 360 # payments, 9 % rate, fv 0. Why do. | Excel Worksheet Functions |