how to calculate annual rate of return on investment

Discussion created by danielgardner on Aug 25, 2013
Latest reply on Aug 26, 2013 by steve_ssh

I really have looked for the answer to this question and went through the built in claculations and couldn't find anything that would work. I've created a database that tracks homes purchased, fixed up and sold and would like to track the annual rate of return which appears to require a special calculation to complete. Since I track the expenses, dates, sale price - I believe I have all the data I need - I just can't figure out how to get the actual result. It looks like it requires multiplying by the root = representing the number of years held.


It appears more complicated than I expected. Any help would be appreciated!