My Add-ins Pivot Table Recommended Table Pivot Tables Pictures Online Shapes Icons Pictures Models Illustrations Add-ins Tables Checked Checked Volatility 3. Consider two funds that start with $1.000 and have returns as shown below. 4 Fund #1 5 Return Year Beg Balm $ Return Withdrawal End Bal 6 -12.9% 1000 8 12.9% 10 -18.3% 15.8% 15.0% 17 Fund #2 18 Return 19 -18.9% Year Beg Bal 1000 $ Return Withdrawal End Bal 21 18.9% -26.8% 25 27 23.2% 23.0% 30 Step 1. Fill in each table. For instance, the "Returnfor Fund #1 for 31 the first year would be -$129.0000 (which is -12.90% of that year's beginning 32 balance.) 33 34 Hint: the Ending Balance on the last row of teach table should be 35 almost identical within a dollar of each other). Key 990901 964 905) 910 969 (8) 919) 9 (10) End 4 Fund #1 5 Return 6 -12.9% Year $ Return End Bal Beg Bal 1000 Withdrawal 149 18 12.9% 149 -18.3% 149 15.8% 149 + 54 15.0% 5 57 Fund #2 58 Return 59 -18.9% Year $ Return End Bal Beg Bal 1000 Withdrawal 149 61 18.9% 2 149 63 -26.8% 3 149 23.2% 149 23.0% 149 71 Step 3. Using the tables from Step 2. please compare the Ending Balance 72 on the last row (Year 5) of each table. 73 How much less is Fund #2's Ending Balance for Year 52 74 A Between 20 and 37 75 B Between 37 and 50 76 C Between 50 and 61 77 D Between 61 and 75 78 Key 962 903 904 905) 916) 90 9( 919 Ready 120 e 0. AS SOON 9610) Ends