{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["PRODUCT DATA","SCENARIO OUTPUT","CHART DATA"],"not_rendered":{"charts":2,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"PRODUCT DATA","index":0,"n_rows":25,"n_cols":3,"rows_kept":25}
[]
[null,"[Company Name]"]
[null,"New-Product Sales and Profit Forecasting Model — Product Data"]
[null,"[Date]"]
[null,null,{"$f":"CompanyName&\" CONFIDENTIAL\"","v":"[Company Name] CONFIDENTIAL"}]
[null,"Product Sales Data"," "]
[null,"Product name","Widget"]
[null,"Year 1 estimated unit sales",{"v":100,"d":"$100.00"}]
[null,"Year 1 unit price",{"v":400,"d":"$400.00"}]
[null,"Unit price compound annual growth rate (CAGR) (years 2 through 5)",{"v":0.05,"d":"5.00%"}]
[null,"Year 1 market size (dollars)",{"v":50000000,"d":"$50,000,000.00"}]
[null,"Market size CAGR (years 2 through 5)",{"v":0.1,"d":"10.00%"}]
[null,"Year 1 variable cost per unit",{"v":250,"d":"$250.00"}]
[null,"Variable cost per unit CAGR (years 2 through 5)",{"v":0.05,"d":"5.00%"}]
[null,"Year 1 fixed costs",{"v":250000,"d":"$250,000.00"}]
[null,"Fixed cost CAGR (years 2 through 5)",{"v":0.03,"d":"3.00%"}]
[null,"Target operating income (year 5)",{"v":100000,"d":"$100,000.00"}]
[null,"Target market share (year 5)",{"v":0.02,"d":"2.00%"}]
[]
[null,"Ramp Factors - Years 2 through 4 (% of year 5 sales)"]
[null,"Year 1","N/A"]
[null,"Year 2",{"v":0.1,"d":"10.00%"}]
[null,"Year 3",{"v":0.5,"d":"50.00%"}]
[null,"Year 4",{"v":0.75,"d":"75.00%"}]
[null,"Year 5",{"v":1,"d":"100.00%"}]

{"sheet":"SCENARIO OUTPUT","index":1,"n_rows":23,"n_cols":7,"rows_kept":23}
[]
[null,{"$f":"'PRODUCT DATA'!B2","v":"[Company Name]"}]
[null,"New-Product Sales and Profit Forecasting Model -- Scenario Output"]
[null,{"$f":"DateSet","v":"[Date]"}]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything in them.",{"$nulls":4},{"$f":"CompanyName&\" CONFIDENTIAL\"","v":"[Company Name] CONFIDENTIAL"}]
[null,"Product Sales Data","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Unit prices",{"$f":"UnitPrice","v":{"v":400,"d":"$400.00"}},{"$f":"C8*(1+GrowthRate)","v":{"v":420,"d":"$420.00"}},{"$f":"D8*(1+GrowthRate)","v":{"v":441,"d":"$441.00"}},{"$f":"E8*(1+GrowthRate)","v":{"v":463.05,"d":"$463.05"}},{"$f":"F8*(1+GrowthRate)","v":{"v":486.20250000000004,"d":"$486.20"}}]
[null,"Unit costs",{"$f":"CostPerUnit","v":{"v":250,"d":"$250.00"}},{"$f":"C9*(1+CostPerUnitCAGR)","v":{"v":262.5,"d":"$262.50"}},{"$f":"D9*(1+CostPerUnitCAGR)","v":{"v":275.625,"d":"$275.63"}},{"$f":"E9*(1+CostPerUnitCAGR)","v":{"v":289.40625,"d":"$289.41"}},{"$f":"F9*(1+CostPerUnitCAGR)","v":{"v":303.87656250000003,"d":"$303.88"}}]
[null,"Fixed costs",{"$f":"FixedCosts","v":{"v":250000,"d":"$250,000.00"}},{"$f":"C10*(1+FixedCostCAGR)","v":{"v":257500,"d":"$257,500.00"}},{"$f":"D10*(1+FixedCostCAGR)","v":{"v":265225,"d":"$265,225.00"}},{"$f":"E10*(1+FixedCostCAGR)","v":{"v":273181.75,"d":"$273,181.75"}},{"$f":"F10*(1+FixedCostCAGR)","v":{"v":281377.2025,"d":"$281,377.20"}}]
[null,"Market size",{"$f":"MarketSize","v":{"v":50000000,"d":"$50,000,000.00"}},{"$f":"C11*(1+MarketSizeCAGR)","v":{"v":55000000.00000001,"d":"$55,000,000.00"}},{"$f":"D11*(1+MarketSizeCAGR)","v":{"v":60500000.000000015,"d":"$60,500,000.00"}},{"$f":"E11*(1+MarketSizeCAGR)","v":{"v":66550000.00000002,"d":"$66,550,000.00"}},{"$f":"F11*(1+MarketSizeCAGR)","v":{"v":73205000.00000003,"d":"$73,205,000.00"}}]
[]
[null,"Scenario 1: Based on target operating income"]
[null,"Unit sales",{"$f":"UnitSales","v":{"v":100,"d":"$100.00"}},{"$f":"RampYear2*$G$14","v":{"v":209.17331221730316,"d":"$209.17"}},{"$f":"RampYear3*$G$14","v":{"v":1045.8665610865157,"d":"$1,045.87"}},{"$f":"RampYear4*$G$14","v":{"v":1568.7998416297737,"d":"$1,568.80"}},{"$f":"(G10+OperatingIncome)/(G8-G9)","v":{"v":2091.7331221730315,"d":"$2,091.73"}}]
[null,"Dollar sales",{"$f":"C14*C8","v":{"v":40000,"d":"$40,000.00"}},{"$f":"D14*D8","v":{"v":87852.79113126732,"d":"$87,852.79"}},{"$f":"E14*E8","v":{"v":461227.15343915345,"d":"$461,227.15"}},{"$f":"F14*F8","v":{"v":726432.7666666667,"d":"$726,432.77"}},{"$f":"G14*G8","v":{"v":1017005.8733333334,"d":"$1,017,005.87"}}]
[null,"Operating income",{"$f":"C15-(C14*C9)-C10","v":{"v":-235000,"d":"($235,000.00)"}},{"$f":"D15-(D14*D9)-D10","v":{"v":-224555.20332577475,"d":"($224,555.20)"}},{"$f":"E15-(E14*E9)-E10","v":{"v":-92264.81746031746,"d":"($92,264.82)"}},{"$f":"F15-(F14*F9)-F10","v":{"v":-769.4624999999651,"d":"($769.46)"}},{"$f":"G15-(G14*G9)-G10","v":{"v":100000,"d":"$100,000.00"}}]
[null,"Market share",{"$f":"C15/C11","v":{"v":0.0008,"d":"0.08%"}},{"$f":"D15/D11","v":{"v":0.001597323475113951,"d":"0.16%"}},{"$f":"E15/E11","v":{"v":7.6235893130438565E-3,"d":"0.76%"}},{"$f":"F15/F11","v":{"v":0.010915593789130977,"d":"1.09%"}},{"$f":"G15/G11","v":{"v":0.013892573913439423,"d":"1.39%"}}]
[]
[null,"Scenario 2: Based on target market share"]
[null,"Unit sales",{"$f":"UnitSales","v":{"v":100,"d":"$100.00"}},{"$f":"RampYear2*$G$20","v":{"v":301.1296733356987,"d":"$301.13"}},{"$f":"RampYear3*$G$20","v":{"v":1505.6483666784936,"d":"$1,505.65"}},{"$f":"RampYear4*$G$20","v":{"v":2258.4725500177406,"d":"$2,258.47"}},{"$f":"G21/G8","v":{"v":3011.2967333569873,"d":"$3,011.30"}}]
[null,"Dollar sales",{"$f":"C8*C14","v":{"v":40000,"d":"$40,000.00"}},{"$f":"D20*D8","v":{"v":126474.46280099347,"d":"$126,474.46"}},{"$f":"E20*E8","v":{"v":663990.9297052157,"d":"$663,990.93"}},{"$f":"F20*F8","v":{"v":1045785.7142857148,"d":"$1,045,785.71"}},{"$f":"MarketShare*G11","v":{"v":1464100.0000000007,"d":"$1,464,100.00"}}]
[null,"Operating income",{"$f":"C21-(C20*C9)-C10","v":{"v":-235000,"d":"($235,000.00)"}},{"$f":"D21-(D20*D9)-D10","v":{"v":-210072.07644962746,"d":"($210,072.08)"}},{"$f":"E21-(E20*E9)-E10","v":{"v":-16228.401360544085,"d":"($16,228.40)"}},{"$f":"F21-(F20*F9)-F10","v":{"v":118987.89285714307,"d":"$118,987.89"}},{"$f":"G21-(G20*G9)-G10","v":{"v":267660.2975000002,"d":"$267,660.30"}}]
[null,"Market share",{"$f":"C21/C11","v":{"v":0.0008,"d":"0.08%"}},{"$f":"D21/D11","v":{"v":0.00229953568729079,"d":"0.23%"}},{"$f":"E21/E11","v":{"v":0.010975056689342406,"d":"1.10%"}},{"$f":"F21/F11","v":{"v":0.015714285714285715,"d":"1.57%"}},{"$f":"G21/G11","v":{"v":0.02,"d":"2.00%"}}]

{"sheet":"CHART DATA","index":2,"n_rows":5,"n_cols":3,"rows_kept":5}
[]
[null,{"$f":"CompanyName","v":"[Company Name]"}]
[null,"New-Product Sales and Profit Forecasting Model — Chart Data"]
[null,{"$f":"DateSet","v":"[Date]"}]
[null,null,{"$f":"CompanyName&\" CONFIDENTIAL\"","v":"[Company Name] CONFIDENTIAL"}]