UnThreaded | Threaded | Whole Thread (5) | Ignore Thread Prev | Next
Author: UhuruPeak One star, 50 posts Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 75816  
Subject: Re: Formula to Calculate Growth Date: 3/13/2002 12:16 AM
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Recommendations: 3
Hi,
I am wondering what mathematical formula is used to calculate growth of an investment if you have the percent return (or the doubling time of the investment). I could do it if there was a one time addition but what if you add a set amount each year (as in IRA contributions)?
Thanks,
Carson


I'm not sure which formula you are after? The amount you'll have in 10 years if your initial capital coumpounds at a 10% rate (A)? or the Rate of Return on your investment (B)?

For (A), you want to do the following calculation:
Final_value = Initial_value * (1+ Rate of Return)^Nb_years
(in Excel speak, FV = IV * POWER((1+RR), Nb_yrs)

For (B), you can use the following formula:
IRR(Value, Guess)
Here is the help Excel provides:

IRR(values,guess)

Values is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

Values must contain at least one positive value and one negative value to calculate the internal rate of return.


IRR uses the order of values to interpret the order of cash flows. Be sure to enter your payment and income values in the sequence you want.


If an array or reference argument contains text, logical values, or empty cells, those values are ignored.
Guess is a number that you guess is close to the result of IRR.

Microsoft Excel uses an iterative technique for calculating IRR. Starting with guess, IRR cycles through the calculation until the result is accurate within 0.00001 percent. If IRR can't find a result that works after 20 tries, the #NUM! error value is returned.


In most cases you do not need to provide guess for the IRR calculation. If guess is omitted, it is assumed to be 0.1 (10 percent).


If IRR gives the #NUM! error value, or if the result is not close to what you expected, try again with a different value for guess.

Examples

Suppose you want to start a restaurant business. You estimate it will cost $70,000 to start the business and expect to net the following income in the first five years: $12,000, $15,000, $18,000, $21,000, and $26,000. B1:B6 contain the following values: $-70,000, $12,000, $15,000, $18,000, $21,000 and $26,000, respectively.

To calculate the investment's internal rate of return after four years:

IRR(B1:B5) equals -2.12 percent

To calculate the internal rate of return after five years:

IRR(B1:B6) equals 8.66 percent

To calculate the internal rate of return after two years, you need to include a guess:

IRR(B1:B3,-10%) equals -44.35 percent



Did I answer your question?
UhuruPeak
Post New | Post Reply | Reply Later | Create Poll . Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (5) | Ignore Thread Prev | Next

Announcements

The Retire Early Home Page
Discussion on accelerating retirement day.
Pencils of Promise - Back to School Drive
"Pencils of Promise works with communities across the globe to build schools and create programs that provide education opportunities for children."
Managing Your Wealth
Our own TMFHockeypop from Rule Your Retirement fame on the TV show Managing Your Wealth.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.
Advertisement