As mentioned, you must calculate the TWR for each sub-period. Then, you must link the returns, which tells us the total return for the entire period.

To do this, divide the net income by the average total assets, and then multiply the result by 100 to convert it into a percentage. For example, if a company has a net income of $500,000 and total ...

Calculating Total Expected Return in Excel First, enter the following data labels into cells A1 through F1: Portfolio Value, Investment Name, Investment Value, Investment Return Rate, Investment ...