Assume the following data for a hypothetical investment account. Considering the material on Arithmetic, Geometric, Time-Weighted and Dollar-Weighted returns, answer the following questions:

- Compute and fill in the missing values (highlighted in yellow):

A B D E F G 0 Year: Beginning Market Value Total Return During the year Cash In/Out at 'Year End' Ending Market Value Holding Period Returns (HPRS) $ $ $ $ 1,000,000.00 $ $ 1,000,000.00 $ 1 2 3 1,000,000.00 $ 2,250,000.00 $ 480,000.00 250,000.00 $ (270,000.00) $ 72,000.00 1,000,000.00 $ (1,500,000.00) $ 2,250,000.00 $ 480,000.00 $ 552,000.00 Cash In and Out (and Ending MV) 0 1 2 3 Arithmetic Average Return Geometric Average Return Time-Wighted Returns (TWR) Hint: Geo=TWR so long as CFS concide with HPR periods Dollar-weighted Return (DWR) Hint: You need the periodic cash flows and ending market value to compute DWR