{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Product Data","Scenario Output","Charts"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"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","formulas":"cached_only"}

{"sheet":"Product Data","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name]"]
["New-Product Sales and Profit Forecasting Model — Product Data "]
["[Date]"]
[]
[null,"[Company Name] CONFIDENTIAL"]
["Product Sales Data"]
["Product name","Widget"]
["Year 1 estimated unit sales",100]
["Year 1 unit price",400]
["Unit price compound annual growth rate (CAGR) (years 2 through 5)",0.05]
["Year 1 market size (dollars)",50000000]
["Market size CAGR (years 2 through 5)",0.1]
["Year 1 variable cost per unit",250]
["Variable cost per unit CAGR (years 2 through 5)",0.05]
["Year 1 fixed costs",250000]
["Fixed cost CAGR (years 2 through 5)",0.03]
["Target operating income (year 5)",100000]
["Target market share (year 5)",0.02]
[]
["Ramp Factors","Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
["Years 2 through 4 (% of year 5 sales)","N/A",0.1,0.5,0.75,1]

{"sheet":"Scenario Output","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name]"]
["New-Product Sales and Profit Forecasting Model -- Scenario Output"]
["[Date]"]
[]
["Gray cells will be calculated for you. You do not need to enter anything in them.",null,null,null,null,"[Company Name] CONFIDENTIAL"]
["Product Sales Data","Year 1","Year 2","Year 3","Year 4","Year 5"]
["Unit prices",400,420,441,463.05,486.20250000000004]
["Unit costs",250,262.5,275.625,289.40625,303.87656250000003]
["Fixed costs",250000,257500,265225,273181.75,281377.2025]
["Market size",50000000,55000000.00000001,60500000.000000015,66550000.00000002,73205000.00000003]
[]
["Scenario 1: Based on target operating income"]
["Unit sales",100,209.17331221730316,1045.8665610865157,1568.7998416297737,2091.7331221730315]
["Dollar sales",40000,87852.79113126732,461227.15343915345,726432.7666666667,1017005.8733333334]
["Operating income",-235000,-224555.20332577475,-92264.81746031746,-769.4624999999651,100000]
["Market share",0.0008,0.001597323475113951,0.0076235893130438565,0.010915593789130977,0.013892573913439423]
[]
["Scenario 2: Based on target market share"]
["Unit sales",100,301.1296733356987,1505.6483666784936,2258.4725500177406,3011.2967333569873]
["Dollar sales",40000,126474.46280099347,663990.9297052157,1045785.7142857148,1464100.0000000007]
["Operating income",-235000,-210072.07644962746,-16228.401360544085,118987.89285714307,267660.2975000002]
["Market share",0.0008,0.00229953568729079,0.010975056689342406,0.015714285714285715,0.02]

{"sheet":"Charts","index":2,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Graph 1 Title","Scenario 1: Widget Sales and Profit Analysis"]
["Graph 2 Title","Scenario 2: Widget Sales and Profit Analysis"]