{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Graph of Option Price"]
[null,null,null,"The program graphs the price V_0 of an option with a user defined"]
["N  (periods)",50,null,"payoff function F(S_N, K) against any one of the variables u, d, K, and i,"]
["u  (up)",1.1000000000000001,null,"the variable chosen by the user. First, a table of prices V_0 is generated"]
["d  (down)",0.7,null,"and then Excel's line chart facility is invoked to draw the graph."]
["K  (strike price)",15,null,"Inputs go in yellow cells. Enter function formula in B8, for example"]
["i  (period rate)",1E-4,null,"enter = MAX(B10 - B9, 0) for calls and enter = MAX(B9 - B10, 0) for puts"]
["F(S_N, K)  (function)",{"$f":"MAX(B10 - B9,0)","v":0},null,"(Excel formulas). The stock price is fixed at 10.00"]
["K"]
["S_N"]
[]
["Enter letter:","u, d, K, or i","u","V_0"]
[null,null,1.0501,2.2416642363991413]
[null,null,1.1001000000000001,3.7981225606316551]
[null,null,1.1501000000000001,4.8013089769542328]
[null,null,1.2001000000000002,5.540246412241836]
[null,null,1.2501000000000002,6.1555933133668681]
[null,null,1.3001000000000003,6.6278812240841418]
[null,null,1.3501000000000003,6.9995159105009321]
[null,null,1.4001000000000003,7.3304075540662765]
[null,null,1.4501000000000004,7.5660160075659784]
[null,null,1.5001000000000004,7.805392976922831]
[null,null,1.5501000000000005,8.0044857947930232]
[null,null,1.6001000000000005,8.179875980726754]
[null,null,1.6501000000000006,8.3597696113317781]
[null,null,1.7001000000000006,8.503427331876896]
[null,null,1.7501000000000007,8.5920337246171492]
[null,null,1.8001000000000007,8.7200493134859585]
[null,null,1.8501000000000007,8.8081871538819527]
[null,null,1.9001000000000008,8.8943511315143962]
[null,null,1.9501000000000008,8.9645580278924104,null,null,null,null,null,null,""]
[null,null,2.0001000000000007,9.0445648553241949]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}