Ask Experts Questions for FREE Help !
Ask
    jpullen's Avatar
    jpullen Posts: 1, Reputation: 1
    New Member
     
    #1

    May 20, 2010, 02:21 PM
    How to calculate annualized rate of return for account
    If I have a beginning balance uneven yearly contributions and a ending balance how do I calculate an annualized rate of return?
    shaneshot417's Avatar
    shaneshot417 Posts: 17, Reputation: 1
    New Member
     
    #2

    May 20, 2010, 06:10 PM

    Don't quote me on this because it has been a long time since high school. Take ending balance, subtract money invested to get profit. Divide profit by money invested. That give you percent of return. Example invest 3000. Now, subtract it from total worth at end of term, suppose it to be 5000. Then take profit and divide it by original investment . That equals percent of return. . 66666 percent. Something like that...
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #3

    May 21, 2010, 04:49 AM
    Shane's calc works fine for a single investment with a one-year horizon. But the wording of the question suggests a multi-year scenario, with an uneven pattern of annual contributions into the investment.

    JPullen, if (1) you're given an opening balance of B; (2) you know the subsequent contribution amounts (not necessarily the same) and the timing of each, in terms of the number of one-year periods between the contribution and the ending date; and (3) you're given the ending amount E; then your answer is the amount r which solves a basic forward-value equation.

    Short example: Opening balance is B; a contribution is made after 2 years; another is made after 4 years; and the result is an ending balance E one year after the final contribution; then



    The effective average annual return r which makes the opening balance and the two subsequent contributions grow to E by the end of the fifth year is what you're looking for. Finding r, I'm afraid, requires plain ol' trial-and-error. (Or at least the modern equivalent, such as Excel's Goal Seek, WolframAlpha... )

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to calculate Accounting rate of return [ 3 Answers ]

I need to calculate Accounting rate of return I know that it is Average Profit/Average investment If project 1 Cost is 1,000,000 And cash flows are Year 0 0 Year 1 150,000 Year 2 200,000 3 300,000...

Calculate Rate of return [ 2 Answers ]

A bond is available for Rs 1400. It offer include one immediate payment nad 10 annual payments of Rs 210 each. Compute the rate of return?

Calculate the rate of return [ 1 Answers ]

Calculate the required rate of return for Mercury, Inc. assuming that investors expect a 5 percent rate of inflation In the future. The real risk-free rate is equal to 3 percent and the market risk premium is 5 percent. Mercury has a beta of 2.0, and its realized rate of return has averaged 15...


View more questions Search