PLS GIVE A CORRECT ANSWER FOR THIS

B 1 0.3 0.1 25 38 y=k 5 5 n 7 g 3 3 0 D Period k 1 4.3 2 =D2+K2 3 =D3+K3 4 =D4+K4 5 =D5+K5 16 =D6+K6 7 =D74K7 8 =D8+K8 9 =D9+K9 E F H 1 Sk =$B$9*D2^0.5 =(1-$8$2)"E2 =E2-F2 =$B$3D2 =$B$9*D3^0.5 =(1-$B$2) *3 =E3-F3 =$B$3D3 -$B$9D4^0.5 =(1-$B$2) "54 =E4-F4 =$B$3 D4 !=$B$9*D5^0.5 =(1-$B$2)*5 =E5-F5 =$B$3*D5 $B$9*D6^0.5 =(1-$B$2) "E6 =E6-F6 $B$3*D6 =$B$9*D740.5 =(1-$B$2) *E7 =E7-F7 =$B$3 D7 =$B$9*D8^0.5 =(1-$8$2) "E8=E8-F8 =$B$3*08 =$B$9*D940.5 =(1-$B$2) "E9=E9-F9 =$B$3D9 =$B$9 D10^0.5=(1-$B$2) "E10 =E10-F10 =$B$3D10 nk =$B$6*D2 =$B$6D3 =$B$6-04 =$B$6*D5 $B$6*D6 =$B$6*D7 =$B$6*DS =$B$6*D9 -$B$6'010 gk =$B$7D2 =$B$7*D3 =$B$7*D4 =$B$705 =$B$7D6 =$B$7*D7 =$B$7DS =$B$7*D9 =$B$7010 K AK =G2-H2-12-22 =G3-H3-13-13 =G4-H4-14-14 | =G5-H5-15-15 =G6-H6-16-J6 =G7-H7-17-37 =G8-H8-18-18 =G9-H9-19-19 =G10-H10-110-1 0.015 10.02 1 5. Suppose you have a fully functional excel program with all the components outlined above. Describe how you would run multiple simulations to determine the Golden Rule savings rate. (20 points) B 1 0.3 0.1 25 38 y=k 5 5 n 7 g 3 3 0 D Period k 1 4.3 2 =D2+K2 3 =D3+K3 4 =D4+K4 5 =D5+K5 16 =D6+K6 7 =D74K7 8 =D8+K8 9 =D9+K9 E F H 1 Sk =$B$9*D2^0.5 =(1-$8$2)"E2 =E2-F2 =$B$3D2 =$B$9*D3^0.5 =(1-$B$2) *3 =E3-F3 =$B$3D3 -$B$9D4^0.5 =(1-$B$2) "54 =E4-F4 =$B$3 D4 !=$B$9*D5^0.5 =(1-$B$2)*5 =E5-F5 =$B$3*D5 $B$9*D6^0.5 =(1-$B$2) "E6 =E6-F6 $B$3*D6 =$B$9*D740.5 =(1-$B$2) *E7 =E7-F7 =$B$3 D7 =$B$9*D8^0.5 =(1-$8$2) "E8=E8-F8 =$B$3*08 =$B$9*D940.5 =(1-$B$2) "E9=E9-F9 =$B$3D9 =$B$9 D10^0.5=(1-$B$2) "E10 =E10-F10 =$B$3D10 nk =$B$6*D2 =$B$6D3 =$B$6-04 =$B$6*D5 $B$6*D6 =$B$6*D7 =$B$6*DS =$B$6*D9 -$B$6'010 gk =$B$7D2 =$B$7*D3 =$B$7*D4 =$B$705 =$B$7D6 =$B$7*D7 =$B$7DS =$B$7*D9 =$B$7010 K AK =G2-H2-12-22 =G3-H3-13-13 =G4-H4-14-14 | =G5-H5-15-15 =G6-H6-16-J6 =G7-H7-17-37 =G8-H8-18-18 =G9-H9-19-19 =G10-H10-110-1 0.015 10.02 1 5. Suppose you have a fully functional excel program with all the components outlined above. Describe how you would run multiple simulations to determine the Golden Rule savings rate. (20 points)