The Motley Fool Discussion Boards

Previous Page

Fool Community Help Desk / Ask A Foolish Question


Subject:  Financial Calculators Date:  8/12/1999  12:30 PM
Author:  Zora Number:  58737 of 283081

I am looking for an Excell macro or the approprieat equations that performes the following financial calulation:

If you invested $5000.00 in a mutal fund 37 months ago, and a monthly purchase plan of $150.00/month for the first 17 months, then increase it to $250.00/month for 10 more months, and the last 10 months increase it again to $350.00/month. What is your average rate of return since inception, if the value of your fund is now worth $15,000.


Copyright 1996-2020 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us