Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to I perform principal component analysis in excel invin Excel Discussion (Misc queries) 1 August 13th 08 10:38 PM
Amortisation with a lump sum principal payment during term Network Capital Excel Worksheet Functions 2 February 3rd 07 08:16 AM
how do i calculate principal payed in one year in excel bigjd45 New Users to Excel 2 April 15th 05 03:39 PM
Extra Payments go toward principal or interest in template? Lindsay Excel Discussion (Misc queries) 1 April 7th 05 03:57 AM
Data $9,620,320 principal, 360 # payments, 9 % rate, fv 0. Why do. rfreddy Excel Worksheet Functions 3 April 4th 05 01:51 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"