{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet 1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet 1","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[10,3,10,4],[10,6,10,7],[17,10,17,16]]}
["Training-- Spreadsheet Example"]
[null,"for Figure 19.2 in Kuhn, P. Personnel Economics"]
[]
["In this example, Sam is making decisions at age 18 that affect his earnings up to age 35 "]
["Interest Rate =",{"$nulls":5},0.08,0.08]
["Tuition Cost =",{"$nulls":5},20,20]
["Annual earnings without training =",{"$nulls":5},30,30]
["Annual earnings with training =",{"$nulls":5},35,35]
[]
[]
[{"$nulls":3},"Without Training",null,null,"With Training"]
["(1)","(2)",null,"(3)","(4)",null,"(5)","(6)"]
[]
["Age","Year (t)",null,"Income","PV(Income)",null,"Income","PV(Income)"]
[18,0,null,{"$f":"$H$7","v":30},{"$f":"D15/(1+$G$5)^B15","v":{"v":30,"d":"30.00"}},null,{"$f":"-$G$6","v":-20},{"$f":"G15/(1+$G$5)^B15","v":{"v":-20,"d":"-20.00"}}]
[{"$f":"A15+1","v":19},{"$f":"B15+1","v":1},null,{"$f":"$H$7","v":30},{"$f":"D16/(1+$G$5)^B16","v":{"v":27.777777777777775,"d":"27.78"}},null,{"$f":"$G$8","v":35},{"$f":"G16/(1+$G$5)^B16","v":{"v":32.407407407407405,"d":"32.41"}}]
[{"$f":"A16+1","v":20},{"$f":"B16+1","v":2},null,30,{"v":25.720164609053494,"d":"25.72"},null,{"$f":"$G$8","v":35},{"v":30.006858710562412,"d":"30.01"}]
[21,3,null,30,{"v":23.814967230605088,"d":"23.81"},null,35,{"v":27.784128435705934,"d":"27.78"}]
[22,4,null,30,{"v":22.0508955838936,"d":"22.05"},null,35,{"v":25.726044847875865,"d":"25.73"}]
[23,5,null,30,{"v":20.41749591101259,"d":"20.42"},null,35,{"v":23.820411896181355,"d":"23.82"}]
[24,6,null,30,{"v":18.905088806493136,"d":"18.91"},null,35,{"v":22.05593694090866,"d":"22.06"}]
[25,7,null,30,{"v":17.504711857864017,"d":"17.50"},null,35,{"v":20.422163834174683,"d":"20.42"}]
[26,8,null,30,{"v":16.208066535059274,"d":"16.21"},null,35,{"v":18.90941095756915,"d":"18.91"}]
[27,9,null,30,{"v":15.007469013943771,"d":"15.01"},null,35,{"v":17.508713849601065,"d":"17.51"}]
[28,10,null,30,{"v":13.895804642540527,"d":"13.90"},null,35,{"v":16.21177208296395,"d":"16.21"}]
[29,11,null,30,{"v":12.866485780130118,"d":"12.87"},null,35,{"v":15.010900076818471,"d":"15.01"}]
[30,12,null,30,{"v":11.913412759379739,"d":"11.91"},null,35,{"v":13.898981552609694,"d":"13.90"}]
[31,13,null,30,{"v":11.030937740166424,"d":"11.03"},null,35,{"v":12.869427363527494,"d":"12.87"}]
[32,14,null,30,{"v":10.213831240894836,"d":"10.21"},null,35,{"v":11.916136447710642,"d":"11.92"}]
[33,15,null,30,{"v":9.457251148976699,"d":"9.46"},null,35,{"v":11.03345967380615,"d":"11.03"}]
[34,16,null,30,{"v":8.756714026830277,"d":"8.76"},null,35,{"v":10.216166364635322,"d":"10.22"}]
[35,17,null,30,{"v":8.108068543361368,"d":"8.11"},null,35,{"v":9.459413300588261,"d":"9.46"}]
[]
["SUM",{"$nulls":3},{"$f":"SUM(E15:E32)","v":{"v":303.64914320798266,"d":"303.649"}},null,null,{"$f":"SUM(H15:H32)","v":{"v":299.25733374264655,"d":"299.257"}}]
[]
["Note: \"base case\" parameter values in bold"]