Assets under management at start of year $($NAV$)$

Assets at end of year before net inflows $($NAV$)$

Change in NAV

Holding Period Return $(\%)$

Net Inflows

NAV at end of year after net inflows

Arithmetic Average HPR at end of each year

Geometric Average HPR at end of each year

Why is an arthimatice mean return typically higher than the geometric mean return and

which one is more reflective of perfomance?

Dollar weighted four year return

Cash flows for dollar weighted return calculation

$0$

$1$

$2$

$3$

Dollar weighted return at end of year $4($IRR$)$

Why is the dollar weighted return lower than the geometric mean retu

Dollar weighted five year return

Cash flows for dollar weighted return calculation

Dollar weighted return at end of year $5($IRR$)$

Can you also assist in labeling the excel functions to solve the problems