Time Weighted Rate of Return

Articles / Directory


	3/16/2010 Latest version of TraderCode(v4.0) adds new Strategy Backtesting Expert . 1/04/2010 InvestmentCode, a comprehensive suite of Financial calculators and models for Excel is now available. 9/01/2009 Launch of Free Investment and Financial Calculator for Excel . 1/02/2009 Launch of NeuralCode(v1.0) for Neural Networks Trading . 8/06/2008 Launch of ConnectCode Excel Training Courses. Get this Free Excel Training (over 100 pages) now. 7/23/2008 ConnectCode Text Manager - add-in that enhances your productivity when working with text in Excel. 6/17/2008 ConnectCode Number Manager - add-in that enhances your productivity when working with numbers in Excel. 6/3/2008 ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes. 3/5/2008 Release of ConnectCode Deluxe Add-In - a collection of commonly used add-ins for Excel. It includes Formula Report Generator, Dynamic Ranges Namer, Conditional Row Deletion, Scheduler and many more. 2/1/2008 Release of SparkCode Professional - add-in for creating Dashboards in Excel with sparklines 12/15/2007 Announcing ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel 09/08/2007 Launch of TinyGraphs - add in for creating sparklines and tiny charts in Excel.

Time Weighted Rate of Return

The Time Weighted Rate of Return measures the compound rate of growth over a period of time by assuming an investment at the beginning of a period and measuring the growth of market value at the end of the period. This calculation removes the money weighted effects on investments and is typically used to compare the returns of investment managers.

The following Excel worksheet Time Weighted Rate of Return in the Rate of Return.xls spreadsheet describes how to calculate the Time-Weighted Rate of Return.

The worksheet first calculates the Holding Period Return of the Cash inflow and outflow of each period.

Time Weighted Return = ((1+Holding Period Return at time 1) *
                                     (1+Holding Period Return at time 2) *
                                     ..
                                     (1+Holding Period Return at time n)) - 1

Holding Period Return is described in the next section.

Next :
Holding Period Return

Back to Free Investment and Financial Calculator main page.

Back to Excel Add-Ins and Templates main page.

Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners