PLS GIVE A CORRECT ANSWER FOR THIS

A B F 1 C 1 D Period k 1 4.3 2 =D2+K2 0.3 0.1 3 4 25 3 6 4 y=k 5 5n 7 g 3 3 A 0 E G H Sk =$B$9*D240.5 =(1-$8$2) "E2 =E2-F2 =$B$3D2 =$B$9*D310.5 =(1-$8$2)*E3 =E3-F3 =$B$3D3 =$B$9*D4^0.5 =(1-$B$2)*4 =E4-F4 =$B$3 D4 1-$B$9*D510.5 =(1-$B$2)*ES -ES-F5 =$B$3D5 =$B$9*D6^0.5 =(1-$B$2) "E6=E6-F6 =$B$3D6 =$B$9*D710.5 =(1-$B$2) "E7 E7-F7 $B$3-D7 =$B$9*D80.5 =(1-$B$2)*8 =E8-F8 =$B$3DS =$B$9*D940.5 =(1-$8$2) *E9=E9-F9 =$B$3*09 =$B$9*10^0.5=(1-$B$2)*E10 =E10-F10 =$B$3*010 nk =$B$6D2 -$B$6*D3 =$B$604 $B$6*05 $B$6*D6 =$B$6*D7 =$B$6D8 =$B$6 D9 =$B$6*010 gk =$B$7*D2 =$B$7*D3 =$B$704 =$B$7*05 =$B$7*D6 =$B$7"D7 =$B$7*D8 =$B$7D9 =$B$7*010 =D3+K3 =D4+K4 =D5+K5 =D6+K6 =D74K7 =D8+K8 =D9+K9 K k =G2-H2-12-22 =G3-H3-13-13 =G4-H4-14-14 1=G5-H5-15-15 -G6-H6-16-J6 =G7-H7-17-37 =G8-H8-18-J8 =G9-H9-19-19 =G10-H10-110-1 5 0.015 10.02 16 1 7 8 9 6. Suppose you have a fully functional excel program with all the components outlined above. Describe how you would run simulations to compute the sensitivity of consumption to increases in total factor productivity. (15 points) A B F 1 C 1 D Period k 1 4.3 2 =D2+K2 0.3 0.1 3 4 25 3 6 4 y=k 5 5n 7 g 3 3 A 0 E G H Sk =$B$9*D240.5 =(1-$8$2) "E2 =E2-F2 =$B$3D2 =$B$9*D310.5 =(1-$8$2)*E3 =E3-F3 =$B$3D3 =$B$9*D4^0.5 =(1-$B$2)*4 =E4-F4 =$B$3 D4 1-$B$9*D510.5 =(1-$B$2)*ES -ES-F5 =$B$3D5 =$B$9*D6^0.5 =(1-$B$2) "E6=E6-F6 =$B$3D6 =$B$9*D710.5 =(1-$B$2) "E7 E7-F7 $B$3-D7 =$B$9*D80.5 =(1-$B$2)*8 =E8-F8 =$B$3DS =$B$9*D940.5 =(1-$8$2) *E9=E9-F9 =$B$3*09 =$B$9*10^0.5=(1-$B$2)*E10 =E10-F10 =$B$3*010 nk =$B$6D2 -$B$6*D3 =$B$604 $B$6*05 $B$6*D6 =$B$6*D7 =$B$6D8 =$B$6 D9 =$B$6*010 gk =$B$7*D2 =$B$7*D3 =$B$704 =$B$7*05 =$B$7*D6 =$B$7"D7 =$B$7*D8 =$B$7D9 =$B$7*010 =D3+K3 =D4+K4 =D5+K5 =D6+K6 =D74K7 =D8+K8 =D9+K9 K k =G2-H2-12-22 =G3-H3-13-13 =G4-H4-14-14 1=G5-H5-15-15 -G6-H6-16-J6 =G7-H7-17-37 =G8-H8-18-J8 =G9-H9-19-19 =G10-H10-110-1 5 0.015 10.02 16 1 7 8 9 6. Suppose you have a fully functional excel program with all the components outlined above. Describe how you would run simulations to compute the sensitivity of consumption to increases in total factor productivity. (15 points)