in excel please

Note--I am giving you the risk free rate of return per period--not on an annualized basis. Thus, you do not need to know how long each "node" is. Please be careful with this and email any questions!

Create a 3 period Binomial model on an American Put. Assume S ₀=$99, X=$100, r=1.0% per period! or 1.01, u = 5.5% (1.055), d = -4.5% (.955), please give the value of an American PUT at each observation (there should be 10!)---but you need to WATCH FOR EARLY EXERCISE! to get this right. If the put is worth below its intrinsic value, you need to use the intrinsic value to calculate the value for the previous period.

Create a 2 period Binomial model on an Call. Assume S ₀=$49, X=$50, r=.50% per period! or 1.005, u = 3.5% (1.035), d = -1.0% (.99), please give the value of an Call at each observation (there should be 6!)

So--you have a total of 16 observations I will grade. The assignment is worth 15 points. I will also give you 2 points for turning it