{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Input","Output"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
["Expected Commerical Value (NPV)",{"$f":"(NPV_Income*Probability_of_Commerical_Success-NPV_Launch_and_Marketing_Costs)*Probability_of_Technical_Success-NPV_Development_Costs","v":46606.812486730065}]
[]
["Probability of Commerical Success",0.8]
["Probability of Technical Success",1]
["Unit Sales Price",700]
["Discount Rate",0.06]
[]
[]
["Cashflows","FY00","FY 01","FY02","FY03","FY04","FY05 ","FY06","FY07","FY08","FY09","FY10"]
["Development Costs",10000,5000,0,0,0,0,0,0,0,0,0]
["Launch and Marketing Costs",null,3000,2000,2000,500,500,500,500,250,250,0]
["Forecasted Units Sold",null,10,30,40,20,20,14,10,3,4,2]
["Forecasted Revenue (Unit Sales Price x Units Sold )",null,{"$f":"C13*Unit_Sales_Price","v":7000},21000,28000,14000,14000,9800,7000,2100,2800,1400]
[]
[]
["Discounted Cashflows (10 Year) ","Calculated"]
["NPV Income",{"$f":"NPV(Discount_Rate,C14:L14)","v":85674.611912614477}]
["NPV Development Costs",{"$f":"NPV(Discount_Rate,B11:B11:L11)","v":13883.944464222141}]
["NPV Launch and Marketing Costs",{"$f":"NPV(Discount_Rate,C12:L12)","v":8048.9325791393721}]
[]
[]
[]
[]
["Marketing Cost Ratio","Success Probability","Cost of Capital"]
[0.2,0.2,0.06]
[0.4,0.4,0.08]
[0.6,0.6,0.1]
[0.8,0.8,0.12]
[1,1,0.14000000000000001]
[1.2,null,0.16]
[1.4,null,0.18]
[1.6,null,0.2]
[1.8,null,0.22]
[2,null,0.24]
[2.2000000000000002,null,0.26]
[2.4,null,0.28000000000000003]
[2.5,null,0.3]
[2.6]
[2.8]
[3]
[3.2]
[3.4]
[3.6]
[3.8]
[4]

{"sheet":"Output","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Expected Commerical Value (NPV)",{"$f":"(NPV_Income*Probability_of_Commerical_Success-NPV_Launch_and_Marketing_Costs)*Probability_of_Technical_Success-NPV_Development_Costs","v":46606.812486730065}]