"Gentlemen prefer bonds." - Andrew Mellon
logo

Go Back   Saving Advice > Financial Chit Chat > Investing & Banking

Investing & Banking stocks, bonds, banking interest rates, CDs and all other investment vehicles you want to talk about

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 01-24-2008, 03:08 PM
Snowgirl Snowgirl is offline
$ Saving Sixth Grader
 
Join Date: Dec 2007
Location: Canada
Posts: 62
Points: 665.00
Donate
Default Investment return rate calculator

Does anyone know of a good tool, preferably an Excel/OpenOffice spreadsheet that I could use to calculate my effective return rate on my investments? Something that could tell me last year I had X%, year before Y%, since beginning, ... The place that hold my investments tell me the last 12 months rate, but that's it. It would need to handle periodic and one-time contributions. And in typical saving advice fashion, free if possible! I would pay a small fee thought if needed, working in software myself, I know it "cost" something!

Without that, it's hard to see how much my money grows, because I constantly add to it. Could write something myself, but that'd be done in many months, and I'm sure someone on the web already did it for me!
Reply With Quote
  #2 (permalink)  
Old 01-24-2008, 06:42 PM
jIM_Ohio's Avatar
jIM_Ohio jIM_Ohio is offline
$ Saving Professor
 
Join Date: Feb 2007
Location: Milford, OH
Posts: 5,376
Last Blog Entry: Career change
Points: 27853.63
Donate
Default

Search the forum for IRR, this was discussed around Jan 1st. There is more than one way.

The easiest way

(Beginning balance/ending balance)-1

If you had desposits

[(Beginning balance+deposits)/ending balance]-1

If you had several deposits over course of year, you could approximate it by

[(begin balance-.5*deposits)/(ending balance+.5*deposits)]-1
__________________
  • General questions get general responses. Specific questions get better responses. Want a better answer? Re-read my signature LOL
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



Powered by vBulletin®
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.

Copyright © 2012 SavingAdvice.com. All Rights Reserved.