Using My Annualized Rate of Return Spreadsheet
Steven from ValueBlogReview sent me the following question in an email today:
“Do you know of a quick formula to figure out a per annum interest rate when multiple deposits are made at different times?”
I sent Steven straight to a post a wrote a few weeks ago on how to calculate your return on investment. I recommended that he check out the Microsoft Excel (MSFT) and Google (GOOG) Spreadsheet examples I included in that article. I wasn’t to sure that my post was all that clear, but Steven figured it out and even posted a story about his experience.
Steven decided to use my Google Spreadsheet and he even figure out how to customize it for his own use. I learned something new about Google Spreadsheets from his experience and I wanted to share his knowledge with you. Steven wrote:
“Before you can customize it, in the Google spreadsheet you will need to click on file in the upper right, select copy spreadsheet, and rename it… What you want to do is change the notes to reflect your own needs… This is a nice little sheet that George has and I recommend it for the new investor looking for a quick way to track their progress.”