{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Breakeven Model"],"not_rendered":{"charts":0,"images":0,"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":"Breakeven Model","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"Input your values into the yellow cells"]
[null,"Blue cells are locked calculations"]
[]
[]
[null,"Card:","Misty Rainforest"]
[null,"Pre-Announcement Price (tix):",23]
[]
[]
["Scenario","Description","Cards drop to X% of their original price:","Likelihood of this happening:","Profit in this scenario (per copy):","EV"]
[1,"They fix it right away.",1,0.5,{"$f":"$C$6*C10-$C$26","v":3.4499999999999993},{"$f":"E10*D10","v":1.7249999999999996}]
[2,"They fix it but it takes several more months.",0.75,0.45,{"$f":"$C$6*C11-$C$26","v":-2.3000000000000007},{"$f":"E11*D11","v":-1.0350000000000004}]
[3,"They can't fix it for a long time.",0.25,0.05,{"$f":"$C$6*C12-$C$26","v":-13.8},-0.69000000000000006]
[4,"*Your added scenario*","-","-",{"$f":"IFERROR(\"-\",$C$6*C13-$C$26)","v":"-"},{"$f":"IFERROR(\"-\",E13*D13)","v":"-"}]
[5,"*Your added scenario*","-","-",{"$f":"IFERROR(\"-\",$C$6*C14-$C$26)","v":"-"},{"$f":"IFERROR(\"-\",E14*D14)","v":"-"}]
[6,"*Your added scenario*","-","-",{"$f":"IFERROR(\"-\",$C$6*C15-$C$26)","v":"-"},"-"]
[]
[null,null,null,{"$f":"SUM(D10:D15)","v":1},null,{"$f":"SUM(F10:F15)","v":0}]
[null,null,null,"This must sum to 100%"]
[]
[]
[]
[]
[]
[]
[]
[null,"Expected Breakeven (Buy Below) Price:",19.55]