Chained Returns

Calculating the total rate of return on a chain of returns produces a time weighted rate of return. I covered this in my post “Time & Dollar Weighted Rates of Return Calculator“. In this spreadsheet I have segregate the time weighted return into an easier calculator for someone interested in taking their annual, monthly, quarterly, etc. rates of return over time and calculating the annual rate of return for the total period. There are two formulas I have used in the past to do the calculation. One is an array formula and one is not. This spreadsheet uses the non array formula which incorporates the Excel built in function “FVSCHEDULE”.

Chain1

The calculator is simple. Just add the rates of return in the yellow cells and tell the calculator what times periods the rates are for, using the drop down box. The formula calculates an APY (annual percentage yield) and then calculates the equivalent APR (annual percentage rate). Clicking the green button clears the yellow data cells:

Chain2 Your choices in the dropdown box are:

Chain3 Download “Chain

Comments

  1. Brian Field says:

    Love your site! Have you ever produced any illustrations of “strip funding”?

    I am working on a project that is looking to transform our funding approach to a strip funding approach…..and I am not familiar with it at all!

    Best,

    Brian

    1. Don Pistulka Don Pistulka says:

      Brian,

      I had to do a Google search to find strip funding. Most of my investment career was on the fixed income side, and as CFO of a credit union, I had use for strip funding. If I can help with specific calculations of what you are working on, let me know.

      Don

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

WordPress spam blocked by CleanTalk.