I want to know the annualised growth rate for an investment where I know the amount invested, the total amount of money into and out of the investment during the term and the final value. I then wish the rate to be automatically updated when I update the final investment value for the period since inception to today's date. So for example, an investment starts on 1st Jan 1990 with a starting value of £100,000. Between then and today, £14,500 was taken out and £71,000 was put in so net additional contributions of £56,000. Today it's valued at £314,000. Then in 6 months time, I'd like to be able to update the final value field and the answer field will automatically update to reflect the new growth rate taking into account a further 6 months has elapsed.
Hi,
I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.
Hello,
I can help you in managing your business without being overwhelmed with the loads of work.
Ready to get your business to greater heights? That's what I'm here for.
My name is Felvie Sario-Libay, and I am a virtual assisting and bookkeeping expert. I understand that you need some one to help you in an excel spreadsheet that would show how your investment grow for a period of time. I worked as an accountant that is why I already have an expert knowledge in creating excel formula.
If you wish to know me more professionally and personally you can please check my profile at
I am really excited and looking forward in helping you. We can be a great team in managing your investments worry free and hassle free.
Felvie Sario- Libay