{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["IRR","SOLN"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"IRR","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Goal Seek Example",null,null,null,"Goalseek.xlsm"]
[]
[0.1,"Discount Rate"]
[null,"End of Period","Cash Flows","Discount Factor","Present Value (PV)"]
[null,0,-100,null,null,{"$f":"SUBSTITUTE(getformula(D5)&\" and \"&getformula(E5),\"<--\",\"\",2)","v":{"$error":"#NAME?"}}]
[null,{"$f":"1+B5","v":1},30,null,null,{"$error":"#NAME?"}]
[null,{"$f":"1+B6","v":2},20,null,null,{"$error":"#NAME?"}]
[null,3,50,null,null,{"$error":"#NAME?"}]
[null,4,80,null,null,{"$error":"#NAME?"}]
[null,5,25,null,null,{"$error":"#NAME?"}]
[null,null,null,"Total",null,{"$f":"getformula(E11)&\" =NPV\"","v":{"$error":"#NAME?"}}]
[null,null,null,"IRR"]

{"sheet":"SOLN","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Goal Seek Example",null,null,null,"Goalseek.xlsm"]
[null,null,null,null,null,null,null,null,"Excel command: Data/What-If-Analysis/Goal Seek"]
[0.1,"Discount Rate"]
[null,"End of Period","Cash Flows","Discount Factor","Present Value (PV)"]
[null,0,-100,{"$f":"(1+$A$3)^-B5","v":1},{"$f":"C5*D5","v":-100},{"$f":"SUBSTITUTE(getformula(D5)&\" and \"&getformula(E5),\"<--\",\"\",2)","v":{"$error":"#NAME?"}}]
[null,{"$f":"1+B5","v":1},30,{"$f":"(1+$A$3)^-B6","v":0.90909090909090906},{"$f":"C6*D6","v":27.272727272727273},{"$error":"#NAME?"}]
[null,{"$f":"1+B6","v":2},20,0.82644628099173545,16.528925619834709,{"$error":"#NAME?"}]
[null,3,50,0.75131480090157754,37.565740045078876,{"$error":"#NAME?"}]
[null,4,80,0.68301345536507052,54.64107642920564,{"$error":"#NAME?"}]
[null,5,25,0.62092132305915493,{"$f":"C10*D10","v":15.523033076478873},{"$error":"#NAME?"}]
[null,null,null,"Total",{"$f":"SUM(E5:E10)","v":51.53150244332538},{"$f":"getformula(E11)&\" =NPV\"","v":{"$error":"#NAME?"}}]
[null,null,null,"IRR",{"$f":"IRR(C5:C10,0.1)","v":0.26443797441463657}]
[null,null,null,null,null,"<-- Start Goal Seek here in case it fails!"]