{"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 American Option Price"]
[]
["N  (periods)",50,null,"Inputs go in yellow cells. Enter function formula,"]
["u  (up)",1.1000000000000001,null,"in B8, for example: = MAX(B10 - B9, 0) for calls",null,null,null,null,"The program graphs the price V_0 of an American option with a user"]
["d  (down)",0.7,null,"and: = MAX(B9 - B10, 0) for puts (Excel formulas).",null,null,null,null,"defined payoff function F(S_N, K) against any one of the variables"]
["K  (strike price)",15,null,"The stock price is fixed at 10.00",null,null,null,null,"u, d, K, and i chosen by the user. First, a table of prices V_0 is"]
["i  (period rate)",1E-4,null,null,null,null,null,null,"generated and then Excel's line chart facility is used to draw graph."]
["F(S_N, K)  (function)",{"$f":"MAX(B9-B10,0)","v":0}]
["K"]
["S_N"]
[]
["Enter letter:","u, d, K, or i","u","V_0"]
[null,null,1.0501,7.1869942507674134]
[null,null,1.1001000000000001,8.7409816547461254]
[null,null,1.1501000000000001,9.7420950589143782]
[null,null,1.2001000000000002,10.480832386441177]
[null,null,1.2501000000000002,11.096595710056812]
[null,null,1.3001000000000003,11.568942493854715]
[null,null,1.3501000000000003,11.940493947499153]
[null,null,1.4001000000000003,12.272076054395638]
[null,null,1.4501000000000004,12.508419540252417]
[null,null,1.5001000000000004,12.747333317281173]
[null,null,1.5501000000000005,12.946713939428179]
[null,null,1.6001000000000005,13.122877863115651]
[null,null,1.6501000000000006,13.302680977260213]
[null,null,1.7001000000000006,13.446244266352027]
[null,null,1.7501000000000007,13.535193458255488]
[null,null,1.8001000000000007,13.663544091279201]
[null,null,1.8501000000000007,13.751612613839434]
[null,null,1.9001000000000008,13.838408493864092]
[null,null,1.9501000000000008,13.908535496871805,null,null,null,null,null,null,""]
[null,null,2.0001000000000007,13.988864786083292]

{"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":[]}