+ Reply to Thread
Results 1 to 4 of 4

Calculating Returns & Compounding - Need a MATH Expert

  1. #1
    Forum Contributor
    Join Date
    12-06-2005
    Posts
    118

    Calculating Returns & Compounding - Need a MATH Expert

    In the attached, I have 2 different calculations for a compounded return. Looking at cell D9, I don't think this approach is right as it doesn't seem to take the quarters into account. I think cell F9 is correct though as you are using time.

    Can a math person shed some light on the different approaches?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Calculating Returns & Compounding - Need a MATH Expert

    F9 is only correct if you have some very odd accounting parameters

    Perhaps you could explain what you're trying to do?

  3. #3
    Forum Contributor
    Join Date
    12-06-2005
    Posts
    118

    Re: Calculating Returns & Compounding - Need a MATH Expert

    I am trying to get a compound, since inception return with those 6 or 7 quarters. I was presented with the calculation in cell D9.

    Cell D9 doesn't seem to factor in time at all though whereas F9 does.

  4. #4
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Calculating Returns & Compounding - Need a MATH Expert

    Quote Originally Posted by sabunabu View Post
    I am trying to get a compound
    What?

    An average return? Are your quarterly returns per quarter? Normalised? Annualised?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1