1) On the spreadsheet, create a 4 step binomial tree model by replacing all the cells highlighted in yellow with the appropriate formula. (The cells highlighted in green are the inputs.

interast rai 2 dr idend rale Eura Cal Euro Pu American Cal Amcrican Put 5.29889 5 28889 6 siuma 17327 0.92173 0.51767 Euro Cal Euro Pu 5.29889 9.15854 32.68984 5.29009 .2948 8.53144 1C0.00000 10732707 116.19099 123.63111 13269964 107.327O7 115.19089 83 17314 100 03co0 90 89679 81234 0.00000 0.0000000 6.92696 9.11421 13.1 15.19099 23.63111 2707 3.53106 0,00300 0.000 0.C0000 3.53406 13,18766 83.17314 100.00000 96.81234 0.00000 87E 24.83617 rmerican Call rverican Put Strke .15864 15.19099 23.63111 32.68984 3.53406.00000 5.29809 1.2948 5.29989 853144 0.00000 3.53406 0.00000 0.00000 6.82686 19.11421 131 32707 3.18766 0.00000 13.1B73E 24.83817 0.11221 038131 0.39777 0.13873 1.00000 0.48233 D41T67 023264 049534 028799 0.37408 132.88964 15.1809B 1C0 0C0 6.41234 75.38383 0.05412 023235 0 37405 028765 0.07181 interast rai 2 dr idend rale Eura Cal Euro Pu American Cal Amcrican Put 5.29889 5 28889 6 siuma 17327 0.92173 0.51767 Euro Cal Euro Pu 5.29889 9.15854 32.68984 5.29009 .2948 8.53144 1C0.00000 10732707 116.19099 123.63111 13269964 107.327O7 115.19089 83 17314 100 03co0 90 89679 81234 0.00000 0.0000000 6.92696 9.11421 13.1 15.19099 23.63111 2707 3.53106 0,00300 0.000 0.C0000 3.53406 13,18766 83.17314 100.00000 96.81234 0.00000 87E 24.83617 rmerican Call rverican Put Strke .15864 15.19099 23.63111 32.68984 3.53406.00000 5.29809 1.2948 5.29989 853144 0.00000 3.53406 0.00000 0.00000 6.82686 19.11421 131 32707 3.18766 0.00000 13.1B73E 24.83817 0.11221 038131 0.39777 0.13873 1.00000 0.48233 D41T67 023264 049534 028799 0.37408 132.88964 15.1809B 1C0 0C0 6.41234 75.38383 0.05412 023235 0 37405 028765 0.07181