LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jIM jIM is offline
external usenet poster
 
Posts: 17
Default installing XIRR

I do not have XIRR function to calculate IRR for my investments. I
only deposit, do not withdraw, can someone help me with formula or
installing XIRR.

The formula others use:

([old value-.5* deposits]/[end value+.5*deposits])-1

this worked well when combining 6 accounts (two 401k, 2 Roth IRA, 2
Rollover IRA), = 4.7% IRR, but did not do well with each sub account
(no account had less than a 30% IRR).

suggestions?
 
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
installing new program worknpoman New Users to Excel 1 July 12th 07 07:55 AM
Error when installing Add-ins Tinus Excel Discussion (Misc queries) 3 April 26th 05 06:16 PM
Installing MS Office [email protected] New Users to Excel 3 March 24th 05 04:29 PM
installing sql.request help sql.request help Excel Worksheet Functions 0 December 15th 04 10:17 PM
installing feature Villa Bithiah Excel Discussion (Misc queries) 1 December 7th 04 07:21 AM


All times are GMT +1. The time now is 07:18 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"