Option Pricing with Binomial Trees - Excel

You need to submit an Excel file. You have six input cells: S, X, rc, σ, T, and N=6. All other cells should be formulas and automatically computed. Test your spreadsheets thoroughly. Note that the risk-free rate (rc) is continuously compounded and that you must use the EXP function, not (1+rc)T... (Budget: $10 - $30 USD, Jobs: Excel, Finance, Mathematics, SPSS Statistics, Statistical Analysis)

Mar 28, 2025 - 17:12
 0
Option Pricing with Binomial Trees - Excel
You need to submit an Excel file. You have six input cells: S, X, rc, σ, T, and N=6. All other cells should be formulas and automatically computed. Test your spreadsheets thoroughly. Note that the risk-free rate (rc) is continuously compounded and that you must use the EXP function, not (1+rc)T... (Budget: $10 - $30 USD, Jobs: Excel, Finance, Mathematics, SPSS Statistics, Statistical Analysis)