LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
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 11:18 AM.

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"