Time-Weighted Return Diagnostic Report

This report is used to troubleshoot or audit return numbers for your Client and Account performance reports.  If the TWR period return number appears to be inaccurate for a given time frame, running this report will help to narrow the cause of the return discrepancy down to a single day.

What levels within the software can I run this report?

This report can be run at the following levels within the software:

What information is presented in this report?

This report displays the following information.

Column Header Description
Date This column provides a single day during the reporting date range
BMV This column provides the Beginning Market Value for each day in the reporting date range. This number should match the Ending Market Value for the previous day.
EMV This column provides the Ending Market Value for each day in the reporting date range.
Net Cash Flow This column nets the cash flow additions into the account minus withdrawals out of the account. (Excluding management fees) . The sum of this column should match the net investment field for the account on the Client Return Summary.
TWR % This column provides the Time Weighted Return percentage for each day in the reporting period.

 

How can I manually confirm that the information displayed is correct?

If you want to manually confirm your Period Rate of Return, please follow the steps below:

  1. Paste the following formula into cell F12 without quotation marks.
    =100*((1+F11/100)*(1+E12/100)-1)

  2. Copy the formula into the cell for each day of the reporting date range.  

  3. The final cell of your reporting date range will display your result.

Note: this formula will still yield a small discrepancy due to rounding. Please see the example below.


How can I use this report to confirm my daily average balance for Billing?

To use this report to confirm your average daily balance for billing please follow the steps below:

  1. In the EMV column, select cells for each day of the reporting date range.

  2. Use the =AVERAGE formula to find the average for each day in the reporting period.

  3. The cell under the final day in your EMV column will display your average daily balance.