161) Total & Annualized Return Calculators

161) Total Return & Annualized Return Calculators using Microsoft Excel.

Now you can calculate the Total Returns and Annualized Returns from the Annual Returns given.
The Annual Returns are published based on investment performance.

The Annual Returns exclude the Initial Service Charge, Switching fees and Transfer fees.
All distributions are reinvested.
However, it includes the Management Fee, Trustee fees, Auditor Fees, Broker fees and other investment related expenses. 

In the actual investment, the daily returns changes everyday. Some days it will be positive returns, while other days will be negative returns.

The formula for simple return calculation is shown below:

Simple Return = (End Value - Begin Value) / Begin Value

Begin Value is the initial amount you start with. It is also known as Present Value.
End Value is the new amount after some time. It is also known as Future Value.

Assumptions:
1) Single lump sum investment.
2) No additional amount added.
3) No amount withdrawn.


For example,
Initial investment was $1000 (Begin Value)
Investment value grown to $1200 (End Value)

Simple Return:
= (End Value - Begin Value) / Begin Value
= (1200 - 1000) / 1000
= 200 / 1000
= 20%
 
Annual Return is basically the Simple Return for 1 year period.

Total Returns are calculated using multiple Annual Returns numbers.
Annualized Return is calculated using Begin Value, End Value and years invested.
 
Their relationship can be shown using the formula below:

FV = PV (1+i)^n

FV = Future Value
PV = Present Value
n = number of years
i = Annualized Return


The file has the template and formula for your reference.


Go to this web link to locate the Excel file location:
https://drive.google.com/open?id=1YufKxq4PcsmJ79qCQu-79NIzOGbHE6RV