What reports and statements are available with performance data?

This guide provides information on how performance returns are calculated for Macquarie Wrap reports and statements. Some of the locations that include performance data are:

Online Reporting
  • Account | Performance tab on Adviser Online
  • Account | Report Builder on Adviser Online
  • Wrap Group | Report Builder on Adviser Online 
  • Performance Over Time Report on Wrap Online.
Statements
  • Super and pension annual and exit statements.

What are the different levels of performance reporting?

Adviser Online provides performance reporting at three levels:

Group-level performance reporting

By using Report Builder via Wrap Groups in Adviser Online, group performance reporting is available to provide information for a group of accounts. This allows the user to generate a reporting pack of performance, asset allocation and balance history for a group of accounts over a selected period.

You can generate group reports for Wrap groups with a maximum of 8 accounts. See how to create a Wrap group.

For more information on how to use Report Builder, see Using Report Builder.

Account-level performance reporting

You can locate a comprehensive view of your client’s account-level performance on the ‘Performance - Summary’ page in Adviser Online or via Report Builder.

The purpose of this report is to provide a clear, consolidated view of total portfolio performance. The report shows capital flows, income and growth. It's designed to present the bottom line, quickly and clearly.

Security-level performance reporting

You can locate a comprehensive view of your client’s security-level performance on the ‘Performance - Security detail’ page in Adviser Online or via Report Builder.

This report allows for a deep-dive analysis of the portfolio's overall result by examining the individual securities and asset classes at the asset and holding level.

It is purpose-built for investigating, sorting and filtering to identify top movers and understand the performance of each holding.

What calculation methodologies are available for performance reporting?

There are two performance reporting calculation methodologies available:

It's important to understand how a choice of reporting method could impact the performance figures provided.

Money-weighted rate of return (MWR)

MWR calculates the internal rate of return (IRR) that accounts for the timing and magnitude of all cash flows. It reflects the actual return earned by the investor based on when they invested or withdrew money.
 

Key characteristics of MWR
  • Shows the client’s personal investment experience
  • Reflects the impact of investment timing decisions
  • Accounts for dollar-cost averaging effects
  • More intuitive for clients to understand.

How account-level MWR is calculated

(Closing portfolio value – Opening portfolio value – Net capital flows) / (Opening portfolio value + Sum of the weighted capital flows)
 

How security-level MWR is calculated

(Closing portfolio value – Opening portfolio value – Net capital flows) + Income accrued] / (Opening portfolio value + Sum of the weighted capital flows)

Time-weighted rate of return (TWR)

TWR measures the compound rate of growth of an investment by eliminating the impact of cash flows (deposits and withdrawals). It focuses purely on the investment manager’s ability to grow the portfolio. TWR calculations are specifically designed for account-level performance.
 

Key characteristics of TWR
  • Focuses purely on investment selection and portfolio management
  • Unaffected by client cash flow timing
  • Industry standard for comparing fund managers and strategies
  • Ideal for benchmarking against market indices.
How account-level TWR is calculated

TWR calculations for all investments are calculated daily to obtain the most accurate results. The daily figures are then compounded to obtain returns for any required period.

TWR is calculated using the formula below:

(Closing portfolio value – Opening portfolio value – Net capital flows) / (Opening portfolio + Net capital flows)/2)

Please note:

  • TWR calculations are performed based on data available at a specific point in time. Performance figures may not automatically recalculate if updated or revised data becomes available after the initial calculation date.
  • TWR figures will smooth out significant spikes or troughs in the daily portfolio balance of an account. Not all days will be included in the final performance figure.
  • Due to the current system calculation methodology, TWR figures may not accurately reflect investment performance during periods when in-specie transfers occur.

What 'rules' are used in performance reporting?

The following rules apply to TWR and MWR performance calculations:

Account-level performance rules

  • Returns for periods over 12 months are annualised, making it easier to compare the performance of different investments over different time periods. Alternatively, returns for periods less than 12 months are not annualised.
  • Managed funds are valued using cumulative (cum) pricing. While this has minimal impact on TWR, it affects the timing of when distributions are recognised as cash flows in the shorter term for MWR performance return calculations.
  • Franking credits are not included in TWR or MWR performance calculations.
  • Non-custodial (Other) assets are not included in the TWR calculation. They are included in the MWR calculation, only for our Private Bank clients.
  • Performance calculations generally include income and expenses (including fees and taxes if applicable).

Security-level performance rules

  • For Macquarie Wrap, security performance isn't available for the Cash Account/Hub, Term deposits or any other assets. For Macquarie Vision, security performance is available for Other assets.
  • If the security was transferred in after the report start date, then the opening value used in the security performance calculation is as at the date the security was transferred in. Otherwise, the opening value used is as at report start date.
  • For reporting periods that span ex-dividend dates, cumulative pricing can create temporary differences in security-level performance compared to ex-pricing methods.
  • The 'Growth' figure on the Performance Summary report can at times differ from 'Security Performance' because they’re calculated over different timeframes. While Growth is always calculated for the entire reporting period, Security Performance is calculated only for the most recent holding period of that security. An event like a corporate action, redemption or restructure can shorten the security's holding period. When this occurs, a warning tooltip will appear on the ‘Performance Security’ detail page confirming the exact dates used in the calculation.

 

Group-level performance rules

  • Group performance is calculated using only money-weighted rate of return.
  • Group performance will only consider the account’s active period when calculating performance and limit all values to the accounts active period. Even if the reporting period is selected for a greater date range, it will only allow the group report to be generated from the earliest account’s opening date to the latest account’s close date.
  • Group performance will only include an account within the report pack if it was active during at least a part of the reporting period.

What if a transaction occurs before an account's opening or after its closure?

In Adviser Online, transactions that take place before an account's opening date or after its closure date will not be presented.

  • If an account was opened on or before the start of the group reporting period, its initial value is captured as 'Opening value'
  • If an account was opened after the start of the group reporting period, it’s captured as 'Capital inflow'  
  • For post-account closure, the value at the close date is captured as 'Capital outflow'. Any transactions occurring after the close date are excluded from performance reporting.

For income and expenses, only those transactions occurring during the active period will be presented.

How do I switch between group and account views in performance reports?

Adviser Online group reports provide a flexible filter, allowing you to choose between a group-only view or a combined group and individual account view for the following reports:

  • Performance Summary
  • Performance Capital flows
  • Performance Income and Expenses
  • Performance Security Details
  • Asset Allocation
  • Balance History.

What is cumulative pricing?

Our platform uses cumulative pricing for all managed fund valuations, which mean income amounts remain included in the unit price until the ex-date, at which point they’re removed from the price and treated as a separate cash distribution.

Why do the fund manager's performance figures differ from our performance report?

Performance figures can vary due to differences in calculation methods, factors considered and timing. Fund managers focus on individual fund returns, typically including only income received and excluding account-level factors like fees or taxes. In contrast, Macquarie Wrap calculates performance at the account level, incorporating all holdings, cash flows, fees, taxes and accrued income. Timing differences, such as when transactions or distributions occur, may also create discrepancies between fund manager and Macquarie Wrap performance figures.

How is the performance summary income return calculated?

Income return = Total income received for the period selected / Closing portfolio x 100

Note: For Macquarie Wrap, the income return will be calculated using the closing value excluding other assets.

How is market movement calculated?

Market movement represents any unrealised growth. It also acts as a balancing figure and is calculated as follows:

Market movement = Closing portfolio balance – Opening portfolio balance – Capital inflows – Capital outflows – Income – Expense – Realised gains

How are net capital flows calculated?

Net capital flows = Additions – Capital outflows

What is the sum of the weighted capital flows?

Sum of the weighted capital flows = Sum of [Capital flows x (Days in period – Days of cashflow in period)] / Days in period

Chat to us on Adviser Online

You can start a new chat with us and leave a message at any time. Consultants are available to chat Monday to Friday, 8am to 7pm Sydney time (excluding public holidays).

Resolve a complaint

Everyone at Macquarie is commited to providing our clients with the highest standard of products and services available. If you have feedback we would like you to tell us about it. 

Talk to us today

To speak to a specialist complete this form and we'll be in touch.