Does anyone know how to calculate the % return with the following data points for super?
Im with Unisuper and it doesnt give me the %.
Total opening balance at 1 July 2022 $A
Contributions $B
Investment returns $C
Taxes -$D
Fees and costs deducted from your account -$E
Total closing balance at 30 June 2023 $F
Yep but I have a combination and certain ones I made changes during the year. Trying to see a return for my portfolio.
Before or after tax?
Before or after added contributions?
Before or after fees?
Before or after all of the above?
When superannuations say x type got 10.2% etc as an example is it before everything normally?
I'd suggest going with tsunamisurfer's approximation below for the least amount of effort.
Combination of investments, plus switching investments mid year, plus all transactions makes it difficult but not impossible to do.
However, if you really wanted the exact amount
Unisuper: Go to investments > Investment performance > tick all your investment options, pick your date range > Download as a CSV (where is says "For daily cumulative rates 1 July 2022 – 22 August 2023, download a copy of the CSV file.) - This file essentially shows you price movement of the underlying "shares".
Open a sharesight account > Add custom investment, call it unisuper - "investment option". There is a button for Bulk upload prices.
You need to change the csv from unisuper to match the upload template for sharesight (eg change date from DD-MM-YYYY to YYYY-MM-DD)
You have to repeat this for however many investments options you have.
Say you have 4 investment options as my original reply you should now have 4 custom investments in sharesight with daily price movements to match.
Go back to unisuper > Transactions > filter to your date range > download transactions as CSV.
Every transaction in unisuper will have a date, each date transaction will a contribution and contribution tax of 15%. Your actual purchase of the underlying investment option is contribution less contribution tax. Add that amount as a manual trade into sharesight. Repeat for contributions.
To factor in the fees, add $8 monthly as a brokerage cost to the closest contribution date.
C> D+ E :)
C<D+E :(
Its not easy or straightforward to calculate.
You will need to know exact dates and sizes of contributions, and deductions (such as taxes and fees).
If the contributions were weighted to the start of the period, they would have longer time to compound (assuming a positive return for the year).
If the fees/deductions were taken out at the start of the period, they would negatively impact performance to a greater extent than if they were taken out at the end of the period (assuming a positive return for the year).
+1 due to having contributions going in every week to quarterly (depending on how your employer pays your super to your super fund) you'd need to know the returns from the time the contribution hit your account until 30 June - for every contribution.
You don't have enough info in the post to make that assessment.
(C - E Less insurance premiums) / A
Do not include taxes as they also incorporate conts tax.
Yeah this will give you a ballpark estimate of returns, but will depend on the size of the opening balance compared to the size of the contributions (and timing of contributions).
It will be more accurate for larger opening balances (A), with small contributions (B) - as interest earned on contributions will be immaterial compared to interest earned on the large opening balance.
If however the contributions (B) are relatively large in comparison to the opening balance (A), then the calculation will be overstated - as interest earned on contributions will be large compared to interest earned on the opening balance, and the contributions are not included in the calculation (but the interest earned on contributions will be).
There are probs many ways to slice this, but here's what I track: gain = F - A - B; return = gain/A
I've always found it weird that Super funds don't display a % gain or loss on your main page.
You're essentially buying units in their funds, so it should be easy to do.
I think they do something at the end of the year in the statement.
Yeah its weird. I thought the same, ive got my June statement but it doesnt have it. Unless theres another statement coming…
Go to Investments > Investment Performance
Select all the investment types you've invested in (Balanced, High Growth, AU Shares, International Shares etc)
Pick a date range - From July 2022 to current.
Balanced: 9.32%
High Growth: 12.89%
AU Shares: 13.57%
International Shares: 14.44%