Overview
This report provides a summary view of the changes and the returns for a Portfolio over a given time period.The Investment Movement and Returns Report can be used to demonstrate the performance of the Portfolio over various time periods compared against benchmarks, with or without expenses, and including/excluding income declared but not paid. The Investment Movement and Return report will provide a summary view over the time period defined as well as the previous year and 3 year period.
Investment Movement and Returns
Report Parameters
|
Field Name |
Field Description |
Field Validations |
Example |
|
Output Format |
The format of the file generated. PDF and RTF/Word formats available |
Mandatory radio button |
|
|
Last Period Update End Date |
Shows when the last period update was run |
Pre filled text |
30/06/2014 |
|
Start Date |
Report start date |
Mandatory date field |
01/07/2013 |
|
End Date |
Report end date |
Mandatory date field |
30/09/2013 |
|
Include Income Declared But Not Paid |
Option to include or exclude Income Declared But Not Paid in the report |
Mandatory radio button |
No |
|
Include After Expenses in TWR |
Option to include or exclude the Cumulative Net Investment in the report |
Mandatory radio button |
No |
|
Compare to Benchmark 1 |
Option to include a benchmark as a comparison in the report. Refer to Investment Movement and Returns Benchmark Indexes for a list of benchmark indexes. |
Drop-down menu |
Gold |
|
Compare to Benchmark 2 |
Option to include a benchmark as a comparison in the report. Refer to Investment Movement and Returns Benchmark Indexes for a list of benchmark indexes. |
Drop down menu |
Energy |
|
Expense reporting settings |
Link to business settings to manage which expenses are included/excluded in the report |
Link to Business level expense settings |
Configure Business Settings |
|
Report Header |
Turns on the report header logo To learn more about setting up logos on reports refer to White Labels |
Mandatory radio button |
No |
|
Draft Watermark |
Option to put a draft watermark on each page. |
Mandatory radio button |
No |
|
Dollar Sign |
Option to display a '$' in the report |
Mandatory radio button |
No |
|
Rounding |
Option to round off amounts to the nearest dollar. |
Mandatory radio button |
Yes |
|
Negative Amount |
Option to display negative amounts with brackets or a minus sign. |
Mandatory radio button |
Brackets |
|
Page Footer / Number |
Option to either display both a page footer with the date and time stamp, page numbers only or leave blank |
Mandatory drop-down |
No |
Expense Settings
You can configure the expenses to be included/excluded at the Business Level. Refer to Investment Returns Report Settings for details on how to do this.
Report Calculations
Movement in Value
|
Value |
Description |
|
Starting Market Value |
The market value of the portfolio on the day prior to the reporting period |
|
Net Addition (withdrawal) |
All equity contributions - equity withdrawals over the reporting period |
|
Realised and Unrealised Gains/Losses |
The change in value of the portfolio over the reporting period |
|
Investment Income (excluding credits) |
All Investment Income based excluding foreign, franking and TFN credits |
|
Movement in Income Declared but not Paid* |
Change in income declared but not paid over the reporting period |
|
Portfolio Income* |
All portfolio income such as a fee refund |
|
Portfolio Expenses* |
All portfolio and investment expenses such as Accounting fees |
|
Other* |
This is an adjustment market movement value. A Market value movement between the end balance and start market value of investment formula : Starting Market Value + Unrealised and Realised Gains/Losses + Acquisitions - Disposals = End Market Value
In this report, the movements include Net Addition/(Withdrawal), Investment Income (excluding Credit) and Portfolio Expense that does not correspondence with market value changes. Hence, the value of Other* refers to Acquisitions* -Disposal* - Net Addition/(Withdrawal) - Investment Income + Portfolio Expenses
Acquisition* and Disposal* values for the year can be obtained from Investment Performance Report. |
|
Ending Market Value |
The market value of the portfolio on the last day of the reporting period |
|
Movement in Value |
The Ending Market Value - The Starting Market Value |
* not displayed if the value is $0
Portfolio Value versus Cumulative Net Investment (graph)
|
Value |
Description |
|
Portfolio Value |
Shows the movement in the portfolio over the reporting period calculated on a daily basis |
|
Cumulative Net |
Shows the cumulative net value of the portfolio with the equity contributions and withdrawals. Starts at 0 or you can set the starting net cumulative value in Class in when in a fund under 'fund/load opening balances/starting new cumulative balance'. |
Portfolio Return
|
Value |
Description |
|
Realised and unrealised Gains/Losses |
The change in value of the portfolio over the reporting period |
|
Investment Income |
All Investment Income - Investment Expense based on the values displayed at the business level in 'settings/investment income' and 'settings/investment expense' except it does not include Foreign or franking credits |
|
Gross Income Declared but not Paid* |
Income declared but not paid over the reporting period |
|
Credits |
Franking, foreign and TFN credits received over the reporting period |
|
Total dollar return before expenses |
The addition of all items above. |
|
Investment Expenses |
Based on the expenses configured at the business level in 'settings/investment returns report' |
|
Total dollar return after expenses |
The addition of Total dollar return before expenses - Investment Expenses |
|
Investment returns before/after expenses: |
TWR calculated on a daily basis 1 year: 1 year returns calculated from the end date of the report |
* not displayed if the value is $0
Return Over Time (graph)
|
Value |
Description |
|
Cumulative TWR (after expenses) |
Shows the TWR after configured expenses for the portfolio |
|
Cumulative TWR (before expenses) |
Shows the TWR before configured expenses for the portfolio |
Returns are calculated using the Time Weighted Return shown below
The Time Weighted Return uses the following formula to calculate the investment performance:
The TWR eliminates the timing effect that external portfolio cash flows have on returns. When calculating TWR, daily portfolio valuations are needed whenever there is external cash flow, such as a deposit or a withdrawal.
Parameters
CV = Closing Valuation
OV = Opening Valuation
NCF = Net cash flow received at the period end
Assumptions
- Net Cash Flows are deemed to occur at the end of the period.
- Calculation of the return is done on a daily basis.
- The daily return values are then compounded over the period selected.
Fund, investment and member expenses are excluded from the calculation.
The benefits of the time weighted return calculation are:
-
it enables the performance of the portfolio to be captured, independent of the flow of money into and out of the portfolio
-
it enables the investment portfolio to be compared against industry benchmarks